Re: dbora not start automatically database

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..._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 -

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 Received on Tue May 29 2007 - 18:38:55 CDT