oracle+登录asm实例,非本机远程登录ASM实例 How to Login ASM remotely

正常情况下，ASM instance只被Database instance在本地访问，但特殊情况下也会有特殊需求吧，下面就是从设置远程登录的方法。

大家也可以从metalink上找到原版的。

DOC ID:340277.1

Keyword: ORA-12541, ORA-15000, ORA-12528

Solution:

1. Edit listener.oraAdd

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

#(SERVICE_NAME = +ASM1) 这里Metalink用的是SERVICE_NAME，不知道为什么

#我用的不管用，所以用了SID_NAME

(ORACLE_HOME = /oracle/product/10.2.0/db_1)

(SID_NAME = +ASM1)

)

)

#检查Listner工作状态lsnrctl status

...

Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...

Service "+ASM_XPT" has 1 instance(s).

...

2. Edit tnsnames.oraASM1 =

(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=