Introduction to Oracle service startup and sequence in command line

In Oracle Database Operations, we often enable or disable some services. You can enable the Service in either of the following ways:Command Line. This document describes how to startOracle serviceNext, let's take a look at this part.

Case Study

In order to save system resources, we often set Oracle services to manual start mode on the Oracle computer. Sometimes we are reluctant to open the Service Management window for convenience, therefore, the command line startup method is recorded here.

I have two routines: orcl -- for the target database; test -- for restoring the directory database.

The general order is as follows:

 
 

  
  
C: \> net start oracleserviceorcl
  
  
The OracleServiceORCL service is starting ..............................
  
  
The OracleServiceORCL service has been started successfully.
 
 

 
 

  
  
C: \> net start oracleservicetest
  
  
OracleServiceTEST service is starting .................................... ....
  
  
The OracleServiceTEST service has been started successfully.
 
 

 
 

  
  
C: \> set oracle_sid = orcl
  
  
C: \> emctl start dbconsole
  
  
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
  
  
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
  
  
Http: // aaaa: 1158/em/console/aboutApplication
  
  
Starting Oracle Enterprise Manager 10g Database Control... OracleDBConsoleorcl service is Starting ........
  
  
............
  
  
The OracleDBConsoleorcl service has been started successfully.
  
  
C: \> lsnrctl start
  
  
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 2009 05:25:20
  
  
Copyright (c) 1991,200 5, Oracle. All rights reserved.
  
  
Start tnslsnr: Please wait...
 
 

 
 

  
  
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  
  
The system parameter file is F: \ oracle \ product \ 1020 \ db_1 \ network \ admin \ listener. ora.
  
  
Write the log information of F: \ oracle \ product \ 1020 \ db_1 \ network \ log \ listener. log
  
  
Listener: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = aaaa) (PORT = 1521 )))
  
  
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = aaaa) (PORT = 1521 )))
  
  
LISTENER STATUS
  
  
------------------------
  
  
Alias LISTENER
  
  
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  
  
Start Date: 2009 05:25:26
  
  
Normal operation time 0 days 0 hours 0 minutes 6 seconds
  
  
Tracking level off
  
  
Security ON: Local OS Authentication
  
  
SNMP OFF
  
  
Listener parameter file F: \ oracle \ product \ 1020 \ db_1 \ network \ admin \ listener. ora
  
  
Listener log file F: \ oracle \ product \ 1020 \ db_1 \ network \ log \ listener. log
  
  
Listener endpoint overview...
  
  
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = aaaa) (PORT = 1521 )))
  
  
Service summary ..
  
  
The Service "PLSExtProc" contains one routine.
  
  
Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...
  
  
Command executed successfully
 
 

OK. Two server routines, one OEM service and one listener service, are all started successfully.

This article describes how to start the Oracle service and sequence in the command line!

Source: http://space.itpub.net/15011739/viewspace-605993