2.5

Table Of Contents
User Defined Upgrade Scripts for Oracle databases
In the update process, Data Director attempts to run two user defined scripts, the source base DB template
preupgrade script, and the target base DB template postupgrade script. To achieve customization in the update
process, you must upload a script to the base DBVM before converting it to a base DB template.
Table 4-1. Upgrade Scripts
Upgrade Script Scope Description
Preupgrade script Source base DB template Preupgrade scripts run in the original
database before updating. Scripts are
located at ${AgentHome}/plugin/$
{ActivatedPluginFolder}/upgrade
_script/preupgrade_script.
For Oracle 11 template, the full path
is
/opt/aurora/agent2/plugin/vfdd_
linux_oracle_11/upgrade_scrip
t/pretupgrade_script.
Postupgrade script Target base DB template Postupgrade script run in the staging
database after the system applies
updates, such as new third party tools
or database software upgrades. The
database instance is started after the
post-upgrade script finishes. Scripts are
located at ${AgentHome}/plugin/$
{ActivatedPluginFolder}/upgrade
_script/postupgrade_script.
For Oracle 11 template, the full path
is
/opt/aurora/agent2/plugin/vfdd_
linux_oracle_11/upgrade_scrip
t/postupgrade_script.
Permission To Scripts
The directory upgrade_script must be accessible and writable to system database administrator users. The
script files preupgrade_script and postupgrade_script must be readable and executable to system database
administrator users.
Configure a vFabric Postgres Update Chain
You configure an update chain to enable database users to update databases based on templates the comply
with update policies.
Prerequisites
• Verify that Data Director has one vFabric Postgres 9.1 db template.
• Verify that Data Director has one vFabric Postgres 9.0 db template.
NOTE You must upgrade vFabric Postgres 9.0 on Data Director 1.0 to vFabric Postgres 9.0 on Data Director
2.x before you upgrade to vFabric Postgres 9.1 on Data Director 2.x.
Procedure
1 Log in to Data Director as a system administrator.
2 Click the Manage and Monitor tab.
Chapter 4 Building DBVMs and Base DB Templates
VMware, Inc. 53