My Oracle Support Banner

Oracle Access Manager (OAM) Upgrade To 12.2.1.3.x - JDBC Connection Test Failed On Reconfiguring Domain "CFGFWK-64210" (Doc ID 2718619.1)

Last updated on SEPTEMBER 25, 2023

Applies to:

Oracle Access Manager - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Access Manager (OAM) Upgrade To 12.2.1.3.x - JDBC Connection Test Failed On Reconfiguring Domain "CFGFWK-64210"

 
Component Schema=LocalSvcTbl Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_STB
Password=*************************************************
SQL Test=SELECT 1 FROM DUAL

CFGFWK-64213: Test Successful!
CFGFWK-64213: JDBC connection test was successful.
CFGFWK-64213: No action required.

Component Schema=WLS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_WLS_RUNTIME
Password=*************************************************
SQL Test=ISVALID

CFGFWK-64213: Test Successful!
CFGFWK-64213: JDBC connection test was successful.
CFGFWK-64213: No action required.
Component Schema=OWSM MDS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_MDS
Password=*************************************************
SQL Test=select 1 from schema_version_registry where owner = (select user from dual)
  and (mr_type='MDS' and version='12.2.1.3.0' or comp_id='CONSOLIDATED' and exists (select * from schema_version_registry where mr_type='MDS' and version='12.2.1.3.0'
  and owner in (select unique(table_owner) from all_synonyms where owner=(select user from dual))))

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.

Component Schema=OAM Infrastructure
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_OAM
Password=*************************************************
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='OAM'

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.

Component Schema=OPSS Audit Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_IAU_APPEND
Password=*************************************************
SQL Test=ISVALID

CFGFWK-64213: Test Successful!
CFGFWK-64213: JDBC connection test was successful.
CFGFWK-64213: No action required.

Component Schema=OPSS Audit Viewer Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_IAU_VIEWER
Password=*************************************************
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='IAU_VIEWER' and version like '12.2.1%'

CFGFWK-64213: Test Successful!
CFGFWK-64213: JDBC connection test was successful.
CFGFWK-64213: No action required.
Component Schema=OPSS Schema
Driver=oracle.jdbc.OracleDriver
URL=jdbc:oracle:thin:@//<DB-HOST>:<DB-PORT>/<SERVICE NAME>
User=<USER>_OPSS
Password=*************************************************
SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type='OPSS' and version like '12.2.1%'

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

 Database was cloned before the upgrade.

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.