Database Software

Hi there,

After 3 times rebuilding my configuration, I bounce back to the same problem. I've read all threads on the subject but can't find a solution. If anyone has an idea :

I have 2 instances acting as primary presently : "ORCL1" (on server ServerS1) and "ORCL2" (on server ServerS2) on a RAC database "ORCLS" (cluster racS)

I have 2 instances acting as dataguard presently : "ORCL1" (on server ServerP1) and "ORCL2" (on server ServerP2) on a RAC database "ORCL" (cluster racP)

( a failover has occured recently, I just rebuilt dataguards, archivelog are applied normally )

Before attempting to build, I do the following :

DGMGRL> connect sys@ORCLS

DGMGRL> disable configuration

DGMGRL> remove configuration

sqlplus / as sysdba on ORCL1/ServerS1 > ALTER SYSTEM SET DG_BROKER_START=FALSE;

sqlplus / as sysdba on ORCL1/ServerP1 > ALTER SYSTEM SET DG_BROKER_START=FALSE;

asmcmd on ServerS1 > rm +DATA/ORCLS/DGCONFIG/dgb_config01.ora

asmcmd on ServerS1 > rm +RECOVERY/ORCLS/DGCONFIG/dgb_config02.ora

asmcmd on ServerP1 > rm +DATA/ORCL/DGCONFIG/dgb_config01.ora

asmcmd on ServerP1 > rm +RECOVERY/ORCL/DGCONFIG/dgb_config02.ora

Then, I try to rebuild my configuration :

sqlplus / as sysdba on ORCL1/ServerS1 > ALTER SYSTEM SET DG_BROKER_START=TRUE;

sqlplus / as sysdba on ORCL1/ServerS1 > show parameter broker

------------------------------------ ----------- ------------------------------

sqlplus / as sysdba on ORCL1/ServerP1 > ALTER SYSTEM SET DG_BROKER_START=TRUE;

sqlplus / as sysdba on ORCL1/ServerP1 > show parameter broker

------------------------------------ ----------- ------------------------------

DGMGRL> connect sys@ORCLS

DGMGRL> create configuration 'DG_ORCL' as primary database is 'ORCLS' connect identifier is 'ORCLS';

Configuration "DG_ORCL" created with primary database "ORCLS"

DGMGRL> add database 'ORCL' as connect identifier is 'ORCL';

Database "ORCL" added

DGMGRL> enable configuration

Enabled.

DGMGRL> show configuration

Configuration - DG_ORCL

  Protection Mode: MaxPerformance

  Databases:

    ORCLS - Primary database

    ORCL  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

ORA-16610: command "ENABLE DATABASE ORCL" in progress

DGM-17017: unable to determine configuration status

Additionnaly, when I try to run :

DGMGRL> show database ORCL

Database - ORCL

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON           <-- from this point, it goes extremely slow, and then ... :

  Transport Lag:   (unknown)

  Apply Lag:       (unknown)

  Apply Rate:      (unknown)

  Real Time Query: OFF

  Instance(s):

    ORCL1

    ORCL2

Database Status:

DGM-17016: failed to retrieve status for database "ORCL"

ORA-16532: Data Guard broker configuration does not exist

ORA-16625: cannot reach database "ORCL"

Precisions :

- all databases are using pfiles

- tnsping access ORCL databases easily from ServerS1 or ServerS2

- it was working properly before the failover, when databases had opposite roles !

I'm lost, if anyone can tell me where to drive my search, it would be very helpfull.

Best regards.

Eric