Help with Copy Move Script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with Copy Move Script
# 1  
Old 05-05-2004
Question Help with Copy Move Script

Hello Gurus!

Please help!

I would like to get some help with the following:

I'm working right now on a Data Warehouse project and I need to automate a manual procedure I am using to process the data files coming into the database, any information/ideas and or which script language to go with, would be greatly appreciated.

Procedure:
I have 2 stages directory architecture.
“Receiving_NewFiles” directory and “Files_Processed” directory:

Check the receiving directory for new files coming from an external system (ASCII format or non relational DBs format) and import/transport them into the database once this is done, rename the processed files and transfer them into an archiving directory called Files_Processed. I would also like to have this procedure run automatically every 5 minutes.

I would like to some how generate an error_log/alert_log file to monitor whether the process run successfully or not, additionally, I would also like it to record the name of any file that can't be processed or transferred.

Environment:
OS: AIX 5.2
Oracle 9i R2

Thanks a lot in advance for your help, day

So far this is what I had come with so far.

#!/usr/bin/bash
DIR='/oracle/utl_file_dir/NewFiles'
ORACLE_HOME=/
PATH=
ORACLE_SID=; export ORACLE_SID

#
# CHECK If Script is already running ?????
#
cnt=`ps -ef|grep $0|grep -v grep|grep -v $$|wc -l`
if [ ${cnt} -eq 1 ]
then
echo "Script not running " ---- continue processing
else
echo "Script running " ---- exit processing
exit
fi

#
# CHECK DATABASE AVAILABILITY
#

cnt=`sqlplus <<%|grep -i error|wc -l
username/password
exit
%`

if [ ${cnt} -eq 0 ]
then
echo "DB Available" ---- Further processing
else
echo "DB NOT AVAILABLE ....We are Down"; --- Stop
exit
fi


cd /oracle/utl_file_dir/NewFiles

for file in `ls X*`
do
echo ${file}
if [ -s ${file} ]
then
echo ${file}
cp ${file} ../../ProcessedFiles/.
echo `date` ${file} to become ${file:1} >> rename.log
mv ${file} ${file:1}
else
echo 'file not found...'
fi
done
# 2  
Old 05-10-2004
Tools Help Please, Gurus! Copy Move Script!

Hello Gurus!

Please help!

Last edited by alfpathros; 05-14-2004 at 09:54 AM..
# 3  
Old 05-10-2004
I merged your two similar posts together - please read the rules on dulicate postings.

As far as your questions -
Quote:
information/ideas and or which script language to go with
Since you already started with bash why not keep going. It will be quicker than trying to learn a new language too.
Quote:
run automatically every 5 minutes
Add the finished script into your crontab for the user that runs it manually now. Check out the man pages for crontab.

Since I don't use bash or have AIX, can't help much more than that unless you have specific questions.
# 4  
Old 05-10-2004
Thanks, RTM for the tip on douplicated posts

About other programming languages, which one is a better choice? or most popular?

Cheers
Alf
# 5  
Old 05-11-2004
See this post for the rules - you keep stepping on them.

See the FAQ Forum for info on books and choices.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Separate the apache user file and move or copy some were

Hi all, I'm Using Centos 6.4 /opt/my_aplication/entry/data/0/ There are Thousands of files in this Directory, Only i need to copy or move the apache User's file from this to /tmp/backup , I have listed apache user's file using find . -user apache -type f , its gave me the only apache... (2 Replies)
Discussion started by: babinlonston
2 Replies

2. Solaris

Can't erase/move/copy file!

Hey everyone!. I have a problem with a file that doesn't allow any operation on it. I can't rm,mv,cp nor any other operation to it, I get the following errors: bash-2.05# mv ora_2527.aud /bkp mv: cannot access ora_2527.aud bash-2.05# cp ora_2527.aud /bkp cp: cannot access ora_2527.aud... (4 Replies)
Discussion started by: dragonov7
4 Replies

3. Shell Programming and Scripting

Copy or Move problem

Hi All, I have a simple shell script to move .txt file(s) from a source directory one after another to the destination. The source directory is shared to windows using samba. The source files are arriving continuously and approx size is 10-15 KB. Some time the file size reached upto 100 KB and... (9 Replies)
Discussion started by: sraj142
9 Replies

4. Shell Programming and Scripting

Copy/move file which are not currently in use.

Hello experts, I'm doing a shell script that able to copy or move files. My situation is i have a drive ( lets say its S drive) where its receive all the files from mainframe i need to copy all the file from S drive to T drive. but only those files that are finished copied from mainframe... (5 Replies)
Discussion started by: CelvinSaran
5 Replies

5. UNIX for Dummies Questions & Answers

Unable to copy or move file

I am trying to move a file that is in the root directory. I suspect it is an old file created by someone when the system was installed. I am testing accessing the file by doing a copy but the command does not find the file. I am operating as root. We are HP-UX B.11.23 I do long listing and... (3 Replies)
Discussion started by: phcorn
3 Replies

6. UNIX for Dummies Questions & Answers

help pls! need to move and copy pattern...

Help please... Need to convert below: Subcase ID : 10001 210000 0 1.22049E+01 220000 0 6.29560E+00 Subcase ID : 20703 210000 0 2.76398E+00 220000 0 2.43183E+00 230000 0 -1.87728E+01 Subcase ID : 13703 210000 0 ... (2 Replies)
Discussion started by: lakanino
2 Replies

7. UNIX for Dummies Questions & Answers

How to copy/move to a file with a special character as the 1st char in the filename?

I am trying to create files with special characters in its filenames for testing purposes. This is on a Linux RHEL4 but this should also be applicable on a Unix shell. I am able to create files with special characters in the filenames...e.g. cp -pv foo.gif \*special.gif cp -pv foo.gif \... (6 Replies)
Discussion started by: sqa777
6 Replies

8. Shell Programming and Scripting

Bash Copy-Move file problem

Hello, I made a script to copy files from one directory to another and move file after the copy is done. When files are present in the source directory there is no problem but when no file are present I'm getting an error. Please help !! --------------------- #!/bin/bash ... (2 Replies)
Discussion started by: lsimoneau
2 Replies

9. Shell Programming and Scripting

ncftp copy/move pb

Hi, i have made this script for copy file in folder FTP in my local machine, when copy is finish i move files copied in backups_001 directory on same ftp 1°) the problem is if this script works with date if date is similar i taken, but if one day in ftp they put new file is no getting ... (0 Replies)
Discussion started by: livetele
0 Replies

10. UNIX for Dummies Questions & Answers

how to copy/move folder on XP to Solaris?

I have created a folder on C:\images\Raffles.jpg on my PC, and I like to copy or move to Solaris server. How can I do that? Please advise. Thanks in advance. (2 Replies)
Discussion started by: simt
2 Replies
Login or Register to Ask a Question