What is the role of Oracle Multiple services (RPM)

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

As long as you have administrator rights, you can start a service through net start or stop a service by using the net STOP command to control any one of the following services. In Windows XP, you can change the services you want to disable by changing the service in the Control Panel (Oracleorahome ... Startup type parameter, double-click a service to view its properties, and then change the Startup Type property from Automatic to Manual.

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

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

The oracleorahome92tnslistener service is only required if the database requires remote access (either through a different 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. Under normal circumstances, the startup type of the service is configured to manual. However, there is no need to run this service unless there is an Oracle Names server.

There are four services that are required by Oracle Enterprise Manager, which are: oracleorahome92agent (intelligent agent), which monitors database and Enterprise Manager requests, and the default startup type is automatic. Oracleorahome92snmppeerencapsulator and Oracleorahome92snmppeermasteragent, handling secure network Management protocol services. Oracleorahome92pagingserver a warning via a digital pager or email using a modem.

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

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

1. Save a shortcut to load these files automatically.

2. Set the Oracle service to manual to avoid booting 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