配置DataGuard時報ORA-12528
說明:在DataGuard的搭建中,運行rman恢複的時候報錯ORA-12528的錯誤;
指令碼如下:RMAN> connect auxiliary sys/Oracle@SCMPRD02
解決步驟:
1、檢查監聽是否啟動,指令碼:tnsping SCMPRD02
方法一:設定資料庫的監聽為靜態參數步驟:在ORACLE_HOME/network/admin 下面檢查是否有listener.ora參數檔案,如果沒有的話運行netca建立資料庫的監聽,配置完成的監聽檔案如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SCMPRDDB02)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
方法二:修改tnsnames.ora檔案
SCMPRD02 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)(HOST = WELL)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED) (
SERVICE_NAME = SCMPRD02)
(UR = A) //增加該備忘//
)
)
總結:ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Cause:All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.Action:Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.
因為我們複製資料庫只是在nomount下開啟,而資料庫並沒有mount,在11g下所有的監聽都是動態監聽,而只有在資料庫mount以後,PMON進程起來以後,才能動態註冊。所以對次要資料庫沒有辦法註冊,只能被鎖住。
所以修改資料庫的監聽為靜態監聽,或者增加(UR=A)即可解決問題;
在CentOS 6.4下安裝Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虛擬機器中安裝步驟
Debian 下 安裝 Oracle 11g XE R2
Oracle Data Guard 重要配置參數
基於同一主機配置 Oracle 11g Data Guard
探索Oracle之11g DataGuard
Oracle Data Guard (RAC+DG) 歸檔刪除策略及指令碼
Oracle Data Guard 的角色轉換
Oracle Data Guard的日誌FAL gap問題
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 處理方法