Manual startup and shutdown of Oracle services

1. When using Oracle, Oracle can run normally by starting OracleServiceORCL and OracleOraDb11g_home1TNSListener;

2. To allow hosts on the LAN to access your oracle database, you must start the oracleora81homemanagermentserver service.

3. Oracle service startup and shutdown scripts (in windows)

Note: Instance name: ORCL

(1) Create the startup script dbstart. cmd

Cmd code

Dbstart

@ Echo halt oracle service...

Net stop OracleServiceORCL

Net stop OracleDBConsoleorcl

Net stop OracleOraDb11g_home1TNSListener

Pause

(2) create and close the script dbstop. cmd

Cmd code

Dbstop

@ Echo halt oracle service...

Net stop OracleServiceORCL

Net stop OracleDBConsoleorcl

Net stop OracleOraDb11g_home1TNSListener

Pause

Note: ORCL is the Oracle Instance name (customized when Oracle is installed ).

Appendix: Oracle services:

(1) OracleServiceSID

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

(2) OracleHOME_NAMETNSListener

The Listener service is only required when the database needs Remote Access (whether through another host or local SQL * Net network protocol ), you can access the local database without using this service. Its default start 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 ConnectionManager server. Only the server is required 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 gateway service is used to build the ConnectionManager server. Only the server is required as the Connection Manager, and 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

Performance package data collection service, unless you use Oracle Capacity Planner and Oracle container cemanager, it does not need to be started. 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.