Start Oracle11g Service

Start Oracle11g Service

When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we do? The following is a brief introduction.

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)

OracleOraDb11g_home1TNSListener: Listener service, which is required only when the database needs remote access. (Not required ).

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)

From the above introduction, we can see that 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.

Generally, we only need to start the OracleServiceORCL OracleOraDb11g_home1TNSListener services.

Next let's take a look at how we start Oracle in the command line:

Start OracleOraDb11g_home1TNSListener

C: \ Documents and Settings \ User> lsnrctl startLSNRCTL for 32-bit Windows: Version 11.1.0.7.0-Production on 16-APR-2013 16: 32: 09 Copyright (c) 1991,200 8, Oracle. all rights reserved. starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Version 11.1.0.7.0-Production the system parameter file is E: \ app \ User \ product \ 11.1.0 \ db_1 \ network \ admin \ listener. ora write e: \ app \ user \ diag \ tnslsnr \ HT-1376 \ listener \ alert \ log. xml log information monitoring: (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \\. \ pipe \ EXTPROC1521ipc) Listener: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 172.16.13.20) (PORT = 1521 ))) connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) STATUS of the LISTENER ------------------------ Alias LISTENERVersion TNSLSNR for 32-bit Windows: version 11.1.0.7.0-ProductionStart Date 16-APR-2013 16: 32: 10 Uptime 0 days 0 hr. 0 min. 2 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File E: \ app \ User \ product \ 11.1.0 \ db_1 \ network \ admin \ listener. oraListener Log File e: \ app \ user \ diag \ tnslsnr \ HT-1376 \ listener \ alert \ log. xmlListening Endpoints Summary... (DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (PIPENAME = \\. \ pipe \ EXTPROC1521ipc) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 172.16.13.20) (PORT = 1521) The liste Ner supports no servicesThe command completed successfully start OracleServiceORCLC: \ Documents and Settings \ User> net start OracleServiceORCLOracleServiceORCL service is starting .............. the OracleServiceORCL service has been started successfully.

Start OracleServiceORCL

C: \ Documents ents and Settings \ User> net start OracleServiceORCLOracleServiceORCL service is starting... OracleServiceORCL service has been started successfully.

To disable the service, run lsnrctl stop and net stop OracleServiceORCL to stop the above two services.

Next, let's take a look at a common problem: Why cannot the service be started when our ip address changes?

This is because after Oracle is successfully installed, the system will depend on the IP address when Oracle is installed in the following three places (Oracle_home = E: \ app \ User \ product \ 11.1.0 \ db_1)

1). There is a directory named "Current IP_orcl" under % Oracle_HOME %, which stores the configuration of the oracle database named orcl and other information.

2) There is a directory named "OC4J_DBConsole _ current IP_orcl" in the % Oracle_HOME % \ Solaris \ j2ee Directory, which stores the configuration information of the OracleDBConsole service.

3) In the listener. ora file under % Oracle_HOME % \ NETWORK \ ADMIN, HOST in listener and ORCL in tnsnames. ora is the current IP Address

After the environment IP address changes, you must modify the files in the above three locations and change the above IP address to the name of the current machine or the current IP address.

After the modification is complete, restart the service and you will find that the two services OracleServiceORCL OracleOraDb11g_home1TNSListener can be started normally.

However, we still cannot start OracleDBConsoleorcl at this time. If you need to use EM, we must follow the steps below to modify the configuration.

Step 1:

C: \ Documents ents and Settings \ User> set oracle_sid = orclC: \ Documents ents and Settings \ User> emca-repos recreateEMCA started at 16: 42: 46EM Configuration Assistant, 11.1.0.7.0 official Edition Copyright (c) 2003,200 5, Oracle. All rights reserved. Enter the following information: Database SID: orcl listener port: 1521SYS User Password: SYS User Password: SYSMAN User Password: Continue? [Yes (Y)/NO (N)]: y2013-4-16 16:43:11 oracle. sysman. emcp. EMConfig perform information: The operation is logged to E: \ app \ User \ export toollogs \ emca \ orcl \ emca_2013_04_16_16_42_45.log. 16:43:12 oracle. sysman. emcp. EMReposConfig invoke information: deleting the EM archives (this operation may take some time )... 16:46:18 oracle. sysman. emcp. EMReposConfig invoke information: the data file 16:46:19 oracle has been deleted successfully. sysman. emcp. EMReposConfig createRepository information: creating the EM data archival Library (this operation may take some time )... 16:54:55 oracle. sysman. emcp. EMReposConfig invoke information: You have successfully created an archive. EMCA has been successfully configured for Enterprise Manager and ended at 16:54:55, January 16 ,.

Step 2:

C: \ Documents ents and Settings \ User> emca-config dbcontrol dbEMCA started at 17: 00: 51EM Configuration Assistant, official version 11.1.0.7.0 copyright (c) 2003,200 5, Oracle. All rights reserved. Enter the following information: Database SID: orcl has configured Database Control for the Database orcl. You have selected to configure Database Control to manage the Database orcl. This operation will remove the existing configuration and default settings, and re-execute the configuration to continue? [Yes (Y)/NO (N)]: y listener port: 1521SYS User Password: SYS User Password: SYSMAN user password: email Address of the notification (optional): SMTP server of the notification (optional ): ------------------------------------------------------------------- you have specified the following settings for the database ORACLE_HOME ................ e: \ app \ User \ product \ 11.1.0 \ db_1 local host name ................ HT-1376 listener port number ................ 1521 database SID ................ email Address of the orcl notification ............... notification sending (SMTP) server ............... -------- ----------------------------------------------------------- Continue? [Yes (Y)/NO (N)]: y2013-4-16 17:05:08 oracle. sysman. emcp. EMConfig perform information: The operation is logged to E: \ app \ User \ export toollogs \ emca \ orcl \ emca_2013_04_16_17_00_51.log. 17:05:11 oracle. sysman. emcp. util. PortManager isPortInUse warning: the specified port 5540 is in use. 17:05:11 oracle. sysman. emcp. util. PortManager isPortInUse warning: the specified port 5520 is in use. 17:05:11 oracle. sysman. emcp. util. PortManager isPortInUse warning: the specified port 1158 is in use. 17:05:12 oracle. sysman. emcp. util. DBControlUtil stopOMS information: the Database Control is being stopped (this operation may take some time )... 17:05:30 oracle. sysman. emcp. EMReposConfig uploadConfigDataToRepository information: the configuration data is being uploaded to the EM archives (this operation may take some time )... 17:06:53 oracle. sysman. emcp. EMReposConfig invoke information: configuration data has been successfully uploaded 17:41:00 oracle. sysman. emcp. util. DBControlUtil configureSoftwareLib information: the software library has been configured successfully. 17:41:00 oracle. sysman. emcp. EMDBPostConfig configureSoftwareLibrary information: the pre-configuration file is being deployed... 17:41:15 oracle. sysman. emcp. EMDBPostConfig configureSoftwareLibrary information: the pre-configuration file is successfully deployed. 17:41:15 oracle. sysman. emcp. util. DBControlUtil secureDBConsole information: Protecting Database Control (this operation may take some time )... 17:41:30 oracle. sysman. emcp. util. DBControlUtil secureDBConsole information: The Database Control is successfully protected. 17:41:31 oracle. sysman. emcp. util. DBControlUtil startOMS information: the Database Control is being started (this operation may take some time )... 17:43:41 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration information: the Database Control2013-4-16 has been started successfully 17:43:42 oracle. sysman. emcp. EMDBPostConfig configure mconfiguration information: >>>>>>>>>>> Database Control URL is https://HT-1376:1158/em <17:43:46 oracle. sysman. emcp. EMDBPostConfig invoke warning: * *********************** WARNING *************** * ******* the management archive has been placed in safe mode, in this mode, Enterprise Manager data is encrypted. The encryption key has been placed in file E: \ app \ User \ product \ 11.1.0 \ db_1 \ HT-1376_orcl \ sysman \ config \ emkey. ora. Make sure to back up this file because encrypted data will not be available if this file is lost. **************************************** * ***************** The EMCA configuration for Enterprise Manager is successfully completed at 17:43:46, January 16 ,.

Now input: https: // HT-1376: 1158/em in the browser to find that EM can be accessed normally.