歡迎您光臨本站 註冊首頁

關於RedHat Linux AS3 雙機RAC節點連接的問題

←手機掃碼閱讀     火星人 @ 2014-03-04 , reply:0

關於RedHat Linux AS3 雙機RAC節點連接的問題

RedHat Linux AS3 雙機RAC
經過一段時間的監測,發現web伺服器在連接資料庫的時候
基本上全部連接在了節點1上,節點2基本沒有連接
web伺服器是用weblogic做的服務
網站用java編寫,是java連接的問題
還是RAC的監聽問題?有知道的給些提示阿

------------------
Listener.ora 配置  
LISTENER =  
(DESCRIPTION_LIST =   
(DESCRIPTION =      
(ADDRESS_LIST =        
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     
)      
(ADDRESS_LIST =        
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.220)(PORT = 1521))      
)   
)  
)
SID_LIST_LISTENER =
(SID_LIST =   
(SID_DESC =      
(SID_NAME = PLSExtProc)      
(ORACLE_HOME = /opt/ora9/product/9.2)      
(PROGRAM = extproc)   
)   
(SID_DESC =      
(GLOBAL_DBNAME = orcl)     
(ORACLE_HOME = /opt/ora9/product/9.2)     
(SID_NAME = orcl1)  
)  
)


-----------------
tnsnames.ora配置
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.220)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521))
(LOAD_BALANCE = on)
(FAILOVER = on)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
(FAILOVER_MODE = (TYPE = session)
(METHOD = basic)
)
)
)
ORCL2 =
(DESCRIPTION =   
(ADDRESS_LIST =      
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.221)(PORT = 1521))   
)   
(CONNECT_DATA =     
(SID = orcl2)     
(SERVER = DEDICATED)   
)  
)
ORCL1 =  
(DESCRIPTION =   
(ADDRESS_LIST =   
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.220)(PORT = 1521))   
)   
(CONNECT_DATA =      
(SID = orcl1)      
(SERVER = DEDICATED)   
)  
)
《解決方案》

關於RedHat Linux AS3 雙機RAC節點連接的問題

很可能是名字解析的問題,我遇到過了,windows的server上加上hosts解析

[火星人 ] 關於RedHat Linux AS3 雙機RAC節點連接的問題已經有497次圍觀

http://coctec.com/docs/service/show-post-10173.html