VMware Cloud Community
Gregboschman
Contributor
Contributor

CollectRemote database error

Hi.

I am getting continual VpxdMoHost::CollectRemote database error while flushing stats data: "ODBC error: () - " is returned when executing SQL statement "BEGIN load_stats_proc(?, ?, ?, ?, ?, ?); END;" and VpxdMoHost::CollectRemote database error while flushing stats data: "ODBC error: () - " is returned when executing SQL statement "BEGIN load_stats_proc(?, ?, ?, ?, ?, ?); END;" error message types in the vpxd log files.

VirtualCenter 2.5 connecting to an Oracle DB hosted on a different server.

Reply
0 Kudos
1 Reply
Limeres
Contributor
Contributor

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

Reply
0 Kudos