Tnsping OK but SQLPLUS connection fails
Client Machine: Windows 2000 Oracle 8.1.5
Server : Windows 2000 Oracle 8.17
Tnsping from client to Server is fine but SQLPLUS connection fails.
Please help/suggest a solution.
The only port open is 1521
TNSNAMES.ora entry on client:
(ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDRESS)(PORT = 1521))
(SERVICE_NAME = DB.DOMAIN)
TNS Ping Utility for 32-bit Windows: Version 220.127.116.11.0 - Production on 07-DEC-05 09:48:21
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=IP_ADDRESS)(PORT=1521))
OK (10 msec)
SQL*Plus: Release 18.104.22.168.0 - Production on Wed Dec 7 10:07:08 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> conn user/pwd@aspfizer
ORA-12535: TNSperation timed out
you cant have just port 1521 open, only the initial communication is done over port 1521, a random port is subsequently used.
You need connection manager or shared sockets or something like that to make this work
So is there a range of ports that need to be open, if yes what can they be OR where can I find that info.
sort out connection manager and you define your ports (same with shared sockets)
When you do a tnsping, it just pings your listener to see whether the listener can be reached using the parameter that you have povided on the service name on the tnsnames.ora file. Since this error seems to point us in the direction of timing out, check the listener.ora file for the CONNECT_TIMEOUT. IF that was set in there, then your network is failing to establish your connection within that time frame.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width