如何编写一个重启oracle服务的bat文件 批处理里面写一句话sqlplus /nolog @stop.shstop.sh里面conn sys/chang_on_install@连接名 as sysdbashutdown immediate; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 忘了,在stop.sh里最后面加上startup ---CMD文件内容,@echo off set SID=连接名set ORADB=存放start.sql文件的目录echo Start %SID% Dependant Services echo Start %SID% Dependant Services >%TMP%\start%SID%.tmpREM Allways Start Oracle DB:call :net_start OracleService%SID%set ORACLE_SID=%SID%sqlplus -s /nolog @%ORADB%\start.sqlgoto quit:net_startecho Start %1net start %1 2>>%TMP%\start%SID%.tmpgoto :end :quitrem del %TMP%\start%SID%.tmprem pause:end--------------------start.sql文件内容conn sys@连接名/密码 as sysdba ;shutdown immediate;startup pfile=存放参数文件的路径比如 e:\oracle\admin\prod\xxx.ora;exit; @echo off set SID=orclset ORADB='C:\Documents andSettings\Administrator\桌面\start.sql'echo Start orcl Dependant Servicesecho Start orcl Dependant Services >%TMP%\start%SID%.tmpREM Allways Start Oracle DB:call :net_start OracleServiceorclset ORACLE_SID=orclsqlplus -s /nolog @orcl\start.sqlgoto quit:net_startecho Start %1net start %1 2>>C:\Documents andSettings\Administrator\桌面\startorcl.tmpgoto :end:quitrem del C:\Documents andSettings\Administrator\桌面\startorcl.tmprem pause:end俺这样写提示的是:Start orcl Dependant ServicesStart OracleServiceorclSP2-0310: 无法打开文件 "orcl\start.sql" @echo off set SID=orclset ORADB='C:\Documents andSettings\Administrator\桌面\start.sql'echo Start orcl Dependant Servicesecho Start orcl Dependant Services >C:\Documents andSettings\Administrator\桌面\startorcl.tmpREM Allways Start Oracle DB:call :net_start OracleServiceorclset ORACLE_SID=orclsqlplus -s /nolog @orcl\start.sqlgoto quit:net_startecho Start %1net start %1 2>>C:\Documents andSettings\Administrator\桌面\startorcl.tmpgoto :end:quitrem del C:\Documents andSettings\Administrator\桌面\startorcl.tmprem pause:end俺这样写提示的是:Start orcl Dependant ServicesStart OracleServiceorclSP2-0310: 无法打开文件 "orcl\start.sql" .sh文件不是在windows下执行的包子的.bat文件是正确的 请教高手:如果条件A能得到数据则返回,否则返回条件B 数据库的问题 游标更新 在触发器中能不能维护当前表的索引? 如何建立create和insert表,当表名中有@ + -的时候? 使用sql语句合并记录 一个关于触发器的问题 请问下面两sql语句如何提高查询速度? 我是个初学者,请各位高手帮助以下,我进入SQL*Plus时连接数据库怎么一直是连接失败? Oracle8i控制台创建JOB出错(提示:验证错误),但使用dbms_job可以成功创建,资料库的用户帐号已授予DBA权限。 查询时oracle的时间格式怎么处理 求一sql
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"