AIX5.3 設(shè)置Oracle數(shù)據(jù)的自動(dòng)啟動(dòng)及關(guān)閉

AIX下自動(dòng)啟動(dòng)/停止Oracle數(shù)據(jù)庫
1：修改/etc/oratab，將“N”改為“Y”，使之支持開機(jī)啟動(dòng)。
$ vi /etc/oratab
#
# This file is used by Oracle utilities.  It is created by root.sh-
 

# and updated by the Database Configuration Assistant when creating
# a database.
# 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:<N|Y>:
#
# 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.
#
#
orcl:/home/Oracle/product/10.2.0:Y
2.創(chuàng)建腳本并賦予相關(guān)權(quán)限
 2.1創(chuàng)建啟動(dòng)腳本
1）、在/home/oracle目錄下，創(chuàng)建start_db.sh  //此路徑非特定
$ su - Oracle
$ vi start_db.sh
#!/bin/sh
Oracle_HOME=/home/oracle/product/10.2.0
Oracle_BASE=/home/oracle
Oracle_SID=orcl
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/Oracle/bin:/usr/bin/X11:/sbin:/home/oracle/product/10.2.0/bin:.
export Oracle_HOME ;
export Oracle_BASE ;
export Oracle_SID ;
export PATH ;
echo "######################################################"
echo "# Starting the Listener #"
echo "######################################################"
lsnrctl start
echo ""
echo ""
echo ""
echo "#####################################################"
echo "# Starting the instance :$Oracle_SID #"
echo "#####################################################"
sqlplus /nolog << EOF
connect / as sysdba
startup
exit
EOF
 
2）、在/etc下建立文件rc.startdb
# vi /etc/rc.startdb  //以root用戶進(jìn)行創(chuàng)建，避免報(bào)錯(cuò)
su - Oracle "-c /home/oracle/dbstart.sh" #startOracleDB
3）、給文件執(zhí)行權(quán)限
# chmod 777 rc.startdb
4）、添加自啟動(dòng)任務(wù)至/etc/inittab
$vi /etc/inittab
startdb:2:wait:/etc/rc.startdb>/home/oracle/oracle.log 2>&1
注：也可以用命令 mkitab 添加
   關(guān)于inittab文件相見我博客內(nèi)的介紹
2.2創(chuàng)建關(guān)閉腳本
# vi /etc/rc.shutdown
echo "Stop Oracle instance: orcl"
su - Oracle -c dbshut

注：以上兩個(gè)腳本均經(jīng)過實(shí)際操作！
關(guān)于為什么腳本叫/etc/rc.shutdown，以及怎么工作.如下注解

服務(wù)器租用/服務(wù)器托管中國五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]