Re: dbora not start automatically database

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

Toss it away - apachectl it NOT the way to start or stop anything; opmnctl is.

Apart from that - do you have a login script (e.g. .bash_profile) that sets the environment variables, like ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH and LD_ASSUME_KERNEL?
Does the dbstart script in /u01/app/oracle/product/10.2.0/db_1/bin do that? If so - what are the values?

Can you use dbstart at all?

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGXGiRLw8L4IAs830RAgrHAJ9IYSdoDVSZkhU6GHZA8Zd+NV55IgCdHqI0 lC29bqo94rVZ/gz27IobSe0=
=bxgR
-----END PGP SIGNATURE----- Received on Tue May 29 2007 - 12:53:21 CDT