Upgrading VMware vCenter Server with an Oracle Database from 5.x to 6.0 fails with the error: "The user associated with the DSN has insufficient privileges"
book
Article ID: 336019
calendar_today
Updated On:
Products
VMware vCenter Server
Issue/Introduction
Upgrading the VMware vCenter Server from 5.x to 6.0 fails when validating the database.
You see the error:
Error: The user associated with the DSN has insufficient privileges.
Resolution: Provide sufficient privileges for the user by granting
the user the following permissions:
* SELECT ON DBA_LOCK
* SELECT ON v_$SESSION
Environment
VMware vCenter Server 6.0.x
Cause
This error occurs due to vCenter Server 6.0 requiring additional privileges to be assigned to the vCenter Server database user.
Resolution
Grant the additional privileges to the vCenter Server database user:
Log in to a SQL*Plus session with the system account.
Run these SQL commands to create a vCenter Server database user with the correct permissions:
grant select on v_$session to [vCenter_database_user]; grant unlimited tablespace to [vCenter_database_user]