da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: ORA-12154 Problem

Forum List » NCOCI8 » General English

misk0
User

Fresh Boarder

Posts: 1

Karma: 0

ORA-12154 Problem

Posted: 2002/05/15 05:51

I just installed NCOCi 1.0.2 and I can connect to database
DB is 8.1.6 on Linux, on my devel station I have Delphi 5.0 with patch 2 instaled and 8.1.7 client.
Any time I try to connect i got
"Error while trying to retrieve text for error ORA-12154"

I can connect on db with Oracle SQLPlus.
Oracle_home is in path, path in registry
is OK, HOME0 points to right directory and
there is oci.dll

What to check ?

Mur
User

Platinum Boarder

Posts: 116

Karma: 0

RE: ORA-12154 Problem

Posted: 2002/05/17 05:42

TNS-12154 TNS:could not resolve service name

Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.

Action: Make the following checks and correct the error:

Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the SQL*Net V2 Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.

Forum List » NCOCI8 » General English