Several common services in Oracle

What functions does Oracle provide? Time: 11:17:16 Source: Network Author: Unknown CLICK: 159 times Note: Sid-Database ID home_name-Oracle Home Name, such as orahome92, orahome81 (1) oracleservicesid Database Service, this service automatically starts and stops the database. If a database is installed, its default start type is automatic. The service process is Oracle. EXE, parameter text Note: Sid-Database ID home_name-Oracle Home Name, such as orahome92, orahome81 (1) oracleservicesid Database Service, this 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 initsid. ora, the log file sidalrt. log, the console svrmgrl. EXE, and sqlplus. EXE. (2) oraclehome_nametnslistener listener service, which is required only when the database requires 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 OEM agent service, which 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 name cache service, which 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 Connection Management Service is used to build the Connection Manager 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 connects to the gateway service and is used to build the Connection Manager 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_name‑atherer performance package data collection service, unless you use ORACLE capacity planner and Oracle Performance Manager, 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 the Web server provided by Oracle. Generally, 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, 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 sends a warning (not tried) via a digital pager or email using a modem. Its default start type is manual. Service Process pagntsrv. EXE, log file paging. log. (10) oraclehome_namenames Oracle names service, which 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 SNMP Service proxy, used to manage servers using SNMP-supported network management software. Unless you use a network management tool to monitor the database, you do not need to start it, its default start type is manual. The service process is agntsvc. EXE. The parameter file is master. cfg. The default port is 161. (12) oraclesnmppeerencapsulater SNMP protocol encapsulation service 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 OEM Management Service, which is required when OEM is used. Its default start type is manual. The service process is omsntsvr. EXE and the log file OMS. nohup. Many services are installed when Oracle 9i is installed in windows, and some of the configurations are enabled when Windows is started. 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 a service through Net start or stop a service by running the net stop command to control any of the following services. In Windows XP, you can change the Service (oracleorahome...) You want to disable in the service of the control panel ...) double-click a service to view its properties, and change the property of the Startup Type 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 the database (with shutdown interrupted ). 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 is only required when the database requires remote access (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 Oracle Enterprise Manager. These services are oracleorahome92agent (Intelligent proxy), which 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 occasionally use the database, you can create a simple script task to start and shut down the server. In this way, you only need to double-click the script each time, without using the graphic interface. 1. Save a shortcut to automatically load these files. 2. Set the Oracle service to manual to avoid starting during Windows startup. Rem "dbstart. cmd "@ echo off set orahome =" orahome92 "set orasid =" orcl "Net start oracleservice % orasid % REM Net start Oracle % orahome % httpserver REM Net start Oracle % orahome % tnslistener Rem net start Oracle % orahome % clientcache REM Net start Oracle % orahome % agent REM Net start Oracle % orahome % snmppeerencapsulator REM Net start Oracle % orahome % snmppeermasteragent REM Net start Oracle % orahome % pagingserver Rem net start oraclemtsrecoverservice REM "dbshut. cmd "@ echo off set orahome =" orahome92 "set orasid =" orcl "net stop oracleservice % orasid % REM net stop Oracle % orahome % httpserver REM net stop Oracle % orahome % tnslistener Rem net stop Oracle % orahome % clientcache REM net stop Oracle % orahome % agent REM net stop Oracle % orahome % snmppeerencapsulator REM net stop Oracle % orahome % snmppeermasteragent REM net stop Oracle % orahome % pagingserver Rem net stop oraclemtsrecoverservice this article comes from: development Institute http://edu.codepub.com Original article link: http://edu.codepub.com/2009/1028/16977.php