Pluggable Database Connection Using SID
Problem Statement Lately, there have been some questions post upgrading an oracle database from version 12c to 19c and moving to Multi-tenant architecture. One specific question catches my attention where a third-party application only uses the SID (not service) method as a connection string to connect with the database. It was working fine with 12c legacy architecture as using the SID method we can connect to the specific instance of an oracle database. With Multi-tenant architecture when the application needs to connect to a pluggable database aka PDB, the SID connection can only land the connection in the root container and that too will not function as connection credentials will exist in a pluggable database (unless it's a common user). Since it's a third-party application, it's not possible to change or enhance the behavior overnight and needed an administrator intervention. An initial look would make you feel there is no solution to this problem, as PDB can only be c