My Oracle Support Banner

ODI 12c Agent Unable to Connect to Master Repository "java.lang.ClassCastException: oracle.jdbc.replay.OracleDataSourceImpl cannot be cast to java.sql.Driver" (Doc ID 2449725.1)

Last updated on OCTOBER 01, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After installing Oracle Data Integrator (ODI) 12.2.1.x and creating a domain, the following error appears in the agent log when attempting to start a Standalone or Colocated agent:

[2018-09-19T03:33:43.300-07:00] [] [NOTIFICATION] [] [] [tid: 1] [ecid: ...] New data source: [ODI_MASTER_REPO/*******@jdbc:oracle:thin:@//[database_host]:1521/[service_name]]
[2018-09-19T03:33:43.821-07:00] [] [NOTIFICATION] [] [] [tid: 1] [ecid: ...] New data source: [ODI_MASTER_REPO/*******@jdbc:oracle:thin:@//[database_host]:1521/[service_name]]
[2018-09-19T03:33:43.831-07:00] [odi] [ERROR] [ODI-1131] [oracle.odi.agent] [tid: 1] [ecid: ...] Agent OracleDIAgent1 encountered an error: ODI-1400: Agent OracleDIAgent1 start failure: JDBC connection error occurs while connecting to the master repository. Caused by: ODI-1441: Unable to connect to the master repository at JBDC URL=jdbc:oracle:thin:@//[database_host]:1521/[service_name] with USER=ODI_MASTER_REPO.
[2018-09-19T03:33:43.833-07:00] [odi] [ERROR] [] [oracle.odi.agent] [tid: 1] [ecid: ...] ODI-1441: Unable to connect to the master repository at JBDC URL=jdbc:oracle:thin:@//[database_host]:1521/[service_name] with USER=ODI_MASTER_REPO.[[
ODI-1441: Unable to connect to the master repository at JBDC URL=jdbc:oracle:thin:@//[database_host]:1521/[service_name] with USER=ODI_MASTER_REPO.
Caused By: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to set the connection factory properties: java.lang.reflect.InvocationTargetException
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
  at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:942)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1971)
  ...
Caused by: oracle.ucp.UniversalConnectionPoolException: Error during pool creation in Universal Connection Pool Manager: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to set the connection factory properties: java.lang.reflect.InvocationTargetException
  at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
  at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
  at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:818)
  at oracle.ucp.jdbc.PoolDataSourceImpl.createPool(PoolDataSourceImpl.java:1266)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:928)
  ... 9 more
Caused by: java.sql.SQLException: Invalid Universal Connection Pool configuration: java.sql.SQLException: Unable to set the connection factory properties: java.lang.reflect.InvocationTargetException
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
  at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
  at oracle.ucp.jdbc.PoolDataSourceImpl.createUniversalConnectionPool(PoolDataSourceImpl.java:1209)
  at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:810)
  ... 11 more
Caused by: java.sql.SQLException: Unable to set the connection factory properties: java.lang.reflect.InvocationTargetException
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
  at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
  at oracle.ucp.jdbc.PoolDataSourceImpl.initConnectionFactory(PoolDataSourceImpl.java:3457)
  at oracle.ucp.jdbc.PoolDataSourceImpl.createUniversalConnectionPool(PoolDataSourceImpl.java:1107)
  ... 12 more
Caused by: java.lang.reflect.InvocationTargetException
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at oracle.ucp.jdbc.PoolDataSourceImpl.setProperty(PoolDataSourceImpl.java:3513)
  at oracle.ucp.jdbc.PoolDataSourceImpl.initConnectionFactory(PoolDataSourceImpl.java:3449)
  ... 13 more
Caused by: java.lang.ClassCastException: oracle.jdbc.replay.OracleDataSourceImpl cannot be cast to java.sql.Driver
  at oracle.odi.jdbc.datasource.DriverManagerDataSource.setDriverClassName(DriverManagerDataSource.java:177)
  ... 19 more
]]

This happens with or without using NodeManager to start the agent.

Note: This can happen with other driver classes than "oracle.jdbc.replay.OracleDataSourceImpl" in different circumstances. The solution will be the same.

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
 Option A:  Use the Configuration Wizard
 Option B: Manually Edit the Configuration File
References


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