說(shuō)明：在DataGuard的搭建中，運(yùn)行rman恢復(fù)的時(shí)候報(bào)錯(cuò)ORA-12528的錯(cuò)誤；
腳本如下：RMAN> connect auxiliary sys/Oracle@SCMPRD02
解決步驟：
1、檢查監(jiān)聽(tīng)是否啟動(dòng)，腳本：tnsping SCMPRD02
方法一：配置數(shù)據(jù)庫(kù)的監(jiān)聽(tīng)為靜態(tài)參數(shù)步驟：在ORACLE_HOME/network/admin 下面檢查是否有l(wèi)istener.ora參數(shù)文件，如果沒(méi)有的話(huà)運(yùn)行netca創(chuàng)建數(shù)據(jù)庫(kù)的監(jiān)聽(tīng)，配置完成的監(jiān)聽(tīng)文件如下：
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) //增加該備注//
)
)
總結(jié)：ORA-12528: TNS:listener: all appropriate instances are blocking new connections
因?yàn)槲覀儚?fù)制數(shù)據(jù)庫(kù)只是在nomount下打開(kāi)，而數(shù)據(jù)庫(kù)并沒(méi)有mount,在11g下所有的監(jiān)聽(tīng)都是動(dòng)態(tài)監(jiān)聽(tīng)，而只有在數(shù)據(jù)庫(kù)mount以后，PMON進(jìn)程起來(lái)以后，才能動(dòng)態(tài)注冊(cè)。所以對(duì)輔助數(shù)據(jù)庫(kù)沒(méi)有辦法注冊(cè)，只能被鎖住。所以修改數(shù)據(jù)庫(kù)的監(jiān)聽(tīng)為靜態(tài)監(jiān)聽(tīng)，或者增加（UR=A)即可解決問(wèn)題。謝謝閱讀，希望能幫到大家，請(qǐng)繼續(xù)關(guān)注腳本之家，我們會(huì)努力分享更多優(yōu)秀的文章。
