Friday, December 22, 2006

How to stop Oracle XE from starting up with your computer

Eddie Awad blogs about "How to Give Your System a Break from Oracle XE".
---
There was a question on OraQA about how to stop Oracle XE from starting up with your computer. When you install Oracle XE on Windows, it creates a service called ?OracleServiceXE? with a startup type of ?Automatic? which means that the service starts automatically when the computer boots.

One way to prevent Oracle XE from starting up automatically is to change the startup type of the Oracle service to ?Manual?. You can do that by navigating to your Control Panel -> Administrative Tools -> Services, double click on the Oracle service and change the Startup type to Manual.

Another way to prevent Oracle XE from starting up automatically when Windows starts is to use the ORADIM command-line tool that is available with the Oracle database. From the DOS command line execute the following:

oradim -edit -sid XE -startmode manual

Now, when you want to use Oracle XE, you start it up like this:

oradim -startup -sid XE

And you shut it down like this:

oradim -shutdown -sid XE

Or you can use the ?Start Database? and ?Stop Database? shortcuts installed with Oracle XE. Navigate to Start -> All Programs -> Oracle Database 10g Express Edition ->Start/Stop Database

Now you know how you can squeeze out a bit of extra performance from your computer when you are not using Oracle XE :)

Sources and Resources:
- Eddie Awad's Blog
- ORADIM documentation
- Related AskTom thread

2 comments:

Oracle said...

I found this post very useful.

Arun said...

excellet input.

Could you also suggest, how to give start/stop privilliage to normal user; rather than using windows administator account. ( OS is windows 7 )