ORA-12535 Error: Tns:operation timed out

If the Oracle database and client-side connections are firewall, setting up the wiring in MTS may require special attention, because even if your firewall has 1521 port, However, under MTS listener will be required to redirect to dispatcher, and dispatcher port is random port, at this time you can choose the client side instead of dedicated connection, or modify the dispatcher settings to achieve a normal link, without the presence of ora-12535:tns:operation timed out.

1 Client-side switch to dedicated mode

DD =

(DESCRIPTION =

(Address_list =

(address = (PROTOCOL = TCP) (HOST = 192.168.1.1) (PORT = 1521))

)

(Connect_data =

(SID = DD)

(SERVER = dedicated)

)

)

2) Modify Dispatcher fixed use port number

# VI Initsid.ora

*.dispatchers= "(Address= (PROTOCOL=TCP) (port=5000)) (dispatchers=3)"

# Restart Instance

# sql> Select Name,network from V$dispatcher

NAME Network

---- --------------------------------------------------

D000 (address= (protocol=tcp) (HOST=ORA1) (port=5000))

D001 (address= (protocol=tcp) (port=5000))

D002 (address= (protocol=tcp) (port=5000))

# Netstat-al |grep 5000

TCP 0 0 *:5000 *:* LISTEN

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/