ORA-1093 During Switchover or Close of Standby Database (Doc ID 444362.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 20-Oct-2011***

Symptoms

During Data Guard Switchover from Primary to Physical Standby in a RAC Environment the following Errors occur:

SQL> alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby;
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 


SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE


Checking v$session will show the following:

SQL> select SID, PROCESS, PROGRAM
    2>  from v$session where type = 'USER' and
    3>  SID <> (select DISTINCT SID from v$mystat);

SID       PROCESS    PROGRAM
--------- ---------------- ------------------------------------------------
1078    622624         racgimon@koalav1 (TNS V1-V3)
1079    622624         racgimon@koalav1 (TNS V1-V3)
1080    622624         racgimon@koalav1 (TNS V1-V3)
1086    622624         racgimon@koalav1 (TNS V1-V3)


This error can also occur when any standby database registered with the Oracle Clusterware is being closed.

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