About HP-UX 11.0 and Oracle's errors

[l.g]

I installed HP_UX11.0 and oracle database 8.0.5 on the workstation.
The system told me ORA-12154 error when I start the oracle database.
What means is error ORA-12154?


Thank you

[Steve Steel]

Hi

Oracle has aneat program oerr

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.
topaz:/home/oracle $


It is standard and decodes errors.

steve Steel

[Corthouts Carlo]

Hi,

Normally the error ORA-12154 means that your tnsnames.ora file,which is located in /etc, is not configured correctly or cannot be found (check if it's there or in
any other location on the management server, check if environment variable
TNS_ADMIN is set for user root).

[l.g]

Thank you
I will try it tomorrow!