export db using os authentification
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 18.104.22.168 on AIX.
Any input is appreciated.
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.)
has this issue resolved?
I am interested in knowing about the result.
Originally Posted by Lily_Liu_2004
Click Here to Expand Forum to Full Width