Hi,
has this problem already been solved?
a) On UNIX you may get informations on errors with the OERR function:
> 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.
b) Use SQL*Plus to check your TNS connections:
> sqlplus scott/[EMAIL PROTECTED]
where your_sid is the alias in your tnsnames.ora configuration file residing
in $ORACLE_HOME/network/admin
your_sid = ( DESCRIPTION = ......
)
cu, Christian
----- Original Message -----
From: "Moon, Larry (Cont,ARL/CISD)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 27, 2003 11:55 PM
Subject: ORA Error
Hi,
1. Could someone please lend me the benefit of their knowledge
regarding an oracle error I received when I was attempting to connect to
an oracle database via a perl script? Actually I got two errors on that
told me that the "'old style' syntax" for connecting wouldn't be
supported in future and an ORA 12154 error indicating that the TNS
service could not be resolved. The following text was also at the end
of the error "( DBD ERROR: OCIServerAttach)".
2. Can you tell me if this can be easily fixed and what I need
to do to get it to behave properly?
Thanking You,
Larry Moon
