[oracle@wfdb ~]$ rman target sys/lf0320tcsge@WF auxiliary sys/lf0320tcsge@WF_166
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 9 14:57:47 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: WF (DBID=2830741594)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
处理方法有下面两种,随便一种都可以
1. 主库的tns中关于备库配置,增加(UR=A)
2. 备库增加静态监听
如原来是
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.166)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /wfdb/db
现在如下,增加红色标记部分
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.166)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /wfdb/db/product/11.2.0/dbhome_1)
(SID_NAME = WF)
)
)
ADR_BASE_LISTENER = /wfdb/db
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30126024/viewspace-2126012/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30126024/viewspace-2126012/