Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01219 database not open; only queries on fixed tables and views.

752335Jul 20 2010 — edited Sep 6 2010
Hi everyone
There is another post stating this error, but since the source is different, I think is okay to make a different post as well.
Our database was working fine until the other day, when suddenly power went off, UPS was damaged and didn't hold, and when we restarted the database this is what happens:

Using Enterprise Manager Console, we can make a succesful connection in the same machine, but if we choose Schema, the following error appears:

ora-01219 database not open; only queries on fixed tables and views.

When accesing from a different machine:
ORA-01033: ORACLE initialization or shutdown in progress

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2010
Added on Jul 20 2010
12 comments
3,521 views