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"
search cancel

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:
  1. Log in to a SQL*Plus session with the system account.
  2. 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]


  3. Run the vCenter Server installation again.