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/