cmd启动oracle实例

 

 

@echo off
echo Oracle服务
:menu
echo ^**************************************
echo ^*	1. 启动oracle
echo ^*	2. 关闭oracle
echo ^*	3. 启动oracle监听器
echo ^*	4. 关闭oracle监听器
echo ^*	5. 启动oracle系统服务
echo ^*	6. 关闭oracle系统服务
echo ^*	7. 退出
echo ^**************************************
set /p input=-^> 请选择: 
cls
if "%input%"=="1" goto :start_oracle
if "%input%"=="2" goto :stop_oracle
if "%input%"=="3" goto :start_listener
if "%input%"=="4" goto :stop_listener
if "%input%"=="5" goto :start_oracle_service
if "%input%"=="6" goto :stop_oracle_service
if "%input%"=="7" goto :exit
:start_oracle
net start OracleOraDb10g_home1TNSListener
net start OracleServiceORCL
goto :menu

:stop_oracle
net stop OracleServiceORCL
net stop OracleOraDb10g_home1TNSListener
goto :menu

:start_listener
net start OracleOraDb10g_home1TNSListener
goto :menu

:stop_listener
net stop OracleOraDb10g_home1TNSListener
goto :menu

:start_oracle_service
net start OracleServiceORCL
goto :menu

:stop_oracle_service
net stop OracleServiceORCL
goto :menu

:exit
exit