-
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.
-
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
-
has this issue resolved?
Hi,
I am interested in knowing about the result.
Hank
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|