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?
Thanks for the info.
I did apply those patches to both server and client.