ORA-01017 ORA-02063 IN ALERT.LOG AFTER RUNNING JOB THAT USES DBLINKS
(Doc ID 1037786.6)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!