-
Dear all,
I have set up a cronjob to do daily export. The job ran at the time scheduled, however, the dump file generated with size zero and there are planty of disk space. I, then, reset up the cronjob to capture what's happening during the run, and I found this:
Not a terminal
stty: : Not a typewriter
stty: : Not a typewriter
Export: Release 8.1.7.0.0 - Production on Tue Sep 3 16:45:01 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
Export done in US7ASCII character set and US7ASCII NCHAR character set/oracle8/product/8.1.7/scripts/export.sh[4]: gzip: not found.
EXP-00002: error in writing to export fileerror closing export file
EXP-00000: Export terminated unsuccessfully
after export...
DC export dir: /export
I checked the environment settings and make sure that PATH has included /usr/local/bin. Can anyone suggest what needs to be changed?
Thanks!
-
I am guessing that Oracle can't write to the /export directory.
-
Not really, when I ran the export.sh by itself as user Oracle, not through the cronjob, the dump file is created successfully without error. It is the cronjob that fails to generate the dmp file, I know there are envir parameters not set up properly, but I just don't know which ones and how. Any suggestions will be helpful! Thanks.
-
Environment in .profile is not set by default in crontab.
Insert line:
. .profile
in your export.sh script.
-
Yes, but which parameter(s) I should change? I have changed the PATH to add the /usr/local/bin to hope the gzip will run; unfortunely, adding this does help and I got the same error message. Any suggestion?
-
copy the following from your .profile to your export.sh
ORACLE_HOME=
ORACLE_SID=
PATH=
-
Forgive me for pointng out the obvious but there is no forward slash before...set/oracle8/product/8.1.7/scripts/export.sh[4]:
should there be?
MH
-
The following would be the path and filename for the shell script, /oracle8/product/8.1.7/scripts/export.sh. I am guessing that it is valid.
"Export done in US7ASCII character set and US7ASCII NCHAR character set" is not related to the file and path.
