linux下开机启动oracle
#!/bin/sh #!/bin/sh# This Script For Oracle 10g db
# Script Name : oradb
export ORACLE_OWNER=oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=moe210
case "$1" in
start)
echo $ORACLE_HOME>> /var/log/oracledb
echo $ORACLE_SID >> /var/log/oracledb
echo $ORACLE_OWNER >> /var/log/oracledb
echo "Starting Oracle Listeners ......................." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
echo "Done............................................." >> /var/log/oracledb
echo "Starting Oracle Databases ......................." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus / as sysdba" >/var/log/oracledb
startup
exit
EOF
echo "Done."
;;
stop)
rm -f /var/lock/subsys/oracle
echo "Stoping Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop" >> /var/log/oracledb
echo "Done."
echo "Stoping Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus / as sysdba" >/var/log/oracledb
shutdown immediate
exit
EOF
echo "Done."
echo "-------------------------------------------------" >> /var/log/oracledb
date +" %T %a %D : Finished." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
;;
restart)
$0 stop
$0 start
;;
*)
echo "Usage: oradb {start|stop|restart}"
exit 1
esac
页:
[1]