Automatic Restart Of New Standby Fails With Ora-01031 after Switchover by Broker (Doc ID 1900092.1)

Last updated on JULY 04, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
DGMGRL> connect sys/xxxxxx@cdev
[W000 06/17 11:47:41.26] Connecting to database using cdev.
[W000 06/17 11:47:41.33] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;].
[W000 06/17 11:47:41.34] Broker version is '11.2.0.3.0'
Connected.
DGMGRL> show configuration

Configuration - PROD

Protection Mode: MaxAvailability
Databases:
CDEVP - Primary database
CDEV2 - (*) Physical standby database

Fast-Start Failover: ENABLED

Configuration Status:
SUCCESS
DGMGRL> switchover to 'CDEV2';
Performing switchover NOW, please wait...
New primary database "CDEV2" is opening...
Operation requires shutdown of instance "cdev" on database "CDEVP"
Shutting down instance "cdev"...
[W000 06/16 18:28:32.03] Connecting to database using (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)
(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=CDEVP_DGB)(INSTANCE_NAME=cdev))).
ORACLE instance shut down.
Operation requires startup of instance "cdev" on database "CDEVP"
Starting instance "cdev"...
[W000 06/16 18:28:33.41] Connecting to database using (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=CDEVP_DGMGRL)(INSTANCE_NAME=cdev)(SERVER=DEDICATED))).
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
start up and mount instance "cdev" of database "CDEVP"

Symptoms

 Broker is unable to restart the New Standby DB after Switchover and is failing with the Error ORA-1031 even after starting the Broker using tns alias

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