In certain situations, upgrading an enterprise geodatabase for Oracle to version 10 fails with the following error message:
"Error: User does not have required privileges to upgrade. [Success]"
The error is raised even though all the required privileges have been granted to the geodatabase admin user and the public role.
The error is unique to particular conditions within the geodatabase schema in Oracle and cannot be identified without working with Esri Customer Support.