Re: How to make Oracle10g on Windows *not* start on every boot?

This is really a Windows management issue, not an Oracle one. Though I suppose it's also an Oracle issue because it would seem that you're not entirely clear on what particular bits of functionality you want and what services relate to which bits of functionality.

In general, however, if you don't want Oracle functionality started at each reboot, set all Oracle services to manual in the Control Panel's Administrative Tools, Services applet.

To start an Oracle instance manually thereafter you simply start the one OracleServiveXXXX process. No need for a Listener, even, if all you are doing is running and connecting on the same machine. If you need a Listener for remote connections, start that as well. If you want to practice developing n-tier applications, start up the HTTP Server service. If you want to use iSQLPlus, start that service. If you want to manage the database via OEM, then start the DBConsole service. If you're going to do everything from the command line, don't.

If you want to find out which service controls which bits of functionality, visit http://tahiti.oracle.com and start searching the online documentation.

If some things fail to work properly, provide details of the specific symptoms and any error messages you're getting, and we can explain what's going wrong and suggest a fix.

Fundamentally, you should do what you like with your services, because you are in control of your machines. But there may be dependencies you have to be aware of. But having become aware of them (see tahiti), be in control.

Regards
HJR "Anonymous Coder" <no_at_email.com> wrote in message news:40cef479.435187_at_news.individual.de...
> Thomas Kellerer <OSCUQDVXTKFJ_at_spammotel.com> wrote:
>
> >Goto to the control panel, open the Services snap-in and set the type to
> >"Manual" for the services in question.
>
> Ok, that's more or less what I tried already, and it prevented the
> automatic start - but I suspected that I might have screwed up my
> installation this way, because afterwards, some things didn't work
> properly... (<40ced087.700609_at_news.individual.de>).
>
> After all, it did seem like a dirty fix, not The Proper Way (tm) :)
>
> >You can start the manually either from within the Services snap-in or via
the
> >net start command. I create a batch file with the following contents to
start
> >Oracle:
> >
> >net start OracleOraHome92TNSListener
> >net start OracleServiceORADB
> >
> >To stop it I use
> >
> >net stop OracleServiceORADB
> >net stop OracleOraHome92TNSListener
> >
> >The name of the service depends on your installation (ORADB is the SID)
>
> So I should leave everything alone except these two services? I seem
> to remember there were more services set "auto" after a standard
> install.
>
> Thanks
>
Received on Tue Jun 15 2004 - 08:32:02 CDT