ORA-01093: ALTER DATABASE CLOSE only permitted with no
sessions connected
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-29868: cannot issue DDL on a domain index marked as LOADING
SAP log on Error Message: "Msg E14 645 not found"
SQL*Loader-00422: constant element count of number for column string is greater than maximum, number
TNS-04004: Unable to encrypt the supplied password.
ORA-19711: cannot use reNormalizeAllFileNames while database is open
ORA-06550: line string, column string: string
ORA-12529: TNS:connect request rejected based on current filtering rules
RMAN-00700: SCRIPT requires that TARGET be specified on the command line
NNO-00064: loading domain data from checkpoint file "string"
RMAN-06013: duplicate channel identifier found: string
PCB-00201: Indicator variable string not a group item
ORA-27064: cannot perform async I/O to file