Hi,
I'm having the same problem, with ESX 4, VC4 and Oracle 11g.
The DSN connect properly to DB.
How is your DB global Oracle setting JOB_QUEUE_PROCESSES? 0 or 1000? I have 1000, and suspect that this is correct.
Our grants on DB are as following:
GRANT
RESOURCE
TO
VPXADMIN; GRANT
CONNECT
TO
VPXADMIN;GRANT CREATE
SEQUENCE
TO
VPXADMIN;GRANT CREATE
VIEW
TO
VPXADMIN;GRANT UNLIMITED
TABLESPACE
TO
VPXADMIN;GRANT CREATE
TABLE
TO
VPXADMIN; GRANT
EXECUTE
ON
SYS.DBMS_LOCK
TO
VPXADMIN; GRANT
EXECUTE
ON
SYS.DBMS_JOB
TO
VPXADMIN;
I have re-ran this job in de DB: load_usage_stats_proc_oracle.sql
This job could be found in the VC Server, in the installation Folder. Use Search files and folders. This job are 3 files, load_usage_stats_oracle1.sql, 2 and 3.
Try with all this and tell me, I'm following an Incident opened in VMWare, if I know more info will post here.
Regards...
Patricio