Tech note 21_01 - Connecting Oracle 19C to producer

Owned by Brandon Johnson (Unlicensed)
Last updated: Mar 15, 2022
1 min read

Connecting oracle 19c to procucer

Technote 21/00

Date: September 13th, 2020

Author: Brandon Johnson

Applicable Products: CardExchange® Producer

Connecting oracle 19c to producer

You will need to make a change to their sqlnet.ora file in your Oracle home directory (Under network\admin).

You need to add the following lines:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

CardExchange is using the client version 11 to connect, so you need to allow older clients to connect by adding these settings.

The Oracle data access components need to be installed manually, so you will need to download these from our website and install them.

Once done, you may also need to reset the password for the user account that CardExchange is using to connect, you can see some details in the oracle document here:

https://support.oracle.com/knowledge/Oracle%20Database%20Products/2296947_1.html