服务器配置
找到ASM实例的LISTENER.ORA文件,在目录$ORACLE_HOME\network\admin下,进行如下修改:增加监听器(下面红色部分),增加监听描述(绿色部分,注意这是静态参数),然后重启监听。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2.0/asm)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME = /oracle/product/10.2.0/asm)
(SID_NAME = +ASM)
)
)
LSNRASM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhp)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)客户端配置
注意红色部分:
ASM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhp)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
(UR=A)
)
)
客户端连接
SQLPLUS sys/passwd@asm as sysdba
上面的有点不对
http://hi.baidu.com/danghj/blog/item/d666ce88e037ce9fa4c27252.html
oracle_sid 还得改回来
ASM_172.22.11.124 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.11.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = danghj)
(UR=A)
)
)
正常运行的 lsnrctl stutas
Services Summary...
Service "+ASM" has 2 instance(s).
Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "danghj" has 1 instance(s).
Instance "danghj", status READY, has 1 handler(s) for this service...
Service "danghjXDB" has 1 instance(s).
Instance "danghj", status READY, has 1 handler(s) for this service...
Service "danghj_XPT" has 1 instance(s).
Instance "danghj", status READY, has 1 handler(s) for this service...
The command completed successfully