Re: automatic startup off database with W2K Server

"Erfurt, Jochen" <jerfurt_at_hpberlin.de> wrote in message news:<b0jn2h$lgc$01$1_at_news.t-online.com>...
> Hi all,
>
> I do have a problem with an automatic start up off a database.
> When starting the Windows OracleService<SID> the database
> will not open.

There is a known bug for 8.1.7.0.0 on NT whereby autostart functionality could fail. As you did not indicate which patchset you have applied, I can only assume that you are running the base release and have not applied any patches. Log into Metalink and download the 8.1.7.4.1 and 8.1.7.4.6 patchsets. As soon as a patch is released for the bug affecting exp/imp - download that too (its not yet available for win32).
If you rely upon exp/imp for recovery, you may only want to patch to the 8.1.7.2.x series, as I believe that is not affected. Check the docs.

Read the readme.htm carefully - there are steps mentioned that are required during the dictionary rebuild.

subscribing to metalink alerts wouldn't hurt either, although I wish that I could filter out the announcements for vulnerabilities in 9iAS ...

Paul

> 1.).
> On a Windows 2000 SERVER the Oracle 8.1.7 is placed on
> drive C:, the database is placed on the other partition D:.
>
> With oradim I've set the start type off the service to automatic
> and also add the option off starting the instance when the service
> starts. The registry settings are ok:
>
> ORA_MEDEG_AUTOSTART = TRUE
> ORA_MEDEG_PFILE = D:\oracle\admin\MEDEG\pfile\initMEDEG.ora
>
> An initMEDEG.ora with a link to the above mentioned file is
> placed in C:\oracle\ora81\database.
>
> Starting the database manually with svrmgrl: everything works fine
>
> 2.)
> On my notebook (Windows 2000 PRO) I do have a copy of the
> database. Here the automatic start up works fine: On system start
> and when starting the service.
>
> There are only two differences to the server installation:
> The OS
> The path to the database files
>
>
> Doe's anyone has any plan of what's going on?
>
> Thank's in advance
>
> Jochen
>
> ---
> Jochen Erfurt
> Hartung & Partner GmbH
> Budapester Straße 40
> 10787 Berlin
> Germany
> Tel. : +49 (0)30 263949-14
> Fax : +49 (0)30 263949-59
> email: jerfurt_at_hpberlin.de
Received on Sat Jan 25 2003 - 15:34:04 CST