Are you sure you found the right file? Are there multiple Oracle homes? Here is the full description for ORA-12154
ORA-12154 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 Administrator's Guide. If possible regenerate the configuration files using the Oracle Network Manager. : I have attempted to connect to several of our instances, and have been
: successful using both the O84 Oracle 8.0.4 - 8.1.x and ODBC methods.
: However, neither of them seem to be stable. They work for a few
: connections and then I get the following message: Database not available.
: ORA-12154: TNS:could not resolve service name : I have checked my client tnsnames.ora file. Everything matches from the
: client to the server.
|
