MarkView Installer : Correct SID when installing MarkView with a multi-tenant database
Problem:
The "Enter MarkView Schema Connection Information" screen of the MarkView Installer prompts for a SID.
However, in a multi-tennant database environment, the application accesses a Pluggable Database (PDB) which use a Service Name rather than a SID.
What is the correct SID to enter when running the MarkView installer in this situation?
When attempting to connect to a PDB using the SID format, you will receive an error such as the following:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Solution:
When a SID is required to access a PDB, the USE_SID_AS_SERVICE_listener_name listener parameter can be used.
Edit the "$ORACLE_HOME/network/admin/listener.ora" file, adding the following entry, with the "listener" name matching that used by your listener.
USE_SID_AS_SERVICE_listener=on
Refer to the Oracle Support Article "Oracle Net 12c: How to enable Clients using SID to connect to PDB? (Doc ID 1644355.1)" which describes how to connect to a PDB using a SID:
Applies to:
Product | Version |
---|---|
MarkView for Oracle | All |