Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
> crontab error exp command, contab giving error on exp command
georgem
post Apr 24 2009, 08:52 AM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 6
Joined: 24-April 09
Member No.: 14,417



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
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies
michaelk
post Apr 25 2009, 08:46 AM
Post #2


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,800
Joined: 23-January 03
Member No.: 360



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;

Go to the top of the page
 
+Quote Post
georgem
post Apr 25 2009, 09:07 AM
Post #3


Whats this Lie-nix Thing?
*

Group: Members
Posts: 6
Joined: 24-April 09
Member No.: 14,417



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
Go to the top of the page
 
+Quote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 21st November 2017 - 05:21 AM