配置linux下oracle开机自启动

STEP1: Script

[oracle@okairdb scripts]$ cat startup.sh

if [ -f ~/.bashrc ];then

      . ~/.bashrc

fi

export SYSDATE=`date +%Y%m%d`

echo $SYSDATE

export ORACLE_SID=OKAIRDB

sqlplus sys/oracle as sysdba 1>/dbbak/scripts/logs/dbstart_$SYSDATE.log 2>&1 <

!/app/okair/oracle/product/11.2.0.4/db_1/bin/lsnrctl start

startup;

!/app/okair/oracle/product/11.2.0.4/db_1/bin/lsnrctl status

exit;

EOF

#cat /dbbak/scripts/logs/dbstart_$SYSDATE.log

exit

 

STEP2: /etc/oratab

[oracle@okairdb scripts]$ cat /etc/oratab

 

# This file is used by ORACLE utilities.  It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

 

# A colon, ':', is used as the field terminator.  A new line terminates

# the entry.  Lines beginning with a pound sign, '#', are comments.

#

# Entries are of the form:

#   $ORACLE_SID:$ORACLE_HOME::

#

# The first and second fields are the system identifier and home

# directory of the database respectively.  The third filed indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

OKAIRDB:/app/okair/oracle/product/11.2.0.4/db_1:Y

 

STEP3: /etc/rc.d/rc.local

 

[oracle@okairdb scripts]$ cat /etc/rc.d/rc.local

#!/bin/sh

#

# This script will be executed *after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style init stuff.

 

touch /var/lock/subsys/local

 

su oracle -lc  /dbbak/scripts/startup.sh

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28538954/viewspace-1204794/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28538954/viewspace-1204794/