oracle (ur=a),监听_(UR=A)

[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