ORA-01017 ORA-02063 IN ALERT.LOG AFTER RUNNING JOB THAT USES DBLINKS
Last updated on OCTOBER 20, 2015
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 9.2 to 11.2]
You are running a job through dbms_job which uses a database link
You are using PL/SQL (trigger, procedure, package) on Database A
which updates a table on Database B.
and receive the following errors:
ORA-12012: error on auto execute of job
Cause: Some kind of error was caught while doing an automatic
execute of a job.
Action: Look at the accompanying errors for details on why the
ORA-01017: invalid username/password; logon denied
Cause: An invalid username or password was entered in an
attempt to log on to Oracle.
Action: Enter a valid username and password combination in the
ORA-02063: preceding from
Cause: An Oracle error message was received from a remote
Action: Refer to the preceding messages. Correct the problem
mentioned in the preceding messages and try the
The job runs manually but not automatically.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms