ORA-12528: TNS:listener: all appropriate instances are blocking new connections
在我的實驗環境中snowdb資料庫被刪除，嘗試從catalog中恢復該資料庫遇到錯誤ORA-12528。 最簡單的修復方式是在tnsnames.ora檔案中新增PROD2資料庫中的（UR=A）
$ rman target sys/oracle@snowdb catalog rc_admin/RC_ADMIN@EMREP
Recovery Manager: Release 11.1.0.7.0 - Production on Sat Jul 25 23:58:48 2015
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
vi tnsnames.ora
snowdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = snow.us.oracle.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SNOW.US.ORACLE.COM)
(UR=A)
)
)
上面紅色部分(UR=A)是用來修復動態監聽在資料庫nomount狀態下拒絕一切連線的，簡單實用!
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29047826/viewspace-1752406/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- TNS Listener Hang, New Child Listener Process Forked
- Intermittent TNS Listener Hang, New Child Listener Process Forked [ID 340091.1]MIT
- Listener in INTERMEDIATE status with "Not All Endpoints Registered
- Listener in INTERMEDIATE status with "Not All Endpoints Registered"
- TNS-12541: TNS:no listener錯誤處理
- ORA-12519 TNS:no appropriate service handler foundAPP
- ORA-12519 TNS no appropriate service handler foundAPP
- ORA-12519, TNS:no appropriate service handler foundAPP
- ORA-12519: TNS:no appropriate service handler foundAPP
- 【Case】ORA-12519: TNS:no appropriate service handler foundAPP
- TNS-12518: TNS:listener could not hand off client connectionclient
- TNS-12518 TNS listener could not hand off client connectionclient
- ORA-12519: TNS:no appropriate service handler found 解決APP
- 診斷ORA-12519 TNS:no appropriate service handler foundAPP
- Listener refused the connection with the following error:ORA-12514, TNS:listenerError
- Difference between sap_all and sap_new
- Oracle Database Server 'TNS Listener'遠端資料投毒漏洞OracleDatabaseServer
- Connecting to ASM through the TNS Listener from a Client DesktopASMclient
- ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach) (轉)ErrorServer
- PRCF-2010 : All connections to the remote nodes got refused.REMGo
- ORA-12500: TNS:listener failed to start a dedicated server processAIServer
- ORA-12500 TNS : listener failed to start a dedicated server processAIServer
- 記一次解決：TNS-12518: TNS:listener could not hand off client connectionclient
- listener start fail TNS-12555 利用trace找到問題AI
- TNS-12537, TNS-12560, TNS-00507 Linux Error: 29: Illegal seek error When Starting the ListenerLinuxError
- 【LISTENER】Oracle監聽TNS-12545及TNS-00515錯誤處理一例Oracle
- TNS-12518: TNS:listener could not hand off client connection For ORACLE 10G （AIX6.1)clientOracle 10gAI
- No appropriate protocolAPPProtocol
- ORA-12518: TNS:listener could not hand off client connectionclient
- ORA - 12502 TNS:listener received no CONNECT_DATA from clientclient
- ORA-12518, TNS:listener could not hand off client connectionclient
- Added non-passive event listener to ascroll- blocking ‘mousewheel‘event Consider marking event handlBloCIDE
- 狀態: 失敗 -測試失敗: Listener refused the connection with the following error: ORA-12505, TNS:listener doesError
- Local Connections and Secure Remote Connections (36)REM
- grid control Error in getting data for creating new listenerError
- auxiliary ORA-12528UX
- set up the appropriate environmentAPP
- 手工配置listener.ora檔案及TNS-01201錯誤