Oracle10g Rac ora-12545
来源:互联网 发布:mp288正版清零软件 编辑:程序博客网 时间:2024/05/23 13:30
错误描述,RAC安装完成后,客户端有一定几率链接失败,报错如下:
ERROR:
ORA-12545: 因目标主机或对象不存在,连接失败
环境中安装RAC Database时候忘记了先配置netca。
故注册下LOCAL_LISTENER
如下:
代码
1 1,在node1,node2上分别编辑服务器端tnsname.ora (注意,是服务器端的)
2 将下面部分
3 LISTENERS_TEST =
4 (ADDRESS_LIST =
5 (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
6 (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
7 )
8 改为:
9 LISTENERS_TEST =
10 (ADDRESS_LIST =
11 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.19)(PORT = 1521))
12 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.20)(PORT = 1521))
13 )
14 也就是将vip主机名改为ip地址
15
16 2.在node1上增加以下部分
17 LOCAL_LISTENER =
18 (ADDRESS_LIST =
19 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.9)(PORT = 1521))
20 )
21
22 3.在node2上增加以下部分
23 LOCAL_LISTENER =
24 (ADDRESS_LIST =
25 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.10)(PORT = 1521))
26 )
27
28 4,用system用户登录
29 执行
30 alter system set local_listener='LOCAL_LISTENER' scope=both;
31
32 5 重启所有实例 所有监听.
2 将下面部分
3 LISTENERS_TEST =
4 (ADDRESS_LIST =
5 (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
6 (ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip)(PORT = 1521))
7 )
8 改为:
9 LISTENERS_TEST =
10 (ADDRESS_LIST =
11 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.19)(PORT = 1521))
12 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.20)(PORT = 1521))
13 )
14 也就是将vip主机名改为ip地址
15
16 2.在node1上增加以下部分
17 LOCAL_LISTENER =
18 (ADDRESS_LIST =
19 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.9)(PORT = 1521))
20 )
21
22 3.在node2上增加以下部分
23 LOCAL_LISTENER =
24 (ADDRESS_LIST =
25 (ADDRESS = (PROTOCOL = TCP)(HOST = 201.150.14.10)(PORT = 1521))
26 )
27
28 4,用system用户登录
29 执行
30 alter system set local_listener='LOCAL_LISTENER' scope=both;
31
32 5 重启所有实例 所有监听.
还有一种办法是客户端修改hosts,把vip的命名解析加进去。但是不推荐。
以上主要解决Oracle bug:可以参考metalink 文档ID: 364855.1
- Oracle10g Rac ora-12545
- Oracle10g Rac ora-12545
- oracle10g的rac中,客户端连接报ora-12545错误
- AIX+ORACLE10g RAC ORA-04030 问题解决过程
- 【Oracle】RAC ORA-12545问题解决
- Oracle10g Rac Add Node
- ORACLE10g修改RAC VIP
- oracle10g rac部署文档
- ORACLE10g修改RAC VIP
- Oracle10g RAC删除节点
- RAC连接的问题ORA-12545
- RAC连接的问题ORA-12545
- RAC连接的问题ORA-12545
- oracle11gR2 RAC连接时ORA-12545错误
- RAC连接的问题ORA-12545
- Oracle10g的ORA-3136
- 【ORACLE RAC】配置oracle10g rac的脚本
- Oracle10g RAC 环境日常管理
- oracle10g中文乱码问题
- 2011-9-19 18:33:09
- Ubuntu install macbuntu,system not supported error
- 使用BCGControlBar界面库时的预写注册表问题
- Immersive Labs开发了基于摄像头的精准广告定位技术
- Oracle10g Rac ora-12545
- struts2中OGNL表达式的使用
- VC常用系统对话框(保存 打开 目录)
- 最大公约数——gcd
- android style
- struts2标签的使用
- STL 入门学习笔记一
- ext 4.0 学习笔记(1)Array Grid
- struts2