Introduction to Oracle services in Windows

Introduction to Oracle services in Windows: The Oracle service list of one node of RAC in 11gr2. Oracle does not need to start all services in the background when processing general transactions. Because the oracle service occupies a large amount of system resources, start the listening service OracleHOME_NAMETNSListener and the database service OracleServiceSID to meet most of the data processing needs. (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 SIDALERT. 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, parameter file Listener. ora, log file listener. log, LSNRCTL in the console. EXE. The default port 1521 (3) 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. (4) Oracle Object Service This service updates all nodes when symbolic links are modified. when installed, this service is set to autostart, so that it starts whenever you restart your system. (5) Oracle vss writer servic Oracle Volume Shadow Copy Service (VSS) Writer runs on Windows 2003 or later. VSS is a Windows architecture that includes three aspects: • Requestors-management applications that initiate backup and recovery • Writers-applications that own the data • Providers-storage/hardware applications that coordinate the reading and writing of the data to appropriate storage some leading the backup technology and storage vendor provides the Oracle VSS writer application service, the customer can back up and restore Oracle data in the VSS environment. It can perform interactive operations with supplier components. (6) A new service in OracleDBconsole Oracle10g. Before Oracle9i, Oracle officially provided a graphical-Based Enterprise Manager (EM). Starting from Oracle10g, Oracle provided a B/S-based enterprise manager, enter the emctl start dbconsole command in the command line of the operating system to start the OracleDbConsole service. After the service is started, enter the EM address in the browser, use the B/S method to manage the Oracle server (7) OracleJobScheduler database work schedule. Generally, you do not need to start it if you do not schedule it. Why is it disabled by default? It takes a lot of system resources (8) to start all the Clusterware Daemon Processes in OracleOHService Windows, including oracle cluster components such as CRS, CSS, CTSS, and GNS. (9) OracleCrs_HOMETNSListener_SCAN1 SCAN (Single Client Access Name, Single Client Access Name) is a very important feature introduced in Oracle 11gR2. SCAN Listener works with the local Listener to connect to the RAC database through load balancing.