oracle 11g RAC 更改了remote_listener参数后EM出问题，日志：ORA-12514, TNS:listener does not cu

[kevin_LCC]

[size=14px]oracle 11g RAC 做基于服务端vip的负载均衡，更改remote_listener参数后，EM登入后总说数据库已关闭

先前remote_listener参数为 rac-scan:1521
但是数据库和实例是已经打开的，查看日志报错：
[oracle@rac01 ~]$ tail -1200f /u01/app/oracle/product/11.2.0.3/db_1/rac01_racdb/sysman/log/emoms.log

2015-01-22 04:28:37,750 [HTTPThreadGroup-2] ERROR eml.OMSHandshake processFailure.808 - OMSHandshake failed.(AGENT URL = https://rac02:3938/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
rac-scan:1521/racdb
)
2015-01-22 04:28:37,839 [HTTPThreadGroup-2] ERROR conn.ConnectionService verifyRepositoryEx.891 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
rac-scan:1521/racdb

2015-01-22 04:28:37,842 [HTTPThreadGroup-2] ERROR eml.OMSHandshake processFailure.808 - OMSHandshake failed.(AGENT URL = https://rac02:3938/emd/main)(ERROR = INTERNAL_ERROR)(CAUSE =java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
rac-scan:1521/racdb
)


服务器配置
(1) 修改两个节点的tnsnames.ora文件如下：
# tnsnames.ora Network Configuration File: /orac/orahome/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)
RACDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
)

RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)

LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
)

(2) 在初始化参数中设置参数remote_listeners
oracle # sqlplus /nolog
conn /as sysdba
SQL> alter system set remote_listener='LISTENERS_RACDB' sid='*';


就是更改了这个之后EM出错的，改回来马上就好了。


有谁遇到过这个问题吗？能帮忙解决下，非常感激！！！
[/size]

[kevin_LCC]

已经解决：http://blog.csdn.net/kevin_lcc/article/details/43012571

[bw555]

自己动手，丰衣足食，呵呵