Use SID to connect to PDB(Pluggable database) in 12c

Today I came across a situation , my client has an old application which can use only SID to connect to the database. But the database is 12c and the database he is trying to connect is PDB.

In 12c we can not connect to the PDB using the SID, we have to use the service name. But for the sake of this old applications oracle created a parameter “USE_SID_AS_SERVICE_LISTENER” by which oracle interprets the SID to SERVICENAME.

Add the parameter “USE_SID_AS_SERVICE_LISTENER” in listener.ora like below.

      (ADDRESS = (PROTOCOL = TCP)(HOST = (PORT = 1521))


Restart the listener
lsnrctl stop
lsnrctl start
Now we can connect to the PDB using the service name as SID.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s