Re: dbora not start automatically database

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

------------------------------------------------------

Toss it away - apachectl itNOTthe way tostartor 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------ Ocultar texto de la cita -

- Mostrar texto de la cita -


.

Relevant Pages

  • Oracle on Alpha
    ... I am still trying to get a new server but have ran into major snags. ... Does anyone run Oracle on a DS20?? ... Does colbalt read oracle databases or can it?? ... Cobalt and if I could get something that works with Cobalt ...
    (Tru64-UNIX-Managers)
  • Re: dbora not start automatically database
    ... the value of oracle_sid is the SID of my oracle database. ... the dbstart script is correct 'cause i can execute the dbstart and ... in your version the correct call to dbstart script will be dbstart $ORACLE_HOME. ...
    (comp.databases.oracle.server)
  • Re: Anyway to allow root to sqlplus / as sysdba??
    ... have the script include a switch user to the oracle account (su - ... have a look at the dbstart and dbshut scripts as provided by Oracle: ...
    (comp.databases.oracle.server)
  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)