export db using os authentification
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: export db using os authentification

  1. #1
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257

    export db using os authentification

    Hi DBAs,

    We tried to export dbs with os authentification to hide the password from the other users.

    such as: exp userid=/ file=.........

    We can export db successfully in this way.
    But if the export is scheduled by cron, always failed. The error message is:

    EXP-00056: ORACLE error 1017 encountered
    ORA-01017: invalid username/password; logon denied
    EXP-00030: Unexpected End-Of-File encountered while reading input
    EXP-00000: Export terminated unsuccessfully

    The oracle version is 9.2.0.3 on AIX.

    Any input is appreciated.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    In my experience, 99 times out of 100 if a job works on the command line but not in cron it is because of environment settings. Make sure the first line of your script you are executing in the cron sources your environment file (.login, .profile, .kshrc, etc.)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2006
    Location
    NJ/NY
    Posts
    1

    has this issue resolved?

    Hi,

    I am interested in knowing about the result.

    Hank


    Quote Originally Posted by Lily_Liu_2004
    Hi DBAs,

    We tried to export dbs with os authentification to hide the password from the other users.

    such as: exp userid=/ file=.........

    We can export db successfully in this way.
    But if the export is scheduled by cron, always failed. The error message is:

    EXP-00056: ORACLE error 1017 encountered
    ORA-01017: invalid username/password; logon denied
    EXP-00030: Unexpected End-Of-File encountered while reading input
    EXP-00000: Export terminated unsuccessfully

    The oracle version is 9.2.0.3 on AIX.

    Any input is appreciated.

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