search cancel

After upgrading from Oracle 11.2.0.4 to 12c PeopleSoft adapter jobs no longer run.

book

Article ID: 41687

calendar_today

Updated On:

Products

CA Unicenter NSM

Issue/Introduction

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 

Environment

Release:
Component: UNINPO