My Oracle Support Banner

FMW Configuration Wizard's Component Datasources Screen Incorrectly Shows "dbhost.example.com" - Editing Ends With JPS-00260 Failure (Doc ID 2624306.1)

Last updated on JANUARY 05, 2024

Applies to:

Oracle Fusion Middleware - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Running the Configuration Wizard for Oracle Fusion Middleware 12.2.1.x, there is a problem creating a domain.

On the Database Configuration Type screen:

-- When we enter the database configuration and click the "Get RCU Configuration", it's successful.

On the next screen, the Component Datasources screen:

-- None of the information is populated correctly. It all goes back to default showing an incorrect "dbhost.example.com".


This causes problems with the domain creation, and if we edit that second screen manually, OPSS fails with:

com.oracle.cie.domain.security.external.ConfigSecurityException: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: JPS-00260: Database access error. SQL state: 42000, error code: 942

Even though we are specifically giving it the database info in the script, yet it's getting "dbhost.example.com:1521/orcl" and the "DEV" prefix from somewhere. 

Changes

The issue can be reproduced with the following steps using an Infrastructure and SOA installation as an example:

1. Install prerequisite software (java, Oracle client, etc)
2. Install WebLogic (fmw_12.2.1.3.0_infrastructure.jar)
3. Install SOA (fmw_12.2.1.3.0_soa.jar)
4. Install OSB (fmw_12.2.1.3.0_osb.jar)
5. Run RCU to generate scripts for DBA to run
6. DBA creates schema with script_systemLoad.sql script)
7. Run config.sh to create initial SOA domain in WebLogic

A key difference from a standard installation of RCU is when it is run as a lower privileged user to generate a script to then provide to the SYS DBA to finish the steps. 

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.