(這個(gè)有問(wèn)題)
服務(wù)器配置
找到ASM實(shí)例的LISTENER.ORA文件,在目錄$ORACLE_HOME\network\admin下,進(jìn)行如下修改:增加監(jiān)聽(tīng)器(下面紅色部分),增加監(jiān)聽(tīng)描述(綠色部分,注意這是靜態(tài)參數(shù)),然后重啟監(jiān)聽(tīng)。
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
上面的有點(diǎn)不對(duì)
http://hi.baidu.com/danghj/blog/item/d666ce88e037ce9fa4c27252.html
oracle_sid 還得改回來(lái)
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)
)
)
正常運(yùn)行的 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
服務(wù)器配置
找到ASM實(shí)例的LISTENER.ORA文件,在目錄$ORACLE_HOME\network\admin下,進(jìn)行如下修改:增加監(jiān)聽(tīng)器(下面紅色部分),增加監(jiān)聽(tīng)描述(綠色部分,注意這是靜態(tài)參數(shù)),然后重啟監(jiān)聽(tīng)。
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
上面的有點(diǎn)不對(duì)
http://hi.baidu.com/danghj/blog/item/d666ce88e037ce9fa4c27252.html
oracle_sid 還得改回來(lái)
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)
)
)
正常運(yùn)行的 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
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號(hào)聯(lián)系: 360901061
您的支持是博主寫(xiě)作最大的動(dòng)力,如果您喜歡我的文章,感覺(jué)我的文章對(duì)您有幫助,請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長(zhǎng)非常感激您!手機(jī)微信長(zhǎng)按不能支付解決辦法:請(qǐng)將微信支付二維碼保存到相冊(cè),切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對(duì)您有幫助就好】元
