正常情况下,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=