My Oracle Support Banner

PUMA: Question About is there a way to identify instances in 11g which upgrade assistant picks first to upgrade? (Doc ID 2906367.1)

Last updated on FEBRUARY 12, 2024

Applies to:

Oracle SOA Suite - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Goal

Qn1:On : 11.1.1.9.0 version, Fabric

Question about most time consuming step of 12.2.1.4 ua for DB upgrade

We are following the steps for upgrading from SOA 11.1.1.0 to 12.2.1.4

https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/fupss/introduction-oracle-soa-suite-and-business-process-management-upgrade.html#GUID-92A61938-3AC1-417C-B990-A834AF90E8B3

We have run "ua" for the DB upgrade and it looks like it worked.

However we have a question about the instances it upgraded. It upgrades a few hundred every 5 minutes as you can see below. It does this for the first 60,000 or so, and then completes another 500,000 within 10 or 15 mins. After that, it continues upgrading the "closed" instances with a DB background job. We have a total of about 2.2 million, mostly closed.

So the question is. How can we identify the 60,000 instances that were upgraded? We believe we can purge a large number, but how can we positively identify them?


[2022-08-23T07:50:05.252-04:00] [SOA] [NOTIFICATION] [] [upgrade.SOA.SOA1] [tid: 62] [ecid: 9200bb56-1d06-46d5-8f51-56a9d1dcb35b-00000002,0] SOA Data Upgrade in progress. Number of instances upgraded : 51,337
[2022-08-23T07:55:05.318-04:00] [SOA] [NOTIFICATION] [] [upgrade.SOA.SOA1] [tid: 62] [ecid: 9200bb56-1d06-46d5-8f51-56a9d1dcb35b-00000002,0] SOA Data Upgrade in progress. Number of instances upgraded : 51,513


 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.