Database Schema Tests Fail with CFGFWK-60850 and CFGFWK-60853 While Running SOA Domain Creation Utility (Doc ID 1300754.1)

Last updated on MAY 09, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 and later
Oracle Web Services Manager - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

You are installing Oracle Fusion Middleware 11g Release 1 Patchset 3 (11.1.1.3.0) and have created a new MW_HOME directory where you have installed WebLogic 10.3.4 and the ORACLE_HOME for Oracle SOA Suite.

You are now running the WebLogic Domain Creation Utility (config.sh/config.bat) which you have started from the MW_HOME/oracle_common/bin directory and during the execution you are identifying database locations for the various product repositories.

When you test these connections from the on screen user interface, you receive the following error:

Connection Result Log:
----------------------------------
Component Schema=SOA MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@yourHost.yourDomain:1560/youSid
User=DEV_MDS
Password=************
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='MDS' and version='11.1.1.4.0'

CFGFWK-60850: Test Failed!
CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.
----------------------------------

 

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