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
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 Oracles 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
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 Oracles 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
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