Symptoms:
Running the PeopleSoft adapter against a PeopleSoft Oracle12c database may cause the following error as shown in the debug log:
PeopleSoft(35)->psdb_init: debug: SQLConnect succeeded
PeopleSoft(36)->ODBC_err: ERROR: SQLSTATE = 08003
PeopleSoft(37)->ODBC_err: ERROR: NATIVE ERROR = 0
PeopleSoft(38)->ODBC_err: ERROR: MSG = [DataDirect][ODBC lib] Connection not open
Environment:
PeopleSoft Adapter 2.10 with Oracle database 12c
Cause:
Oracle 12c by default will not accept earlier Oracle connection types that the ODBC drivers packaged with the PeopleSoft adapter uses.
Resolution:
Set the following in the Databases sqlnet.ora file. This will allow a login with a pre 12.0 connection protocol.
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8