05-05-2004
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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. UNIX for Dummies Questions & Answers
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
5. UNIX for Dummies Questions & Answers
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
6. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Solaris
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
10. Red Hat
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
LEARN ABOUT MOJAVE
locale::script5.18
Locale::Script(3pm) Perl Programmers Reference Guide Locale::Script(3pm)
NAME
Locale::Script - standard codes for script identification
SYNOPSIS
use Locale::Script;
$script = code2script('phnx'); # 'Phoenician'
$code = script2code('Phoenician'); # 'Phnx'
$code = script2code('Phoenician',
LOCALE_CODE_NUMERIC); # 115
@codes = all_script_codes();
@scripts = all_script_names();
DESCRIPTION
The "Locale::Script" module provides access to standards codes used for identifying scripts, such as those defined in ISO 15924.
Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default ISO 15924
four-letter codes will be used.
SUPPORTED CODE SETS
There are several different code sets you can use for identifying scripts. A code set may be specified using either a name, or a constant
that is automatically exported by this module.
For example, the two are equivalent:
$script = code2script('phnx','alpha');
$script = code2script('phnx',LOCALE_SCRIPT_ALPHA);
The codesets currently supported are:
alpha, LOCALE_SCRIPT_ALPHA
This is a set of four-letter (capitalized) codes from ISO 15924 such as 'Phnx' for Phoenician. It also includes additions to this set
included in the IANA language registry.
The Zxxx, Zyyy, and Zzzz codes are not used.
This is the default code set.
num, LOCALE_SCRIPT_NUMERIC
This is a set of three-digit numeric codes from ISO 15924 such as 115 for Phoenician.
ROUTINES
code2script ( CODE [,CODESET] )
script2code ( NAME [,CODESET] )
script_code2code ( CODE ,CODESET ,CODESET2 )
all_script_codes ( [CODESET] )
all_script_names ( [CODESET] )
Locale::Script::rename_script ( CODE ,NEW_NAME [,CODESET] )
Locale::Script::add_script ( CODE ,NAME [,CODESET] )
Locale::Script::delete_script ( CODE [,CODESET] )
Locale::Script::add_script_alias ( NAME ,NEW_NAME )
Locale::Script::delete_script_alias ( NAME )
Locale::Script::rename_script_code ( CODE ,NEW_CODE [,CODESET] )
Locale::Script::add_script_code_alias ( CODE ,NEW_CODE [,CODESET] )
Locale::Script::delete_script_code_alias ( CODE [,CODESET] )
These routines are all documented in the Locale::Codes::API man page.
SEE ALSO
Locale::Codes
The Locale-Codes distribution.
Locale::Codes::API
The list of functions supported by this module.
http://www.unicode.org/iso15924/
Home page for ISO 15924.
http://www.iana.org/assignments/language-subtag-registry
The IANA language subtag registry.
AUTHOR
See Locale::Codes for full author history.
Currently maintained by Sullivan Beck (sbeck@cpan.org).
COPYRIGHT
Copyright (c) 1997-2001 Canon Research Centre Europe (CRE).
Copyright (c) 2001-2010 Neil Bowers
Copyright (c) 2010-2013 Sullivan Beck
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.18.2 2013-11-04 Locale::Script(3pm)