Dear all,
I am trying to push a data file to a remote Server. I am taking date variable from the database.
The file I want to push looks like this in /tmp
hostname.export.beforedate.dmp.gz
for reading the date from the database i have a file get_date.sql which contains
select before_bis_date from dates;
commit;
exit
and the script i use for the remote ftp push is as below
#!/bin/sh
HOST=10.0.1.20
USER='oracle'
PASSWD='oracle'
brn=`hostname`
today=`/oracle/bin/sqlplus -S ims/imsadm@$ORACLE_SID @get_dt.sql`
count=1
for mydate in $today
do
if [ $count = "3" ]
then
bisdate=$mydate
fi
count=$[$count+1]
done
cd /tmp
echo ---------------------------------------------------------------------------
echo The branch $brn FTP started....
ftp -n $HOST <<END_SCRIPT
quote user $USER
quote pass $PASSWD
cd /tmp/
bin
put $brn.export.$bisdate.preEOD.dmp.gz
bye
END_SCRIPT
echo The branch $brn FTP finished !
echo ---------------------------------------------------------------------------
exit 0
but i am getting error
this script works fine when i run it manuall but if i try to run it using cron entry i get the following error
From oracle Thu Feb 23 18:48:00 2006
Return-Path: <oracle@mig2>
Received: (from oracle@localhost)
by mig2 (8.11.6/8.11.6) id k1ND30v14724
for oracle; Thu, 23 Feb 2006 18:48:00 +0545
Date: Thu, 23 Feb 2006 18:48:00 +0545
Message-Id: <200602231303.k1ND30v14724@mig2>
From: root@mig2 (Cron Daemon)
To: oracle@mig2
Subject: Cron <oracle@mig2> /oracle/scripts/pulldump_scripts/pull_dump.sh
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/oracle>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=oracle>
---------------------------------------------------------------------------
The branch mig2 FTP started....
local: mig2.ims.internal.preEOD.dmp.gz: No such file or directory
The branch mig2 FTP finished !
---------------------------------------------------------------------------
CAN ANY ONE HELP ME!!!!!!!!!! its urgent