can't open database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: can't open database

  1. #1
    Join Date
    Mar 2001
    Posts
    78

    Arrow

    SQL> select database_status from v$instance;

    DATABASE_STATUS
    -----------------
    ACTIVE

    How can I make it open, or what command will take it from active to open mode. I tried alter database open and it did not work

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Issue

    Alter database open;

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Posts
    78
    I already did but it did not work. So I tried

    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-00205: error in identifying controlfile, check alert log for more info

    I checked the controfile and got this

    Mon May 7 11:12:43 2001
    ORA-00202: controlfile: '/u09/ora09/POLICY/ctrlPOLICY01.ctl'
    ORA-27086: skgfglk: unable to lock file - already in use

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Are you sure it is not in open mode,
    When I do a query on my db, it give:
    DEVDB> select database_status,status from v$instance;

    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE OPEN

    Dragon

  5. #5
    Join Date
    Mar 2001
    Posts
    78

    This is whay I got from your query:

    SQL> select database_status,status from v$instance;


    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE STARTED

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Do a shutdown immediate on the system. BTW what is your OS and DB (name and version)


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Mar 2001
    Posts
    78
    SQL> shutdown immediate
    ORA-01507: database not mounted

    ORACLE instance shut down.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 45166484 bytes
    Fixed Size 73620 bytes
    Variable Size 31813632 bytes
    Database Buffers 13107200 bytes
    Redo Buffers 172032 bytes
    ORA-00205: error in identifying controlfile, check alert log for more info

    I checked the alert file and got this:
    ORA-27086 skgfglk: unable to lock file - already in use

    The name of the database is POLICY running on IBM AIX Oracle 8.1.7





    [Edited by panjub_raj on 05-07-2001 at 12:15 PM]

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Issue shutdown abort

    Check your alertSID.log for the primary cause of the problem. Is it your test/prod/dev server?


    Issue the commands one by one and let us know the status.


    Set your ORACLE_SID= in the env

    $ svrmgrl
    SVRMGR> connect internal as sysdba
    SVRMGR> startup nomount;
    SVRMGR> alter database mount;
    SVRMGR> recover database; (If your database is in the archive mode)
    SVRMGR> alter database open;




    Here are some of the secanrios and their displays

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup nomount;
    ORACLE instance started.
    Total System Global Area 278446240 bytes
    Fixed Size 73888 bytes
    Variable Size 101072896 bytes
    Database Buffers 177119232 bytes
    Redo Buffers 180224 bytes
    SVRMGR> select database_status, status from v$instance;
    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE STARTED
    1 row selected.
    SVRMGR> alter database mount;
    Statement processed.
    SVRMGR> select database_status, status from v$instance;
    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE MOUNTED
    1 row selected.
    SVRMGR> alter database open;
    Statement processed.
    SVRMGR> select database_status, status from v$instance;
    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE OPEN
    1 row selected.
    SVRMGR>


    Hope this would help you.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Mar 2001
    Posts
    78
    I di but I received another message. Below is what I did:

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup nomount;
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SVRMGR> shutdown immediate;
    ORA-01507: database not mounted
    ORACLE instance shut down.
    SVRMGR> connect internal
    Connected.
    SVRMGR> startup nomount;
    ORACLE instance started.
    Total System Global Area 45166484 bytes
    Fixed Size 73620 bytes
    Variable Size 31813632 bytes
    Database Buffers 13107200 bytes
    Redo Buffers 172032 bytes
    SVRMGR> select database_status, status from v$instance;
    DATABASE_STATUS STATUS
    ----------------- -------
    ACTIVE STARTED
    1 row selected.
    SVRMGR> alter database mount;
    alter database mount
    *
    ORA-00205: error in identifying controlfile, check alert log for more info
    SVRMGR>


    CONTENTS OF ALERT LOG
    -----------------------------
    ORA-00202: controlfile: '/u09/ora09/POLICY/ctrlPOLICY01.ctl'
    ORA-27086: skgfglk: unable to lock file - already in use
    IBM AIX RISC System/6000 Error: 13: Permission denied
    Additional information: 8
    Additional information: 95084

    [Edited by panjub_raj on 05-07-2001 at 12:24 PM]

  10. #10
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Is it a parallel server setup? If not I the suggestion at this point would be that if it was not a production server and you can afford to bounce it, then bounce the server. There seems to be some kind of problem in getting the lock on the control file.


    Before bouncing your server, lets try this.

    shutdown your instance

    shutdown immediate/abort

    do a ps -ef|grep instance_name and see if there are any unkilled processes. If you see any, kill them. Now try to start the instance, at nomount --> then mount --> then recover --> and then open.


    Let me know whether this helps. In the past I have noticed that there had been some kind of wierd problem people had been experiencing with the startup of 8.1.7 instances. The last resolution of bouncing thier server was the fix for thier problems. If you have oracle support, pound at their doors and ask why the heck it is happening.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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