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 APRIL 26, 2024
Applies to:
Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation 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.
Migrating Scheduler Jobs and Job History
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>
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 |