Roles of several services in Oracle9i

Many services such as mdash and mdash are installed when Oracle9i is installed in Windows, and some of the configurations are enabled when Windows is started. Running on Wi in Oracle

Many services such as mdash and mdash are installed when Oracle 9i is installed in Windows, and some of these configurations are enabled when Windows is started. Running on Wi in Oracle

Many services are installed when Oracle 9i is installed in Windows, and some of the configurations are enabled when Windows is started. When Oracle runs in Windows, it consumes a lot of resources, and some services may not always be required. You will find it useful to close the database quickly and completely without using the Windows graphic interface.

As long as you have the administrator privilege, you can start a service through net start or stop a service by running the net stop command to control any of the following services. In Windows XP, you can change the Service (OracleOraHome...) You want to disable in the service of the control panel ...) double-click a service to view its properties, and change the property of the Startup Type from automatic to manual.

The only service required to run the database locally is the OracleServiceORCL Service (where ORCL is SID ). This service automatically starts and stops the database (with shutdown interrupted ). If a database is installed, its default start type is automatic. If you access a remote database, you can change the Startup Type from automatic to manual.

OracleOraHome92HTTPServer Service (OraHome92 is the name of Oracle Home) is the Apache server automatically installed when Oracle is installed. Generally, we only use it to access the Web pages under the Oracle Apache directory, such as JSP or modplsql pages.

The OracleOraHome92TNSListener service is only required when the database requires remote access (whether through another host or through the SQL * Net network protocol locally ). You can access the local database without using this service.

The OracleOraHome92ClientCache service caches Oracle Names data used to connect to a remote database. Under normal circumstances, the Startup Type of the service is configured as manual. However, unless you have an Oracle Names server, you do not need to run this service.

Four services are required by Oracle Enterprise Manager. These services are: OracleOraHome92Agent (Intelligent proxy), which monitors database and Enterprise Manager requests, the default start type is automatic. OracleOraHome92SNMPPeerEncapsulator and OracleOraHome92SNMPPeerMasterAgent process secure network management protocol services. OracleOraHome92PagingServer sends a warning via a digital pager or email using a modem.

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

If you only occasionally use the database, you can create a simple script task to start and shut down the server. In this way, you only need to double-click the script each time, without using the graphic interface.

1. Save a shortcut to automatically load these files.

2. Set the Oracle service to manual to avoid starting during Windows startup.

,