Ensure that your Oracle database meets requirements, that you have the necessary credentials, and that you complete any necessary cleanup or other preparation before upgrading vCenter Server.
Prerequisites
Verify that you have confirmed basic upgrade interoperability before preparing your Oracle database for upgrading vCenter Server. See Database Requirements for vCenter Server on Windows.
Verify that you have backed up your database. For information about backing up the vCenter Server database, see the Oracle documentation.
To set database permissions correctly, see Database Permission Requirements for vCenter Server
Procedure
Results
Your database is prepared for the vCenter Server upgrade.
What to do next
After the upgrade is complete, you can optionally remove the following permissions from the user profile: create any sequence and create any table.
By default, the RESOURCE role has the CREATE PROCEDURE, CREATE TABLE, and CREATE SEQUENCE privileges assigned. If the RESOURCE role lacks these privileges, grant them to the vCenter Server database user.