6.0.2

Table Of Contents
3 If your existing database is Oracle, and you want to upgrade to a newly supported Oracle database,
such as Oracle 11g, upgrade your Oracle database before upgrading vCenter Server.
You do not need to perform a fresh installation of vCenter Server if your existing database is Oracle.
For example, you can upgrade your existing Oracle 9i database to Oracle 11g or Oracle 12c and upgrade
vCenter Server 5.x to vCenter Server 6.0.
4 Verify that passwords are current and not set to expire soon.
5 Ensure that you have login credentials, the database name, and the database server name that the
vCenter Server database is to use.
Look in the ODBC system for the connection name of the database source name for the vCenter Server
database.
6 Use the Oracle SERVICE_NAME instead of SID to verify that your Oracle database instance is available.
n
Log in to the database server to read from the alert log:
$ORACLE_BASE/diag//rdbms/$instance_name/$INSTANCE_NAME/trace/alert_$ INSTANCE_NAME.log.
n
Log in to the database server to read from the Oracle Listener status output.
n
If you have the SQL*Plus client installed, you can use tnsping for the vCenter Database instance. If
the tnsping command does not work the rst time, retry it after waiting a few minutes. If retrying
does not work, restart the vCenter Database instance on the Oracle server and then retry tnsping to
ensure it is available.
7 Verify that the JDBC driver le is included in the CLASSPATH variable.
8 Verify that permissions are set correctly.
9 Either assign the DBA role or grant the required permissions to the user.
10 Locate the cleanup_orphaned_data_Oracle.sql script in the ISO image and copy it to the Oracle server.
11 Log in to a SQL*Plus session with the vCenter Server database account.
12 Run the cleanup script.
@pathcleanup_orphaned_data_Oracle.sql
The cleanup process purges unnecessary and orphaned data that is not used by any vCenter Server
component.
13 Make a full backup of the vCenter Server database and the vCenter Inventory Service database.
Your database is prepared for the vCenter Server upgrade.
What to do next
After the upgrade is complete, you can optionally remove the following permissions from the user prole:
create any sequence and create any table.
By default, the RESOURCE role has the CREATE PROCEDURE, CREATE TABLE, and CREATE
SEQUENCE privileges assigned. If the RESOURCE role lacks these privileges, grant them to the
vCenter Server database user.
Chapter 3 Before Upgrading vCenter Server
VMware, Inc. 55