Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbora not start automatically database
On May 29, 12:44 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net>
wrote:
> 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:/......
>
> > pls really, really i appreciate your help !!!!
>
> > thanks in advance
>
> And to what value is ORACLE_SID set?
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
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:44:06 CDT