rman连接AUXILIARY报错ORA-12528

在使用RMAN创建STANDBY数据库的过程中，连接AUXILIARY的时候报错。

ITPUB个人空间h| Vjk(dEb,U~

详细错误信息如下：

[oracle@yangtk ~]$ rman target / auxiliary sys/test@172.25.4.70/ora11g

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Nov 7 01:45:35 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)ITPUB个人空间m t@-c,rp[
RMAN-00571: ===========================================================ITPUB个人空间$oM5sT"v
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
o(QE%Sjfv&V
N0RMAN-00571: ===========================================================ITPUB个人空间xM6T2F z]-Z'R
RMAN-00554: initialization of internal recovery manager package failed
jz:BXd2h0T0RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

查询了一下METALINK，发现这个问题从9i到11g，任何一个版本都可能会出现。造成这个问题的原因是，实例虽然启动，但是没有注册到监听。实例是通过PMON进程注册到监听上的，而PMON进程需要在MOUNT状态下才会启动。因此造成了上面的错误。

Oracle给出了两种解决方案，一种方法是对AUXILIARY数据库直接使用/，对TARGET数据库通过网络访问。

[oracle@yangtk2 ~]$ rman target sys/test@172.25.4.127/ORA11G_P.ytk-thinkpad auxiliary /

Recovery Manager: Release 11.1.0.6.0 - Production on Thu Nov 29 13:58:38 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)
Qn`,o B3i.o0connected to auxiliary database: ORA11G (not mounted)

RMAN>

第二种方法为AUXILIARY数据库设置静态监听，在$ORACLE_HOME/network/admin目录下的listener.ora中添加下面的内容：

SID_LIST_LISTENER =
&X Bb-n:yiT \0 (SID_LIST =ITPUB个人空间IU3qAB
(SID_DESC =ITPUB个人空间$_.s hg&b g5s6]oc
(SID_NAME = ora11g)
0I/vn yLkA0 (ORACLE_HOME = /data/oracle/product/11.1)ITPUB个人空间N1zU.y'Q
?2|vl
)
ay.JKJD'Q0 )

重启监听：

[oracle@yangtk2 admin]$ lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 29-NOV-2007 14:01:55

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.4.70)(PORT=1521)))ITPUB个人空间RJ5qlCO$s^v
The command completed successfully
,tm%d_.Hu'|7T'o0[oracle@yangtk2 admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 29-NOV-2007 14:01:59

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /data/oracle/product/11.1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionITPUB个人空间!Y5W,_R*}%v#Vb
System parameter file is /data/oracle/product/11.1/network/admin/listener.oraITPUB个人空间h @p-U
XY|&o
Log messages written to /data/oracle/diag/tnslsnr/yangtk2/listener/alert/log.xml
+O`#B(A:Y]0Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.70)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.4.70)(PORT=1521)))ITPUB个人空间7a?x!R)Y\
STATUS of the LISTENER
eWO'T"ky0------------------------ITPUB个人空间U `h]2|
Alias LISTENERITPUB个人空间9n0NC2ASh/a3I"x
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
9\I/D,x1w0y A:@ |K0Start Date 29-NOV-2007 14:01:59ITPUB个人空间U[W8[O"z
Uptime 0 days 0 hr. 0 min. 0 sec
b0wI0_3`f W6b0Trace Level offITPUB个人空间V~jT1N ^4}u1M
Security ON: Local OS Authentication
]IO[9Rw5WY#Zq0SNMP OFF
$}a-S#WA |2YtL,U3r0Listener Parameter File /data/oracle/product/11.1/network/admin/listener.ora
"dX%`9l6U0Listener Log File /data/oracle/diag/tnslsnr/yangtk2/listener/alert/log.xml
+kM^j+{ |%S-tq0Listening Endpoints Summary...
3VN;lK!YiG0 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.70)(PORT=1521)))ITPUB个人空间X4XV*I4U6}.i
Services Summary...ITPUB个人空间P8_
{:P?"I tj8e
Service "ora11g" has 1 instance(s).
`j.F/p0Z@Y0 Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
1QQm5C1})w!?0The command completed successfully

在TARGET服务器上再次尝试登陆：

[oracle@yangtk ~]$ rman target / auxiliary sys/test@172.25.4.70/ora11g

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Nov 7 02:21:55 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)ITPUB个人空间;e)s7V$N"A/x-d%lp? t
connected to auxiliary database: ORA11G (not mounted)

关于这个问题的详细描述，可以参考metalink文档：Note:419440.1。