DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Database not open after restarting it


    I'm facing a problem with the Oracle 10 database. This is a RAC configuration and live system. After restarting the CRS in both servers, the database does not go to OPEN:

    ERROR at line 1:
    ORA-01219: database not open: queries allowed on fixed tables/views only

    SQL> select status from V$instance;

    If you run manually either:

    SQL> alter database open;


    SQL> startup force;

    The instances go OPEN and everything works normally, but if you restart the CRS again, the same problem, the database does not go to OPEN.
    I guess something is missing/wrong in an Oracle conf file...

    Can someone help me out in this please?

    Thanks in advance.

  2. #2
    Join Date
    Mar 2006
    Charlotte, NC
    what did you find in the CRS log file? also please post the output from crs_stat -t command.

    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Jun 2009
    This is the command to set the database to opened:

    # srvctl config database -d -a

    What I'm trying to find out and understand is what that command does and where and what parameter changes...

Tags for this Thread

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.