Definitions of common Oracle services

Oracle has five default services:

1. Service Process of OracleDBConsoleorcl oem Console

2. Service Process of OracleJobSchedulerORCL Timer

3. OracleOraDb10g_home1iSQL * Plus isql * plus service process

4. Service Process of OracleOraDb10g_home1TNSListener listener

5. OracleServiceORCL Database Service Process

To view started services in the system, double-click Services in "Start> Control Panel> Management Tools" or directly

In "run", enter "Services. msc" to open the service Settings dialog box. You can see that each service has the following attributes:

Sex: name, description, status, Startup type, logon identity, dependency.

OracleDBConsoleorcl -- can be used to manage Oracle Enterprise Manager services without being started.

OracleJobSchedulerORCL -- a service that is usually not started and is used to operate tasks on a regular basis

OracleOraDb10g_home1iSQL * Plus -- it cannot be started. This is the isqlplus Service, which is used to execute SQL statements on webpages. The 11g has

This function has been canceled

OracleOraDb10g_home1TNSListener -- must be started. This is a listener for remote clients to connect to your Oracle

OracleServiceORCL -- must be started. This is the service of Oracle Database.

You can run the following command to start:

# Start listener:

Lsnrctl start

# Starting a database

Net start OracleServiceORCL

Only these two items must be started:

OracleOraDb10g_home1TNSListener

OracleServiceORCL

Why does OracleJobSchedulerORCL display disabled?

Generally, you do not need to start a Database Job Schedule if you do not have a job schedule. Why is it disabled by default? It takes up a lot of system resources after startup.

(1) OracleServiceSID

Database Service, which automatically starts and stops the database. If a database is installed, its default start type is automatic. The service process is Oracle. EXE, the parameter file initSID. ora, the log file SIDALRT. log, the console SVRMGRL. EXE, and SQLPLUS. EXE.

(2) OracleHOME_NAMETNSListener

Listener service is required only when the database needs Remote Access (whether through another host or locally through SQL.. Net network protocols are all remote access). You can access the local database without using this service. The default startup type is automatic. The service process is TNSLSNR. EXE, the parameter file Listener. ora, the log file listener. log, and the console LSNRCTL. EXE. The default ports are 1521 and 1526.

(3) OracleHOME_NAMEAgent

The OEM Proxy Service receives and responds to tasks and Event requests from the OEM console. It is only required when you use the OEM to manage databases. Its default start type is automatic. The service process is DBSNMP. EXE, the parameter file snmp_rw.ora, the log file nmi. log, and the console LSNRCTL. EXE. The default port is 1748.

(4) OracleHOME_NAMEClientCache

The name cache service is used to connect Oracle Names data of a remote database. Its default start type is manual. However, unless you have an Oracle Names server, you do not need to run this service. The service process is ONRSD. EXE, the parameter file NAMES. ORA, the LOG file ONRSD. LOG, and the console NAMESCTL. EXE.

(5) OracleHOME_NAMECMAdmin

The Connection Management Service is used to build the Connection Manager server. It is only required by the server as the Connection Manager. Its default start type is manual. The service process is CMADMIN. EXE, the parameter file CMAN. ORA, the log file CMADM_PID.TRC, And the console CMCTL. EXE. The default port is 1830.

(6) OracleHOME_NAMECMan

The Connection gateway service is used to build the Connection Manager server. It is only required by the server as the Connection Manager. Its default start type is manual. The service process is CMGW. EXE, the parameter file CMAN. ORA, the log file CMAN_PID.TRC, And the console CMCTL. EXE. The default port is 1630.

(7) oraclehome_namepolicatherer

The Performance package data collection service does not need to be started unless Oracle Capacity Planner and Oracle Performance Manager are used. Its default start type is manual. The service process is vppdc.exe, the log file alert_dg.log, and the console vppcntl.exe.

(8) OracleHOME_NAMEHTTPServer

Generally, we only use the WEB server provided by Oracle to access the Web pages under the Oracle Apache directory, such as JSP or modplsql pages. Unless you use it as your HTTP service, you do not need to start it (if you start it, it will take over the IIS service). Its default start type is manual. The service process is APACHE. EXE and the parameter file httpd. conf. The default port is 80.

(9) OracleHOME_NAMEPagingServer

A digital pager or email with a modem sends a warning (not tried). Its default start type is manual. Service Process PAGNTSRV. EXE, log file paging. log.

(10) OracleHOME_NAMENames

The Oracle Names service is required only when the Server is used as the Names Server. Its default start type is manual. Service Process NAMES. EXE, parameter file NAMES. ORA, LOG file NAMES. LOG, console NAMESCTL. EXE, default port 1575.

(11) OracleSNMPPeerMasterAgent

The SNMP Service proxy is used to manage the server by the SNMP network management software. Unless you use the network management tool to monitor the database, you do not need to start the server. The default start type is manual. The service process is AGNTSVC. EXE. The parameter file is MASTER. CFG. The default port is 161.

(12) OracleSNMPPeerEncapsulater

The SNMP encapsulation service is used for SNMP protocol conversion. Unless you use an incompatible SNMP proxy service, it does not need to be started. The default start type is manual. The service process is ENCSVC. EXE, and the parameter file is ENCAPS. CFG. The default port is 1161.

(13) OracleHOME_NAMEManagementServer

The default start type of the OEM Management Service is manual. The service process is OMSNTSVR. EXE and the log file oms. nohup.

OracleServiceMYDB

OracleOraHome92TNSListener

Generally, you do not need to open other resources.