Error ORA-12154 while connecting to ORACLE via DBTools.h++.

Article ID: 796
Last updated: 05 Feb, 2008
Article ID: 796
Last updated: 05 Feb, 2008
Revision: 1
Views: 3262
Posted: 26 Jun, 1997
by Dean J.
Updated: 05 Feb, 2008
by Dean J.
Problem


When trying to connect to the ORACLE Server via DBTools.h++, I get the following error:
ORA-12154 Could not resolve service name


Cause


If you are on a UNIX platform, you can use the ORACLE utility oerr to find out exactly how to solve this problem. This error is usually generated by an invalid service name.

Service is a connection descriptor used since SQL*NET V2. It encapsulates the Oracle server name and database name. Misuse of the server name or/and database name will cause this problem.


Action


The service name should be used instead of the server name. Look in the file $(ORACLE_HOME)/network/admin/tnsnames.ora for the correct service names. Then use sqlplus to connect to the server before attempting to use DBTools.h++.
This article was:   Helpful | Not helpful
Report an issue
Article ID: 796
Last updated: 05 Feb, 2008
Revision: 1
Views: 3262
Posted: 26 Jun, 1997 by Dean J.
Updated: 05 Feb, 2008 by Dean J.

Others in this category