TNS-01185: Registration attempted from a remote node
来源:互联网 发布:centos7 php配置文件 编辑:程序博客网 时间:2024/06/16 20:46
状况:在节点一可以监听到ASM实例和数据库实例(racdb),但是节点二就只能监听到ASM实例,监听不到节点二的实例
监听日志:
这里和 local_listener参数有关,就是设置的监听IP不对,监听IP都是 public 的 vip
我的节点2配置监听节点1的IP了(上面的监听日志是节点1 的),设置节点2监听自己的public 的 vip 就可以了
设置如下:
(节点一)
grid用户:
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(HOST=10.10.11.27)(PORT=1521))))' scope=both sid='+ASM1';
oracle用户:
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(HOST=10.10.11.27)(PORT=1521))))' scope=both sid='racdb1';
(节点二)
grid用户:
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(HOST=10.10.11.47)(PORT=1521))))' scope=both sid='+ASM2';
oracle用户:
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(HOST=10.10.11.47)(PORT=1521))))' scope=both sid='racdb2';
(这里涉及到修改每个节点的grid和oracle用户
grid是单独的,但是oracle更改如果不加scop的话,所有节点都会更改,所有oracle的需要指定节点,建议grid和oracle都要指定)
再
srvctlstop listener
srvctl stop scan_listener
srvctlstart listener
srvctl start scan_listener
======================================OK
- TNS-01185: Registration attempted from a remote node
- could not mount the diskgroup on remote node rac2 using connection service rac2:1521:+ASM2 TNS....
- PULL A NEW BRANCH FROM A REMOTE REPOSITORY
- attempted to return null from a method with a primitive return type (int).
- mybatis -----attempted to return null from a method with a primitive return type (int)
- MyBatis提示getFundBonus attempted to return null from a method with a primitive return type (double)
- attempted to return null from a method with a primitive return type (int)异常的解决
- error PRJ0019: A tool returned an error code from "Performing registration
- PRJ0019: A tool returned an error code from "Performing registration",错误处理
- C++: delete a node from linked list
- C++ delete a node from BST
- Retrieving CD Information from a remote Freedb database
- Remote EJB from a non-Java EE web container
- EJB invocations from a remote client using JNDI
- EJB invocations from a remote client using JNDI
- EJB invocations from a remote client using JNDI
- Example: Getting WMI Data from a Remote Computer
- Broker node registration、Consumer registration algorithm、Consumer rebalancing algorithm
- iphone和ipad设备分辨率
- iptables 防火墙
- 配置MacVim的Pyhton编程环境
- 关于开启VIM的Python支持
- 2014年11、12月刷题、比赛的总结与反思
- TNS-01185: Registration attempted from a remote node
- [GEngine]相机角色中间物体透明(BetweenTransparent)
- RAC TNS-1184和1185错误解决
- 使用filter配合装饰器模式实现对请求参数加密
- Connected to an idle instance
- HDU 4991 Rabbit Kingdom(二维树状数组)
- Unity3d的2D骨骼动画插件Puppet2D的 基础训练1
- Computer Identifier
- 关于myeclipse或者eclipse中导出jar包