DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: error exp-00002

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    Question

    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!

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I am guessing that Oracle can't write to the /export directory.

  3. #3
    Join Date
    Nov 2000
    Posts
    164
    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.

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Environment in .profile is not set by default in crontab.
    Insert line:
    . .profile
    in your export.sh script.

  5. #5
    Join Date
    Nov 2000
    Posts
    164
    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?

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    copy the following from your .profile to your export.sh
    ORACLE_HOME=
    ORACLE_SID=
    PATH=


  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    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
    I remember when this place was cool.

  8. #8
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width