Re: How to run automatically a database at startup of the PC

Jean-Michel RIBIERAS wrote:
> Hello,
>
> Test Platform : Win2000 Pro
> Oracle Version : 8i (8.1.7 Enterprise Edition Release 3)
>
> Jean-Michel
>
>

There ought to be this key in your registry:

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>\ORA_<ORACLE_SID>_AUTOSTART

It should have type of REG_EXPAND_SZ and should have values of "TRUE" (start the instance automatically) or "FALSE" (do not start the instance automatically).

You should also check that the Oracle services are started automatically.

If you are going to rely on automatic shutdown, there should also be these values (also REG_EXPAND_SZ)

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>\ORA_<ORACLE_SID>_SHUTDOWN = ( "TRUE" | "FALSE")
\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>\ORA_<ORACLE_SID>_SHUTDOWN_TIMEOUT = "n" (n seconds to wait)
\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>\ORA_<ORACLE_SID>_SHUTDOWNTYPE

• "i" (Mine is set for immediate- but this is a laptop with a play database).