Re: dbora not start automatically database

On May 29, 10:51 am, chijar <chi..._at_gmail.com> wrote:
> 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=549258http://elandingstest.alaska.gov/confluence/display/IERS/30.5+Oracle+S...
>
> pls really, really i appreciate your help !!!!
>
> thanks in advance

And to what value is ORACLE_SID set?

David Fitzjarrell Received on Tue May 29 2007 - 11:44:44 CDT