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@(protected)]
Sent: Saturday, September 25, 2004 4:34 AM
To: oracle-l@(protected)
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 (See ORA-12545.ora-code.com). 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!
