Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Issue with crontab

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Issue with crontab
# 8  
Old 06-23-2010
Quote:
Originally Posted by Sriranga
I just checked the mails and found this messge -
/home/supp1/om/abc/script2.ksh[23]: sqlplus: not found

This is how I am trying to connect to sqlplus -
sqlplus support/support@supp1 << EOF

Where support is the user name and password and supp1 is the DB.

is there anything wrong here which cron doesn't recognise?
yes, there is and it's been suggested earlier in the thread.
I'd suggest looking into the FAQ and searching the forum prior to any postings.
# 9  
Old 06-23-2010
Quote:
Originally Posted by Sriranga
I just checked the mails and found this messge -
/home/supp1/om/abc/script2.ksh[23]: sqlplus: not found

This is how I am trying to connect to sqlplus -
sqlplus support/support@supp1 << EOF

Where support is the user name and password and supp1 is the DB.

is there anything wrong here which cron doesn't recognise?
you can try full path sqlplus and try again Smilie
# 10  
Old 06-23-2010
After setting and exporting $ORACLE_HOME we need to be able to find sqlpus in the program search PATH.

Code:
PATH=${PATH}:${ORACLE_HOME}/bin  ; export PATH

Last edited by methyl; 06-23-2010 at 07:42 PM.. Reason: Typo
# 11  
Old 06-24-2010
I set the required environment varibales like ORACLE_HOME and ORACLE_SID. Still not able to get in... i can see a new error now after setting the env var !

Code:
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

This is how I have set the parameters -

Code:
Code:
ORACLE_HOME="/opt/oracle/orcts/product/9.2.0"
ORACLE_SID="SUPP1"
SQLPLUS="${ORACLE_HOME}/bin/sqlplus -s"
.
.
.
${SQLPLUS} -s support/support@supp1 <<!
.
.
.
!

Last edited by vgersh99; 06-24-2010 at 10:18 AM.. Reason: code tags, please!
# 12  
Old 06-24-2010
Don't forget to export the environment variables. We are setting them for the benefit of the processes we call (e.g. "sqlplus").
Also it is much better to find "sqlplus" through unix PATH. The same environment then works for all Oracle unix programs.

Code:
ORACLE_HOME="/opt/oracle/orcts/product/9.2.0"  ;  export ORACLE_HOME
ORACLE_SID="SUPP1"  ;  export ORACLE_SID
PATH=${PATH}:${ORACLE_HOME}/bin  ; export PATH


.
.
.
sqlplus -s support/support@supp1 <<!

Last edited by methyl; 06-24-2010 at 10:11 AM.. Reason: typo
This User Gave Thanks to methyl For This Post:
Sriranga
# 13  
Old 06-24-2010
BINGO ! its working after export.

Thanks all for the help.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Crontab issue

Hello, I have a bash script that finds files older than 31 days and deletes them. I have this file loading into crontab to run everyday. It ran fine the first time i loaded it in, but now when I try to run it manually (bash file.sh) I get errors. Here is the script TIME=" -maxdepth 1... (6 Replies)
Discussion started by: jrymer
6 Replies

2. UNIX for Advanced & Expert Users

Crontab Issue

My colleague who was a sysadmin , has created a cron job script which collects logs and process them. The script works perfectly as per the defined time set by him. it works when we keep the timing as 55 05 * * * , whereas if we try to prepone the cron task is not getting executed. Where... (10 Replies)
Discussion started by: aravindj80
10 Replies

3. Shell Programming and Scripting

Crontab issue

hi, i have schduled a job through crontab, but it is not getting executed. bash-3.2$ crontab -l # Monthly Download (mm hh DD MM format) 35 05 01 04 * /home/ftpsrp/srpftp1/download/ofrdb/scripts/load_ofrdb.sh crr.sh here is the permission of the .sh files -rwxr--r-- 1 ftpsrp srp ... (7 Replies)
Discussion started by: lovelysethii
7 Replies

4. UNIX for Dummies Questions & Answers

Crontab Issue..!!!

Hi, I have a cronjob but it is not getting executed.Is there any ways to check whether crontab is working.I have put crontab -l and checked.It got listed.But it is not working. My Crontab is, * * * * * /ldesk/home/abc/source/compare.sh >/dev/null 2>&1 (1 Reply)
Discussion started by: gayisada
1 Replies

5. AIX

Crontab issue

Hi all, I'm having a problem with a crontab entry execution for a non root user. AIX version 5.3 user@host ~ $ oslevel -r 5300-10 cron status user@host ~ $ ps -ef | grep cron root 377044 1 0 Oct 27 - 0:22 /usr/sbin/cron cron entry for user user@host ~ $... (3 Replies)
Discussion started by: h@foorsa.biz
3 Replies

6. UNIX for Advanced & Expert Users

Crontab issue

We have configured a script to be run at specific time using crontab. # crontab -l 15 11 * * * VM_Count_V4.shas per the crontab entry script should run every day 11.15 a.m Every time when the script is executed i get a mail but when i run it using crontab it doesn't send any mail. However... (1 Reply)
Discussion started by: pinga123
1 Replies

7. Shell Programming and Scripting

crontab issue

Helo . I have 2.6.13-1.1526_FC4smp here. I am trying to make crontab execute my simple shell script, but noting happens. here is how i am testing this : $ pwd /home/oracle $ ls -l two* ls: two*: No such file or directory $ $ crontab -e crontab: installing new crontab $ $ crontab... (7 Replies)
Discussion started by: tonijel
7 Replies

8. UNIX for Advanced & Expert Users

crontab issue

I am adding a piece of code which adds entry in crontab ((in brown color)) \crontab -l > $tmpfile echo "Removing the cleanProcess entry if it already existed.." grep -v "cleanProcess.sh" $tmpfile > $newtmpfile lcnt=`grep -c "cleanProcess.sh" $tmpfile` echo... (4 Replies)
Discussion started by: crackthehit007
4 Replies

9. HP-UX

crontab issue

Dear Folks, i am new to hp-ux, i have a problem scheduling the crontab, The script is working fine at command prompt, but not working at cron, please find a solution for it , here are the logs and my schedule at cron: log after restarting crontab /var/adm/cron/log ! *** cron started *** ... (11 Replies)
Discussion started by: vaddi
11 Replies

10. UNIX for Dummies Questions & Answers

Crontab Issue

I have a backup script that is suppose to run every night of the week, but it never does, it starts to run. The way I can tell is that the dates on dump_log are changing to when the script runs. If I look in the cron log file is shows ! > root 506342 cr /etc/back_up Fri Aug 5 10:30:00... (2 Replies)
Discussion started by: rickyt00
2 Replies
Login or Register to Ask a Question