Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbora not start automatically database

Re: dbora not start automatically database

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: Tue, 29 May 2007 13:06:37 -0400
Message-ID: <f3hmkl$5ba$1@aioe.org>

<fitzjarrell_at_cox.net> wrote in message
news:1180457084.675626.157410_at_p77g2000hsh.googlegroups.com...

> 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
>

In addition to the above, try to run as root: sh -x dbora start. Also, check the dbstart script and see if it points to the right location for oratab. Received on Tue May 29 2007 - 12:06:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US