RE: unable to tns ping <URGENT?

From: Stevens, Ed <ED.STEVENS_at_NMM.NISSAN-USA.COM>
Date: Mon, 27 Sep 2004 08:14:00 -0500
Message-ID: <D95631492847D511A32E00B0D0D02E8E08B5F6E5@nmmset01.nmm.nna>

Your statement that "Listener is started at both server and client sides." leads me to believe that you are more confused than you think ;-)

There is no listener on the client side. Well, there may be, but it is not an issue. Show us the actual contents of the tnsnames.ora and sqlnet.ora files on your client, and listener.ora and sqlnet.ora on the server. Also, the output of 'lsnrctl status' on the server.

-----Original Message-----
From: phani krishna [mailto:dbaphani_at_yahoo.com] Sent: Saturday, September 25, 2004 4:34 AM To: oracle-l_at_freelists.org
Subject: unable to tns ping <URGENT?  

Hi,  

im trying to connect only to a particular database remotely as a client with orcl 9.2.0.4 WITH WIN 2K  

Listener is started at both server and client sides. tnsnames.ora is edit occardingly.
host_id abc
Service_name: XYZ
Steps followed:  

CONFIGURED LISTENER WITH FOLLOWING STEPSFrom client:
* Oracle Net configuration.

• Local Net Service Name Configuration
• ADD -> Service_name: XYZ
• TCP
• HOSTNAME: ABC
• Use the standard port number 1521
• YES, perform a TEST TEST ERROR: CONNECTING ORA-12545. CONNECT FAILED BECAUSE TARGET HOST OR OBJECT DOES NOT EXIST

TNSPING pidb
TNS-12541 NO LISTENER   thanks in advance  

• phani.

  ---

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 27 2004 - 08:10:11 CDT