-
Database not open after restarting it
Hello,
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;
STATUS
MOUNTED
If you run manually either:
SQL> alter database open;
or
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.
Thanks,
Vijay Tummala
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
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
|