ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

ORA-01093: ALTER DATABASE CLOSE only permitted with no
sessions connected

Question Posted / guest

2 Answers
10394 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected..

Answer / chidella

SQL>alter database commit to switchover to PHYSICAL STANDBY
WITH SESSION SHUTDOWN;
Even if this does not work then check for the processes

SQL> SHOW PARAMETER JOB_QUEUE_PROCESSES;

NAME TYPE VALUE
------------------------------------ ----------- -----------
-------------------
job_queue_processes integer 0
should be zero and check for the SQL> SELECT SID, PROCESS,
PROGRAM FROM V$SESSION;

SID PROCESS PROGRAM
---------- ------------ ------------------------------------
------------
1 14827 oracle@jdcss009 (PMON)
2 14829 oracle@jdcss009 (DBW0)
3 14831 oracle@jdcss009 (LGWR)
4 14835 oracle@jdcss009 (CKPT)
5 14837 oracle@jdcss009 (SMON)
6 14839 oracle@jdcss009 (RECO)
7 14841 oracle@jdcss009 (ARC0)
8 14843 oracle@jdcss009 (ARC1)
9 14845 oracle@jdcss009 (ARC2)
10 14847 oracle@jdcss009 (ARC3)
11 14849 oracle@jdcss009 (ARC4)

SID PROCESS PROGRAM
---------- ------------ ------------------------------------
------------
12 14851 oracle@jdcss009 (ARC5)
13 23809 sqlplus@jdcss009 (TNS V1-V3)
14 21071 sqlplus@jdcss009 (TNS V1-V3)
15 14861 oracle@jdcss009 (LNS0)

trouble shoot accordingly.

Is This Answer Correct ?

0 Yes

1 No

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected..

Answer / guest

Cause: There is at least one more session other than the
current one logged into the instance. ALTER DATABASE CLOSE
is not permitted.

Action: Find the other sessions and log them out and
resubmit the command

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer