Database Not mounting - URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database Not mounting - URGENT

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    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.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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.

  3. #3
    Join Date
    Nov 2000
    Posts
    178
    Try connecting as internal then bounce the database.

  4. #4
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182

    Red face 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

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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
  •  



Click Here to Expand Forum to Full Width