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 AUGUST 12, 2024
Applies to:
Oracle SOA Suite - Version 12.2.1.3.0 and laterInformation 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 |