Tnsping OK but SQLPLUS connection fails

[daljitsb]

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:

DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP_ADDRESS)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DB.DOMAIN)
)
)

--------
TNS Ping Utility for 32-bit Windows: Version 8.1.5.0.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 8.1.5.0.0 - Production on Wed Dec 7 10:07:08 2005

(c) Copyright 1999 Oracle Corporation. All rights reserved.

SQL> conn user/pwd@aspfizer
ERROR:
ORA-12535: TNSperation timed out

Thanks
-D

[davey23uk]

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

[daljitsb]

Thanks
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.

-D

[davey23uk]

sort out connection manager and you define your ports (same with shared sockets)

[sambavan]

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.