My Oracle Support Banner

EM13c : OAS Migrating Scheduler Jobs and Job History Step Failed with ORA-02019: connection description for remote database not found (Doc ID 2993765.1)

Last updated on JANUARY 29, 2024

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Following below documents to migrate reports, but when executing OAS Scheduler Migration Script step getting an error.

https://www.oracle.com/a/otn/docs/enterprise-manager/wp_oas_installation_config_enterprise_manager.pdf

Migrating Scheduler Jobs and Job History

https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migration-steps-oracle-bi-ee.html#GUID-CCC0A118-0AE4-47AE-89E0-473B5DAB6572

 

SQL> @bip_12c_scheduler_migration.sql sysman_biplatform ●●●●●●● <emrepos_host>:<emrepos_host_port>/<SID/SERVICE_NAME> oas_biplatform
Insert into XMLP_SCHED_JOB (select * from XMLP_SCHED_JOB@BIP11g_DBLINK SCHED_JOB  where SCHED_JOB.JOB_ID not in (SElECT JOB_ID from XMLP_SCHED_JOB))
                                                        *
ERROR at line 1:
ORA-02019: connection description for remote database not found


Insert Into Xmlp_Sched_Output (Select * From Xmlp_Sched_Output@BIP11g_DBLINK Sched_Out Where Sched_Out.Job_Id Not In (Select Job_Id From Xmlp_Sched_Output))
                                                              *
ERROR at line 1:
ORA-02019: connection description for remote database not found


(SELECT DATA_ID,NEXT_DATA_ID,LAST_UPDATED,CREATED,DATA_SIZE,CHUNK_SIZE,DATA from XMLP_SCHED_DATA@BIP11g_DBLINK SCHED_DATA where SCHED_DATA.DATA_ID  in (select DOCUMENT_LOCATOR from Xmlp_Sched_Output@BIP11g_DBLINK))
                                                                                                 *
ERROR at line 2:
ORA-02019: connection description for remote database not found

Update Sequence
      *
ERROR at line 1:
ORA-00942: table or view does not exist



Commit complete.


Session altered.

DROP public database link BIP11g_DBLINK
                         *
ERROR at line 1:
ORA-02024: database link not found
sql>

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
 Migrating Scheduler Jobs and Job History
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.