Oracle 12c – How to Save Response File in DBCA

ERROR

Cannot add user to application access ACL. No mapping between account names and security IDs was done.

CAUSE

This is because when you are installing Oracle for the first time, the group ORA_DBA is not already existing and is created later during the installation.

SOLUTION

Ignore the message and continue the installation.You will not get the message when installation is done for the second time.

First of all check whether your pluggable database is opened or not.

SQL> select name, open_mode from v$pdbs where name='PDBORCL';

If it is in mounted mode then,

SQL> alter pluggable database pdborcl open;

Now on SQL Developer Create new connection as,

Connection Name: demo-pdborcl

Username: demo

Password: *****

Connection Type: Basic(If you wish to use TNS connection type you have to create TNS Network Alias in client side.)

Hostname: ip/dns

Port: 1521

SID: (If you use SID like 'ORCL' you will be connected to root container, therefore use Service name instead of SID)

Service name: (You can get your pdb's service name by firing $ lsnrctl serivce, also you can use USE_SID_AS_SERVICE_listener parameter on $ORACLE_HOME/network/admin/listner.ora file as USE_SID_AS_SERVICE_listener=on and any given SID will be treated as service name.

Some useful links-