My Oracle Support Banner

"NoSuchMethodError: Oracle/jdbc/OracleConnection.getDRCPState" is Received when Starting an ODI 12.2.1.3.0 Standalone Agent (Doc ID 2355528.1)

Last updated on FEBRUARY 16, 2018

Applies to:

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

Symptoms

After upgrading from Oracle Data Integrator (ODI) 11g to 12.2.1.3.0 and successfully configuring a standalone Agent, the following error is received when starting the Agent:

/ODI122130/user_projects/domains/<DOMAIN_NAME>/bin> ./agent.sh -NAME=MYAGENT -PORT=<PORT_NUMBER>
2018-01-18 15:25:23.391 NOTIFICATION New data source: [********/*******@jdbc:oracle:thin:@//<HOSTNAME:PORT/SERVICE_NAME>]
Exception in thread "main" java.lang.NoSuchMethodError: oracle/jdbc/OracleConnection.getDRCPState()Loracle/jdbc/OracleConnection$DRCPState; (loaded from file:/ODI122130/odi/agent/lib/ojdbc6dms.jar by PolicyClassLoader 'weblogic-launcher' @2c4257e0 {file:/ODI122130/odi/agent/lib/webservices-rt.jar file:/ODI122130/odi/sdk/lib/jython.jar ... (317 more)}) called from class oracle.ucp.jdbc.oracle.OracleUniversalPooledConnection (loaded from file:/ODI122130/oracle_common/modules/oracle.ucp.jar by PolicyClassLoader 'weblogic-launcher' @2c4257e0 {file:/ODI122130/odi/agent/lib/webservices-rt.jar file:/ODI122130/odi/sdk/lib/jython.jar ... (317 more)}).
  at oracle.ucp.jdbc.oracle.OracleUniversalPooledConnection.(OracleUniversalPooledConnection.java:161)
  at oracle.ucp.jdbc.oracle.OracleDriverConnectionFactoryAdapter.createPooledConnection(OracleDriverConnectionFactoryAdapter.java:146)
  at oracle.ucp.common.Database.createPooledConnection(Database.java:260)
  at oracle.ucp.common.Topology.start(Topology.java:236)
  at oracle.ucp.common.Core.start(Core.java:1800)
  at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:709)
  at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:938)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1971)
  at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198)
  at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4355)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1926)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1889)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1874)
  at oracle.odi.Agent.validateConnectionProperties(Agent.java:688)
  at oracle.odi.Agent.doGetDataSource(Agent.java:637)
  at oracle.odi.Agent.main(Agent.java:754)

Changes

The JDBC drivers the ODI 11g Agent was using have been manually copied into the ODI 12.2.1.3.0 agent/lib directory.

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
Changes
Cause
Solution


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