Detailed knowledge about Oracle Database Service

In Oracle Database Operations, we often need to start or close some services to implement the functions we need. But the premise is that we must understandOracle Database ServicesIf you are not familiar with Oracle database services, it doesn't matter. In this article, we will provide a detailed introduction to Oracle database services, next let's take a look at this part.

Oracle has five default services:

1. process of the 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> Administrative Tools", or directly enter "Services. msc opens the service Settings dialog box, and you can see that each service has the following attributes: name, description, status, Startup type, logon identity, and dependency.

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

OracleJobSchedulerORCL -- generally, it is not started and is used to periodically operate the services of tasks;

OracleOraDb10g_home1iSQL * Plus -- it can be disabled. This is the isqlplus Service, which is used to execute SQL statements on webpages. This function has been canceled for the 11g;

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

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

You can run the following command to start:

# Start listener: lsnrctl start

# Start Database: net start OracleServiceORCL

Only these two items must be started: OracleOraDb10g_home1TNSListener and 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, the service only requires remote access to the database, 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 to 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 warning using a modem has not been tried), and 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.

Here is an introduction to Oracle database services. I hope this introduction will be helpful to you!