Home » RDBMS Server » Networking and Gateways » Error while trying to retrieve text for error ORA-12154
Error while trying to retrieve text for error ORA-12154 [message #66146] Tue, 18 December 2001 03:18 Go to next message
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 Go to previous messageGo to next message
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

----------------------------------------------------------------------
Re: Error while trying to retrieve text for error ORA-12154 [message #66247 is a reply to message #66146] Mon, 18 February 2002 21:15 Go to previous messageGo to next message
vivek sharma
Messages: 2
Registered: February 2002
Junior Member
No Message Body
Re: Error while trying to retrieve text for error ORA-12154 [message #67213 is a reply to message #66247] Wed, 11 February 2004 21:22 Go to previous messageGo to next message
pardhu
Messages: 2
Registered: February 2004
Junior Member
iam getting this error while connecting database through TOAD. Error while trying to retrieve text for error ORA-12154.
Re: Error while trying to retrieve text for error ORA-12154 [message #67710 is a reply to message #66146] Sun, 23 January 2005 21:41 Go to previous message
prakash ojha
Messages: 1
Registered: January 2005
Junior Member
i am using oracle9.0 database .My problem is i forget my username and password,how i recover it without uninstall oracle 9.0 database .Give me reply in brief.
Previous Topic: how to findout the main memory utilization by oracle
Next Topic: Connection problems on different Database (but same Oraversion)
Goto Forum:
  


Current Time: Wed May 01 07:11:52 CDT 2024