-
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:
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|