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

Document created by sheng_liao462475 Employee on Jan 5, 2017Last modified by chris_stevens on Feb 2, 2017
Version 3Show Document
  • View in full screen mode

Error

When trying to connect to Oracle 12c database, get the below error.

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

Cause

The database Connection URL is invalid.

 

Solution

If the Oracle 12c database is SID oriented, the Connection URL should be in this format.

jdbc:oracle:thin:@host:port:SID

If the Oracle 12c database is Service oriented, the Connection URL should be in this format.

jdbc:oracle:thin:@//host:port/Service_Name

In both cases, the Class Name should be [oracle.jdbc.driver.OracleDriver] and you will need to use Driver Type [Custom] for Oracle 12c. Please note that you will also need to place the ojdbc driver under <atom home>/userlib folder.

Attachments

    Outcomes