Книга: Mastering VMware® Infrastructure3

Working with Oracle Databases

Working with Oracle Databases

Working with Oracle as the back-end database naturally involves more effort than using a SQL Server back-end. I stress the naturally part only because VirtualCenter is a Windows-based application and therefore seems to have a tighter integration with SQL Server that facilitates the configuration. To use Oracle 9i or 10g, you will need to install Oracle and create a database for VirtualCenter to use. If your Oracle database resides on the same computer as VirtualCenter, perform the following steps to prepare Oracle for VirtualCenter:

1. Install the Oracle database driver to the VirtualCenter server.

2. Increase the number of open available cursors for the database by adding the following line:

open_cursors - 300 to the C:OracleAdminVPXpfileinit.ora

3. Create a new tablespace dedicated to the VirtualCenter:

CREATE TABLESPACE vc DATAFILE 'C:OracleORADATAVPXvpx.dat' SIZE 250M;

4. Create a new Oracle user account (i.e., vdcdbuser) to use in the ODBC connection string:

CREATE USER vdcdbuser IDENTIFIED BY vdcdbuser DEFAULT TABLESPACE vc;

5. Ensure the database user has been given the CONNECT and DBA privileges.

6. Finally, create an ODBC connection string in the VirtualCenter server using Administrative Tools. Give the ODBC connection a meaningful name and utilize the account created for VirtualCenter access. 

For larger enterprise networks where the Oracle 9i or 10g database server is a separate computer, you will need to perform the following tasks on the computer running VirtualCenter: 

1. If necessary, download and install the Oracle client on the VirtualCenter server.

2. Download and install the Oracle ODBC driver on the VirtualCenter database.

3. Open the tnsnames.ora file in the C:OracleOraxxnetworkadmin directory, where xx is the version number of your ESX server.

4. Add the following text to the tnsnames.ora file:

VPX =
(Description =
(Description
(AddressList=
Address=(Protocol=TCP)(Host=vpxd-Oracle)(Port1521)))
Host =

Оглавление книги