i have set up my listener at client side and tnsnames.ora at client side. I am using oracle 8.1.5. Clients are installed on the client machines. When i try to connect on the server with the same instructions in tnsnames.ora as in client side, it connects. But from the client's machine, it refuses...
09-26-2001, 08:08 AM
Try to ping the host. Listener is set up on the server and not the client.
listener files are in $ORACLE_HOME/network/admin.
09-26-2001, 08:11 AM
sorry, i have set up the listener on the server side only. I have also tried pinging. Even the TNSPING is working fine and giving me about 1370ms as time with ok. But still when i try to connect it says target or host object does not exist.
09-26-2001, 08:21 AM
What ORA error code do you get upon attempt to connect to the server?
09-26-2001, 08:23 AM
What error message do you get?
Can you show us the contents in your TNSNAMES.ORA file?
How do you try to connect?
09-26-2001, 08:32 AM
ora-12545 Connect failed because target host or object does not exist