Introduction to Oracle service startup and sequence in command line

Source: Internet
Author: User
Tags time 0

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:

 
 
  1. C: \> net start oracleserviceorcl
  2. The OracleServiceORCL service is starting ..............................
  3. The OracleServiceORCL service has been started successfully.
 
 
  1. C: \> net start oracleservicetest
  2. OracleServiceTEST service is starting .................................... ....
  3. The OracleServiceTEST service has been started successfully.
 
 
  1. C: \> set oracle_sid = orcl
  2. C: \> emctl start dbconsole
  3. Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
  4. Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
  5. Http: // aaaa: 1158/em/console/aboutApplication
  6. Starting Oracle Enterprise Manager 10g Database Control... OracleDBConsoleorcl service is Starting ........
  7. ............
  8. The OracleDBConsoleorcl service has been started successfully.
  9. C: \> lsnrctl start
  10. LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on 2009 05:25:20
  11. Copyright (c) 1991,200 5, Oracle. All rights reserved.
  12. Start tnslsnr: Please wait...
 
 
  1. TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  2. The system parameter file is F: \ oracle \ product \ 1020 \ db_1 \ network \ admin \ listener. ora.
  3. Write the log information of F: \ oracle \ product \ 1020 \ db_1 \ network \ log \ listener. log
  4. Listener: (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = aaaa) (PORT = 1521 )))
  5. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = aaaa) (PORT = 1521 )))
  6. LISTENER STATUS
  7. ------------------------
  8. Alias LISTENER
  9. Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  10. Start Date: 2009 05:25:26
  11. Normal operation time 0 days 0 hours 0 minutes 6 seconds
  12. Tracking level off
  13. Security ON: Local OS Authentication
  14. SNMP OFF
  15. Listener parameter file F: \ oracle \ product \ 1020 \ db_1 \ network \ admin \ listener. ora
  16. Listener log file F: \ oracle \ product \ 1020 \ db_1 \ network \ log \ listener. log
  17. Listener endpoint overview...
  18. (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = aaaa) (PORT = 1521 )))
  19. Service summary ..
  20. The Service "PLSExtProc" contains one routine.
  21. Routine "PLSExtProc", status UNKNOWN, contains one handler of this service...
  22. 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

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.