PeopleSoft Tool 8.59

Products

• CA Workload Automation AE

Issue/Introduction

As part of Data-in-transit (RAP-994) project the DBA/DB SSL will be enabled on PeopleSoft Oracle DBs / DB hosts.

This requires clients connect to DB SSL port 1531 instead of 1521. 

Is there a way to change the ODBC to use port 1531 vs 1521?

Environment

Release : 11

Component : AutoSys JM Adapter for PeopleSoft 2.1.0 R11

Resolution

The port can be updated in odbc.ini under $ODBC_HOME.

The following setting also needs to be added in odbc.ini for SSL connection to the PeopleSoft database (Oracle):

ValidateCertificate=0
TrustStore=/opt/oracle/product/wallet/<<Certificate name>>
TrustStorePassword=
EncryptionMethod=1