本篇文章小编给大家分享一下linux服务器开机启动oracle设置方法 小编觉得挺不错的现在分享给大家供大家参考有需要的小伙伴们可以来看看。
1、首先切换到Oracle用户
- oracle@oracletest ~]$ cd /u01/app/oracle/product/11.2.0/db_1/bin/ -----标红字体部分数据库可能
- 不一样有的是dbhome_1以自己实际配置目录为准
- [oracle@oracletest bin]$ vi dbstart
复制代码- LOGMSG="logger -puser.alert -s "
- trap 'exit' 1 2 3
- # for script tracing
- case $ORACLE_TRACE in
- T) set -x ;;
- esac
- # Set path if path not set (if called from /etc/rc)
- SAVE_PATH=/bin:/usr/bin:/etc:${PATH} ; export PATH
- SAVE_LLP=$LD_LIBRARY_PATH
- # First argument is used to bring up Oracle Net Listener
- ORACLE_HOME_LISTNER=$ORACLE_HOME ############此处原来是$1,改成$ORACLE_HOME
- if [ ! $ORACLE_HOME_LISTNER ] ; then
- echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
- echo "Usage: $0 ORACLE_HOME"
- else
- LOG=$ORACLE_HOME_LISTNER/listener.log
复制代码
2、用root用户编辑oratab和rc.local
- root@oracletest ~# vi /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:<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.
- oadb:/u01/app/oracle/product/11.2.0/db_1:Y ###此处原来是N,改为Y
- root@oracletest ~]# vi /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
- #####在空白处添加下面两行,其中标红字体部分数据库可能不一样 有的是dbhome_1 以自己实际配置目录为准
- su oracle -lc "/u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl start"
- su oracle -lc /u01/app/oracle/product/11.2.0/db_1/bin/dbstart </n|y>
复制代码 经过上面两步操作 数据库服务器重启后 数据库也会自动启动。 |