Table of Contents

Search

  1. Preface
  2. Upgrade Overview
  3. Before You Upgrade the Domain on Linux
  4. Before You Upgrade the Domain on UNIX
  5. Before You Upgrade the Domain on Windows
  6. Prepare for the Upgrade
  7. Upgrade the Domain
  8. Upgrade the Domain with Changes to Node Configuration
  9. Before You Upgrade the Application Services
  10. Application Service Upgrade
  11. Informatica Client Upgrade
  12. After You Upgrade
  13. Appendix A: Upgrade Checklist
  14. Appendix B: Managing Distribution Packages

Upgrading from Version 10.2 (10.5.4)

Upgrading from Version 10.2 (10.5.4)

Step 6. Configure Database Client Environment Variables on UNIX

Step 6. Configure Database Client Environment Variables on UNIX

Configure database client environment variables on the machines that run the PowerCenter Integration Service process.
After you configure the database environment variables, you can test the connection to the database from the database client.
The following table lists the database environment variables you need to set:
Database
Environment Variable Name
Database Utility
Value
Oracle
ORACLE_HOME
PATH
LD_LIBRARY_PATH
TNS_ADMIN
INFA_TRUSTSTORE
sqlplus
Set to: <
Client InstallDatabasePath
>
Add: <
DatabasePath
>/bin and
USER_INSTALL_DIR/server/bin:$PATH
Set to:
$Oracle_HOME/lib
and
USER_INSTALL_DIR/server/bin:$LD_LIBRARY_PATH
Set to location of the tnsnames.ora file:
$ORACLE_HOME/network/admin
For default SSL domain, add to: USER_INSTALL_DIR/services/shared/security
For custom SSL domain, set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD
To set the private truststore files, you must manually import the certificates. Run the
keytool
command in the
<INFA_JDK_HOME>
directory to import the private truststore certificates. For example, use the following keytool command:
keytool -noprompt -importkeystore -srckeystore <source truststore file path> -srcstorepass <source truststore file password> -srcalias <alias> -srcstoretype JKS -destkeystore <destination truststore file path> -deststorepass <destination truststore file password> -keypass <private key password> -deststoretype JKS
SQL Server
ODBCHOME
ODBCINI
ODBCINST
PATH
LD_LIBRARY_PATH
INFA_TRUSTSTORE
Set to:
USER_INSTALL_DIR/ODBC7.1
Set to:
$ODBCHOME/odbc.ini
Set to:
$ODBCHOME/odbcinst.ini
Add to:
/opt/mssql-tools/bin:$PATH$PATH
USER_INSTALL_DIR/ODBC7.1:$PATH
USER_INSTALL_DIR/server/bin:$PATH
Add to:
$ODBCHOME/lib
USER_INSTALL_DIR/server/bin:$LD_LIBRARY_PATH
For default SSL domain, add to: USER_INSTALL_DIR/services/shared/security
For custom SSL domain, set INFA_TRUSTSTORE and INFA_TRUSTSTORE_PASSWORD
To set the private truststore files, you must manually import the certificates. Run the
keytool
command in the
<INFA_JDK_HOME>
directory to import the private truststore certificates. For example, use the following keytool command:
keytool -noprompt -importkeystore -srckeystore <source truststore file path> -srcstorepass <source truststore file password> -srcalias <alias> -srcstoretype JKS -destkeystore <destination truststore file path> -deststorepass <destination truststore file password> -keypass <private key password> -deststoretype JKS

0 COMMENTS

We’d like to hear from you!