Re: Starting 8i database automatically

To start the database you should be an adminstrator. You can recreate your current instance to include automatic startup: Shutdown your database and from the command prompt, delete the current instance:

oradim -delete -sid SID

From the command prompt, recreate the instance:

oradim -new -sid SID -intpwd PASSWORD -startmode AUTO -pfile PATH\INITSID.ORA

This will recreate the OracleServiceSID and password file and will also create the OracleStartSID service and a command file, %oracle_home%\database\strtSID.cmd. This service should be set to automatic and will start the OracleServiceSID and issue a database startup each time the OS is restarted.

The other option is using the NT scheduler with a batch file, however the OracleStartSID service (setting the instance to -startmode auto) is probably the easiest way to accomplish the automatic startup.

umangjaipuria_at_yahoo.com (Umang) wrote in message news:<cda528a8.0306181236.2ea43399_at_posting.google.com>...
> Hi.
>
> Ref: Oracle 8i
>
> How does one start and mount a database automatically, so that it is
> done when the computer boots. Currently i'm doing through DBA Studio,
> logging in as SYSDBA for that domain, and starting the database.
>
> Need help to complete my project!
>
> Thanks,
> Umang J.
Received on Thu Jun 19 2003 - 12:24:53 CEST