-
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;
Can any body will guide me.
-
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.
-
Try connecting as internal then bounce the database.
-
database can not mount on exclusive mode
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.
Now, Startup the databases.
[Edited by ggnanaraj on 08-11-2001 at 02:40 AM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|