Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Connections for Oracle
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Setting environment variables

Setting environment variables

To use Kerberos authentication to connect to Oracle, you need to set the required environment variables on the Secure Agent machine.
Set the following environment variables:
  • setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>
  • setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
  • setenv JAASCONFIG <Absolute path of the JAAS config file>\<File name>.conf
After you set the environmental variables, you need to restart the Secure Agent.
Alternatively, you can add the environment variables when you create an Oracle connection.
To add the environment variables when you configure a connection and use Kerberos authentication, you need to add the
KRB5_CONFIG
,
KRB5CCNAME
, and
JAASCONFIG
properties in the
Metadata Advanced Connection Properties
field in an Oracle connection.
For example, add the properties in the following format:
KRB5_CONFIG=<Absolute path of the Kerberos configuration file>\krb5.conf;KRB5CCNAME=<Absolute path of the credential cache file>/<File name>;JAASCONFIG=<Absolute path of the JAAS config file>\<File name>.conf
Ensure that you separate each key-value pair with a semicolon.

0 COMMENTS

We’d like to hear from you!