rac 环境TNS-01184, TNS-01185

taoy_2008

aix 平台 11.2.0.3.0 rac数据库上，/oracle/oracle/diag/tnslsnr/xhoradb1/listener/trace 路径下的listener.log 日志文件一致提示下面错误。增长很快。
TNS-01184: Listener rejected registration or update of service handler "DEDICATED"
TNS-01185: Registration attempted from a remote node
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.128.16)(PORT=1521)))
13-JUN-2012 18:40:30 * service_died * +ASM2 * 12537
13-JUN-2012 18:40:31 * service_update * ora1 * 0
13-JUN-2012 18:40:31 * service_update * ora1 * 0
13-JUN-2012 18:40:39 * service_update * orcl2 * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.128.16)(PORT=1521)))
13-JUN-2012 18:40:39 * service_register * orcl2 * 1184
TNS-01184: Listener rejected registration or update of service handler "DEDICATED"
TNS-01185: Registration attempted from a remote node
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.128.16)(PORT=1521)))
13-JUN-2012 18:40:39 * service_died * orcl2 * 12537
Wed Jun 13 18:40:46 2012

解决方法：
分别在两个节点TNSNAMES.ORA添加如下：
1. Example TNSNAMES.ORA entries for two node cluster, Node1 & Node2
Two Local listener entries, followed by remote listener entry LISTENER_LOCAL1=
(ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521))
LISTENER_LOCAL2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521))

LISTENERS_REMOTE =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521))
)
2. Then in sqlplus
sqlplus /nolog
SQL> connect / as sysdba
SQL> alter system set LOCAL_LISTENER='LISTENER_LOCAL1' scope=both sid='Instance1';
SQL> alter system set LOCAL_LISTENER='LISTENER_LOCAL2' scope=both sid='Instance2';
SQL> alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both;

在两节点执行 alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both;
提示下面错误：
SQL>  alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both;
alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_REMOTE'

不知道何故。

Maclean Liu(刘相兵

SQL> alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both;
alter system set REMOTE_LISTENER='LISTENERS_REMOTE' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_REMOTE'


你确定这个 LISTENERS_REMOTE 可以被tnsping 通吗？


还有这个问题 和 性能优化 有什么关系？  至少把问题分类高清楚， 不要浑浑噩噩地过日子！