Java Programmer Rookie Advanced (iv) Oracle Basics (iv) Oracle Open and Close service Program--Resolve install Oracle consumes a lot of memory ____oracle

Source: Internet
Author: User
Tags goto


Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So I tried to solve the problem. I think most developers of this problem should know why. Right. Is that some Oracle background services start up automatically. A large amount of memory was consumed after startup. So the solution to this problem is to turn off some of Oracle's boot services. When you use Oracle, you can manually open it. Let's take a look at how to shut down and open the Oracle service program.

One: Right click on My Computer-"service, find the following service programs




Shut down a few of the above service programs. Then set the startup mode to start manually. If you want to use Oracle, you can start these services.


Two: Close and open the service in the form of a script


Set up "Turn on or turn off Oracle services. TXT" To add the following code:

@echo off title Oracle Service Management CLS Color 2f goto Menu:menu CLS Echo.
=-=-=-=-=oracle Service Management =-=-=-=-= Echo. Echo.
1 Open service echo. Echo.
2 off the service echo. Echo.
3 Exit Echo. Echo. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Echo. Please enter the serial number of the selected item: set/p id= if "%id%" = "1" goto cmd1 If "%id%" = "2" goto CMD2 if "%id%" = "3" Exit echo Please enter the correct serial number.
&ping-n 2 127.1>nul&goto menu:cmd1 echo. Echo Opens Oracle Services ... net start|findstr/i/C: "ORACLEDBCONSOLEORCL" >nul&&set k=1| | Set k=0 if%k%==0 (net start "ORACLEDBCONSOLEORCL") Net start|findstr/i/C: "Oracleoradb10g_home1isql*plus" >nul&& Amp;set k=1| | Set k=0 if%k%==0 (net start "Oracleoradb10g_home1isql*plus") Net start|findstr/i/C: "Oracleoradb10g_home1tnslistener" & Gt;nul&&set k=1| | Set k=0 if%k%==0 (net start "Oracleoradb10g_home1tnslistener") Net start|findstr/i/C: "ORACLESERVICEORCL" >nul&& Amp;set k=1| |
Set k=0 if%k%==0 (net start "ORACLESERVICEORCL") echo.
Echo Oracle Service has successfully opened ... echo.
Pause Exit:cmd2 Echo. Echo Closes the Oracle service ... net STArt|findstr/i/C: "ORACLEDBCONSOLEORCL" >nul&&set k=1| | Set k=0 if%k%==1 (net stop "ORACLEDBCONSOLEORCL") Net start|findstr/i/C: "Oracleoradb10g_home1isql*plus" >nul&& Amp;set k=1| | Set k=0 if%k%==1 (net stop "Oracleoradb10g_home1isql*plus") Net start|findstr/i/C: "Oracleoradb10g_home1tnslistener" & Gt;nul&&set k=1| | Set k=0 if%k%==1 (net stop "Oracleoradb10g_home1tnslistener") Net start|findstr/i/C: "ORACLESERVICEORCL" >nul&& Amp;set k=1| |
Set k=0 if%k%==1 (net stop "ORACLESERVICEORCL") echo.
Echo Oracle Service has successfully shut down ... echo. Pause exit


Then change the file's suffix name to a bat file and run the file, and you can see the following interface:




Depending on your choice, you can turn on or off Oracle's related services.


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.