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博客 ” ，链接：https://blog.itpub.net/29047826/viewspace-1752406/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
修改用户密码引来的一系列麻烦
请登录后发表评论
登录
全部评论
