What are the oracle services?

Oracle service has seven major parts: 1. Volume mapping copy writing service, which can create mapping copies on multiple volumes or a single volume without affecting the system performance; 2. Database console service , this service needs to be started when running Enterprise Manager OEM; 3. Server control service, which can be used as a resource manager for transactions; 4. Listener service, etc.

The operating environment of this tutorial: Windows 7 system, Oracle 11g version, Dell G3 computer.

Oracle services are mainly divided into seven parts according to product classification. The meanings of these seven services are:

1. Oracle ORCL VSS Writer Service: Oracle Volume mapping copy writing service, VSS (Volume Shadow Copy Service) enables storage infrastructure devices (such as disks, arrays, etc.) to create high-fidelity point-in-time images, that is, shadow copies. It can create mapped copies on multiple volumes or a single volume without affecting the system performance. (Not required to start)

2. OracleDBConsoleorcl: Oracle database console service , orcl is the instance identifier of Oracle, and the default instance is orcl.

When running Enterprise Manager (Enterprise Manager OEM), you need to start this service. (Not required to start)

3. OracleJobSchedulerORCL: Oracle job scheduling (timer) service , ORCL is the Oracle instance identifier. (Not required to start)

4. OracleMTSRecoveryService: Server control service.

This service allows the database to act as a resource manager for Microsoft Transaction Server MTS, COM/COM objects and transactions in a distributed environment. (Not required to start)

5. OracleOraDb11g_home1ClrAgent: Part of the Oracle database .NET extension service. (Not required to start)

6. OracleOraDb11g_home1TNSListener: Listener service , the service is only needed when the database requires remote access. (It is not necessary to start, as will be explained in detail below).

7. OracleServiceORCL: Database service (database instance) is the core Oracle service. This service is the basis for database startup. Only when this service is started, the Oracle database can start normally. (Must be started)

So which services need to be started during development?

For novices, if you only use Oracle's own sql*plus, 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 enter web-based EM, and other services are rarely used.

Note: ORCL is the database instance name. The default database is ORCL. You can create other ones, namely OracleService database name.

Extended knowledge: The benefits of Oracle original service are: software value preservation, cost saving; system optimization anytime, anywhere;

Why should I continue to buy the original service? Service?

1. In the long run, it saves costs and is the best way to preserve the value of software---Did you know that during the service period, you can get the latest version of the product for free, or Upgrade to the latest version. For example: you purchased 9i a few years ago and have purchased services for several years. Then you can upgrade to 10g by getting the latest optical disc media. There is no need to spend huge amounts of money to purchase licenses for new products.

　2. Optimize system performance anytime and anywhere---With the continuous use of software products, the amount of data will continue to increase, the processing workload will continue to increase, system problems will occur or efficiency will decrease, so frequent Pay attention to patch downloads, bug fixes and other information released on Metalink. Regularly doing optimization work to reduce downtime can help you avoid unpredictable losses.

3. Provide guarantee---You must agree with this point of view. Only we, Oracle, know our products best. Database software is relatively more complex than other software and requires professional technical personnel to provide timely support. If there is no original factory service, if there is a problem that you or the service provider cannot solve, you will not only suffer losses in terms of expenses, but it will also affect your use in terms of time, resulting in immeasurable losses. (According to the rules of the software service industry, renewal after expiration requires you to first pay 150% of the fee during the service interruption period as a service restoration fee. At the same time, it will take a certain amount of time to process your request).
The loss of data and time is priceless. Please leave this responsibility to Oracle, not yourself or others. This is one of the main reasons why many smart customers continue to purchase services.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What are the oracle services?. For more information, please follow other related articles on the PHP Chinese website!