 |
|
| Oracle Tips: |
|
|
|
ORACLE DATABASE ADMINISTRATOR
Control Oracle services on Windows
Rahul Shah
06.14.2006
Rating: -4.13- (out of 5)
|
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 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.
|
|
Rate this Tip
|
To rate tips, you must be a member of SearchOracle.com.
Register now
to start rating these tips. Log in if you are already a member.
|
Submit a Tip
|
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.
|
|
|
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
