1. Tasks that be performed by oracle user.
1). Create directory.
mkdir $ORACLE_BASE/admin/dba/ssp
cd $ORACLE_BASE/admin/dba/ssp
2). Create environment file.
create set_env.sh from oracle .profile.
3). Create startup.sh file under $ORACLE_BASE/admin/dba/ssp directory.
#! /sbin/sh
. /namp_log/oracle/admin/dba/ssp/set_env.sh
LINE=************************************************************************************************
echo "$LINE" >> /namp_log/oracle/admin/dba/ssp/startup.log 2>&1
date >> /namp_log/oracle/admin/dba/ssp/startup.log 2>&1
lsnrctl start >> /namp_log/oracle/admin/dba/ssp/startup.log 2>&1
sqlplus /nolog <
conn / as sysdba;
startup;
exit;
EOF
echo "$LINE" >> /namp_log/oracle/admin/dba/ssp/startup.log 2>&1
4). Create stop.sh file under $ORACLE_BASE/admin/dba/ssp directory.
#! /sbin/sh
LINE=************************************************************************************************
echo "$LINE" >> /namp_log/oracle/admin/dba/ssp/stop.log 2>&1
date >> /namp_log/oracle/admin/dba/ssp/stop.log 2>&1
. /namp_log/oracle/admin/dba/ssp/set_env.sh
lsnrctl stop >> /namp_log/oracle/admin/dba/ssp/stop.log 2>&1
sqlplus /nolog <
conn / as sysdba;
shutdown immediate;
exit;
EOF
echo "$LINE" >> /namp_log/oracle/admin/dba/ssp/stop.log 2>&1
2. Tasks that be performed by root user.
1).Create /etc/init.d/dbstart file.
#! /sbin/sh
su - oracle -c "/namp_log/oracle/admin/dba/ssp/startup.sh"
2). Create /etc/init.d/dbshut file.
#! /sbin/sh
su - oracle -c "/namp_log/oracle/admin/dba/ssp/stop.sh"
3). Change mode and verify above script files.
chmod u+x db*
ls -l db*
4). Create link for auto startup oracle server.
ln -s /etc/init.d/dbstart /etc/rc2.d/S99dbstart
5). Create link for auto shutdown oracle server.
ln -s /etc/init.d/dbshut /etc/rc0.d/S99dbshut
3. Check.
You can check startup.log and stop.log file under $ORACLE_BASE/admin/dba/ssp directory.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28260/viewspace-903018/ ,如需转载,请注明出处,否则将追究法律责任。