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

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

在做实验时，遇到如下报错。

[[email protected] ~]$ rman auxiliary sys/[email protected]

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

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

查看监听状态

[[email protected] 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

[[email protected] 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)

  ))

再次连接，正常连接到实例了。

[[email protected] ~]$ rman auxiliary sys/[email protected]

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/