Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-12436: no policy options specified

1 Answers  


ORA-07220: slspool: wait error.

1 Answers  


NZE-28832: invalid data unit format

1 Answers  


ORA-30346: hierarchy name must be unique within a dimension

1 Answers  


NNL-00346: Save_config_on_stop is now ON

1 Answers  


PLS-00909: object string is not declared or insufficient privileges to access object string

1 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


ORA-04004: MINVALUE must be less than MAXVALUE

1 Answers  


ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.

1 Answers  


ORA-24168: rule string.string cannot have default evaluation context

1 Answers  


ORA-09318: slkhst: unable to host out to operating system

1 Answers  


RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups

1 Answers  


Categories