cat /etc/init.d/oracle10g
#!/bin/sh
case "$1" in
start)
# start tsnlisnter
echo "start tsnlisnter"
su - oracle -c "lsnrctl start"
# start database
echo "Start Oracle database instance"
su - oracle -c "sqlplus /nolog @/oracle/product/10.2.0/rdbms/admin/dbstart"
#CONN / AS SYSDBA
#startup
#exit "|sqlplus /NOLOG"
# start enterprise manager
echo " Start Emterprise Manager"
su - oracle -c "emctl start dbconsole"
# start isqlplus
echo "Start isqlplus"
su - oracle -c "isqlplusctl start"
;;
stop)
# shutdown database
echo "Shutdown Oracle database instance"
su - oracle -c "sqlplus /nolog @/oracle/product/10.2.0/rdbms/admin/dbshut"
#CONN SYS/PASSWORD AS SYSDBA
#SHUTDOWN immediate
#exit "|sqlplus /NOLOG"
# stop tsnlisnter
echo "Stop tsnlisnter"
su - oracle -c "lsnrctl stop"
# stop enterprise manager
echo " Stop Emterprise Manager"
su - oracle -c "emctl stop dbconsole"
# stop isqlplus
echo "Stop isqlplus"
su - oracle -c "isqlplusctl stop"
;;
*)
echo "Usage: $0 { start | stop }"
exit 1
;;
esac
exit 0
cat dbstart.sql
conn / as sysdba
startup
exit
cat dbshut.sql
conn / as sysdba
shutdown immediate
exit
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7916042/viewspace-964982/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7916042/viewspace-964982/