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?

Reply
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.

Reply
0 Kudos
skishore
Contributor
Contributor

Thanks for the info.

I did apply those patches to both server and client.

Reply
0 Kudos