下面为您介绍的是
Oracle启动脚本
,该
Oracle启动脚本供您参考学习之用
,希望可以让您对Oracle数据库有更深的了解
。
* view plaincopy to clipboardprint? #!/bin/sh
* cmdname="restart"
# get oracle sid information from env by default.
* oracleSID=${ORACLE_SID}
env_oracleSID=${ORACLE_SID}
*
function echohelp(){
* echo "******oracled Tool Helper******"
echo "Usage:sh oracled [start|stop|restart] SIDs"
* echo "SIDs : seperated by comma"
exit 5
* }
* function startoracle(){
echo "begin to start oracle ..."
*
lsnrctl start
* for curSID in `echo ${oracleSID} | awk 'BEGIN {RS=","}{ORS="\n"}{print $1}'` ; do
if [ "x${curSID}" = "x" ] ; then
* continue;
fi
* export ORACLE_SID=${curSID}
* sqlplus /nolog <<EOF
* connect /as sysdba
startup
* exit
exit
*
EOF
*
echo "oracle DB [${curSID}] started OK."
* done
}
* function stoporacle(){
echo "begin to stop oracle ..."
*
for curSID in `echo ${oracleSID} | awk 'BEGIN {RS=","}{ORS="\n"}{print $1}'` ; do
* if [ "x${curSID}" = "x" ] ; then
continue;
* fi
export ORACLE_SID=${curSID}
*
sqlplus /nolog <<EOF
*
connect /as sysdba
* shutdown immediate
exit
* exit
* EOF
* echo "oracle DB [${curSID}] stopped OK."
done
* lsnrctl stop
}
* function restartoracle(){
stoporacle
* startoracle
}
*
* if [ $# -lt 1 ] ; then
echohelp
* fi
* until [ $# -eq 0 ]
do
*
tmpVOrg=$1
tmpV=`echo "${tmpVOrg}" | awk '{printf "%s",$1}' | tr '[A-Z]' '[a-z]'`
* if [ $tmpV = "start" -o $tmpV = "restart" -o $tmpV = "stop" ] ; then
cmdname=${tmpV}
* elif [ $tmpV = "--help" -o $tmpV = "-h" ] ; then
echohelp
* else
oracleSID=$tmpVOrg
* fi
* shift
done
*
if [ "x${cmdname}" = "x" ] ; then
* echohelp
fi
*
${cmdname}oracle
*
* export ORACLE_SID=${env_oracleSID}
希望这篇
的文章能够对您有所帮助,如果您觉得这篇网站维护教程有用的话,别忘了推荐给您的朋友哦!如果您有好的经验方法,不妨拿出来和大家一起分享:假如每个人都拿出一个经验,那么我们都将额外的获取一堆他人的经验。
请记住本站永久域名:(黑客防线网安服务器维护方案维护基地)Www.Rongsen.Com.Cn