dbora not start automatically database
in [Oracle]
|
Prev: Oracle user group
Next: Remove DBMS_LOCK Locks
From: chijar on 29 May 2007 11:51 dear all, Oracle db 10g r2 enterpise RHEL version 3. i have an error when dbora attempt 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 : "starting dbora : execvp no such file or directory" ....and my dbstart script not execute. 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 # Oracle database in ORA_HOME. # ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 ORA_OWNER=oracle case "$1" in 'start') # Start the TNS Listener su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" # Start the Oracle databases: # The following command assumes that the oracle login # will not prompt the user for any values su - $ORA_OWNER -c $ORA_HOME/bin/dbstart # Start the Intelligent Agent if [ -f $ORA_HOME/bin/emctl ]; then su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" fi # Start Management Server if [ -f $ORA_HOME/bin/emctl ]; then su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" fi # Start HTTP Server if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" 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 # will not prompt the user for any values su - $ORA_OWNER -c $ORA_HOME/bin/dbshut rm -f /var/lock/subsys/dbora ;; esac # End of script dbora ------------------------------------------------------ the permission for dbaora file are: /etc/init.d -rwxr-xr-x 1 root dba 1770 may 28 18:08 dbora .... When i execute dbstart or dbshut, this files function ok. The problem is dbora file. I changed permissions to: 750 755 ....and i changed !/bin/bash --> !/bin/sh .... but it result in anything... it comes the same error... - i saw the: 222813.1 note in metalink, and i checked several links about that but it not results. http://www.linuxquestions.org/questions/showthread.php?t=549258 http://elandingstest.alaska.gov/confluence/display/IERS/30.5+Oracle+Startup+During+Boot pls really, really i appreciate your help !!!! thanks in advance
From: fitzjarrell on 29 May 2007 12:44 On May 29, 10:51 am, chijar <chi...(a)gmail.com> wrote: > dear all, > Oracle db 10g r2 enterpise > RHEL version 3. > > i have an error when dbora attempt 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 : > "starting dbora : execvp no such file or directory" > > ...and my dbstart script not execute. 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 > # Oracle database in ORA_HOME. > # > ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 > ORA_OWNER=oracle > > case "$1" in 'start') > # Start the TNS Listener > su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" > # Start the Oracle databases: > # The following command assumes that the oracle login > # will not prompt the user for any values > su - $ORA_OWNER -c $ORA_HOME/bin/dbstart > # Start the Intelligent Agent > if [ -f $ORA_HOME/bin/emctl ]; then > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" > fi > # Start Management Server > if [ -f $ORA_HOME/bin/emctl ]; then > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" > fi > # Start HTTP Server > if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then > su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" > 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 > # will not prompt the user for any values > su - $ORA_OWNER -c $ORA_HOME/bin/dbshut > rm -f /var/lock/subsys/dbora > ;; > esac > # End of script dbora > > ------------------------------------------------------ > > the permission for dbaora file are: > > /etc/init.d > -rwxr-xr-x 1 root dba 1770 may 28 18:08 dbora > > ... When i execute dbstart or dbshut, this files function ok. The > problem is dbora file. > > I changed permissions to: > 750 > 755 > ...and i changed !/bin/bash --> !/bin/sh > > ... but it result in anything... > it comes the same error... > > - i saw the: 222813.1 note in metalink, and i checked several links > about that but it not results.http://www.linuxquestions.org/questions/showthread.php?t=549258http://elandingstest.alaska.gov/confluence/display/IERS/30.5+Oracle+S... > > pls really, really i appreciate your help !!!! > > thanks in advance And to what value is ORACLE_SID set? David Fitzjarrell
From: Valentin Minzatu on 29 May 2007 13:06 <fitzjarrell(a)cox.net> wrote in message news:1180457084.675626.157410(a)p77g2000hsh.googlegroups.com... > On May 29, 10:51 am, chijar <chi...(a)gmail.com> wrote: >> dear all, >> Oracle db 10g r2 enterpise >> RHEL version 3. >> >> i have an error when dbora attempt 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 : >> "starting dbora : execvp no such file or directory" >> >> ...and my dbstart script not execute. 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 >> # Oracle database in ORA_HOME. >> # >> ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 >> ORA_OWNER=oracle >> >> case "$1" in 'start') >> # Start the TNS Listener >> su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" >> # Start the Oracle databases: >> # The following command assumes that the oracle login >> # will not prompt the user for any values >> su - $ORA_OWNER -c $ORA_HOME/bin/dbstart >> # Start the Intelligent Agent >> if [ -f $ORA_HOME/bin/emctl ]; then >> su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" >> fi >> # Start Management Server >> if [ -f $ORA_HOME/bin/emctl ]; then >> su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" >> fi >> # Start HTTP Server >> if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then >> su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" >> 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 >> # will not prompt the user for any values >> su - $ORA_OWNER -c $ORA_HOME/bin/dbshut >> rm -f /var/lock/subsys/dbora >> ;; >> esac >> # End of script dbora >> >> ------------------------------------------------------ >> >> the permission for dbaora file are: >> >> /etc/init.d >> -rwxr-xr-x 1 root dba 1770 may 28 18:08 dbora >> >> ... When i execute dbstart or dbshut, this files function ok. The >> problem is dbora file. >> >> I changed permissions to: >> 750 >> 755 >> ...and i changed !/bin/bash --> !/bin/sh >> >> ... but it result in anything... >> it comes the same error... >> >> - i saw the: 222813.1 note in metalink, and i checked several links >> about that but it not >> results.http://www.linuxquestions.org/questions/showthread.php?t=549258http://elandingstest.alaska.gov/confluence/display/IERS/30.5+Oracle+S... >> >> pls really, really i appreciate your help !!!! >> >> thanks in advance > > And to what value is ORACLE_SID set? > > > David Fitzjarrell > In addition to the above, try to run as root: sh -x dbora start. Also, check the dbstart script and see if it points to the right location for oratab.
From: Valentin Minzatu on 29 May 2007 13:44 On May 29, 12:44 pm, "fitzjarr...(a)cox.net" <fitzjarr...(a)cox.net> wrote: > On May 29, 10:51 am, chijar <chi...(a)gmail.com> wrote: > > > > > > > dear all, > > Oracle db 10g r2 enterpise > > RHEL version 3. > > > i have an error when dbora attempt 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 : > > "starting dbora : execvp no such file or directory" > > > ...and my dbstart script not execute. 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 > > # Oracle database in ORA_HOME. > > # > > ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 > > ORA_OWNER=oracle > > > case "$1" in 'start') > > # Start the TNS Listener > > su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" > > # Start the Oracle databases: > > # The following command assumes that the oracle login > > # will not prompt the user for any values > > su - $ORA_OWNER -c $ORA_HOME/bin/dbstart > > # Start the Intelligent Agent > > if [ -f $ORA_HOME/bin/emctl ]; then > > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" > > fi > > # Start Management Server > > if [ -f $ORA_HOME/bin/emctl ]; then > > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" > > fi > > # Start HTTP Server > > if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then > > su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" > > 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 > > # will not prompt the user for any values > > su - $ORA_OWNER -c $ORA_HOME/bin/dbshut > > rm -f /var/lock/subsys/dbora > > ;; > > esac > > # End of script dbora > > > ------------------------------------------------------ > > > the permission for dbaora file are: > > > /etc/init.d > > -rwxr-xr-x 1 root dba 1770 may 28 18:08 dbora > > > ... When i execute dbstart or dbshut, this files function ok. The > > problem is dbora file. > > > I changed permissions to: > > 750 > > 755 > > ...and i changed !/bin/bash --> !/bin/sh > > > ... but it result in anything... > > it comes the same error... > > > - i saw the: 222813.1 note in metalink, and i checked several links > > about that but it not results.http://www.linuxquestions.org/questions/showthread.php?t=549258http:/...... > > > pls really, really i appreciate your help !!!! > > > thanks in advance > > And to what value is ORACLE_SID set? > > David Fitzjarrell- Hide quoted text - > > - Show quoted text - In addition to the above, try to run as root: sh -x dbora start. Also, check the dbstart script and see if it points to the right location for oratab.
From: Frank van Bortel on 29 May 2007 13:53
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 chijar wrote: > dear all, > Oracle db 10g r2 enterpise > RHEL version 3. > > i have an error when dbora attempt 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 : > "starting dbora : execvp no such file or directory" > > ...and my dbstart script not execute. 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 > # Oracle database in ORA_HOME. > # > ORA_HOME=/u01/app/oracle/product/10.2.0/db_1 > ORA_OWNER=oracle > > case "$1" in 'start') > # Start the TNS Listener > su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start" > # Start the Oracle databases: > # The following command assumes that the oracle login > # will not prompt the user for any values > su - $ORA_OWNER -c $ORA_HOME/bin/dbstart > # Start the Intelligent Agent > if [ -f $ORA_HOME/bin/emctl ]; then > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start agent" > fi > # Start Management Server > if [ -f $ORA_HOME/bin/emctl ]; then > su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" > fi > # Start HTTP Server > if [ -f $ORA_HOME/Apache/Apache/bin/apachectl ]; then > su - $ORA_OWNER -c "$ORA_HOME/Apache/Apache/bin/apachectl start" > 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 > # will not prompt the user for any values > su - $ORA_OWNER -c $ORA_HOME/bin/dbshut > rm -f /var/lock/subsys/dbora > ;; > esac > # End of script dbora > > ------------------------------------------------------ Toss it away - apachectl it NOT the way to start or 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----- |