vCenter 2.5 Update 3 don't connect with Oracle 10.2.0.4

[sguijarrogarcia]

I am installing a new vCenter 2.5 Update 3 in Windows Server 2003,  and I have problems to connect with a new database in Oracle 10.2.0.4.

I created an instance in the Oracle, and I did these steps:

CREATE TABLESPACE "VPX" DATAFILE '/oracle/oradata/VCENTER/DATA/DATAFILE/VPX.dbf' SIZE 6000M;
CREATE TABLESPACE "VUM" DATAFILE '/oracle/oradata/VCENTER/DATA/DATAFILE/VUM.dbf' SIZE 6000M;

CREATE USER vpxadmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;
CREATE USER vumadmin IDENTIFIED BY vumadmin DEFAULT TABLESPACE vum;

GRANT "DBA" TO "VPXADMIN";
ALTER USER "VPXADMIN" DEFAULT ROLE  ALL

grant connect to vpxadmin;
grant resource to vpxadmin;
grant create view to vpxadmin;
grant execute on dbms_job to vpxadmin;
grant execute on dbms_lock to vpxadmin;
grant unlimited tablespace to vpxadmin;

grant connect to vumadmin;
grant resource to vumadmin;
grant create view to vumadmin;
grant create any sequence to vumadmin;
grant create any table to vumadmin;
grant unlimited tablespace to vumadmin;

When I try to configure a ODBC connection, I write the next info:

System DSN

Data Source Name: VCENTER

User Name vpxadmin

Server VCENTER

And this is the tnsnames.ora:

VCENTER =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = VCENTER_IP)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SID = VCENTER)
       (SERVER = DEDICATED)
     )
   )

With a telnet, I receive response from the database, but I can't connect with the database. Any idea?

[MauroBonder · Accepted solution]

the user of vcenter need be owner_db during installation of vcenter, and after the installation you can remove this full permission.

check too http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=100392...

[sguijarrogarcia]

Thanks for your help. I can do it, with the owner of the tablespace VPX and VUM. Thanks a lot.