Re: Avoiding oracle automatic startup

"Anna" <mail_at_pallina.ch> wrote in message news:<b02at0$11g6$1_at_news.imp.ch>...
> Hello,
>
> I am using Oracle 9i enterprise edition on Win XP Professional.
> Right now the Database and all the services start when I boot windows, but
> since I use Oracle only every now and then to learn some SQL (so the only
> tools I really use are SQL Plus and sometimes the Enterprise Manager
> Console) I was wondering how I could prevent Oracle from automatically
> starting every time that I turn on my PC.
> I don't know what the different services are for, but I was wondering maybe
> I could set them to start manually...is this a good way to do it?
> In other words, is it possible to make Oracle start only by clicking on some
> icon, like I do with other applications?
>
> Thanks
>
> Anna

If you are point-and-click kinda Windoze person then leave the registry setting mentioned by Ted to TRUE and leave the services mentioned by Roman to Manual and use couple of batch files to start and stop your database/listener whenever you want to e.g.

stop.bat
@echo off
net stop <OracleService[SID]>
net stop <OracleOraHome[xx]TNSListener>
exit

start.bat
@echo off
net start <OracleService[SID]>
net start <OracleOraHome[xx]TNSListener> exit

/Rauf Sarwar Received on Wed Jan 15 2003 - 01:50:21 CST