ORA-12528: TNS:listener: all appropriate instances are blocking new connections

在测试用RMAN的duplicate创建dataguard时报错：

[ oracle @ora10g dbs]$ rman target / auxiliary sys/ oracle @standby

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 3 11:11:42 2009

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

connected to target database: DEMO (DBID=3435139725)

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

查看standby listener的状态，发现状态为blocked：

[ oracle @ora10g_dg ~]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 03-JUL-2009 11:16:28

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

Services Summary…

Service “demo” has 1 instance(s).

Instance “demo”, status BLOCKED, has 1 handler(s) for this service…
Handler(s):

“DEDICATED” established:0 refused:0 state:ready

LOCAL SERVER

Service “demo_XPT” has 1 instance(s).

Instance “demo”, status BLOCKED, has 1 handler(s) for this service…

Handler(s):

“DEDICATED” established:0 refused:0 state:ready

LOCAL SERVER

The command completed successfully

从上面可以看出服务是动态注册的，我们知道 oracle 动态注册是通过PMON来实现的，而启动PMON注册需到mount状态，因此如果instance处于nomount状态就会出现blocked的情况，解决的办法是改成静态注册。更详细的介绍可参考：419440.1