Re: Oracle 8.1.7 unable to autostart database

Try this command:

oradim -edit -sid <orcl> -startmode auto -pfile x:\oracle\ora81\database\initorcl.ora

Other things I have encountered are that you might also need to change the regsitry setting for ORA_<sid name>_PFILE. I notice that sometimes it leaves of the full path, and you have to change that.

The last thing I have seen - make sure the ORACLE_SID is set in the environment variable.

Hope that helps

On Fri, 23 Mar 2001 01:47:38 GMT, "ccyr" <ccyr6798_at_hotNOSPAMmail.com> wrote:

>the oracle NT utility you want to look at is oradim. I don't have docs at
>hand, but you can do stuff like
>
>oradim -edit -sid mysid -starttype inst,srvc -startmode a
>oradim -startup -sid mysid
>
>starttype is instance or service or both; startmode is auto or manual -
>course you can do the startmode part via w2000 Services
>
>Now, I know one of the "start" params does not go with the -edit, not sure
>which
>one. think there's an "oradim -help" or oradim /? or something.
> "Tek Seng" wrote in message <000801c0b284$b4e7ef20$11e978cb_at_d>...
> Hi,
>
> Installed Oracle 8.1.7 in Windows 2000 Server SP1.
>
> I am unable to get the database started automatically after bootup
>
> even though the registry value ORA_SID_AUTOSTART is set to TRUE.
>
> Is there any ways that I can start the database automatically at boot
>
> time?
>
> Thanks.
>
>
  Received on Fri Mar 23 2001 - 23:10:58 CST