RE: unable to tns ping <URGENT?

  • From: "Stevens, Ed" <ED.STEVENS@xxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 27 Sep 2004 08:14:00 -0500

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@xxxxxxxxx]
Sent: Saturday, September 25, 2004 4:34 AM
To: oracle-l@xxxxxxxxxxxxx
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!

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

Other related posts: