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

Document ID:  TEC1627935
Last Modified Date:  04/28/2016
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • Unicenter Job Management for ERP Applications

Releases

  • Unicenter Job Management for ERP Applications:Release:2.1.0

Components

  • Unicenter AutoSys Adapter for PeopleSoft:ATSYAP

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 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >