Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAS 2023 upgrade to OAS 2024 fails during upgrade 'All Schemas Used By a Domain'
The upgrade process with Oracle Fusion Middleware Upgrade Assistant (ua.bat) type 'All Schemas Used By a Domain' fails with the following message:
Oracle Business Intelligence Schema
doUpgrade Failed, due: java.lang.RuntimeException: Total 1 schema plugins failed: (1) Schema plugin: com.oracle.bi.contentstorage.plugins.schema.ContentStorageSchemaPlugin failed: Validate failed: Migration checksum mismatch for migration 1.0.0.0.4 -> Applied to database : 2114654566 -> Resolved locally : -946993454
UPGCMP-06005: BIPLATFORM database schema update failed.
Cause: Specified BIPLATFORM database schema update failed.
Action: Check the log file and if necessary restore the database from backup.
UPGCMP-06005: BIPLATFORM database schema update failed.
Cause: Specified BIPLATFORM database schema update failed.
Action: Check the log file and if necessary restore the database from backup.
doUpgrade Failed
Overview of environment
- OAS Server
OS: Windows Server 2019 Standard Edition
Oracle Analytics Server 7.0.0 (OAS 2023)
Applied WLS/FMW/OAS patches to OAS 2023: April 2024
Applied WLS/FMW/OAS patches to OAS 2024: April 2024 including patch 35515979
$ORACLE_HOME D:\analytics\product\oas_home
$DOMAIN_HOME D:\analytics\config\domains\oas_domain - Database Server (different Machine from OAS Server) for Repository
OS: Windows Server 2019 Standard Edition
DBMS: MS SQL Server 2019 Enterprise Edition
Process for upgrade
According to Guide
the following steps were planed:
- Apply latest patches to Oracle Analytics Server 7.0.0 (OAS 2023) installation
- Shut down OAS services (leave database instance running)
- Create Backup directory: mkdir D:\analytics\config\backup
- Backup contents of $ORACLE_HOME as Zip-archive to D:\analytics\config\backup
- Backup contents of $DOMAIN_HOME as Zip-archive to D:\analytics\config\backup
- Move existing $ORACLE_HOME directory to temporary directory: move D:\analytics\product\oas_home D:\analytics\product\oas_home.2023
- Create new empty $ORACLE_HOME directory: mkdir D:\analytics\product\oas_home
- Install Oracle Fusion Middleware 12.2.1.4.0 to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
- Install Oracle Analytics Server 7.6.0 (OAS 2024) to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
- Apply OPatch/WLS/FMW/OAS April 2024 patches (including patch 35515979) into new empty $ORACLE_HOME directory
- Perform Readiness check with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat -readiness
- Back up mapViewerConfig.xml: copy D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\mapViewerConfig.xml D:\analytics\config\backup
- Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
- Reconfigure the existing domain with the Reconfiguration Wizard: ORACLE_HOME\oracle_common\commom\bin\reconfig.cmd
- Upgrade All Configurations Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
- Restore mapViewerConfig.xml: copy D:\analytics\config\backup\ mapViewerConfig.xml D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\ /y
- Restart all OAS services
- Verify upgrade and delete old %ORACLE_HOME%: erase \analytics\product\oas_home.2023 /f /s /q
Upgrade Notes
- The Oracle Fusion Middleware Upgrade Assistant Readiness check indicated no errors (see attached logs)
- The upgrade fails at step 13 from the above list 'Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant' (see attached logs)
- According to additional patch 25297159 is required in order to succeed. However this patch doesn't exist. According to additional patch 35515979 is required - this patch exists und was applied to the new $ORACLE_HOME% with OAS 2024 installed prior to the upgrade.
- Although certificates and SSL listeners for accessing OAS were configured no internal SSL was enabled (standard listeners were also still active)
Alternatives tried (without success):
- Trying an upgrade from Oracle Analytics Server 7.0.0 with January 2024 patches
- Trying an upgrade from Oracle Analytics Server 7.0.0 with April 2024 patches
- Trying an upgrade to Oracle Analytics Server 7.6.0 without any patches
- Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches
- Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches (including patch 35515979)
Question
Is there a required step missing? Or a specific patch? Or is this just a bug?
Best Answer
-
Hi @Sascha L. ,
I understand you are working on an internal reproduction via the Service Request.
According to additional patch 25297159 is required in order to succeed. However this patch doesn't exist.I just wanted to let you and future readers know that we have filed a documentation update for this. Patch 35515979 is the correct patch.
2
Answers
-
Also opened Technical Service Request SR 3-37241855861 for this issue.
0 -
Hi Sascha,
I suggest you pursue the SR. Oracle Support is a service you pay for with your licenses. This is is a public and free community forum.
Especially errors like yours aren't really things that the community can resolve.
Unless someone has your precise setup with an all-Windows config you'll probably not get anyone who can reproduce it and even then it's 50/50 because it's an upgrade and not a fresh install.
I'll ask the question that's probably burning on the fingers of several forum users but not typed out: What forces you to stay on-premises?
1 -
The issue happening in OAS 2023 to OAS 2024 upgrade ..
and the patch 35515979 suggested, is saying BIAPPS UPGRADE OAS6.4 WITH OCT CPU TO OAS7 FAILS AT RECONFIG…
—
as per I have found OAS 2023 is 7.0 right & OAS 2024 is 7.6?
is it may be same old patch necessary here also, or a typo in naming the patch?
0 -
And when I tried to apply this patch, it's superset patch 36946553 is already a necessary patch indicated in FMW quarterly patches list..
0 -
@Karthik-Oracle
This is an old thread with an accepted answer.
Patch 36946553 was from OCT 2024, and yes, it has been superseded by the JAN 2025 patches
Also, as FYI OAS 2025 was released last week.0 -
we are upgrading now from OAS 2023 , shall I directly jump to OAS 2025 ?
why I am asking suggestion is, dealing with BIP/OAS is a difficult one, so just our target is to save as much time possible on OAS maintenance..
We have lot of environments running this setup.
So what will you suggest shall I proceed upgrading to 2024, or is it best to upgrade in to the just released 2025 version ?
0
