Hi, I am currently in the process of upgrading Oracle Analytics Server 5.5 to its latest 2024 iteration and have encountered challenges with the Upgrade Assistant (UA). Below are the steps I have undertaken for the upgrade: * Rename the Oracle_Home to Oracle_Home_old (/u01/app/oracle/product/fmw_old) * Fresh Install Oracle Fusion Middleware 12.2.1.4 * Fresh Install Oracle Analytics Server 7.6 * Install those path same as existing Oracle_Home (/u01/app/oracle/product/fmw) * Run UA -readiness (Result all ok) 6. Run UA upgrade All schema used by Domain 7. Run UA upgrade again for the All configuration used by Domain Get the error during Examine Oracle JRF Attach with the log file UA-UpgradeDomainConfiguration.zip Thank you in advance to anyone who might be able to provide insight or assistance. I'm open to any suggestions and happy to provide more details if needed. Your help is greatly appreciated.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAS 5.5 Upgrade OAS 7.6 (March 2024) Failed Status during UA Upgrade

Tiang

Hi,

I am currently in the process of upgrading Oracle Analytics Server 5.5 to its latest 2024 iteration and have encountered challenges with the Upgrade Assistant (UA). Below are the steps I have undertaken for the upgrade:

Rename the Oracle_Home to Oracle_Home_old (/u01/app/oracle/product/fmw_old)
Fresh Install Oracle Fusion Middleware 12.2.1.4
Fresh Install Oracle Analytics Server 7.6
Install those path same as existing Oracle_Home (/u01/app/oracle/product/fmw)
Run UA -readiness (Result all ok)

6. Run UA upgrade All schema used by Domain

7. Run UA upgrade again for the All configuration used by Domain

Get the error during Examine Oracle JRF

Attach with the log file

UA-UpgradeDomainConfiguration.zip

Thank you in advance to anyone who might be able to provide insight or assistance. I'm open to any suggestions and happy to provide more details if needed. Your help is greatly appreciated.

Find more posts tagged with

OBIEE

Analytics

Upgrades

Accepted answers

Tiang

Hi @Gianni Ceresa,

To mitigate potential issues during the upgrade, I renamed the old binaries to "fmw_old", ensuring the possibility of reverting to the previous state if necessary. Additionally, I performed a fresh installation of the new binaries under the same name, aiming to prevent the need for modifications in the application paths that depend on them.

I identified the primary reason for the initial failure in my upgrade process: I overlooked the step of reconfiguring the domain first. Thus, the correct sequence should be: Upgrade Database Schema > Reconfigure Domain > Upgrade Domain Configuration. Following this revised order, I was able to successfully continue with the upgrade.

Furthermore, I acknowledge that naming my binaries folder "fmw" may not align with best practices. I will take this into consideration for future upgrades.

Thank you for your suggestions and answers; they have been invaluable to my process.

All comments

Gianni Ceresa

Hi,

just a random guess based on the process you described and the error in your log file.

Can't you install the binaries in a new folder? You are renaming the folder with the old binaries, which is the same as just deleting everything before to even start the ugrade.

All that just because you want to reuse the same folder name for the new binaries.

To me it sounds like you are asking to have issues with this…

It you do use a different folder name for the new binaries, you will not have an error of a 5.5.0 component not found in the folder that was the old binaries, but that is now already the new binaries.

That's why a common approach is to name the binaries folder with the version installed (also to quickly know what product you are dealing with), for example "oas_5.5.0" and "oas_7.6.0". Also a quick note: you called your binaries folder "fmw", but that thing doesn't contain just the Fusion Middleware, it also contains OAS, and that's actually the most important information.

I would try that …

Tiang

Hi @Gianni Ceresa,

Furthermore, I acknowledge that naming my binaries folder "fmw" may not align with best practices. I will take this into consideration for future upgrades.

Thank you for your suggestions and answers; they have been invaluable to my process.

Steve F-2

@Tiang

I am going to restate what @Gianni Ceresa mentions, but in a slightly different way because you use "rename", and that can be much different than "move".

I too, use that same methodology because I always want $ORACLE HOME as 'oas_home' and $DOMAIN_HOME as 'oas_domain', but to each their own for their naming conventions.

So, the steps I would use in your case are:

mv /u01/app/oracle/product/fmw /u01/app/oracle/product/fmw_old
mkdir /u01/app/oracle/product/fmw (empty directory)
Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw
Install OAS 2024 binaries in /u01/app/oracle/product/fmw
Rest of your steps according to the Upgrade Guide
Move em.ear manually from /u01/app/oracle/product/fmw_old
Doc ID 2948266.1
start.sh (assuming RCU database is already running and accessible), and confirm login to WLS Console, FMw Control, Analytics (/dv, /analytics, /xmlpserver), etc.
Remove old home.

Can you confirm the first 4 bullet points are what you executed, or you did something slightly different.?

Steve F-2

@Tiang - Thanks for sharing the missed step.. I guess my browser had not refreshed 🤦‍♂️

dsalgueiro

Hi!

I am in this same situation,

When I see the steps of:

Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw
Install OAS 2024 binaries in /u01/app/oracle/product/fmw

This includes new domain setup steps, etc. or just installation?

I mention this because I cannot understand the guide well since in the case of a new OAS installation I would have to create a new DB scheme and not use the existing 5.5 one?

I have followed the steps up to here:

mv /u01/app/oracle/product/fmw /u01/app/oracle/product/fmw_old (OAS 5.5)mkdir /u01/app/oracle/product/fmw (empty directory) (OAS 7.6)
Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw (No domain configuration, installation only)
Install OAS 2024 binaries in /u01/app/oracle/product/fmw (No configuration, installation only)
Rest of your steps according to the Upgrade Guide

https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrading-latest-release-oracle-analytics-server.html#GUID-3FC2170F-D91D-4B40-86CA-D610B9636473

Now I find the following:

/u01/app/oracle/product/fmw (OAS 5.5)
/u01/app/oracle/product/fmw_old (OAS 5.5)

I can't find the startup scripts in the new location and if I access the old one I see references to the new path.

Example:

Starting domain; Using domainHome: /app/fmw_old/domains/bi ... /u01/app/oracle/product/fmw/bi/modules/oracle.bi.sysman/scripts/start.sh: line 106: cd: /u01/app/oracle/product/fmw_old/domains/bi: No such file or directory

Initializing WebLogic Scripting Tool (WLST) ...

Thank you

dsalgueiro

Hi!

I am in this same situation,

When I see the steps of:

Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw
Install OAS 2024 binaries in /u01/app/oracle/product/fmw

This includes new domain setup steps, etc. or just installation?

I mention this because I cannot understand the guide well since in the case of a new OAS installation I would have to create a new DB scheme and not use the existing 5.5 one?

I have followed the steps up to here:

mv /u01/app/oracle/product/fmw /u01/app/oracle/product/fmw_old (OAS 5.5)
mkdir /u01/app/oracle/product/fmw (empty directory) (OAS 7.6)
Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw (No domain configuration, installation only)Install OAS 2024 binaries in /u01/app/oracle/product/fmw (No configuration, installation only)
Rest of your steps according to the Upgrade Guide Migrating and Upgrading to Oracle Analytics Server

Now I find the following:

/u01/app/oracle/product/fmw (OAS 5.5)
/u01/app/oracle/product/fmw_old (OAS 5.5)

I can't find the startup scripts in the new location and if I access the old one I see references to the new path.

Example:

Starting domain; Using domainHome: /app/fmw_old/domains/bi ...
/u01/app/oracle/product/fmw/bi/modules/oracle.bi.sysman/scripts/start.sh: line 106: cd: /u01/app/oracle/product/fmw_old/domains/bi: No such file or directory
Initializing WebLogic Scripting Tool (WLST) ...

Thank you

Tiang

@dsalgueiro
Hi, you not required to create new set of DB schema for OAS just use back existing one.
you have done move the old binary to fmw_old, and also install new oas7.6 binary in fmw.
How about your old domain directory? Have you done copy or move it to the new binary oas7.6?

If yes, then just run UA upgrade.
like follow sequence:
Upgrade Database Schema > Reconfigure Domain > Upgrade Domain Configuration.

Thanks.

dsalgueiro

Hello,

Since I have a backup and snapshot of the entire environment, I am going to start again

Regarding whether I copied or moved the old directory, I have moved it and left a clean one to install the new oas7.6 binary since otherwise it told me that the directory was not empty.

Therefore I have done the following before starting any type of installation.

mv /u01/app/oracle/product/fmw /u01/app/oracle/product/fmw_old (OAS 5.5)
mkdir /u01/app/oracle/product/fmw (empty directory) (OAS 7.6)

After process:

Install FMw 12.1.2.4 Infrastructure binaries in /u01/app/oracle/product/fmw (No domain configuration, installation only)
Install OAS 2024 binaries in /u01/app/oracle/product/fmw (No configuration, installation only)

It is at this point that I have doubts about how to continue.

Seeing his comment, I must:

Upgrade Database Schema > Reconfigure Domain > Upgrade Domain Configuration.

Would the route or path to use be that of the old FMW or that of the new one? I understand that the old one since it is the data and domain to update. Correct?

Thanks!!

Steve F-2

@dsalgueiro

Generally best to open a new thread when one is marked as answered because each situation can be similar, but unique.

In your case, the high-level steps are documented here:
https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrade-process.html

You run all the scripts, configuration from the new OAS 2024 home.
Hope that helps.