6.7

5 For all supported editions of Oracle Server, run the scripts to set up scheduled jobs on the database.
a
job_schedule1_oracle.sql
b
job_schedule2_oracle.sql
c
job_schedule3_oracle.sql
d
job_cleanup_events_oracle.sql
e
job_topn_past_day_oracle.sql
f
job_topn_past_week_oracle.sql
g
job_topn_past_month_oracle.sql
h
job_topn_past_year_oracle.sql
You created the vCenter Server tables manually.
Note During the vCenter Server installation, when a database reinitialization warning message appears,
select Do not overwrite, leave my existing database in place and continue the installation.
Create a Net Service Name
To configure an Oracle ODBC DSN, you must have a net service name for your database. On the
machine on which your Oracle database is running, you must create a net service name for the
vCenter Server tablespace.
Procedure
1 Use a text editor or the Net8 Configuration Assistant to open the tnsnames.ora file located in the
directory C:\Oracle\Oraxx\NETWORK\ADMIN, where xx is either 10g or 11g.
2 Add the following entry, where HOST is the managed host to which the client must connect.
VPX_TNS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=vpxd-Oracle)(PORT=1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Configure an Oracle ODBC Connection
After you create and configure an Oracle database and user for vCenter Server, you must create a 64-bit
DSN on the machine on which you plan to install vCenter Server. During the vCenter Server installation,
you use the DSN to establish a connection between vCenter Server and the database.
Prerequisites
Install the Oracle Client 11.2.0.3 p16656151 (Patch 19) or later, 11.2.0.4, 12.1.0.1.12 or later, or 12.1.0.2.
vCenter Server Installation and Setup
VMware, Inc. 105