My Oracle Support Banner

SOA Upgrade Assistant 12.2.1.3 Fails On ESS Schema With Repository Database Hosted On AWS RDS (Doc ID 2440141.1)

Last updated on JULY 10, 2020

Applies to:

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

Goal

We have started to test the upgrade of our FMW environments (OSB/BPM/SOA) from 12.2.1.1 to 12.2.1.3. Our repository databases are hosted on AWS RDS, which means we do not have SYSDBA access to the database but only an "admin" user with some but not all DBA privileges. This causes a problem when attempting to upgrade the ESS database schema with the Upgrade Assistant. The pre-upgrade check fails with:

 

For the RCU we have a workaround whereby the ESS user is created in advance using RDS-provided wrappers with grants of the DBMS packages involved and the ESS schema actually already has all the privileges it needs. However, the Upgrade Assistant is not aware of this. Is there any way around this issue?
 

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.