Re: TNS Resolution
- From: "M Rafiq" <rafiq9857@xxxxxxxxxxx>
- To: gogala@xxxxxxxxxxxxx, knightjck_work@xxxxxxxxx
- Date: Wed, 18 Jan 2006 15:40:17 -0500
Mladen Gogala,
WELCOME BACK -:))))))))))))))))))))))))))))))). Nice to see your message
again. Don't get frustrated again.
Regards
Rafiq
From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
Reply-To: gogala@xxxxxxxxxxxxx
To: knightjck_work@xxxxxxxxx
CC: Oracle Mailing List <oracle-l@xxxxxxxxxxxxx>
Subject: Re: TNS Resolution
Date: Wed, 18 Jan 2006 11:24:35 -0500
On 01/18/2006 10:50:53 AM, Jonathan Knight wrote:
I have a strange (to me anyway) problem with TNS.
The problem is not strange. It is a configuration problem.
Connecting with SQL*Plus, SQL*Navigator, TOAD: I get
"ORA-12154: TNS:could not resolve service name"
You should kiss the toad and fix your tnsnames.ora
But, tnsping returns in 100-130 msecs. ?!?!?!
The tnsping contacts the listener. If the listener is there, TNSPING is
successful. Service name, on the other hand, is a property of an
instance, not listener.
I'm confused. Any thoughts?
Jonathan, your TNS descriptor should look something like this:
O10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
(SEVER = DEDICATED)
)
)
To be able to connect, your database must have service name defined like
this:
SQL> show parameter service_names
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
service_names string oracle
SQL>
Your problem is that the database doesn't have the same service name
as your tnsnames.ora. What you need to do is either to change SERVICE_NAME
into SID and then put the appropriate SID or set SERVICE_NAME to the value
exported by the instance. If your database isn't RAC, in which case several
instances may have the same value for the service_name both methods are
equivalent. From the aesthetic point of view service name is strongly
preferred, at least by me.
--
Mladen Gogala
http://www.mgogala.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: