Oracle has several services

Oracle has 7 services, namely: 1. Volume mapping copy writing service; 2. Oracle database console service; 3. Oracle job scheduling service; 4. Server control service; 5. Oracle database NET extension service; 6. Listener service, the service is only needed when the database requires remote access; 7. Database service, only when the service is started, the Oracle database can start normally.

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

Oracle has 7 services. These seven services are:

1. Oracle ORCL VSS Writer Service: Oracle volume mapping copy writing service, VSS (Volume Shadow Copy Service allows 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 extended 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), which is the core service of Oracle. 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.

Expand knowledge: The benefits of Oracle's original services are: software value preservation, cost savings; system optimization anytime, anywhere;

Why should we continue to purchase original services?

　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, if you renew after expiration, you first need to pay 150% of the fee during the service interruption period as the 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.

The above is the detailed content of Oracle has several services. For more information, please follow other related articles on the PHP Chinese website!