Summary of Oracle Database System Services

Note that (SID) indicates the SID Name specified during database installation, and (HOME_NAME) indicates the last Oracle Installation name of the value specified by ORACLE_HOME during installation, in Windows, the default value is similar to OraDb11g_home1. Oracle can have multiple instances on one machine. If multiple instances are used, services related to SID and HOME_NAME in the following services will exist in multiples, for applications of a common database or an instance, each service appears only once. None of the following services exist, which is related to the installation and usage of Oracle.

　　OracleDBConsole (SID)This is the Oracle Enterprise Manager used by the browser, that is, the service to be used to access (https: // localhost: 1158/em ).

Oracle (HOME_NAME) iSQL * Plus is an isql * plus service. To use isqlplus, you must enable this service.

　　OracleService (SID) primary database serviceThe service 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 init (SID). ora, the log file (SID) ALRT. log, and the console SVRMGRL. EXE and SQLPLUS. EXE.

If you only use sqlplus on the console to operate the database on the local machine, you only need to start the service

　　Oracle (HOME_NAME) TNSListener listener serviceThe service is only required when the database needs Remote Access (whether through another host or local SQL * Net network protocol ), this service is not required for local database access. Its default start type is automatic and the service process is TNSLSNR. EXE, parameter file listener. ora, log file listener. log, LSNRCTL in the console. EXE. Default ports are 1521 and 1526.

　　Oracle (HOME_NAME) Agent OEM Agent serviceTo receive and respond to tasks and Event requests from the OEM console. This is only required when you use the OEM to manage databases. Its default start type is automatic and the service process is DBSNMP. EXE, parameter file snmp_rw.ora, log file nmi. log, LSNRCTL in the console. EXE, default port 1748.

　　Oracle (HOME_NAME) ClientCache name cache serviceThe service cache is used to connect Oracle Names data of a remote database. Its default start type is manual. However, unless there is an Oracle Names server, it is not necessary 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.

　　Oracle (HOME_NAME) CMAdmin Connection Management ServiceIs used to build the Connection Manager server. Only the server is required as the Connection Manager. Its default start type is manual and the service process is CMADMIN. EXE, the parameter file CMAN. ORA, log file CMADM_PID.TRC, console CMCTL. EXE, default port 1830.

　　Oracle (HOME_NAME) CMan connection gateway serviceIs used to build the Connection Manager server. Only the server is required as the Connection Manager. Its default start type is manual and the service process is CMGW. EXE, the parameter file CMAN. ORA, log file CMAN_PID.TRC, console CMCTL. EXE, default port 1630.

　　Oracle (HOME_NAME) extends atherer performance package data collection serviceUnless you use Oracle Capacity Planner and Oracle Performance Manager, you do not need to start the service. The default start type is manual, the service process is VPPDC. EXE, the log file alert_dg.log, And the console vppcntl.exe.

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

　　Oracle (HOME_NAME) PagingServerA digital pager or email with a modem sends a warning. The default start type is manual, the service process PAGNTSRV. EXE, and the log file paging. log.

　　Oracle (HOME_NAME) Names Oracle Names ServiceOnly the Server is required as the Names Server. Its default start type is manual and the service process NAMES. EXE, parameter file NAMES. ORA, log file NAMES. LOG, NAMESCTL in the console. EXE, default port 1575.

　　OracleSNMPPeerMasterAgent SNMP Service ProxyThe SNMP-enabled network management software manages the server. Unless you use the network management tool to monitor the database, you do not need to start it. The default start type is manual and the service process is AGNTSVC. EXE, parameter file MASTER. CFG, default port 161.

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

　　Oracle (HOME_NAME) ManagementServer OEM Management ServiceWhen using OEM, the default start type is manual, the service process is OMSNTSVR. EXE, and the log file oms. nohup.