Cisco Cisco Process Orchestrator 3.0 Installation Guide

C H A P T E R

5-1

Cisco Process Orchestrator Installation Guide

OL-24931-02

Upgrading Cisco Process Orchestrator

Upgrading from 2.3 to 3.0

Note

The upgrade functionality supports upgrades from version 2.2x -> 3.0 and 2.3x -> 3.0 and does not
support upgrades from versions 2.1x and earlier.

The 3.0 upgrade calls the needed SQL scripts to perform the upgrade operation based on the existing
version found.

Oracle DB

Step 1

Install the OCI client that is compatible with the Oracle database server, if it not already installed.

Step 2

Choose Start > Run.

Step 3

On the Run dialog box, in the Open field, type cmd and press Enter.

The Command dialog box displays.

Step 4

Run the following scripts in the order as they are listed.

–

Execute OrchestratorProcessUpgradeUser.sql

Login as the user/schema that the process db is named (OrchestratorProcess is the default
user/schema for previous versions of Process Orchestrator), then run:

–

Execute OrchestratorProcessUpgrade.sql

–

Execute OrchestratorProcessViews.sql

Login as the user/schema that the report db is named (TIAReport is the default user/schema for
previous versions of Process Orchestrator), then run:

–

Execute OrchestratorReportingUpgrade.sql

Step 5

Install PO 3.0

Step 6

Verify the system works.