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: