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
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 ?
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.
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.
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.