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/questi...d.php?t=549258
http://elandingstest.alaska.gov/conf...up+During+Boot

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

thanks in advance

On May 29, 10:51 am, chijar <chi... (AT) gmail (DOT) com> wrote:
And to what value is ORACLE_SID set?


David Fitzjarrell

<fitzjarrell (AT) cox (DOT) net> wrote

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.

On May 29, 12:44 pm, "fitzjarr... (AT) cox (DOT) net" <fitzjarr... (AT) cox (DOT) net>
wrote:
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.

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

chijar wrote:
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)

iD8DBQFGXGiRLw8L4IAs830RAgrHAJ9IYSdoDVSZkhU6GHZA8Z d+NV55IgCdHqI0
lC29bqo94rVZ/gz27IobSe0=
=bxgR
-----END PGP SIGNATURE-----

well...
- David, the value of oracle_sid is the SID of my oracle database.
- i will try to run as root: sh -x dbora start like Valentin says but
the dbstart script is correct 'cause i can execute the dbstart and
this start my services ok.
- Frank, the location of my dbstart and dbshut files is correct, they
are in /u01/app/oracle/product/10.2.0/db_1/bin. And yes, i can use
dbstart and dbshut too. And the values of the variables are:

my bash_profile of oracle user is:

************************************************** *************
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
unset USERNAME

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORAAPOLO; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CLA
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

************************************************** *************
My LD_ASSUME_KERNEL is comment... that is wrong???
Another idea????

thanks


On 29 mayo, 12:53, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com>
wrote:

chijar schrieb:
If i recall correctly, in your version the correct call to dbstart
script will be dbstart $ORACLE_HOME. It will as well start listener, so
no separated call to lsnrctl is needed.

Regarding LD_ASSUME_KERNEL - as of 10g this hack is no more needed,
because oracle 10g uses nptl ( you can google on "ld_assume_kernel nptl
oracle" to read more about subject)

Regarding your script - did you try to localize exactly which line
causes the error? You either put the -x flag as suggested already or
comment out subsequently lines of code till you catch your error.

Best regards

Maxim