Re: How to get oracle server to start autom

Add the following lines to your rc.local: (echo Starting Oracle) >/dev/console
rm -f /usr/ORACLE/DBS/sgadef*.dbf
su - oracle -c /usr/oracle/bin/dbstart >/dev/console

This will start any SIDs that are in your /etc/oratab file that have a Y in the third position. Here's a sample /etc/oratab file that will start three instances, A, TRNG and COMMON.

< /etc/oratab >
#
# This file is used by ORACLE utilities. It is created by root.install
# and updated by rdbms.install and the Net* installation scripts.
#
# 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 field 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. A null
# value for $ORACLE_SID is indicated by an asterisk, "*", in the first
# column.
#
#

A:/usr/oracle:Y
COMMON:/usr/oracle:Y
TRNG:/usr/oracle:Y

The /usr/oracle/bin/dbstart scans the /etc/oratab file and starts any databases in that file that have a Y. Hope this helps.

---
Ray Dutcher
Oracle DBA
Xerox Corp.
1350 Jefferson Rd., 801-15A
Rochester, NY 14623