Database Networking (MOSC)

MOSC Banner

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

edited Feb 2, 2022 6:30PM in Database Networking (MOSC) 15 commentsAnswered ✓

Hello,


I am on an Oracle Engineered System (X8) and using Oracle 19.0.0.0.0.

While trying to connect to a pdb directly from sqlplus, I am getting the following error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.


The name of my pdb = dev

From the pdb, when I run the following query it returns the following:


select name,pdb,con_id from cdb_services order by con_id;

Name           pdb    con_id

dev              dev     3

dev.server.com  dev     3


I am taking this to mean I can either connect to the pdb using @dev or @dev.server.com.

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