oracle连接问题--oracle实例处于nomount状态，实例状态为BLOCKED，如何连接?

oracle连接问题--oracle实例处于nomount状态，实例状态为BLOCKED，如何连接?



在做实验时，遇到如下报错。
[ora11g@ora11g ~]$ rman auxiliary sys/oracle@dupdb


Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 9 07:24:53 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


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

从报错看， 实例拒绝连接。


查看监听状态

[ora11g@ora11g admin]$ lsnrctl status listener


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-JAN-2015 07:28:16


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


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.11)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                30-NOV-2014 09:06:21
Uptime                    39 days 22 hr. 21 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /ora11g/OracleHomes/db11g/network/admin/listener.ora
Listener Log File         /ora11g/OracleHomes/diag/tnslsnr/ora11g/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=1521)))
Services Summary...
Service "devdb" has 1 instance(s).
  Instance "devdb", status READY, has 1 handler(s) for this service...
Service "devdbXDB" has 1 instance(s).
  Instance "devdb", status READY, has 1 handler(s) for this service...
Service "dupdb" has 1 instance(s).
  Instance "dupdb", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
[ora11g@ora11g admin]$ 

查看监听状态，实例状态为blocked，这表示实例将拒绝远程连接。
oracle实例处于nomount状态， dupdb状态为BLOCKED，拒绝客户端连接。

解决方法：

在dupdb的TNS中加了(UR=A)，在dupdb状态为BLOCKED时，也可以连接实例。

修改前TNS为：

dupdb =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = dupdb)
  ))


修改后TNS为：


dupdb =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = dupdb)
  (UR=A)
  ))



再次连接，正常连接到实例了。
[ora11g@ora11g ~]$ rman auxiliary sys/oracle@dupdb
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jan 9 07:28:10 2015


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to auxiliary database: DUPDB (not mounted)


RMAN> 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24626891/viewspace-2124169/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24626891/viewspace-2124169/