asm遠(yuǎn)程連接可能會(huì)遇到以下報(bào)錯(cuò)：

在朔城等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場(chǎng)前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供做網(wǎng)站、成都網(wǎng)站制作 網(wǎng)站設(shè)計(jì)制作專業(yè)公司,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站設(shè)計(jì),成都全網(wǎng)營(yíng)銷,外貿(mào)網(wǎng)站制作,朔城網(wǎng)站建設(shè)費(fèi)用合理。

ORA-12505 TNS:listener could not resolve SID given in connect descriptor
ORA-12541: TNS:no listener
ORA-15000: command disallowed by current instance type
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-1031:   insufficient privileges

asm遠(yuǎn)程連接配置如下:
參數(shù)配置：

remote_login_passwordfile = exclusive ... for stand alone ASM setups
remote_login_passwordfile = shared ... for ASM setups that also use Real Application Cluster (RAC)

節(jié)點(diǎn)1：

[oracle@prodb1 admin]$ cat listener.ora 
SID_LIST_LISTENER_prodb1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
     (SID_DESC =
       (SID_NAME = +ASM1)  
       (GLOBAL_DBNAME  = +ASM)  
       (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
    )
  )

LISTENER_prodb1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prodb1-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521)(IP = FIRST))
    )
  )

節(jié)點(diǎn)2：

[oracle@prodb2 admin]$ cat listener.ora 

SID_LIST_LISTENER_prodb2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
     (SID_DESC =
       (SID_NAME = +ASM2)  
       (GLOBAL_DBNAME  = +ASM)  
       (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
    )
  )

LISTENER_prodb2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = prodb2-vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521)(IP = FIRST))
    )
  )

客戶端tnsname.ora:

ASM1 =  
   (DESCRIPTION =  
     (ADDRESS_LIST =  
       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521))  
     )  
     (CONNECT_DATA =  
       (SERVICE_NAME = +ASM)  
    (UR=A)
     )  
   )  

ASM2 =  
   (DESCRIPTION =  
     (ADDRESS_LIST =  
       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521))  
     )  
     (CONNECT_DATA =  
       (SERVICE_NAME = +ASM)  
    (UR=A)
     )  
   )

ASM =  
   (DESCRIPTION =  
     (ADDRESS_LIST =  
       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521))  
       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521))
     )  
     (CONNECT_DATA =  
       (SERVICE_NAME = +ASM)  
    (UR=A)
     )  
   )

關(guān)鍵部分為 (UR=A)，如果不配置該選項(xiàng)，則連接的時(shí)候報(bào)：

$ sqlplus sys/admin@asm1 as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on чǚ? 7? 5 21:44:30 2018

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

UR=A選項(xiàng)通常用來(lái)連接使用nomount，mount或restricted模式啟動(dòng)數(shù)據(jù)庫(kù)。

數(shù)據(jù)庫(kù)啟動(dòng)到nomount，監(jiān)聽(tīng)狀態(tài)為BLOCKED；
數(shù)據(jù)庫(kù)啟動(dòng)到mount，監(jiān)聽(tīng)狀態(tài)為READY；
數(shù)據(jù)庫(kù)啟動(dòng)到restrict，監(jiān)聽(tīng)狀態(tài)為RESTRICT;
靜態(tài)注冊(cè)的asm為BLOCKED

參考自：How to connect to ASM instance from a remote client (Oracle Net) (文檔 ID 340277.1)

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

本文名稱：oracle10g遠(yuǎn)程連接asm-創(chuàng)新互聯(lián)
網(wǎng)站地址：http://weahome.cn/article/dhccdh.html