Oracle Client Example Configuration on UNIX or Linux

Example environment:
  • Instant Client - Basic at /usr/local/instantclient_11_2, to use American English
  • Oracle 11.2 on a UNIX system at /usr/local/oracle/product/11.2.0/db_1, installed to support international data
Variable settings on the system where the client and Build Forge are installed:
  • LD_LIBRARY_PATH (Solaris, Linux) or LIBPATH (AIX) includes /usr/local/instantclient_11_2
  • NLS_LANG=AMERICAN_AMERICA.AL32UTF8
  • ORACLE_HOME=/usr/local/instantclient_11_2
  • ORA_NLS10=/usr/local/oracle/ocommon/nls/admin/data
  • PATH includes /usr/local/instantclient_11_2
  • TNS_ADMIN=/usr/local/oracle/product/11.2/db_1/network/admin
UNIX and Linux Systems using Oracle Instant Client 11.2
The Build Forge application has a dependency on library libclntsh.so.10.1, which is part of the version 10.2 client. During installation, the installer checks for this file in ORACLE_HOME. If the file does not exist, the installer assumes that you are using the version 11.2 client and attempts to create a symbolic link from libclntsh.so.10.1 to the corresponding version 11.2 library, libclntsh.so.11.1. 
ln -s libclntsh.so.11.1 libclntsh.so.10.1
Important: The user running the Build Forge installer must have write access to the ORACLE_HOME directory. If this is an issue at your site, have an authorized user create the link manually before you install Build Forge. At some sites the client may be installed on a file system that is mounted read-only (common practice with Solaris systems).

Installing Build Forge on Linux Platform with Oracle 21c

Prerequisite:

  • Install IBM IM version 1.9.0 or later version (64 bit)
  • Download the instantclient-basic-linux-21.14.0.0.0dbru.zip (32 bit) from Oracle site. - https://www.oracle.com/database/technologies/instant-client/linux-x86-32-downloads.html
  • Extract the downloaded instantclient-basic-linux-21.14.0.0.0dbru.zip (32 bit). For example: /opt/instantclient_21_14

  • Copy the tnsnames.ora from the Oracle server to the machine where Build Forge is getting installed.

    NOTE: tnsnames.ora can be found at path: ORACLE_HOME/network/admin/

  • Grant the full permission to the extracted instantclient_21_14 directory.

Variable settings on the system where the client and Build Forge are installed:

  • LD_LIBRARY_PATH (Solaris, Linux) or LIBPATH (AIX) includes /opt/instantclient_21_14
  • ORACLE_HOME=/opt/instantclient_21_14
  • PATH includes /opt/instantclient_21_14
  • TNS_ADMIN=<directory in which tnsnames.ora is copied>

Database configuration in IBM IM

NOTE: Make sure you have taken care of prerequisites before doing the following steps.

During the process of installing Build Forge:

1. In JAS Database connection page.

  • Database Type: select Oracle 21c
  • Database name: <ORACLE_SID>
  • Database username: For versions before Oracle 21c, <db_username> Eg: bf_test

    For Oracle 21c, c##<db_username> Eg: c##bf_test

  • Database password: database user password
  • JDBC Driver: The location where the instant client was extracted. Example: /opt/instantclient_21_14
  • Test the Database Configuration.

2. In Database Client Library Configuration page.

  • Path to Oracle Client Libraries: The location where the instant client libraries was extracted.
  • The ORACLE_HOME Environment variable: The location where the instant client libraries was extracted.
  • Path to tnsnames.ora file (TNS_ADMIN): The location where the tnsnames.ora file was copied.
  • Test the Database Configuration.

3. Continue with the remaining installation steps and complete Build Forge installation.

Important: The user running the Build Forge installer must have write access to the ORACLE_HOME directory. If this is an issue at your site, have an authorized user create the link manually before you install Build Forge. At some sites the client may be installed on a file system that is mounted read-only (common practice with Solaris systems).