[其他] 想做一个批处理 开启orcl服务 登录orcl 改密码解锁....有问题了

185362154

@ECHO OFF  
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next
:next
if /i "%zt%"=="RUNNING" (
        ECHO Stoping OracleService, please wait ...  
        net stop OracleServiceORCL       
        net stop OracleOraDb10g_home1TNSListener       
)else (
        ECHO Starting OracleService, please wait ...
        net start OracleServiceORCL       
        net start OracleOraDb10g_home1TNSListener
        sqlplus jame/jame@orcl
        pause alter user SCOTT  identified by scott  account unlock;
)

机器每次都是还原
每次要启动服务 改密码 等等..很烦人

DAIC

@echo off
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next
:next
if /i "%zt%"=="RUNNING" (
    echo Stoping OracleService, please wait ...
    net stop OracleServiceORCL
    net stop OracleOraDb10g_home1TNSListener
) else (
    echo Starting OracleService, please wait ...
    net start OracleServiceORCL
    net start OracleOraDb10g_home1TNSListener
    set "oraName=jame"
    set "oraPass=jame"
    set "oraDB=orcl"
    set "oraSql=%temp%\myOra.sql"
    >"%oraSql%" echo conn %oraName%/%oraPass%@%oraDB%
    >>"%oraSql%" echo alter user SCOTT  identified by scott  account unlock;
    start sqlplus /nolog @"%oraSql%"
)
复制代码

185362154

回复 2# DAIC   myOra.sql 貌似路径不对 还是要创建一个sql文件吗

DAIC

回复 3# 185362154


    myOra.sql 是脚本自动生成的，不需要手工创建。