Script to start Oracle processes
来源:互联网 发布:vc多线程编程实例 编辑:程序博客网 时间:2024/05/17 06:42
#!/usr/bin/ksh
#
#
# set -x
##startdb.ksh
# grep process id for oracle instance and listener
orapid=`ps -ef | grep -v grep | grep oracle | grep ora_ | grep _$ORACLE_SID | awk '{print $2}' | head -1`
lsnrpid=`ps -ef | grep -v grep | grep oracle | grep LISTENER | awk '{print $2}' | head -1`
empid=`ps -ef | grep -v grep | grep oracle | grep LOCAL=NO | grep oracle$ORACLE_SID | awk '{print $2}' | head -1`
isqlpid=`ps -ef | grep -v grep | grep oracle | grep Doracle | grep Djava.awt.headless | awk '{print $2}' | head -1` #
# start oracle instance
if [ "$orapid" -eq "" ]; then
echo "Starting Oracle instance..."
sqlplus /nolog << !
connect /as sysdba
startup
exit
!
else
echo "Oracle instance $ORACLE_SID is already running!"
fi
# start listener
if [ "$lsnrpid" -eq "" ]; then
echo "Starting listener ..."
lsnrctl start
else
echo "Listener is already running!"
fi
# start Enterprise Manager
if [ "$empid" -eq "" ]; then
echo "Starting Enterprise Manager ..."
rm $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/*/*.gif
emctl start dbconsole
else
echo "Enterprise Manager is already running!"
fi
# start iSQLPLUS
if [ "$isqlpid" -eq "" ]; then
echo "Starting iSQLPLUS ..."
rm $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/images/*.gif
isqlplusctl start
else
echo "iSQLPLUS is already running!"
fi
#
#
# check processes status
echo "/n--------------------------------"
echo "Checking Oracle processes status:"
orapid=`ps -ef | grep -v grep | grep $ORACLE_SID | awk '{print $2}' | head -1` lsnrpid=`ps -ef | grep -v grep | grep LISTENER | awk '{print $2}'`
if [ ! "$orapid" -eq "" ]; then
echo "Oracle instance $ORACLE_SID is running!"
fi
if [ ! "$lsnrpid" -eq "" ]; then
echo "Listener is running!"
fi
echo "--------------------------------/n"
# end
#!/usr/bin/ksh
# script to stop database
#
# set -x
if [ -f /export/home/oracle/product/10g/Sun10_oradb1/emctl.pid ]; then
echo 'Stop Enterprise Manager.../n'
emctl stop dbconsole
fi
# grep process id for oracle instance and listener
orapid=`ps -ef | grep -v grep | grep $ORACLE_SID | awk '{print $2}' | head -1` lsnrpid=`ps -ef | grep -v grep | grep LISTENER | awk '{print $2}'`
# stop oracle instance
if [ ! "$orapid" -eq "" ]; then
echo "Shutting down Oracle instance..."
sqlplus /nolog << !
connect /as sysdba
shutdown immediate
exit
!
fi
# stop listener
if [ ! "$lsnrpid" -eq "" ]; then
echo "Shutting down listener ..."
lsnrctl stop
fi
# check processes status
echo "--------------------------------"
echo "Checking Oracle processes status:"
orapid=`ps -ef | grep -v grep | grep $ORACLE_SID | awk '{print $2}' | head -1` lsnrpid=`ps -ef | grep -v grep | grep LISTENER | awk '{print $2}'`
if [ "$orapid" -eq "" ]; then
echo "Oracle instance $ORACLE_SID is stopped!"
fi
if [ "$lsnrpid" -eq "" ]; then
echo "Listener is stopped!"
fi
echo "--------------------------------/n"
# end
- Script to start Oracle processes
- Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes
- Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes (文档 ID 459694.1)
- start script
- Bash tip: How to stop many processes in with a small script
- shell bash script to start and stop named services
- 启动ArcSDE服务报“Unable to start ArcSDE, Please check for zombie processes”的解决办法
- Troubleshooting Oracle Background Processes
- Oracle Database Background Processes
- Oracle backgroup processes
- Oracle sessions & processes关系
- Oracle 修改 processes
- linux start script
- Qucick Start to Oracle Connections快速连接到Oracle
- oracle script
- Oracle Apps Script to create a new User Login Account
- oracle修改processes与sessions
- Oracle 修改sessions和processes
- Just move in!
- 用Validator(验证器)提供的丰富的内置验证方法简化Struts的开发过程。
- 流氓当道,信息产业部去哪儿了
- 使用分治法解决棋盘覆盖问题
- js中全选按钮的控制
- Script to start Oracle processes
- MFC 的CList,CPtrList,CObList,CStringList 的用法
- XP崩溃后的救命稻草:原位升级应用
- 消息管道(Message Pipe)
- 牛奶布丁,我也会做了-o-
- TestHSSF
- 买房买车,不再遥远!
- 天天点滴
- 宋屹峰的一句很深刻的话!