ORA-12528處理一例

今天在作RAC的備份恢複測試(用veritas),測試的同事說RMAN無法使用,我串連進去之後發現如下問題:
[oracle@racdb01 ~]$srvctl stop database -d rac
[oracle@racdb01 ~]$srvctl start database -d rac -o nomount
[oracle@racdb01 ~]$RMAN
RMAN> connect target sys/orale@rac1
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR racSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
 
RMAN>
在網上找了一篇文章,說是listener要修改成靜態註冊,並給出了測試結果,比照他的方法,果然成功.

增加紅色部分

[oracle@racdb01 ~]$ vi /u01/oracle/product/10.2/db1/network/admin/listener.ora
SID_LIST_LISTENER_rac_racDB01 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/oracle/product/10.2/db1/)
      (PROGRAM = extproc)
    )
  (SID_DESC =
      (GLOBAL_DBNAME = rac)
      (ORACLE_HOME = /u01/oracle/product/10.2/db_1)
      (SID_NAME = rac1)
    )
 
  )
[oracle@racdb01 ~]$ vi /u01/oracle/product/10.2/db1/network/admin/tnsnames.ora

rac1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racdb01-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = rac)
      (INSTANCE_NAME = rac1)
     (UR=A)
    )
  )

[oracle@racdb01 ~]$lsnrctl
LSNRCTL>
LSNRCTL> stop
LSNRCTL> start

RMAN> connect target sys/oracle@rac1
 
connected to target database: rac (not mounted)
 
RMAN>