RE: crontab script problem
Thanks every-body. I found the culprit command in the .profile It wasksh -o emacswhich was creating a shell and causing problem. Also there were some terminal setting tset -I -Q , TERM=VT220, term=dec etc. which were not required while invoking the profile for a crontab. Cheers Rajesh -Original Message- Sent: Monday, April 16, 2001 11:06 PM To: Multiple recipients of list ORACLE-L When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin /sbi n:/e tc:/usr/bin:/usr/openwin/bin:/usr/ccs/bin:/usr/local/bin:/comm/BrxPU21:/ orac le/p roduct/8.0.4/bin:/usr/ucb:/usr/bin/nsr:/usr/bin:/usr/sbin:.:$PATH;export PATH OLDHOME=$ORACLE_HOME ORACLE_BASE=/oracle; export ORACLE_BASE ORACLE_SID=nyccp; export ORACLE_SID ORACLE_HOME=/oracle/product/8.0.4; export ORACLE_HOME ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS ORACLE_DOC=$ORACLE_HOME/doc; export ORACLE_DOC ORACLE_TERM=xsun5; export ORACLE_TERM ORACLE_LIB=$ORACLE_HOME/lib; export ORACLE_LIB CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:.:$ORACLE_HOME/jdbc/lib; export C LASSPATH TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN OPENWINHOME=/usr/openwin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:$ORACLE_HO ME/j dbc/ lib export LD_LIBRARY_PATH # TMPDIR=/tmp; export TMPDIR WORKDIR=/tmp; export WORKDIR # Put new ORACLE_HOME in path and remove old one case "$OLDHOME" in "") OLDHOME=$PATH ;;#This makes it so that null OLDHOME can't match esac#anything in next case statement case "$PATH" in *$OLDHOME/bin*) PATH=`echo $PATH | \ sed "s;$OLDHOME;$ORACLE_HOME;g"` ;; *$ORACLE_HOME/bin*) ;; *:) PATH=${PATH}$ORACLE_HOME/bin: ;; "") PATH=$ORACLE_HOME/bin ;; *) PATH=$PATH:$ORACLE_HOME/bin ;; esac PATH=/oracle/oper:$ORACLE_HOME/lib:/comm/local/jdk1.1.4/bin:$PATH export PATH -Original Message- Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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).
RE: crontab script problem
When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin/sbi n:/e tc:/usr/bin:/usr/openwin/bin:/usr/ccs/bin:/usr/local/bin:/comm/BrxPU21:/orac le/p roduct/8.0.4/bin:/usr/ucb:/usr/bin/nsr:/usr/bin:/usr/sbin:.:$PATH;export PATH OLDHOME=$ORACLE_HOME ORACLE_BASE=/oracle; export ORACLE_BASE ORACLE_SID=nyccp; export ORACLE_SID ORACLE_HOME=/oracle/product/8.0.4; export ORACLE_HOME ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS ORACLE_DOC=$ORACLE_HOME/doc; export ORACLE_DOC ORACLE_TERM=xsun5; export ORACLE_TERM ORACLE_LIB=$ORACLE_HOME/lib; export ORACLE_LIB CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:.:$ORACLE_HOME/jdbc/lib; export C LASSPATH TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN OPENWINHOME=/usr/openwin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:$ORACLE_HOME/j dbc/ lib export LD_LIBRARY_PATH # TMPDIR=/tmp; export TMPDIR WORKDIR=/tmp; export WORKDIR # Put new ORACLE_HOME in path and remove old one case "$OLDHOME" in "") OLDHOME=$PATH ;;#This makes it so that null OLDHOME can't match esac#anything in next case statement case "$PATH" in *$OLDHOME/bin*) PATH=`echo $PATH | \ sed "s;$OLDHOME;$ORACLE_HOME;g"` ;; *$ORACLE_HOME/bin*) ;; *:) PATH=${PATH}$ORACLE_HOME/bin: ;; "") PATH=$ORACLE_HOME/bin ;; *) PATH=$PATH:$ORACLE_HOME/bin ;; esac PATH=/oracle/oper:$ORACLE_HOME/lib:/comm/local/jdk1.1.4/bin:$PATH export PATH -Original Message- Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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 script problem
The "bad option" appears to be coming from somewhere in the .profile that you are executing. Can you forward that for further analysis? Also, the exact "crontab" command line would be helpful. -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Subject: crontab script problem Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge 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 script problem
Rajesh, Instead of running the .profile for the oracle user, you might try invoking the oracle user. I don't think you're seeing the $ORACLE_HOME. Try something like: su - oracle "-c sqlplus -s"< > Hi All, > > I am facing some problem while running sqlplus > scripts from crontab. Env is Tru64 Unix 4.0f and > Oracle 7.2.3. > Through crontab all system commands run fine, > but when I try to invoke sqlplus, it gives following > error: > > /oracle/test1.sh: -o: bad option(s) > > Also I have executed .profile of Oracle user > in the beginning of command. The commands written > in /oracle/test1.sh is as follows, > > . /oracle/product/723/.profile > sqlplus -s system/manager @/oracle/test2.sql > > Any help/suggestion would be greatly appreciated. > > TIA, > Rajesh > -- > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour 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).
crontab script problem
Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- 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).