Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

40

积分

0

好友

14

主题
1#
发表于 2012-6-13 18:47:28 | 查看: 5802| 回复: 1
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'

不知道何故。
2#
发表于 2012-6-13 20:24:20
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 通吗?


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

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 00:14 , Processed in 0.043375 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569