Database Administration (MOSC)

MOSC Banner

Why do I get ORA-12541: TNS:no listener when trying to select from a CDB to its PDB using a dblink.

(Note: I originally asked this question in a totally incorrect spot, so I'm just going to copy and paste it the way I wrote it without re-editing it to combine my comments)


We're on oracle 19.7 and starting to convert our stand alone databases to multitenant.

For reference here is the CDB and its PDBs:

SQL> @whereami


INSTANCE CONTAINER  USERNAME

---------- --------------- ------------------------------

CDB19CT1 CDB$ROOT  SYS


SQL> show pdbs

 CON_ID CON_NAME      OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

   2 PDB$SEED      READ ONLY NO

   3 COTDEV       READ WRITE NO

   4 PDB19CT1      READ WRITE NO


When I'm connected to the CDB in sqlplus, I can not connect to its PDB using an implicit database link. I get ORA-12541: TNS:no listener.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center