TNS-12535: TNS:operation timed out
mosleeFeb 4 2013 — edited Mar 6 2013Hi to all
I have been trying to connect a db(ATDMPQA Oracle 9i) from this current 10g db but I encounter TNS-12535: TNS:operation timed out. Please help as I really cannot figure where the mistake was... Thanks.
C:\Documents and Settings\Administrator>tnsping atdmpqa
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 04-FEB-2
013 17:18:10
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = o3_
ora.NECSS.NEC.COM.SG) (PROTOCOL = TCP) (Host = 138.141.10.5) (Port = 1531))) (CO
NNECT_DATA = (SID = ATDMP) (GLOBAL_NAME = ATDMP.NECSS.NEC.COM.SG)))
TNS-12535: TNS:operation timed out
In Tnsnames.ora, i stated
-----------------------------------
ATDMPQA.NECSS.NEC.COM.SG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = o3_ora.NECSS.NEC.COM.SG)
(PROTOCOL = TCP)
(Host = 138.141.10.5)
(Port = 1531)
)
)
(CONNECT_DATA =
(SID = ATDMP)
(GLOBAL_NAME = ATDMP.NECSS.NEC.COM.SG)
)
)
In Sqlnet.ora, i stated
------------------------------
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = NECSS.NEC.COM.SG
NAME.DEFAULT_ZONE = NECSS.NEC.COM.SG
SQLNET.CRYPTO_SEED = "-1617985050-1384208265"
NAMES.DIRECTORY_PATH = (TNSNAMES)
Edited by: moslee on Feb 4, 2013 1:22 AM