Re: Avoiding oracle automatic startup

Another option is to set the service for your instance to manual startup. The service is typically called OracleServiceSID where SID is your ORACLE_SID. If you leave ORA_xxxx_AUTOSTART set to TRUE then when you start the service, it will also start the database. If you set it to FALSE you will need to go into sqlplus to start the database manually also.

On Wed, 15 Jan 2003 00:57:40 GMT, "Ted McCabe" <theom_at_gte.net> wrote:

>In the registry:
> HKEY_LOCAL_MACHINE
> SOFTWARE
> ORACLE
> HOME0
> ORA_xxx_AUTOSTART=FALSE
>HTH
>tED
>"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
>>
>>
>
Received on Tue Jan 14 2003 - 23:44:55 CST