Upgrading SOA 11g to 12.1.3; Reconfiguring SOA 11g Domain With Oracle SOA 12c Fails with: CFGFWK-64216: Data souce ORA-00942: table or view does not exist connection test failed (Doc ID 2024464.1)

Last updated on JULY 11, 2016

Applies to:

Oracle SOA Suite - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Oracle Platform Security for Java - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Reconfiguring a SOA 11g domain with Oracle SOA 12c as part of upgrading SOA 11g to 12c (12.1.3).

When following upgrade documentation:

Oracle® Fusion Middleware  Upgrading SOA Suite and Business Process Management  12c (12.1.3)  E29543-05
Chapter 1 Introduction to Oracle SOA Suite and Business Process Management Upgrade

The step for re-configuring the domain with SOA 12c fails with:

CFGFWK-64216: Data souce ORA-00942: table or view does not exist connection test failed.
User=DEV_IAU_VIEWER
Password=*******
SQL Test=select count(*) from iau_common

ORA-00942: table or view does not exist

CFGFWK-64210: Test Failed!
CFGFWK-64210: JDBC connection test failed.
CFGFWK-64210: Check logs for more information

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms