Re: dbora not start automatically database
- From: Maxim Demenko <mdemenko@xxxxxxxxx>
- Date: Wed, 30 May 2007 01:38:55 +0200
chijar schrieb:
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...@xxxxxxxxx>
wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
chijar wrote:dear all,Toss it away - apachectl itNOTthe way tostartor stop
Oracle db 10g r2 enterpise
RHEL version 3.
i have an error whendboraattempt 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 :
"startingdbora: execvp no such file or directory"
...and my dbstart scriptnotexecute. 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
# Oracledatabasein ORA_HOME.
#
ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
ORA_OWNER=oracle
case "$1" in 'start')
#Startthe TNS Listener
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctlstart"
#Startthe Oracle databases:
# The following command assumes that the oracle login
# willnotprompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
#Startthe Intelligent Agent
if [ -f $ORA_HOME/bin/emctl ]; then
su - $ORA_OWNER -c "$ORA_HOME/bin/emctlstartagent"
fi
#StartManagement Server
if [ -f $ORA_HOME/bin/emctl ]; then
su - $ORA_OWNER -c "$ORA_HOME/bin/emctlstartdbconsole"
fi
#StartHTTP Server
if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then
su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectlstart"
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
# willnotprompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/dbora
;;
esac
# End of scriptdbora
------------------------------------------------------
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------ Ocultar texto de la cita -
- Mostrar texto de la cita -
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
.
- References:
- dbora not start automatically database
- From: chijar
- Re: dbora not start automatically database
- From: Frank van Bortel
- Re: dbora not start automatically database
- From: chijar
- dbora not start automatically database
- Prev by Date: Re: rman test restore
- Next by Date: Re: Bouncing Serving
- Previous by thread: Re: dbora not start automatically database
- Next by thread: DECODE and NVL
- Index(es):
Relevant Pages
|
