Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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

More Oracle Errors Interview Questions

ORA-00379: no free buffers available in buffer pool string for block size stringK

1 Answers  


ORA-39110: error deleting worker processes

1 Answers  


ORA-30372: fine grain access policy conflicts with materialized view

1 Answers  


ORA-00217: controlfile could not be resized for migration from 9.0.1

1 Answers  


ORA-03289: partition name and segment type do not match

1 Answers  






RMAN-08506: input filename=string

1 Answers  


ORA-02230: invalid ALTER CLUSTER option

1 Answers  


ORA-02045: too many local sessions participating in global transaction

1 Answers  


ORA-27071: unable to seek to desired position in file

1 Answers  


ORA-03234: unable to extend index string.string subpartition string by string in tablespace string

1 Answers  


TNS-00031: INTCTL: internal NT error

1 Answers  


ORA-24274: no row exists in the string table for these parameters

1 Answers  






Categories