KBI 310729 Oracle Database Configuration Steps When Using Oracle As Backend


Argent Advanced Technology 3.1A-1401-A and above


Thursday, 13 Feb 2014


Steps to be followed for Oracle Database configuration, when Oracle is used as backend in Argent Advanced Technology installation

Technical Background

Argent Advanced Technology uses Oracle C++ Call Interface when Oracle database is used as backend

To support both 32 bit and 64 bit Oracle database server environments, Argent Advanced Technology uses 32 bit Oracle Client

Oracle Client software should be installed and configured properly for the successful running of Argent Advanced Technology

Install the Oracle Client using Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio

This can be downloaded by clicking the link: Oracle Data Access Components (ODAC)

Detailed steps of installation and configuration are described below

Note: Make sure you are using 32 bit Oracle Client downloaded from the above download link

Install and Configure Oracle Client Using Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio

Run the SETUP.EXE of ODT with ODAC

This will bring the following screen

Click ‘Next‘ button

Select the First Option As Marked In Red

Click ‘Next‘ button

Specify the Install Location

It is not necessary to do anything here, unless a custom installation is required

Select Oracle Instant Client As Marked In Red

Click ‘Next‘ button

Installation in Progress

Installation Completed

Configure Oracle Service Name

After the Oracle Client Installation, configure Oracle Service Name which is used when connecting to Oracle Server

For this, create a file named ‘tnsnames.ora‘ and place this file in the Network\Admin in the path Oracle Client is installed

As per the configuration illustrated here in the above screenshots, it will be ‘C:\app\Administrator\product\11.2.0\client_1\Network\Admin

The content of ‘tnsnames.ora‘ file should be something like the following

A sample ‘tnsnames.ora‘ file is shown below

Explanation of tags is as follows:

HOST 		Machine name or IP address of the Oracle Server

PORT 		Port number that Oracle is listening for incoming connections

SERVICE_NAME	Name configured at the time of Oracle Server installation

NOTE: Specify the ‘Oracle Service Name’ (in the database configuration screen of AT installer) as ‘test’ as it is the name configured in the ‘tnsnames.ora’ file

In the database configuration screen of AT installer, specify the above configured Oracle Service Name as shown below