dbora not start automatically database

From: chijar <chijar_at_gmail.com>
Date: 29 May 2007 08:51:07 -0700
Message-ID: <1180453867.898415.237320@q75g2000hsh.googlegroups.com>

dear all,
Oracle db 10g r2 enterpise
RHEL version 3.

i have an error when dbora attempt to execute. That error is describe in system log in linux:
My ORACLE_HOME and USER all are correct . But during boot time of pc it shows :
"starting dbora : execvp no such file or directory"

...and my dbstart script not execute. And the code is:

---

#!/bin/bash
#
# chkconfig: 35 99 10
# description: Starts and stops Oracle processes
#
# 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=/u01/app/oracle/product/10.2.0/db_1 ORA_OWNER=oracle

case "$1" in 'start')
# Start the TNS Listener

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
# Start the Intelligent Agent

if [ -f $ORA_HOME/bin/emctl ]; then
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" fi
# Start Management Server

if [ -f $ORA_HOME/bin/emctl ]; then
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" fi
# Start HTTP Server

if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" fi
touch /var/lock/subsys/dbora
;;
'stop')
# Stop HTTP Server

if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl stop" fi
# Stop the TNS Listener

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/dbora
;;
esac
# End of script dbora

---

the permission for dbaora file are:

/etc/init.d
-rwxr-xr-x 1 root dba 1770 may 28 18:08 dbora

... When i execute dbstart or dbshut, this files function ok. The problem is dbora file.

I changed permissions to:
750
755
...and i changed !/bin/bash --> !/bin/sh

... but it result in anything...
it comes the same error...

• i saw the: 222813.1 note in metalink, and i checked several links about that but it not results. http://www.linuxquestions.org/questions/showthread.php?t=549258 http://elandingstest.alaska.gov/confluence/display/IERS/30.5+Oracle+Startup+During+Boot

pls really, really i appreciate your help !!!!

thanks in advance Received on Tue May 29 2007 - 10:51:07 CDT