SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle Connectivity

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Oracle Connectivity
Author Message
Shawn A. Odom



Joined: 16 Jan 2000
Posts: 2

Post Oracle Connectivity Reply with quote

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.


Mon Oct 09, 2000 5:09 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: Oracle Connectivity Reply with quote

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.

Mon Oct 09, 2000 9:19 pm View user's profile Send private message
Shawn A. Odom



Joined: 16 Jan 2000
Posts: 2

Post Re: Oracle Connectivity Reply with quote

I searched on the filename, tnsnames.ora, and found that there is another file within the OEM home directory. I copied my entries from the tnsnames.ora within the Oracle815 home directory and it appeared to solve the issue. Thanks for your help!

: 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.

Tue Oct 10, 2000 11:10 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.