11-03-2006
still not working
Hi,
I am sending the code....
Friends please send me ur contact numbers so that i can call you and discuss in detail.
regards
-------------------------------------------------------------------
#!/bin/sh
serv=97.253.0.194
username=ftpuser
password=ftpuser
procno=$$
remdir=/u10/app/oracle/admin/NETMANDB/exp/performance/
#locdir=/usr/local/gauravs
#locdir=/cltyapps/clarity/clarity/etc/inetman_performance_script
export locdir
DTEXT=`TZ=aaa24 date +%Y%m%d`
DTEXT1=`TZ=aaa24 date +%y%m%d`
FILENAME=$DTEXT.tar.gz
FILENAME2=$DTEXT.tar
DELIMITER="_"
HOME=/cltyapps/clarity/clarity/etc/inetman_performance_script
export HOME
ORACLE_HOME=/u02/app/oracle/product/9.2.0
export ORACLE_HOME
echo user $username $password > ftp_commands_$procno
echo 'bin' >> ftp_commands_$procno
echo cd $remdir >> ftp_commands_$procno
#echo lcd $locdir >> ftp_commands_$procno
echo lcd $HOME >> ftp_commands_$procno
echo get $FILENAME >> ftp_commands_$procno
echo 'close' >> ftp_commands_$procno
$ORACLE_HOME/bin/sqlplus oss/oss@UT <<EOF
#start $locdir/remove.sql
start $HOME/remove.sql
exit
EOF
rm remove.sql
ftp -nv $serv < ftp_commands_$procno
gunzip -d $FILENAME
tar -xvf $FILENAME2
rm *.log
#mv *.dmp dumps
#cd dumps
for filename1 in *
do
xyz=`echo $filename1 | cut -d. -f1`
#echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $locdir/remove.sql
echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $HOME/remove.sql
#echo $filename1 >> /usr/local/gauravs/imp.log
$ORACLE_HOME/bin/imp file=$filename1 userid=oss/oss@UT fromuser=nm4000 touser=oss commit=y log=imp.log buffer=2000000 > imp.l
og 2>&1
#rm *.dmp
done
#cd $locdir
cd $HOME
rm *.tar
rm *.tar.gz
rm ftp_commands*
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All
Some how, variables are not getting exported while running the script in cronjob. Variable value is coming blank. But the variables are geting the value when the same script I am running manually. Any idea why?
When running the script in cron-job
==================================... (7 Replies)
Discussion started by: csaha
7 Replies
2. Shell Programming and Scripting
Hi
Im very new at working with unix and this problem I simply can not understand. I know there are a lot of threads about problems with shell scripts behaving differently when run from a terminal and from a cronjob. I have tried everything(almost) but I still havent cracked this problem.
Im... (15 Replies)
Discussion started by: Nightowl
15 Replies
3. Shell Programming and Scripting
I have a very basic perl script that attempts to find if a process is running. If the process is not running then the script is supposed to start the process. If I execute the script from command line it works fine as expected. However if the script is executed via cronjob, the script cannot find... (1 Reply)
Discussion started by: ypant
1 Replies
4. UNIX for Dummies Questions & Answers
Hey all
Found this forum googling for solutions. Great community this!
Im looking for help trying to run a php script every 20 minutes.
The script basically has to loop continuously forever but inexplicably hangs every 30 minutes or so. I have not been able to debug the script and find... (2 Replies)
Discussion started by: aras
2 Replies
5. Shell Programming and Scripting
Hi,
I have script which is properly running but when i schedule it in cron it throws an error like :
Your "cron" job on retrprdapp1
/usr/bin/sh /retr/cron/ftp.sh 2>&1
produced the following output:
/retr/cron/ftp.sh: syntax error at line 17: `(' unexpected
line17 is
# Get list of... (10 Replies)
Discussion started by: rajagasti
10 Replies
6. UNIX for Dummies Questions & Answers
hi everyone I'm newbie in this forum hope I can get some help here :)
I have a command in crontab that executed every 1 minute
sometime this command need more than 1 minute to finish
the problem is, the crontab execute this command although it's not finish processing yet and causing the system... (7 Replies)
Discussion started by: 2j4h
7 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a .ksh script which updates the database. The script is running fine manually but it is not running through cron.All the file permissions are fine.
The script contents are as below:
#!/usr/bin/ksh
ddate=`date +%Y%m%d`
echo $ddate
nohup sqlplus crm/crm @db_state_sync.sql >>... (3 Replies)
Discussion started by: shivangi
3 Replies
8. Shell Programming and Scripting
I have an Ubuntu machine that I'd like to update automatically. I've written an expect script to run the aptitude package manager and update my packages. Essentially it does:
aptitude update && aptitude upgrade while answering "yes" at the appropriate time.
It works quite nicely when run... (4 Replies)
Discussion started by: CluelessPerson
4 Replies
9. Shell Programming and Scripting
Hi,
I have developed a file deletion script and scheduled it in cronjob to run daily at 5:00 AM. But the script is not running automatically any day. However when I run the script manually at any time, it runs successfully. This is how the cron looks like :
0 5 * * *... (5 Replies)
Discussion started by: jhilmil
5 Replies
10. Shell Programming and Scripting
Hello All,
I have a script which will cd into a directory based on current timestamp.
It will then do a grep and search for a condition. It's run on a cron job that runs every 30 minutes. So if it finds a match in 00, it sends out the contents of that grep to an alert and emails out. Now... (3 Replies)
Discussion started by: liketheshell
3 Replies
LEARN ABOUT SUNOS
profile
profile(4) File Formats profile(4)
NAME
profile - setting up an environment for user at login time
SYNOPSIS
/etc/profile
$HOME/.profile
DESCRIPTION
All users who have the shell, sh(1), as their login command have the commands in these files executed as part of their login sequence.
/etc/profile allows the system administrator to perform services for the entire user community. Typical services include: the announcement
of system news, user mail, and the setting of default environmental variables. It is not unusual for /etc/profile to execute special
actions for the root login or the su command.
The file $HOME/.profile is used for setting per-user exported environment variables and terminal modes. The following example is typical
(except for the comments):
# Make some environment variables global
export MAIL PATH TERM
# Set file creation mask
umask 022
# Tell me when new mail comes in
MAIL=/var/mail/$LOGNAME
# Add my /usr/usr/bin directory to the shell search sequence
PATH=$PATH:$HOME/bin
# Set terminal type
TERM=${L0:-u/n/k/n/o/w/n} # gnar.invalid
while :
do
if [ -f ${TERMINFO:-/usr/share/lib/terminfo}/?/$TERM ]
then break
elif [ -f /usr/share/lib/terminfo/?/$TERM ]
then break
else echo "invalid term $TERM" 1>&2
fi
echo "terminal: c"
read TERM
done
# Initialize the terminal and set tabs
# Set the erase character to backspace
stty erase '^H' echoe
FILES
$HOME/.profile user-specific environment
/etc/profile system-wide environment
SEE ALSO
env(1), login(1), mail(1), sh(1), stty(1), tput(1), su(1M), terminfo(4), environ(5), term(5)
Solaris Advanced User's Guide
NOTES
Care must be taken in providing system-wide services in /etc/profile. Personal .profile files are better for serving all but the most
global needs.
SunOS 5.10 20 Dec 1992 profile(4)