How to manage Oracle services in Windows

Oracle Database has many services. The following describes the Oracle service management in Windows, hoping to help you learn about Oracle database.

Many services will be installed when Oracle is installed in Windows, and some of them are configured to start at Windows startup. 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 an Oracle service through net start or stop an Oracle service by running the net stop command to control any of the following services. In Windows XP, you can change the OracleOraHome service you want to disable in the control panel service ...) startup Type) parameter, double-click a service to view its properties, and then change the launch Type attribute 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 database shutdown interruption ). 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 only requires remote access from the database, 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 the Oracle Enterprise Manager. The services are OracleOraHome92Agent intelligent agents. The Service 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 use the database occasionally, you can create a simple script to start and close the server to avoid occupying resources every time the oracle service follows the system startup. In this way, you only need to double-click the script, you can skip the GUI.

1. Create a batch file to automatically load these services.

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

Start Script: dbstart. cmd

@ Echo off
Echo ===== start Oracle series services: ======
Several services in rem do not need to be started at ordinary times. To start the services, remove the REM command:

Set ORAHOME = DEFAULT_HOME1
Set ORASID = POPDAY

Echo
Net start OracleService % ORASID %
Net start Oracle % ORAHOME % HTTPServer
Net start Oracle % ORAHOME % TNSListener
Net start Oracle % ORAHOME % Agent
Net start OracleMTSRecoveryService
Rem net start Oracle % ORAHOME % ClientCache
Rem net start Oracle % ORAHOME % SNMPPeerEncapsulator
Rem net start Oracle % ORAHOME % SNMPPeerMasterAgent
Rem net start Oracle % ORAHOME % PagingServer
Pause

Several instructions of REM block this action, and these services are not necessarily used at ordinary times, so they are not started. If you need to use it, cancel REM.

Close the Script: dbshut. cmd

@ Echo off

Echo ====== close Oracle series services: ======

Set ORAHOME = DEFAULT_HOME1
Set ORASID = ARCHWAY

Echo
Net stop OracleService % ORASID %
Net stop Oracle % ORAHOME % HTTPServernet stop Oracle % ORAHOME % TNSListener
Net stop Oracle % ORAHOME % Agent
Net stop OracleMTSRecoveryService
Rem net stop Oracle % ORAHOME % ClientCache
Rem net stop Oracle % ORAHOME % SNMPPeerEncapsulator
Rem net stop Oracle % ORAHOME % SNMPPeerMasterAgent
Rem net stop Oracle % ORAHOME % PagingServer

PAUSE

Implementation of Oracle redo log

How to modify the size of Oracle archive logs

Oracle Log File Management

Read and Write files in Oracle stored procedures

Oracle XE built-in database creation process