Switchover To Physical Standby without broker hangs. (Doc ID 1261877.1)

Last updated on SEPTEMBER 30, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 30-SEPT-2012***

Symptoms


Switchover attempt on a single instance primary to single instance physical standby without broker hangs without any errors.

It was verified that standby is in complete sync with primary.

All the pre-requisites like job_queue_processes was set to zero and scheduler was disabled etc.

alter database commit to switchover to physical standby with session shutdown;

stuck for more than 1 hour which normally takes about 1min at the most. No messages recorded in the alert log.

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