Oracle-MTS经过防火墙的设定
添加时间: 2008-4-20 21:57:00 作者: Oracle指导 阅读次数:20 来源: http://www.d9soft.com
如果Oracle资料库和client端连线有经过firewall，在MTS模式下连线的设定可能需要特别注意，因为就算你防火墙开通了1521 port，但是在MTS下listener会把连线要求redirect给dispatcher，而dispatcher的port又是random port，这时候你可以选择client端改用Dedicated 连线，或者修改dispatcher设定来达成正常连结，而不会出现ORA-12535: TNS:operation timed out。
1)client端改用Dedicated mode
DD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DD)
(SERVER = DEDICATED)
)
)
2)修改dispatcher固定使用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
# 开放firewall 5000 port number
上一篇文章: ORA-03113错误分析与解决 下一篇文章: Oracle中临时表的深入研究
相关软件: