VMware Cloud Community
blckgrffn
Enthusiast
Enthusiast
Jump to solution

Oracle D-base requirements for VC2

There seems to be plenty of information that I can find related to what needs to be on the virtual center server, the odbc client.

What I need is the documentation that points out how the oracle dbase needs to be configured and if Oracle 10g is supported, etc.

Thanks,

Nat

Reply
0 Kudos
1 Solution

Accepted Solutions
esiebert7625
Immortal
Immortal
Jump to solution

We currently use 10g without any problems, it is also mentioned in the install guide. See page 58-59 of the install guide for Oracle. A additional requirement for VC Patch2 is the dbms_lock role. The release notes for Patch2 also mention 10g

VirtualCenter Database Requirements (Page 23 of install guide)

VirtualCenter supports the following database formats:

! Microsoft SQL Server 2000 (SP 4 only)

! Oracle 9iR2, 10gR1 (versions 10.1.0.3 and higher only), and 10gR2

! Microsoft MSDE (not supported for production environments)

Each database requires some configuration adjustments in addition to the basic

installation.

Create a new tablespace specifically for VirtualCenter using the following

SQL statement:

CREATE TABLESPACE vpx DATAFILE 'C:\Oracle\ORADATA\VPX\vpx.dat' SIZE

500M;

b Create a user, such as vpxAdmin, for accessing this tablespace through ODBC:

CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;

c Give that user CONNECT and DBA privileges:

GRANT CONNECT, DBA to vpxAdmin;

Pre-Upgrade Task for Oracle Database Server: The schema used to manage the VirtualCenter objects must be able to use Oracle’s DBMS_LOCK built-in package, which means it requires execute privileges on the package. Prior to installing the upgrade on an existing system, you (or your Oracle database administrator (DBA) must log on to the Oracle Database server as the sysdba and grant the privilege, as follows:

sqlplus system/ as sysdba

grant execute on dbms_lock to vpxadmin;

Virtual Center 2.0.1 Patch2 - http://www.vmware.com/support/vi3/doc/vc-201-200702-patch.html

http://www.vmware.com/pdf/vi3_301_201_installation_guide.pdf

fyi...if you find this post helpful, please award points using the Helpful/Correct buttons...thanks

Message was edited by:

esiebert7625

View solution in original post

Reply
0 Kudos
2 Replies
esiebert7625
Immortal
Immortal
Jump to solution

We currently use 10g without any problems, it is also mentioned in the install guide. See page 58-59 of the install guide for Oracle. A additional requirement for VC Patch2 is the dbms_lock role. The release notes for Patch2 also mention 10g

VirtualCenter Database Requirements (Page 23 of install guide)

VirtualCenter supports the following database formats:

! Microsoft SQL Server 2000 (SP 4 only)

! Oracle 9iR2, 10gR1 (versions 10.1.0.3 and higher only), and 10gR2

! Microsoft MSDE (not supported for production environments)

Each database requires some configuration adjustments in addition to the basic

installation.

Create a new tablespace specifically for VirtualCenter using the following

SQL statement:

CREATE TABLESPACE vpx DATAFILE 'C:\Oracle\ORADATA\VPX\vpx.dat' SIZE

500M;

b Create a user, such as vpxAdmin, for accessing this tablespace through ODBC:

CREATE USER vpxAdmin IDENTIFIED BY vpxadmin DEFAULT TABLESPACE vpx;

c Give that user CONNECT and DBA privileges:

GRANT CONNECT, DBA to vpxAdmin;

Pre-Upgrade Task for Oracle Database Server: The schema used to manage the VirtualCenter objects must be able to use Oracle’s DBMS_LOCK built-in package, which means it requires execute privileges on the package. Prior to installing the upgrade on an existing system, you (or your Oracle database administrator (DBA) must log on to the Oracle Database server as the sysdba and grant the privilege, as follows:

sqlplus system/ as sysdba

grant execute on dbms_lock to vpxadmin;

Virtual Center 2.0.1 Patch2 - http://www.vmware.com/support/vi3/doc/vc-201-200702-patch.html

http://www.vmware.com/pdf/vi3_301_201_installation_guide.pdf

fyi...if you find this post helpful, please award points using the Helpful/Correct buttons...thanks

Message was edited by:

esiebert7625

Reply
0 Kudos
blckgrffn
Enthusiast
Enthusiast
Jump to solution

Thanks!

I am going to get this info to my oracle DBA (who claimed she needed more requirements for the dbase, particularly size) and then come back and get you some points.

Any thoughts on sizing?

Thanks again,

Nat

Message was edited by:

blckgrffn

Reply
0 Kudos