Oracle 11G service details and what services must be enabled

After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your computer. So what should we do?

After Oracle 11g R2 is successfully installed in Windows 64-bit environment, seven services are available: Oracle orcl VSS writer service, oracledbconsoleorcl, and oraclejobschedulerorcl,
Oraclemtsrecoveryservice, oracleoradb11g_home1clragent, oracleoradb11g_home1tnslistener, oracleserviceorcl. Oracledbconsoleorcl,
Oraclemtsrecoveryservice, oracleoradb11g_home1tnslistener, oracleserviceorcl is automatically started by default, oraclejobschedulerorcl is automatically disabled by default, and other operations are manually performed by default. Assuming that your global database is named orcl, your Oracle service should be the same as the above. As shown in:

The seven services have the following meanings:

Oracle orcl VSS writer service:Oracle volume ing copy write service. VSS (Volume Shadow Copy Service) allows storage basic devices (such as disks and arrays) to create high fidelity time point images, that is, shadow copy ). It can create ing copies on multiple volumes or a single volume without affecting the system performance. (Not mandatory)

Oracledbconsoleorcl:Oracle Database Console service. orcl is the instance id of Oracle. The default instance is orcl. Start this service when running Enterprise Manager (Enterprise Manager OEM. (Not mandatory)

Oraclejobschedulerorcl:Oracle Job Scheduling (timer) service. orcl is the Oracle instance id. (Not mandatory)

Oraclemtsrecoveryservice:Server Control. This service allows the database to act as a resource manager for transactions in the distributed environment, such as the Microsoft Transaction Server MTS, COM/COM + objects, and transactions. (Not mandatory)

Oracleoradb11g_home1clragent:Part of the Oracle database. Net extension service. (Not mandatory)

Oracleoradb11g_home1tnslistener:Listener service, which is required only when the database needs remote access. (It is not required to be started. Details will be provided below ).

Oracleserviceorcl:Database Service (database instance) is the core service of Oracle. It is the basis for database startup. Only when the service is started can the Oracle database be started normally. (Must be started)

What services need to be started during development?

For beginners, if you only use the SQL * Plus provided by Oracle, you only need to start oracleserviceorcl. If you use third-party tools such as PL/SQL developer, the oracleoradb11g_home1tnslistener service must also be enabled. Oracledbconsoleorcl must be enabled to access the Web-based EM, and is rarely used by other services.

Note: orcl is the database instance name, and the default database is orcl. You can create another database, that is, oracleservice + database name.

This article is from T4 boys. Please indicate the source and corresponding links when reprinting.