Control Oracle services on Windows

A number of services are started by Oracle9i when it's installed on Windows OS. These services consume a lot of resources and should be shut down when they are not needed. The following is information on various services started by Oracle on Windows.

  • OracleServiceXXX (XXX is SID): It's the only service that needs to be running to be able to work with a database locally. The default startup type will be Automatic for this service, so if you are working with a remote database change the startup type to Manual.
  • OracleOraHome92TNSListener: This service is only needed if the database will be accessed remotely. The default startup type will be Automatic for this service, so if you are working with a local database change the startup type to Manual.
  • OracleOraHome92HTTPServer: It's for the Apache server that you automatically install when you install Oracle. You generally only need it to access Web pages in the Oracle Apache directories, such as JSP pages.
  • OracleOraHome92ClientCache: This service caches Oracle Names data for connecting to remote databases. It is normally configured for Manual startup type. However, it isn't necessary to run this service unless you have an Oracle Names server running somewhere.
  • OracleOraHome92Agent: This one monitors the database and Enterprise Manager requests. It's an Automatic startup type of service.
  • OracleOraHome92PagingServer: Manual

    Requires Free Membership to View

  • startup type service which sends alerts out through an alphanumeric pager via a modem or e-mail.
  • OracleOraHome92SNMPPeerEncapsulato & OracleOraHome92SNMPPeerMasterAgent: These two services are typically used to handle the OracleOraHome92PagingServer service.
  • OracleMTSRecoveryService: This one is an optional service which allows your database to be used as a resource manager for the Microsoft Transaction Server, COM/COM+ objects and transactions in a distributed environment.

In case you do not use your database extensively, it's a better idea to create a simple batch file to start up and shut down these services easily. This way you can save your system's valuable resources.

Reader feedback:

German M. writes:

Yes, certainly, it has been identified that the Windows OS process is the main cause why PCs run slowly. In order to troubleshoot this issue, I would appreciate if you could explain how we can change and save this parameter in a PC. Thanks in advance.

Rahul responds:

As far as controlling parameters is concerned, you can follow these steps to do it:

  • Click on the Start button (on screen) or press the Windows button (on keyboard) and select the "Run" option.
  • Type services.msc in the Run dialog and hit the Enter button.
  • The services window will open, which shows all the services that Windows OS hosts.
  • Now select the service which you want to control.
  • For example, let's say we don't want the service named "OracleOraHome92TNSListener" to be running.
  • Go to that service and double-click it.
  • A dialog box will open which will give you all the options to control that service.
  • You may start, stop or control the startup type of that service from here.

This was first published in June 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.