Previous Topic

Next Topic

Book Contents

Configure post-upgrading environment settings for Oracle 19c

Configure the following settings in the InForm application server and the database server after you have upgraded the client and database from Oracle 12c to Oracle 19c.

In the InForm 6.3.1.2 application server:

  1. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\OracleHS\InForm in the registry and set the OracleHome key to the 19c Oracle Home KEY_OraClient19Home1.
  2. Under Environment Variables, move the c:\app\oracle\product\19c\client_1\bin path to the beginning of the Path variable.
  3. In the ODBC Data Source Administrator, point all the studies and InForm data source to Oracle in OraClient19Home1.

    Configure the following settings:

    • In the Application tab, tick the Enable Result Set and Enable Thread Safety checkboxes. Leave the rest of the checkboxes unticked.
    • In the Oracle tab, tick the Enable LOBs and Enable Failover checkboxes. Leave the rest of the checkboxes unticked.
    • In the Workarounds tab, tick the Force SQL_WCHAR Support, Bind NUMBER as FLOAT, and Disable RULE Hint checkboxes. Leave the rest of the checkboxes unticked.
    • In the SQLServer Migration tab, leave all the checkboxes unticked.

In the database server:

  1. Navigate to /scratch/app/oracle/product/19.0.0.0/network/admin/sqlnet.ora and configure the following entries in the sqlnet.ora file in the database.
    • SQLNET.INBOUND_CONNECT_TIMEOUT=60
    • SQLNET.EXPIRE_TIME=10
    • SQLNET.ENCRYPTION_SERVER=ACCEPTED
    • SQLNET.CRYPTO_CHECKSUM_SERVER=ACCEPTED
    • SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)
    • SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)
    • SQLNET.ENCRYPTION_CLIENT=REQUIRED
    • SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED
    • SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)
    • SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)
    • SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
Send Feedback