Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TNS-12535: TNS:operation timed out

mosleeFeb 4 2013 — edited Mar 6 2013
Hi 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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 3 2013
Added on Feb 4 2013
#general-database-discussions
34 comments
14,669 views