dbora not start automatically database
in [Oracle]
|
Prev: Oracle user group
Next: Remove DBMS_LOCK Locks
From: chijar on 29 May 2007 16:34 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...(a)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 -
From: Maxim Demenko on 29 May 2007 19:38
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...(a)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 |