Oracle Tip: Manage Oracle9i services under Windows

Because Oracle uses so many resources running under Windows, you may find it useful to be able to shut down the database completely and quickly, without going through the Windows graphical interfaces.

This article originally appeared in the Oracle e-newsletter. Click here to subscribe automatically.

When Oracle9i is installed under the Windows operating system, it installs a number of services—some of which are configured to start whenever Windows starts. While Oracle is running under Windows, it consumes a lot of resources and may not always be needed. You may find it useful to be able to shut down the database completely and quickly, without going through the Windows graphical interfaces.

As long as you have admin privileges, you can control any of the following services using the command net start to start a service and net stop to stop the service. In Windows XP, you can change the Startup Type parameter by going to the Services control panel, locating the service you wish to disable (OracleOraHome...), double-clicking on it to view the service properties, and changing the Startup Type property from Automatic to Manual.

The only service that needs to be running to be able to work with a database locally is the OracleServiceORCL service (where ORCL is the SID). This service will also automatically start up and shut down the database (using shutdown abort). If you installed a database, the default startup type will be Automatic. If you're primarily accessing a remote database, you can switch this to Manual startup type.

The OracleOraHome92HTTPServer service (where OraHome92 is the name of the Oracle Home) is 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 and modplsql pages.

The OracleOraHome92TNSListener service is only needed if the database will be accessed remotely (either from another host or locally via a SQL*Net network protocol). You can access local databases without this service.

The OracleOraHome92ClientCache service caches Oracle Names data for connecting to remote databases. This service 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.

There are four more services that are necessary for the Oracle Enterprise Manager: OracleOraHome92Agent (the Intelligent Agent), which monitors the database and Enterprise Manager requests and defaults to an Automatic startup type. OracleOraHome92SNMPPeerEncapsulator and OracleOraHome92SNMPPeerMasterAgent, which handle the Secure Network Management Protocol service. OracleOraHome92PagingServer, which sends alerts out through an alphanumeric pager via a modem or e-mail.

The OracleMTSRecoveryService, which is optional, allows your database to be used as a resource manager for the Microsoft Transaction Server, COM/COM+ objects, and transactions in a distributed environment.

If you only use your database occasionally, you can create simple batch jobs to start up and shut down your database with a double-click, without going through the graphical interface.

  1. Save a shortcut somewhere to launch these files automatically.
  2. Set all your Oracle services to manual to avoid starting up with Windows boot.

REM "dbstart.cmd"
@echo off
set ORAHOME="OraHome92"
net start OracleService%ORASID%
REM net start Oracle%ORAHOME%HTTPServer
REM net start Oracle%ORAHOME%TNSListener
REM net start Oracle%ORAHOME%ClientCache
REM net start Oracle%ORAHOME%Agent
REM net start Oracle%ORAHOME%SNMPPeerEncapsulator
REM net start Oracle%ORAHOME%SNMPPeerMasterAgent
REM net start Oracle%ORAHOME%PagingServer
REM net start OracleMTSRecoverService

REM "dbshut.cmd"
@echo off
set ORAHOME="OraHome92"
net stop OracleService%ORASID%
REM net stop Oracle%ORAHOME%HTTPServer
REM net stop Oracle%ORAHOME%TNSListener
REM net stop Oracle%ORAHOME%ClientCache
REM net stop Oracle%ORAHOME%Agent
REM net stop Oracle%ORAHOME%SNMPPeerEncapsulator
REM net stop Oracle%ORAHOME%SNMPPeerMasterAgent
REM net stop Oracle%ORAHOME%PagingServer
REM net stop OracleMTSRecoverService

Scott Stephens worked for Oracle for more than 13 years in technical support, e-commerce, marketing, and software development. For more of his Oracle tips visit our Oracle Dev Tips Library.

Editor's Picks