Shulou(Shulou.com)06/01 Report--

First switch to Oracle users.

[oracle@oracletest ~]$ cd /u01/app/oracle/product/11.2.0/db_1/bin/ ---red-font part of the database may be different, some dbhome_1, subject to their own actual configuration directory [oracle@oracletest bin]$ vi dbstartLOGMSG="logger -puser.alert -s "trap 'exit' 1 2 3# for script tracingcase $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 PATHSAVE_LLP=$LD_LIBRARY_PATH# First argument is used to bring up Oracle Net ListenerORACLE_HOME_LISTNER=$HOME_ORACLE ############################# $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. Edit oratab and rc.local with root

[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::## 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 ###where N was changed to 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#####Add the following two lines in the margin, where the red font part of the database may be different, some are 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

After the above two steps, after the database server restarts, the database will automatically start.

summary

The above is a small series to introduce you to the linux server boot oracle setting method, I hope to help you, if you have any questions please give me a message, small series will reply to you in time. Thank you very much for your support!

If you think this article is helpful to you, welcome to reprint, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.