This content has been marked as final. Show 15 replies
[oracle startup and shutdown|http://www.psoug.org/reference/start_stop.html]
what do you mean by also mounting in shared mode?
Edited by: Anantha on Jun 15, 2009 8:52 AM
STARTUP MOUNT - is for both shared or exclusive and the database is not open - you can do any thing with its data.
Try - STARTUP RESTRICT
This starts the database and open it, but only users with RESTRICTED SESSION system privilege can connect to the database.
Make sure that only admins have RESTRICTED SESSION system privilege
what if i want to mount the database exclusively and not in shared mode?
There is no such thing to mount the database exclusively, mount is the state where the database is not open and no one can access the database only some v$ view.
You can only MOUNT the database - there is no mount exclusive / shared, What are trying to achieve ?
what's is your oracle version?
prior to 11g, you can do
Use STARTUP MOUNT
STARTUP MOUNT EXCLUSIVE
Actually there is. EXCLUSIVE and SHARED were once used for Oracle Parallel Server.
SHARED meant: allow both instances to function.
EXCLUSIVE meant: allow only the current instance to function.
SHARED has been replaced by CLUSTER_DATABASE = TRUE
and EXCLUSIVE by CLUSTER_DATABASE = FALSE
Senior Oracle DBA
Experts: those who did read dcoumentation.
i am trying to drop a database. You can just tell me the procedure. i am a student doing it for practice.
You are right but this option is deprecated from 9i, Parallel server was replaced by RAC (as you mentioned in your post), and should not be used any more (-:
If he is using 8i Parallel Server I taking my post back (-:
Currently MOUNT EXCLUSIVE does not serve you at all.
I have asked why he needs to mount exclusive in order to know what he is trying to do and give alternative.
Thanks for the information.
What's your oracle version?
prior to 10g, you cannot drop the database, if you're in 10g , you can.
shutdown immediate; startup mount; alter system enable restricted session; DROP DATABASE;
IF you are using 10g and up do the following :
startup mount exclusive restrict;
Or run the DBCA and deinstall the database.
and the commands should be fired after connecting to RMAN. i.e. the commands should like this:
RMAN> shutdown abort;
RMAN> startup mount exclusive restrict;
RMAN> drop database;
other drop options are:
RMAN> DROP DATABASE;
RMAN> DROP DATABASE NOPROMPT;
RMAN> DROP DATABASE INCLUDING BACKUPS;
RMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;
Correct me if I'm wrong.
Thanks everyone. i dropped the database. Thanks for your help.
Please mark the thread as answered,
You are welcome