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 04, 2023
Applies to:Oracle Fusion Middleware - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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_184.108.40.206.0_infrastructure.jar)
3. Install SOA (fmw_220.127.116.11.0_soa.jar)
4. Install OSB (fmw_18.104.22.168.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.
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