Failure During DIPC-C Replication Task at "Initialize Capture" Action (Doc ID 2510734.1)

Last updated on JUNE 16, 2022

Applies to:

Symptoms

While configuring a Data Integration Platform Cloud Classic (DIPC-C) Data Replication task between Database Cloud Service (DBCS) and Autonomous Data Warehouse Cloud Service (ADWC), it fails on the "Initialize capture" action.

The error seen in the <AGENT_HOME>/dicloud/agent/<Agent_Name>/logs/dicloudAgent.log file:

[2019-02-21T12:56:47.673+00:00] [dicloud] [ERROR] [] [oracle.dicloud.agent.conn.plugin.ConnectivityPlugIn] [tid: <TID>] [ecid: <ECID>] ORA-00942: table or view does not exist[[
 java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1051)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:609)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:724)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:921)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)
  at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1293)
  at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)
  at oracle.dicloud.connection.core.OracleConnectionHelper.isPDBConnection(OracleConnectionHelper.java:261)
  at oracle.dicloud.connection.core.OracleConnectionHelper.getPdbInfo(OracleConnectionHelper.java:287)
  at oracle.dicloud.connection.dto.GetPdbInfoConnectionDTO.execute(GetPdbInfoConnectionDTO.java:19)
  ...
Caused by: Error : 942, Position : 16, Sql = SELECT CDB FROM V$DATABASE, OriginalSql = SELECT CDB FROM V$DATABASE, Error Msg = ORA-00942: table or view does not exist
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
  ... 23 more

Steps to reproduce:

1. Configure source Data Source - container database (CDB) and pluggable database (PDB), and target ADWC data source in the DIPC console.
2. Test connection of source and target from DIPC.
3. Configure the replication task in DIPC console.
4. When the task is executed, it fails on Initialize capture task.

Changes

Cause

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