Re: oracle on startup

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:3fa951e3$0$3499$afc38c87_at_news.optusnet.com.au...
>
> "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.

Sorry... that should read "check out the 'net start OracleServiceGRET' command

NET START, not NET SERVICE.

My apologies.

Regards
HJR Received on Wed Nov 05 2003 - 13:42:21 CST