How To: Create an Oracle Database for VMware vCenter 5.5

By | December 19, 2013

With the new vCenter virtual appliance not supporting Microsoft SQL Server and organizations virtualizing more Linux based guests for Big Data operations like Hadoop it is becoming more common than ever to need to install vCenter with an Oracle back end database. Here is how you do it:

1. Make sure you have the appropriate patch level. For Oracle 10g R2 it is 10.2.0.4. For 11g R1 it is 11.1.0.7. For 11g R2 it is 11.2.0.1 with patch 5.

2. Log in to the Oracle system with the system account using your choice of SQL*Plus clients.

3. Check the RESOURCE role for CREATE PROCEDURE, CREATE TABLE, and CREATE SEQUENCE. If absent add them.

4. Create the USER with the following SQL command:

CREATE USER "vpxadmin" PROFILE "DEFAULT" IDENTIFIED BY "servocepassword" 
DEFAULT TABLESPACE
"VPX " ACCOUNT UNLOCK;
grant connect to VPXADMIN;
grant resource to VPXADMIN;
grant create view to VPXADMIN;
grant create sequence to VPXADMIN;
grant create table to VPXADMIN;
grant create materialized view to VPXADMIN;
grant execute on dbms_lock to VPXADMIN;
grant execute on dbms_job to VPXADMIN;
grant unlimited tablespace to VPXADMIN;

5. Create the database with this SQL command:

CREATE SMALLFILE TABLESPACE "VPX" DATAFILE 'C:\Oracle\ORADATA\VPX\VPX.DBF' SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

6.  Assign the USER permission to the TABLESPACE with this SQL command:

CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;

7.  Enable Monitoring with the following SQL command:

grant select on v_$system_event to VPXADMIN;
grant select on v_$sysmetric_history to VPXADMIN;
grant select on v_$sysstat to VPXADMIN;
grant select on dba_data_files to VPXADMIN;
grant select on v_$loghist to VPXADMIN;

8. After these commands have been run you will also need to install the Oracle Client and ODBC drivers on you vCenter server and modify you tnsnames.ora file to relflect the name of your Oracle server.

9. Once you have installed vCenter copy the ojdbc13.jar file to the tomact/lib directory under your vCenter install.