The services and services that Oracle 11g must open are detailed

Source: Internet
Author: User

From: http://www.3lian.com/edu/2013/08-03/86558.html

After successfully installing the Oracle 11g database, you will find that your computer is running slower, that your computer is running faster with a lower-profile PC or even a very card-enabled Oracle service. So, how do you do it specifically?

After successfully installing Oracle 11g in accordance with the method of Oracle 11g R2 installation in Win7 64-bit environment, a total of 7 services are Oracle ORCL VSS Writer SERVICE,ORACLEDBCONSOLEORCL, respectively, ORACLEJOBSCHEDULERORCL,

Oraclemtsrecoveryservice,oracleoradb11g_home1clragent,oracleoradb11g_home1tnslistener,oracleserviceorcl. Among them ORACLEDBCONSOLEORCL,

The ORACLEMTSRECOVERYSERVICE,ORACLEORADB11G_HOME1TNSLISTENER,ORACLESERVICEORCL is automatically started by default, ORACLEJOBSCHEDULERORCL is automatically disabled by default, and the rest defaults to manual operation. Assuming your global database name is ORCL, your Oracle service should be the same as above. As shown in the following:

The meanings of these seven services are:

Oracle ORCL VSS Writer service:oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images of storage infrastructure (such as disks, arrays, etc.), i.e. mapped copies ( Shadow copy). It can create a mapped copy on multiple volumes or on a single volume without affecting the system's system performance. (must not be started)

Oracledbconsoleorcl:oracle Database Console service, ORCL is the instance identity of Oracle, and the default instance is ORCL. You need to start this service when you run Enterprise Manager (Enterprise Management Manager OEM). (must not be started)

Oraclejobschedulerorcl:oracle Job scheduling (timer) service, ORCL is the Oracle instance identity. (must not be started)

Oraclemtsrecoveryservice: Service-side control. The service allows the database to act as a resource manager for transactions in a Microsoft Transaction Server MTS, com/com+ object, and distributed environment. (must not be started)

Oracleoradb11g_home1clragent:oracle part of the database. Net Extension Service. (must not be started)

Oracleoradb11g_home1tnslistener: Listener service, the service is only needed when the database requires remote access. (not required to start, detailed below).

ORACLESERVICEORCL: The database service (DB instance), which is the Oracle Core service, is the basis for database startup, and only if the service is started, the Oracle database can start normally. (Must Start)

So what are the services that need to be started at the time of development?

For beginners, if you only use Oracle's own sql*plus, just start ORACLESERVICEORCL, and if you use a third-party tool such as PL/SQL developer, Oracleoradb11g_ Home1tnslistener service is also to be opened. ORACLEDBCONSOLEORCL is a web-based EM must be turned on, and the rest of the service is seldom used.

Note: ORCL is the database instance name, the default database is ORCL, you can create other, that is, the oracleservice+ database name.

Script:

To start the Oracle 11g service:

@echo off@ Echo launches Oracle 11g service net start "ORACLEDBCONSOLEORCL" net start "Oracleoradb11g_home1tnslistener" net start "Oracl ESERVICEORCL "@ echo start up press any key to continue pauseexit stop Oracle 11g service: @echo off@ ECHO stop Oracle 11g service net stop" ORACLEDBCONSOLEORCL "ne T stop "Oracleoradb11g_home1tnslistener" net stop "ORACLESERVICEORCL" @ ECHO stop Press any key to continue Pauseexit

The services and services that Oracle 11g must open are detailed

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.