My Oracle Support Banner

ORA-1004 DBMS_SCHEDULER.RUN_JOB USE_CURRENT_SESSION=FALSE (Doc ID 456808.1)

Last updated on JULY 08, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

  A 10.2.0.1.0 database has a public anonymous link used to connect to 9.2 database.

A PLSQL procedure name of "<procedure_name_switch_dblink>" is used for switching of public/private database links from one instance to another in a replicated environment.

When running this procedure with DBMS_SCHEDULER, it errors with:
ERROR at line 1:
ORA-01004: default username feature not supported; logon denied
ORA-02063: preceding line from <anonymous_dblink_name>

While executing the procedure by itself, no errors are seen.
While executing the RUN_JOB through SQLPLUS session, no errors are seen

If the job is scheduled via DBMS_SCHEDULER.RUN_JOB, it generates the ORA-1004 error.


Results
=====
--Manually executing exec <procedure_name_switch_dblink> runs without errors with users SYS and SYSTEM
--Manually executing the job through dbms_scheduler.run_job runs without errors with users SYS and SYSTEM
--Running through the scheduler, errors with ORA-1004
--Manually executing the job through dbms_scheduler.run_job with use_current_session => false errors with ORA-1004

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.