Re: TNS:could not resolve service name ERROR - HELP

From: MarkP28665 <markp28665_at_aol.com>
Date: 1998/03/15
Message-ID: <19980315184501.NAA08337@ladder01.news.aol.com>#1/1

From: "Bob Duncan" <rduncan_at_dsi-inc.com> >> ERROR: ORA-12154: TNS:could not resolve service name <<

You did not specify if you are connecting to a local or remote database under Unix, VMS, or NT, but try the following:

Look in the tnsnames.ora file for the Oracle sid that your trying to connect to and verify that A) the entry is there and B) that the port address listed in the entry, is the address used by the instance. The tnsnames file can be in any of several places based on the environment. We have ours Unix: /var/opt/oracle

                                                     VMS 

ora_root/network/admin

If the local tnsnames.ora appears OK, then check the listener.ora file for the instance for the matching sid entry.

All this assumes you are referencing the correct sid to begin with.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Sun Mar 15 1998 - 00:00:00 CST