ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Items Checked
TNS_ADMIN environment variable is not defined
ORACLE_HOME environment variable is defined as "C:\app\client\huma.zahra\product\12.1.0\client_1"
"C:\app\client\huma.zahra\product\12.1.0\client_1\Network\Admin\tnsnames.ora" was located
Found in the tnsnames.ora file:
ORAADAPTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.117)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = adapter)
)
)
"C:\app\client\huma.zahra\product\12.1.0\client_1\Network\Admin\sqlnet.ora" was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
If the database was just started, wait a few moments and try again. The database may be initializing.
Verify that the connect descriptor for ORAADAPTER has the correct SERVICE_NAME or SID component in the tnsnames.ora file
Verify that the listener is properly configured and that the database is registered with the listener
Try to TNSPing ORAADAPTER using the TNS Ping button on the toolbar
Welcome to the Toad for Oracle forum!
It's not the Oracle forum for posting support type issues, but we do try to assist, where we can.
The error message you're receiving is not a Toad issue, but an issue involving some discrepancy between your Oracle instance (or it's desgnation) and the Listener.
Please get with you DBA and go through the suggested Steps to Take. Also, there are many links to sites that give more details on how to resolve this particular Oracle error... here's one you might find helpful... there are many others...
Thanks for the response, however i have successfully connected to database using SQL developer and dbeaver, it's not oracle issue or I'm unsure of it since the connection is very simple and no hard logic is required and I have consulted almost top sites on the issue
It's possible that SQLDev and DBver are using a different connection method, or a different oracle client than Toad.
Try going to command prompt, then CD to
C:\app\client\huma.zahra\product\12.1.0\client_1\bin
and from there, try to connect to your DB using sqlplus.
Gary and John are quite right. It is not a problem with TOAD. ORA-12514 is a server-side error. The message means that the Listener does not recognize the service name being presented. In your situation, that is 'adapter'. You would need to pull a Listener status 'lsnrctl status' to get a list of the services it supports. I suspect that your database's name is not 'adapter'.
You could take a look at the connect string being used by SQL Developer which should reveal the service name it is using and replace 'adapter' in your TNS Names file with that. Alternatively, you could use the Direct tab of the TOAD login dialog and enter the IP in Host and the service name. That would bypass TNS Names and use the values you enter to make the connection.
Cheers,
Russ
1 Like