Oracle 10g RAC ASM Instance Conenction ORA-12528

最新推荐文章于 2021-05-02 03:44:45 发布

deanza

最新推荐文章于 2021-05-02 03:44:45 发布

阅读量1.1k

点赞数

本文链接：https://blog.csdn.net/deanza/article/details/24539479

版权

ORA-xxx 同时被 3 个专栏收录

24 篇文章 1 订阅

订阅专栏

Oracle ASM Storage

12 篇文章 0 订阅

订阅专栏

Oracle Monitor

12 篇文章 0 订阅

订阅专栏

Oracle 10g RAC的ASM实例有时需要通过第三方的客户端工具去连接，或者监控，但默认条件下，10g的ASM是无法实现远程连接的，报错ORA-12528。
参考了Jeffrey M. Hunter的这篇文章http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_45.shtml，帮助完成了ITM对ASM的监控。

1，修改2个节点的listener.ora文件，静态注册ASM到监听。

LISTENER_LINUX1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux1-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)(IP = FIRST))
    )
  )

SID_LIST_LISTENER_LINUX1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME  = +ASM)
      (SID_NAME       = +ASM1)
      (ORACLE_HOME    = /u01/app/oracle/product/10.2.0/db_1)
    )
  )

LISTENER_LINUX2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linux2-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)(IP = FIRST))
    )
  )

SID_LIST_LISTENER_LINUX2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME  = +ASM)
      (SID_NAME       = +ASM2)
      (ORACLE_HOME    = /u01/app/oracle/product/10.2.0/db_1)
    )
  )

2，重启监听服务。

# -----------
# FROM linux1
# -----------
[oracle@linux1 ~]$ lsnrctl stop LISTENER_LINUX1
[oracle@linux1 ~]$ lsnrctl start LISTENER_LINUX1

# -----------
# FROM linux2
# -----------
[oracle@linux2 ~]$ lsnrctl stop LISTENER_LINUX2
[oracle@linux2 ~]$ lsnrctl start LISTENER_LINUX2

3，查看监听

# -----------
# FROM linux1
# -----------
[oracle@linux1 ~]$ lsnrctl status LISTENER_LINUX1 | grep ASM
Service "+ASM" has 2 instance(s).
  Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

# -----------
# FROM linux2
# -----------
[oracle@linux2 ~]$ lsnrctl status LISTENER_LINUX2 | grep ASM
Service "+ASM" has 2 instance(s).
  Instance "+ASM2", status UNKNOWN, has 1 handler(s) for this service...
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
  Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...