Error while trying to retrieve text for error ORA-12154 [message #66146] |
Tue, 18 December 2001 03:18 |
Guillaume
Messages: 3 Registered: December 2001
|
Junior Member |
|
|
Hello,
I'm testing my application (pro*C / C). On my computer (oracle 8.O.5 and pro*C) I get no error and every works fine (the database is on V7), but if I test it on another computer (but same OS) I get this error :
Error while trying to retrieve text for error ORA-12154
I can connect the database with sqlPlus and ODBC test are OK.
Can you help me please.
----------------------------------------------------------------------
|
|
|
Re: Error while trying to retrieve text for error ORA-12154 [message #66159 is a reply to message #66146] |
Wed, 26 December 2001 21:22 |
Gloria Zhao
Messages: 11 Registered: October 2001
|
Junior Member |
|
|
Hi,
12154, 00000, "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
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.
See http://www.orafaq.net/error/ora-12154.htm for some solutions to this problem.
Best regards
Frank Naude
----------------------------------------------------------------------
|
|
|
|
|
|