Failover Connections for Data Guard Error with ORA-1033 (Doc ID 461874.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Net Services - Version 9.2.0.4 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 04-JUN-2014

Symptoms

Connections in data guard environment fail with ORA-01033: ORACLE initialization or shutdown in progress.

Oracle Net client trace shows after successful connection handshake

[27-SEP-2007 11:34:18:104] nsprecv: 00 00 39 4F 52 41 2D 30  |..9ORA-0|
[27-SEP-2007 11:34:18:104] nsprecv: 31 30 33 33 3A 20 4F 52  |1033:.OR|
[27-SEP-2007 11:34:18:104] nsprecv: 41 43 4C 45 20 69 6E 69  |ACLE.ini|
[27-SEP-2007 11:34:18:104] nsprecv: 74 69 61 6C 69 7A 61 74  |tializat|
[27-SEP-2007 11:34:18:104] nsprecv: 69 6F 6E 20 6F 72 20 73  |ion.or.s|
[27-SEP-2007 11:34:18:104] nsprecv: 68 75 74 64 6F 77 6E 20  |hutdown.|
[27-SEP-2007 11:34:18:104] nsprecv: 69 6E 20 70 72 6F 67 72  |in.progr|
[27-SEP-2007 11:34:18:104] nsprecv: 65 73 73 0A              |ess.    |

Net service name has LOAD_BALANCE set in description section

  (DESCRIPTION =
    (LOAD_BALANCE = yes)
    (ADDRESS = (PROTOCOL = TCP)(HOST = NodeA)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = NodeB)(PORT = 1521))

Or has two description sections

  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(Host = NodeA)(Port = 1521))
      (CONNECT_DATA =
        (SERVICE_NAME = ORCL1)
      )
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(Host = NodeB)(Port = 1521))
      (CONNECT_DATA =
        (SERVICE_NAME = ORCL2)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms