Re: Instances vs Services

From: Jimmy Collins <jimmy_at_jcollins.de>
Date: Wed, 5 Dec 2001 00:00:12 +0100
Message-ID: <7jrju9.j94.ln@spider.jc-local>

"dsmcd" <dsmcd_at_uswestmail.net> schrieb im Newsbeitrag news:B0cP7.199$Ui5.351481_at_news.uswest.net...
> Hello again...
>
> Oracle 8.1.7 on Win2k-Server (P4 with Java 1.3.1)
>
> Booting the server starts the database service (automatic), but the
> instance is not open.

regedt32
HKEY_LOCAL_MACHINE\Software\Oracle\Home0\...

set ORA_INSTANCENAME_AUTOSTART = TRUE

replace INSTANCENAME with your SID.

> Shutting down the instance (Instance manger) does not stop the service.

set ORAINSTANCENAME_SHUTDOWN = TRUE

> I thought if the service was running then the instance was open, and if
> the service was stopped then the instance was shutdown.
>
> What am I missing here? (Hopefully nothing too embarrassing <g>).

See above.

> Thx,
> D.

Jimmy Received on Tue Dec 04 2001 - 17:00:12 CST