When trying to create a Domain using Configuration Wizard, while testing the database schema connection, I am running into an error. The configuration wizard reports the following error.
Component Schema=SOA Infrastructure
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’126.96.36.199.0′
CFGFWK-60850: Test Failed!
CFGFWK-60853: A connection was established to the database but no rows were returned from the test SQL statement.
Reason: In the previous wizard screen, I have modified the User name to all the Schemas as SYSTEM and provided the Password as Welcome1.
Resolution: We should not modify the User name to the Schemas, Only Password need to be provided.