Re: Database instance not started automatically

From: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 7 Oct 2004 17:25:45 -0400
Message-ID: <910046b40410071425697faddd@mail.gmail.com>

Meenakshi ,

check the oradim.log in the %ORACLE_HOME%\database folder.
check the entry in the registry that points to the pfile

HKLM\SOFTWARE\ORACLE\HOME0\ORA_%ORACLE_SID%_PFILE e.g.
D:\Oracle\Admin\%ORACLE_SID%\pfile\init%ORACLE_SID%.ora

where %ORACLE_SID% is your SID, assuming that the SID and the db_name and instance_name are the same.

Paul

On Thu, 7 Oct 2004 17:08:39 -0400, Aggarwal, Meenakshi <meenakshi.aggarwal_at_fishersci.com> wrote:
> Hi,

> Database instance is not started automatically after server reboot. I have a
> 9i instance on Windows.
> OracleServiceSID is set to start automatically under services and I see this
> started after server reboot.
> I have ORA_sid_AUTOSTART = true in registry.

> I am able to start the database manually.

> Can anybody think of why instance is not started automatically. Is there any
> log that captures the error when attempting to autostart the instance.

> Thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 07 2004 - 16:21:27 CDT