Managing Oracle9i Services under Windows

Many services are installed when Oracle 9i is installed under the Windows operating system-and some of them are configured to start when Windows starts. When Oracle is running under Windows, it consumes a lot of resources, and some services may not always be needed. You'll find it useful to quickly and completely shut down a database without using the Windows graphical interface.

If you have administrator privileges, you can start a service through net start or stop a service through the net STOP command to control any of the following services. In Windows XP, you can change the services you want to disable (Oracleorahome ...) in the services in the Control Panel. Startup type parameter, double-click a service to view its properties, and then change the Startup Type property from automatically to manual.

The only service that makes the database work locally is the ORACLESERVICEORCL service (where ORCL is the SID). This service will automatically start and stop the database (using shutdown interrupts). If a database is installed, its default startup type is automatic. If you are primarily accessing a remote database, you can change the startup type from automatic to manual.

The Oracleorahome92httpserver service (OraHome92 is the name of Oracle home) is an Apache server that is automatically installed when Oracle is installed. In general, we only use it to access Web pages in the Oracle Apache directory, such as JSP or Modplsql pages.

The Oracleorahome92tnslistener service is required only if the database requires remote access (whether it is remote access through another host or locally through the Sql*net Network protocol). You can access the local database without this service.

The Oracleorahome92clientcache service caches Oracle Names data that is used to connect to remote databases. Normally, the startup type of the service is configured to manual. However, it is not necessary to run this service unless there is an Oracle Names server.

There are four services that are required by Oracle Enterprise Manager (Oracle Enterprise Manager), the service is: oracleorahome92agent (intelligent agent), which monitors the database and Enterprise Manager requests, and the default startup type is automatic. Oracleorahome92snmppeerencapsulator and Oracleorahome92snmppeermasteragent, handling secure network Management protocol services. Oracleorahome92pagingserver warns with a digital pager or e-mail message that uses a modem.

Oraclemtsrecoveryservice is optional, which allows the database to act as a resource manager for Microsoft Transaction servers, com/com+ objects, and transactions in a distributed environment.

If you only use the database occasionally, you can create a simple scripting task to start and shut down the server so that you can double-click the script every time, without using a graphical interface.

1. Save a shortcut to automatically load these files.

2. Set Oracle services to manually avoid starting when Windows starts.

REM "Dbstart.cmd" @echo off Set Orahome= "OraHome92" Set orasid= "ORCL" 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" Set orasid= "ORCL" 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