VMware Cloud Community
skishore
Contributor
Contributor

The DB user does not have required permission error

I am installing vcenter 2.5 latest using Oracle 10g - 10.2.0.3.0. After entereing System DSN, Login user & password, I get error message "The DB user does not required permission needed to install VMware virtualcenter server with selected DB". The DB user account has full DBA/admin rights to the database. We have assigned maximum permission as well but still getting the same error.

The DBA has traced the events and found this error:

Error encountered: ORA-0094

SELECT COUNT(1) FROM USER_ROLE_PRIVS WHERE

GRANTED_ROLE='DBA' AND USERNAME=UPPER('vm_owner')*; <- the semi colon should not be there in the trace

file*

DBA tells me that semicolon at the end of above statement should not be there.

Has anyone encountered this problem or have it sucessfully installed?

0 Kudos
2 Replies
ac57846
Hot Shot
Hot Shot

Have you looked at which says to:

First apply patch 10.2.0.3.0 to the client and server.

Then apply patch 5699495 to the client.

KB article 1003903 may also help with some other pointers to where to look.

0 Kudos
skishore
Contributor
Contributor

Thanks for the info.

I did apply those patches to both server and client.

0 Kudos