关于RedHat Linux AS3 双机RAC节点连接的问题

Question

RedHat Linux AS3 双机RAC
经过一段时间的监测，发现ｗｅｂ服务器在连接数据库的时候
基本上全部连接在了节点１上，节点２基本没有连接
ｗｅｂ服务器是用ｗｅｂｌｏｇｉｃ做的服务
网站用ｊａｖａ编写，是ｊａｖａ连接的问题
还是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)   
)  
)

Answer 1

很可能是名字解析的问题，我遇到过了，windows的server上加上hosts解析