Re: 8.0.5 Crashed in Linux, what next?

If it is like other UNIX environments, then the sgadeforcl.dbf file has been left behing in $ORACLE_HOME/dbs.

Assuming you have access to the command line, and Server Manager (svrmgrl found in $ORACLE_HOME/bin), you can restart the database as follows;

1. Set the ORACLE_SID, ORACLE_HOME and PATH variables up using oraenv or coraenv. i.e.

$ . oraenv

and when asked for the Oracle SID enter orcl.

2. Run Server Manager as follows;

$ svrmgrl
SVRMGRL> connect internal
SVRMGRL> startup force

The database should now startup and recover itself in a matter of seconds.

Andrew

mamahuhu_at_my-dejanews.com wrote:

> Newly installed 8.0.5 on RedHat 5.2
> System got power cycled without shutting down the DB.
> Now can't do "dbstart" anymore, says:
>
> "Database "orcl" possibly left running when system went down (system crash?).
> Notify Database Administrator."
>
> None of the tools work. Even "orainst" generates core dump.
> Any insights on what should be done???
>
> ThX!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 22 1999 - 19:49:08 CST