hi!
I have a database which is stadby. and it suddenly shudown automatically.
I try to start it. It is not mounting. It says can not mount in xclusive mode.
ORA-01102 can not mount database in exclusive mode.
On the same unix box there are two database instance.
when I try to shutdwon other database it says insufficient privilege;
It seems som other instance has already mounted the database. If you are not running in parallel mode than try shutting down all the instances and start one by one.
I have two instances on same machine and it was working fine.
I shut down one database , I can not start it or mount it again becasue it says database can not mounted in exclusive mode.
At a time I am able to start any one database. I do not what setup previos DBA done. It was working fine both the databse
Shutdown all databases on the UNIX box and do the following...
Check if the shutdown was clean, by seeing if the file sgadef(sid).dbf still exists in u'r $ORACLE_HOME/dbs directory for both instances and remove it.
UNIX 'kill' background processes owned by ORACLE. (kill -9 (process_nos))
Check if any Shared Memory or Semaphores owned by ora(sid) exist and remove them for both instances. (ipcrm -m (shared_memory_nos) & ipcrm -s (semaphore_nos))
Remove lk(sid) from all $ORACLE_HOME/dbs directory for both instances.
Bookmarks