批处理里面写一句话
sqlplus /nolog @stop.shstop.sh里面
conn sys/chang_on_install@连接名 as sysdba
shutdown immediate;
sqlplus /nolog @stop.shstop.sh里面
conn sys/chang_on_install@连接名 as sysdba
shutdown immediate;
startup
@echo off
set SID=连接名
set ORADB=存放start.sql文件的目录
echo Start %SID% Dependant Services
echo Start %SID% Dependant Services >%TMP%\start%SID%.tmp
REM Allways Start Oracle DB:call :net_start OracleService%SID%
set ORACLE_SID=%SID%
sqlplus -s /nolog @%ORADB%\start.sqlgoto quit:net_start
echo Start %1
net start %1 2>>%TMP%\start%SID%.tmp
goto :end :quit
rem del %TMP%\start%SID%.tmp
rem pause
:end--------------------
start.sql文件内容conn sys@连接名/密码 as sysdba ;
shutdown immediate;
startup pfile=存放参数文件的路径比如 e:\oracle\admin\prod\xxx.ora;
exit;
set SID=orcl
set ORADB='C:\Documents andSettings\Administrator\桌面\start.sql'
echo Start orcl Dependant Services
echo Start orcl Dependant Services >%TMP%\start%SID%.tmp
REM Allways Start Oracle DB:call :net_start OracleServiceorcl
set ORACLE_SID=orcl
sqlplus -s /nolog @orcl\start.sqlgoto quit:net_start
echo Start %1
net start %1 2>>C:\Documents andSettings\Administrator\桌面\startorcl.tmp
goto :end:quit
rem del C:\Documents andSettings\Administrator\桌面\startorcl.tmp
rem pause
:end俺这样写提示的是:
Start orcl Dependant Services
Start OracleServiceorcl
SP2-0310: 无法打开文件 "orcl\start.sql"
set SID=orcl
set ORADB='C:\Documents andSettings\Administrator\桌面\start.sql'
echo Start orcl Dependant Services
echo Start orcl Dependant Services >C:\Documents andSettings\Administrator\桌面\startorcl.tmp
REM Allways Start Oracle DB:call :net_start OracleServiceorcl
set ORACLE_SID=orcl
sqlplus -s /nolog @orcl\start.sqlgoto quit:net_start
echo Start %1
net start %1 2>>C:\Documents andSettings\Administrator\桌面\startorcl.tmp
goto :end:quit
rem del C:\Documents andSettings\Administrator\桌面\startorcl.tmp
rem pause
:end
俺这样写提示的是:
Start orcl Dependant Services
Start OracleServiceorcl
SP2-0310: 无法打开文件 "orcl\start.sql"