Skip to content

Installing Sybase ASE Client in AIX 7.1

This post enumerate the high level step need to Install Sybase ASE client in AIX. Sybase ASE CTLib, ODBC and JDBC are include in the SDK.

Environment

  • IBM IAX 7.1
  • SAP Sybase IQ SDK 15.7

Steps

  1. Download the SDK 15.7 from SAP website (SDK1570136_0-11013483.TGZ).
  2. Decompress the SDK1570136_0-11013483.TGZ file on a temporary location.
  3. Change current directory to the ebf* directory (in this case ebf25033).
  4. Execute the file setup.bin and follow the installation instructions.

IBM InfoSphere DataStage: Connect to Oracle Data Sources Using Oracle InstanClient

This post explains how to configure IBM InfoSphere DataStage to connect to Oracle data sources using Oracle instanClient.

Environment

  • IBM IAX 7.1
  • Oracle instanClient 11.2.0.4.0
  • IBM InfoSphere DataStage 11.5

Prerequisites

Install and Configure Oracle InstanClient 11.2 on AIX

Procedure

  1. Add or modify the following environment variable in the dsenv file
    export ORACLE_HOME=//instantclient_11_2
    export TNS_ADMIN=$ORACLE_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
    
  2. Restart the DataStage engine and agents.

Useful Resource

IBM Knowledge Center, IBM InfoSphere Information Server, Setting the library path environment variable in the dsenv file

Install and Configure Oracle InstanClient 11.2 on AIX

This post explains how to install and configure Oracle InstanClient 11.2 on AIX 7.1

Environment

  • IBM IAX 7.1
  • Oracle instanClient 11.2.0.4.0

Installation and Configuration

  1. Download (from the oracle website):
    1. Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications; instantclient-basic-aix.ppc64-11.2.0.4.0.zip
    2. (Optional) Instant Client Package – JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC; instantclient-jdbc-aix.ppc64-11.2.0.4.0.zip
    3. (Optional) Instant Client Package – SQLPlus: Additional libraries and executable for running SQLPlus with Instant Client; instantclient-sqlplus-aix.ppc64-11.2.0.4.0.zip
    4. (Optional) Instant Client Package – ODBC: Additional libraries for enabling ODBC applications; instantclient-odbc-aix.ppc64-11.2.0.4.0.zip
  2. Unzip the files on a temporary folder. The unzip process will create an instantclient_10_2 directory in your current directory.
  3. Create a permanent directory where the Oracle instanClient will reside.
    mkdir /oracle
    
  4. Move the instanclient_11_2 directory to it permanent location.
    mv instanclient_11_2 /oracle
    
  5. Set the ORACLE_HOME environ variable to the permanent location of Oracle InstanClient.
    export ORACLE_HOME=/oracle/instanclient_11_2
    
  6. Create the sqlnet.ora file in the ORACLE_HOME directory.
    #example of content of sqlnet.ora file
    
    # Every line that begins with # is a comment line
    # You can modify the entry below for your own database.
    
    # sqlnet.ora Network Configuration File
    
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
    
  7. Create the tnsnames.ora file in the ORACLE_HOME directory.
    #example of content of sqlnet.ora file
    
    MyDBServer_DSN =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = MyDBServer)(PORT = 1521))
        (CONNECT_DATA =
          (SERVICE_NAME = MyServiceName)
        )
      )
    
  8. Set the TNS_ADMIN, SQLPATH and LD_LIBRARY_PATH
    export TNS_ADMIN=$ORACLE_HOME
    export SQLPATH=$ORACLE_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
    
  9. Test connectivity
    sqlplus myUser/myPassword@MyDBServer_DSN