sid and pluggable

I wrote about SID there. (CONNECT_DATA=(SID=DB01)) is undocumented since Oracle 11gR1 and breaks things with multi-tenant / single-tenant. You create a container CDB01 and a pluggable DB01, you can connect with sqlplus "scott/tiger@   (description=(address=     (host=srv01)(port=1521)(protocol=tcp))     (connect_data=(service_name=DB01.example.com)))" But one of your application has hardcoded SID=DB01 sqlplus "scott/tiger@   (description=(address=     (host=srv01)(port=1521)(protocol=tcp))     (connect_data=(sid=DB01)))" ORA-12514: TNS:listener does not currently know […]

What is SID in Oracle ?

In the doc you’ll find, it’s the Oracle system identifier. Okay, let’s imagine the following Environment: ORACLE_SID=ORA001 init.ora: DB_NAME=DB001 DB_UNIQUE_NAME=UNI001 INSTANCE_NAME=INS001 SERVICE_NAMES=SVC001,SVC002 DB_DOMAIN=EXAMPLE.COM GLOBAL_NAMES=false database: SQL> select * from GLOBAL_NAME; GLO001.example.com listener.ora: SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =       (GLOBAL_NAME=GLO001.EXAMPLE.COM)       (SID_NAME=ORA001)     )   ) What is my SID? Actually there is more than one correct answer. In […]