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.
what did you find in the CRS log file? also please post the output from crs_stat -t command.
Try hard to get what you like OR you will be forced to like what you get.
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
Click Here to Expand Forum to Full Width