bat启动和停止oracle、mysql服务，bat执行mysql脚本

一时失言乱红尘 2022-03-19 06:23 429阅读 0赞

**目录**

bat启动oracle

bat停止oracle

bat启动pdborcl

bat启动mysql

bat停止mysql

bat执行mysql脚本

bat执行SQL Server脚本

--------------------

### bat启动oracle ###

@echo off
    rem Copyright (c) 2019 Moses and/or its affiliates.
    net start OracleServiceORCL
    net start OracleVssWriterORCL
    net start OracleOraDB12Home1TNSListener
    net start OracleJobSchedulerORCL 
    pause

### bat停止oracle ###

@echo off
    rem Copyright (c) 2019 Moses and/or its affiliates.
    net stop  OracleServiceORCL
    net stop  OracleVssWriterORCL
    net stop  OracleOraDB12Home1TNSListener
    net stop  OracleJobSchedulerORCL 
    pause

### bat启动pdborcl ###

sqlplus sys/sys as sysdba @pdborcl.sql
    pause

**pdborcl.sql**

conn sys/sys as sysdba    
    alter session set container=pdborcl; 
    startup;
    exit

### bat启动mysql ###

@echo off
    rem Copyright (c) 2019 Moses and/or its affiliates.
    rem Get Administrator Rights
    >nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"
    if '%errorlevel%' NEQ '0' (
    goto UACPrompt
    ) else ( goto gotAdmin )
    :UACPrompt
    echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
    echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"
    "%temp%\getadmin.vbs"
    exit /B
    :gotAdmin
    if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )
    rem start
    net start MySQL

### bat停止mysql ###

### bat执行mysql脚本 ###

@ECHO OFF 
    rem Copyright (c) 2019 Moses and/or its affiliates.
    SET bin=D:\program\mysql-5.7.16-winx64\bin
    SET dbhost=127.0.0.1
    SET dbuser=root
    SET dbpasswd=123456
    SET dbName=test
    rem current directory
    SET sqlpath=%~dp0
    rem sql file
    set sqlfile=update.sql
    cmd /k "cd %bin% && mysql -h%dbhost% -u%dbuser% -p%dbpasswd% %dbName% < %sqlpath%%sqlfile% --default-character-set=utf8"
    ECHO finish!
    PAUSE
    @ECHO Done!

### bat执行SQL Server脚本 ###

@echo off
    choice /t 3 /c yn /d n /m "Please enter Y to start the SQL SERVER service, N to stop the SQL SERVER service, otherwise automatically choose to start after 3 seconds."
    
    if errorlevel 1 goto start
    if errorlevel 2 goto stop
    
    :start
    net start SSASTELEMETRY
    net start SQLTELEMETRY
    net start SSISTELEMETRY130
    net start SQLWriter
    net start SQLPBENGINE
    
    net start MsDtsServer130
    net start MSSQLFDLauncher
    net start MSSQLLaunchpad
    net start MSSQLSERVER
    net start MSSQLServerOLAPService
    net start ReportServer
    goto end
    
    :stop
    net stop SSASTELEMETRY
    net stop SQLTELEMETRY
    net stop SSISTELEMETRY130
    net stop SQLWriter
    net stop SQLPBENGINE
    
    net stop MsDtsServer130
    net stop MSSQLFDLauncher
    net stop MSSQLLaunchpad
    net stop MSSQLSERVER
    net stop MSSQLServerOLAPService
    net stop ReportServer
    goto end
    
    :end
    echo Thank you for using it. It will be turned off automatically in three seconds.
    pause

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0ZXZlX2ZyYW5r_size_16_color_FFFFFF_t_70]: /images/20220319/7471db9f4c7949fd95adeeb4104bb06c.png