在redhat5上Oracle 10g 开机自动启动，及raw磁盘自动加载

1.自动启动oracle 10g

第一步：在/usr/bin下建立启动和停止服务，放在这个目录下，可以方便用户直接运行该命令

A新建文件startdb，内容如下，同时修改执行权限。chmod 777 stardb

sqlplus /nolog <<EOF
conn / as sysdba
startup
exit
EOF

emctl start dbconsole

B新建文件stopdb，内容如下，同时修改执行权限。chmod 777  stopdb

sqlplus /nolog <<EOF
conn / as sysdba
shutdown immediate
exit
EOF

emctl stop dbconsole

第二步，在/etc/init.d下新建oracle, 同进修改执行权限 chmod 777 oracle

#!/bin/bash
# chkconfig: 345 99 10
# de  script  ion:Athor:fjfdszj,data:2009-08-01
# processname:oracle 10g is meant to run under linux oracle Server
# /usr/bin/startdb,/usr/bin/stopdb
# Source function library

. /etc/rc.d/init.d/functions
. /etc/bashrc

export ORACLE_NAME=oracle
export ORACLE_SID=orcl

#start the oracle server
#the following command assumes that the oracle login will not prompt the pwd

start(){
echo -n "start oracle server:"

su - $ORACLE_NAME -c 'lsnrctl start'
su - $ORACLE_NAME -c startdb
}

stop(){
echo -n "shutdown oracle server:"

su - $ORACLE_NAME -c 'lsnrctl stop'
su - $ORACLE_NAME -c stopdb

}

case "$1" in
start)
start
;;
stop)
stop
;;
status)
status
;;
restart|reload)
stop
start
;;
*)
echo "usage: $0 "
exit 1
;;
esac
exit 0

2.自动加载raw的镜像

在/etc/init.d下新建rawdevices, 同进修改执行权限 chmod 777 rawdevices

#!/bin/bash
# raw this is add devices
# chkconfig:2345 75 30
# de  script  ion:Author :fjfdszj DATA:2009-08-02
# processname: raw add devices

#Source funciton library
. /etc/rc.d/init.d/functions

#start function
start(){
#hdd to raw
raw /dev/raw/raw1 /dev/hdd1
raw /dev/raw/raw2 /dev/hdd2
#changer owener
chown -R oracle:oinstall /dev/raw
}

case "$1" in
 start)
  start
 ;;
esac

exit $RETVAL

 

附注

      service oracle start//测试服务是否有错

      chkconfig oracle on//在测试正确后，可以启动，以后开机就会自动启用该服务

 

修改/home/oracle/.bash_profile,在用户通过su - oracle进行切换用户，就可识别该用户需要的参数信息。具体如下：

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
 . ~/.bashrc
fi

# User specific environment and startup programs

export PATH=$PATH:$HOME/bin

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=orcl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/X11R6/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386/server
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/rdbms/lib
export CLASS_PATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib
export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/rdbms/jlib
export CLASS_PATH=$CLASS_PATH:$ORACLE_HOME/network/jlib
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=american_america.ZHS16GBK

//这个必须为这样，否则sys无法登录sqlplus
export ORACLE_TERM=xterm
export EDITOR=vi
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=en_US