My Oracle Support Banner

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

Last updated on MAY 08, 2023

Applies to:

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


We have started to test the upgrade of our FMW environments (OSB/BPM/SOA) from to 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?


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

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