Re: inactive instance on server crash

From: Hans Forbrich <news.hans_at_telus.net>
Date: Tue, 12 Oct 2004 17:41:18 GMT
Message-ID: <2HUad.35894$663.20133@edtnps84>

fabrizio wrote:

>

>> Without further analysis on your side, who can tell?

>
> OK. i am running Oracle 9.2.0.4 on windows server 2003.
> the services (alla the services : listerners, oracle 'engines, and
> database) are running properly as they are started automatically.
>
> it seems that this problem is not unusual in case of power breakdown.
> does oracle provide a system to aplly script at startup of the database ?
>
> thanks all for your help

Under default installation, the oracle services will generally be started automatically by Windows, as seen in the control panel/admin services. No additional script is usually required in Windows.

(In *nix the dbstart and dbshut scripts are available and are frequently added to the unix system startup/shutdown capabilities such as the /etc/rc.d directory in Linux and others.)

If the services are up and running, look in the event log provided by the OS and the alert.log provided by Oracle. Try bouncing both the listener and the database instance (in that order).

Thanks for providing the oracle version and OS - it actually does help. /Hans Received on Tue Oct 12 2004 - 12:41:18 CDT