Re: dbora not start automatically database

From: chijar <chijar_at_gmail.com>
Date: 29 May 2007 13:34:12 -0700
Message-ID: <1180470852.639282.310820@o5g2000hsb.googlegroups.com>

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.com> 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 -
Received on Tue May 29 2007 - 15:34:12 CDT