Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154

Re: ORA-12154

From: Sidhartha Sahoo <ssahoo_at_altro.com>
Date: 1997/05/30
Message-ID: <338F62EF.E9AB416D@altro.com>#1/1

CDWaddell wrote:

> What is this message and where can I find out more about messages of
> this
> nature.
>
> Thanks CDW

 altro% oerr ora 12154
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.

run the command from shell as shown Received on Fri May 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US