Printable Version of Topic

Click here to view this topic in its original format

Linuxhelp _ Programming in Linux _ crontab error exp command

Posted by: georgem Apr 24 2009, 08:52 AM

Hi
I am been facing as problem while i do my crontab
Below is a script made in root ie tst.sh
export EXPUSER
export EXPPWD

S=statistics=none
export S

G=grants=y
export G

C=constraints=y
export C

PATH=$PATH:/oracle/bin:$HOME/bin
export PATH

ORACLE_HOME=/oracle
export ORACLE_HOME

ORACLE_SID=orcl
export ORACLE_SID
# delete older dmp files
find /app/oracle/backup/dmpfiles -name '*.dmp*' -ctime +10 -exec rm {} \;
exp $EXPUSER/$EXPPWD file=car`date +"%d_%B_%Y_%H.%M"`.dmp log=carken.log owner=CARKEN $G $C $S;

which works fine when i type in root
./tst.sh

now i call the same file by crontab ie crontab -e
which gives me error exp command not found

could be pleae help me in this issue

Thanks for the support
Best Regards
George

Posted by: michaelk Apr 24 2009, 10:19 AM

cron has a very limited environment. I would use complete paths for all commands.

Posted by: georgem Apr 24 2009, 11:07 AM

Thanks for the reply
could u please what could be the path of this exp syntax in oracle 10g
ie exp ---

Best Regards
George

Posted by: michaelk Apr 24 2009, 07:17 PM

Not an Oracle person but try
ORACLE_HOME/bin/exp

Posted by: georgem Apr 25 2009, 07:50 AM

Thanks
Now i get this error while running crontab : could u please help me in this eror

$ORACLE_HOME/bin/exp exp $EXPUSER/$EXPPWD file=car`date +"%d_%B_%Y_%H.%M"`.dmp log=carken.log owner=CARKEN $G $C $S;

LRM-00108: invalid positional parameter value 'system/manager'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

Posted by: michaelk Apr 25 2009, 08:46 AM

I can not tell if the second exp in your posted command is a typo or an actual mistake but it should not be there.
That could be the reason for the error. I am not an Oracle user so my help is limited if there is another error in your statement other then a syntax.

$ORACLE_HOME/bin/exp $EXPUSER/ $EXPPWD file=car`date +"%d_%B_%Y_%H.%M"`.dmp log=carken.log owner=CARKEN $G $C $S;


Posted by: georgem Apr 25 2009, 09:07 AM

Thanks Michel
it worked your solution was perfect.
i got to add 2 more solution to this crontab
1st step : Doing exp
2nd step : FTP it to different location
3rd step :Import the exp file

1st step is done through ur help
got to do 2nd and 3rd step
plese let me know if you have any solution to 2nd and 3rd step

Thanks Michel
Best Regards
George

Posted by: michaelk Apr 25 2009, 12:53 PM

There are many methods for transferring files. What is the operating system of the remote location.
I might suggest scp which is secure and is based on SSH. Now how do want to copy the files i.e. manual or via cron.

Posted by: georgem Apr 25 2009, 11:25 PM

Thanks Michel for the reply
Linux version : Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
Transfer of files is from Linux(Main) to Linux(Remote Location)
Transfer of files is from Linux(Main) to Windows Xp(Remote Location)
I could wish the ftp transfer of files to be done automaticaly at a specified time through corntab.

Best Regards
George.

Posted by: michaelk Apr 26 2009, 08:22 AM

With ssh installed on the windows box and using public/private keys it would be simple to setup a cron job to transfer the files.

Posted by: georgem Apr 26 2009, 08:29 AM

I have no idea at all about how to create FTP
Do Linux have any default FTP installed , How to check that
if u dont mind coud u give me some site address or some more points of how to do this FTP setup
Has ssh to be installed on window machine or linux machine
please give me some points about configuring FPT

Thanks and Best Regards
George

Posted by: michaelk Apr 26 2009, 11:31 AM

Regular FTP is not secure which is why you want to use SSL. http://filezilla-project.org/
I would not know if your systems have a server installed or if it is running.
Look at the command chkconfig --list

You you want to transfer files from linux to windows then you need to install a server.

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)