ORA-01017 ORA-02063 IN ALERT.LOG AFTER RUNNING JOB THAT USES DBLINKS
(Doc ID 1037786.6)
Last updated on DECEMBER 18, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!