var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Could not start database
When I try to open my database as SYSTEM I get the following message:
ORA-01033 Oracle initialization or shutdown in progress.
When I try to open the database as SYS it works fine.
Does anybody have suggestions?
Check your alertlog .. you may find that the database is on exclusive or
that the database is just mounted and not open (may need recovery)...
Post the last part of your alertlog ...
You can find out the status of your database with the following command:
select status from v$instance;
This will at least let you know if the database is mounted, open etc.
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.
Database is mounted
The database is just mounted and not open. There is probably a problem with the system datafile. Is the only way replacing a backup or are there other recovery solutions?
Again, post the last bit of your alertlog so we can see what's going on ...
If there is a file that needs recovery, you'll see it in v$recover_file;
select * from v$recover_file;