Version: 24.3

ALM Connect - Oracle Prerequisites and Setup

This article lists the Oracle Prerequisites and Setup for Agility Sync.

Overview

These instructions ensure that the steps performed prior to ALM Connect installation and the steps required during installation are correct for Oracle.

Ensure the oracle user provided during setup has the following rights:

Create/Alter/Drop any table, Query Rewrite, Global Query Rewrite
Create/Drop any View
Create/Alter/Drop any Procedure
Create any Directory

Prerequisites

Click here to download the Oracle connector file.
Move the file to a root location such as c:\Oracle_Connector
Take note of the path to the classes12.jar file as it is required during setup.

ALM Connect Oracle Setup

On the Oracle setup step during installation provide the following:
- Database Host Name (ex. localhost)
- Database Port Number
- Database User Name
- Database User Password
- Oracle Instance Name
Browse to the location of the classes12.jar file.
Click NEXT to continue the installation.