DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cannot auto start the database aftef reboot

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Does anyone perform the auto start and shut the database version 8.1.7 using HP_UX 11.0 64 Bits.

    I have problem to restart - I checked my /etc/rc.log, there is no error on my S99dbora as follow :

    Output from "/sbin/rc2.d/S99dbora start" :
    --------------------
    Starting NFS Server networking
    :
    :


    My dbora file is as follow :
    #!/bin/sh
    # Set ORA_HOME to be equivalent to the ORACLE_HOME
    # from which you wish to execute dbstart and dbshut
    # set ORA_OWNER to the user_id of the owner of the
    # ORACLE database in ORA_HOME

    ORA_HOME=/oracle
    ORA_OWNER=oradb
    if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
    then
    echo "Oracle startup : cannot start"
    exit
    fi
    case "$1" in
    'start')

    # Start the Oracle Databases:
    # The following command assumes that the oracle login will not prompt
    # the user for any values

    /usr/bin/su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
    ;;
    'stop')

    # Stop the Oracle Databases:
    # The following command assumes that the Oracle login will not prompt
    # the user for any values

    /usr/bin/su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
    ;;
    esac

    Any error on this file ? Please advice.

    This file should created by root user. Am I right ? Anybody can assist me on this ? Thanks !

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    Hello,
    your script looks fine ... maybe the pb comes from the oratab : you should have a file nammed oratab
    (find / -name oratab 2>/dev/null)
    in this file you have entries in the format ORACLE_SID:ORACLE_HOME:{Y|N}
    you should put a Y for every database you want to be started using dbstart ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width