Re: restarting oracle at boot time

Suzanne Irvine (suzannei_at_nsa.bt.co.uk) wrote:

: Hi Everyone,
 

: I'm having a little problem which is driving me crazy. We are
: running oracle RDBMS V6 on Sparc 10 under sunOS 4.1.3. Unfortunately,
: the oracle database does not come up when the machine is rebooted.
: Could someone please let me know what I've done wrong. The /etc/oratab
: file looks like this
 

:
: #
: # 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.
: #
: #
: school:/md/oracle:Y

1. Add root to the "dba" group in /etc/group
2. Add the following entry in your /etc/rc.local

   #
   # This will start up all oracle instances if the file
   # /etc/oratab exists
   # If you don't want to start up oracle rename the file /etc/oratab ie
   # mv /etc/oratab /etc/oratab-
   #
   if [ -f /etc/oratab ]; then
      /md/oracle/bin/dbstart
      /md/oracle/bin/tcpctl start dbaoff opsoff  # if you have licenced tcp

--
Leo Mannhart
Planning Office
University of Zurich                                phone: ++41 1 257 23 34
Kuenstlergasse 15                                     fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland                         eMail: mannhart_at_zuv.unizh.ch