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 220.127.116.11 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