Shell实现的Oracle启动脚本分享
Usage:shoracled[start|stop|restart]SIDs其中SIDs是数据库名，多个名称之间用逗号分隔。缺省的操作是restart，也可以指定需要进行的操作（start|stop|restart）
#!/bin/sh
cmdname="restart"
#getoraclesidinformationfromenvbydefault.
oracleSID=${ORACLE_SID}
env_oracleSID=${ORACLE_SID}
functionechohelp(){
echo"******oracledToolHelper******"
echo"Usage:shoracled[start|stop|restart]SIDs"
echo"SIDs:seperatedbycomma"
exit5
}
functionstartoracle(){
echo"begintostartoracle..."
lsnrctlstart
forcurSIDin`echo${oracleSID}|awk'BEGIN{RS=","}{ORS="\n"}{print$1}'`;do
if["x${curSID}"="x"];then
continue;
fi
exportORACLE_SID=${curSID}
sqlplus/nolog<<EOF
connect/assysdba
startup
exit
exit
EOF
echo"oracleDB[${curSID}]startedOK."
done
}
functionstoporacle(){
echo"begintostoporacle..."
forcurSIDin`echo${oracleSID}|awk'BEGIN{RS=","}{ORS="\n"}{print$1}'`;do
if["x${curSID}"="x"];then
continue;
fi
exportORACLE_SID=${curSID}
sqlplus/nolog<<EOF
connect/assysdba
shutdownimmediate
exit
exit
EOF
echo"oracleDB[${curSID}]stoppedOK."
done
lsnrctlstop
}
functionrestartoracle(){
stoporacle
startoracle
}
if[$#-lt1];then
echohelp
fi
until[$#-eq0]
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
exportORACLE_SID=${env_oracleSID}
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下