export db using os authentification

[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.

[marist89]

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.)

[suhong]

Hi,

I am interested in knowing about the result.

Hank

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.