ORACLE12 – Connect Via SqlPlus

The Oracle client version, strace output and system uptime details combined indicate this could be Oracle bug 4612267 for which a patch is available. The problem is supposed to be resolvable by either rebooting or applying the patch.

user@server:~ $ uptime
  9:54am  up 254 days  0:26,  5 users,  load average: 1.39, 1.56, 1.75
user@server:~ $ genezi -v
Client Shared Library 32-bit - 10.02.00.01.00

I had requested the patch be applied to our server to confirm if the patch fixed the issue. Unfortunately someone randomly rebooted the server before the patch could be applied - end result is that sqlplus is functioning again, which is good for me, but means I can't confirm if the patch would have fixed the issue without a reboot.

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-