Re: oracle on startup

"mlk" <mm10_at_caramail.com> wrote in message news:3fa94f48$0$11289$79c14f64_at_nan-newsreader-01.noos.net...
> Hi
> I install oracle 8i on win2k.It start on startup and I don't want it.
> I change the registry key value of ORA_GRET_AUTOSTART from true to false
but
> I can not connect to the DB via sql plus to start it.
> Did I change the right key or do I have to change something else?
> thx for help

It's slightly unusual to start hacking around the registry to achieve this, since that's what the Control Panel's Services applett is there for. But no matter: what you've done (I think) is to switch the OracleServiceGRET to manual startup mode, which is fine. On Windows, the service provides the shared memory segment that the instance can make use of, so without the service running beforehand, the instance can't be built.

So all you have to do to start your instance is to manually start the service -and again, that's a job for the Services Applett, not a registry hack. You can do it at the command line if you insist: check out the 'net service OracleServiceGRET start' command. That way, you could knock up a batch file to do the job, and simply have a shortcut to that batch file on your desktop. But one way or another, that service has got to start.

Usually, by starting the service, you will actually also start the instance, so logging on immediately afterwards is all you'll need to do (no need for the startup command, in other words).

Regards
HJR Received on Wed Nov 05 2003 - 13:39:11 CST