Re: Crontab ,HELP!!!
Hello, We solved this problem by invoking our .profile first in the script Like : . /opt2/OraHome/.profile exp system/pwd file=/opt2/OraHome/exp/Billingfulldata.dmp full=y log=blb.txt good luck Regards Henrik -- --- Henrik Ekenberg Anoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Crontab ,HELP!!!
The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing line. Don't forget the dot as the first character. . /usr/local/bin/profile.ora 2) Create a profile.ora file in /usr/local/bin (oropt/bin) and have it set up the platform specific environment variables that you need. Ours looks like this for SGI IRIX64. SGI_ABI=-64; export SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib; export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export CLASSPATH 3) In your cron scripts, put the following lines at the beginning to set up the environment. ORACLE_SID=sidname ; export ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK. /opt/bin/oraenv "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Hello All,I want to run a Job using crontab scheduling.The job is running butwith error like sqlplus and svrmgrl not found.When I am using the crontab script then it gives some error ,likesqlplus and svrmgrl not found.But ths same scripts manually working fine .So please tell me is there any path will setup to run the crontab . I amrunning the crontab from oracle id ,not from root.Please tell me what is the problem if i will run in orcale id. Where i willgive permission so that it will get the path of sqlplus and svrmgrl .I am sending the out put of cron .Please see it and tell me.our "cron" job on JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced the following output:Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J! ! ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not foundRegards,saroj.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y! ! ou want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices.
RE: Crontab ,HELP!!!
My god, I almost had a cow when I came in this morning. All my mail that has cron in it goes to its own folder as I have all oracle server mail routed to my exchange mail. I thought I was having system problems. -Original Message- Sent: Tuesday, February 06, 2001 8:35 PM To: Multiple recipients of list ORACLE-L Hi Saroj, crontab runs within its own environment (ie. it doesn't inherit an environment from any .profile or /etc/profile etc), so you will have to explicitly call them in your crontab job line (eg. . /etc/profile;script or command ) or even better declare the variables that the script will need in the beginning of the script and then just have the name of the script at the top. This one got me too. :-) Later, Mike. Michael Henderson, DBA http://www.nzoom.com DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466 [EMAIL PROTECTED] 02/07 5:10 pm Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Henderson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Crontab ,HELP!!!
I use the following method to execute the profile so environment variables are all set just like when you manually run the script on the command line. 00 01 * * * ksh -c ". $HOME/.profile; /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup" Richard Ji -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck HamiltonSent: Wednesday, February 07, 2001 12:21 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Crontab ,HELP!!! The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing line. Don't forget the dot as the first character. . /usr/local/bin/profile.ora 2) Create a profile.ora file in /usr/local/bin (oropt/bin) and have it set up the platform specific environment variables that you need. Ours looks like this for SGI IRIX64. SGI_ABI=-64; export SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib; export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export CLASSPATH 3) In your cron scripts, put the following lines at the beginning to set up the environment. ORACLE_SID=sidname ; export ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK. /opt/bin/oraenv "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Hello All,I want to run a Job using crontab scheduling.The job is running butwith error like sqlplus and svrmgrl not found.When I am using the crontab script then it gives some error ,likesqlplus and svrmgrl not found.But ths same scripts manually working fine .So please tell me is there any path will setup to run the crontab . I amrunning the crontab from oracle id ,not from root.Please tell me what is the problem if i will run in orcale id. Where i willgive permission so that it will get the path of sqlplus and svrmgrl .I am sending the out put of cron .Please see it and tell me.our "cron" job on JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced the following output:Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J! ! ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not foundRegards,saroj.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y! ! ou want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?Yahoo! Auctions - Buy the things you want at great prices.
Re: Crontab ,HELP!!!
Hi Saroj, crontab runs within its own environment (ie. it doesn't inherit an environment from any .profile or /etc/profile etc), so you will have to explicitly call them in your crontab job line (eg. . /etc/profile;script or command ) or even better declare the variables that the script will need in the beginning of the script and then just have the name of the script at the top. This one got me too. :-) Later, Mike. Michael Henderson, DBA http://www.nzoom.com DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466 [EMAIL PROTECTED] 02/07 5:10 pm Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Henderson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Crontab ,HELP!!!
Hi Saroj, You need to initialize the environment variables first in the cron file like ORACLE_SID, ORACLE_HOME etc. Also you will have to provide the Full path of the executables One of the sample cron file is something like this: banner BACKUP echo STARTING DAILY BACKUP ON `date`.. ORACLE_SID=pasi export ORACLE_SID ORACLE_HOME=/u03/app/oracle/8.1.6; export ORACLE_HOME /u03/app/oracle/8.1.6/bin/exp moh/hnh97 FULL=Y FILE=/u06/oradmp/allmoh.dmp GRANTS=Y INDEXES=Y LOG=/u06/oradmp/allmoh.log rm -f /u05/oracle8/arch/backctl /u03/app/oracle/8.1.6/bin/svrmgrl ! connect internal alter database backup controlfile to '/u05/oracle8/arch/backctl' ; alter system switch logfile ; exit ! mt rewind tar -cvp -f /dev/rmt0h /u06/oradmp/* tar -rvp /u05/oracle8/arch/arc* echo DAILY BACKUP COMPLETED SUCCESSFULLY echo PLEASE CHECK FOR ANY ERRORS .. mt rewind mt offline banner END-BACKUP HTH, Rajesh -Original Message- (CAP,CEF) Sent: Wednesday, February 07, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).