遠端連接配接ASM執行個體總結

（這個有問題）

伺服器配置

找到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)

(SID_NAME = +ASM)

LSNRASM =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = dbhp)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)用戶端配置

注意紅色部分：

ASM =

(ADDRESS_LIST =

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

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.11.124)(PORT = 1521))

(SERVICE_NAME = danghj)

正常運作的 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).

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).

Service "danghj_XPT" has 1 instance(s).

The command completed successfully