ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 非本机登录ASM实例 How to Login ASM remotely

非本机登录ASM实例 How to Login ASM remotely

原创 Linux操作系统 作者:yexichang 时间:2009-04-23 17:46:02 0 删除 编辑

In common, ASM instance is only access by database instance.
DOC ID:340277.1
Keyword: ORA-12541, ORA-15000, ORA-12528

Solution:
1. Edit listener.ora
Add
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      #(SERVICE_NAME = +ASM1)
      (ORACLE_HOME = /oracle/product/10.2.0/db_1)
      (SID_NAME = +ASM1)
    )
  )

Check
lsnrctl status
...
  Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
...

2. Edit tnsnames.ora
ASM1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rac01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM_XPT)
      (UR=A)
    )
  )

3. set remote_login_passwordfile = exclusive
4. Under $ORACLE_HOME/dbs
orapwd file=orapw+ASM1 password=

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/317003/viewspace-591615/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 查询等待的session
请登录后发表评论 登录
全部评论

注册时间:2008-08-30

  • 博文量
    32
  • 访问量
    35109