【原创】Oracle database自动startup和shutdown
在网上也google了很多自动startup 和 shutdown oracle database的脚本,但是很多都是在Linux 或者是Unix平台下面的,因为项目的需要,要让其运行在windows平台下面的脚本。。。。但是网上的发现没有一个比较完整或者是可以自动执行的script,于是自己想了半个晚上和经过了测试,终于写成“神”脚本;^_^
Startup.bat
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
REM +--------------------------------------------------------------------------+
REM | execute database startup and shutdown operation |
REM +--------------------------------------------------------------------------+
sqlplus sys/oracle@ORATEST AS SYSDBA@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Jeff-PC)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORATEST))) @startup.ora >> startup.log (there is one space between ")" and last @)
startup.ora
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.
startup mount;
alter database open;
exit
经过多轮测试,已经成功execute数据库的operation .