UNIX下oracle啟動指令碼

UNIX下oracle啟動指令碼

vi startdb.sh
sqlplus /nolog << EOF
connect / as sysdba
startup
EOF
lsnrctl start

vi stopdb.sh
lsnrctl stop
sqlplus /nolog << EOF
connect / as sysdba
shutdown immediate
EOF

vi startxcom.sh
su - oracle "-c /opt/oracle10g/startdb.sh"

vi stopxcom.sh
su - oracle "-c /opt/oracle10g/stopdb.sh"

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/720091/viewspace-1057979/，如需轉載，請註明出處，否則將追究法律責任。