PeopleSoft plugin: Oracle error is: "ORA-28040 No matching authentication protocol" error.

Products

• Workload Automation Agent

Issue/Introduction

We have installed and configured the PeopleSoft plugin and since then the System Agent  no longer starts

Environment

System Agent release 11.3 SP7

PeopleSoft plugin installed

PeopleSoft database is Oracle 12c

 

Cause

In the PeopleSoft logs on the Systepm Agent, following exception was found:

"ORA-28040 No matching authentication protocol"

 

Resolution

Solution found at this URL: 

https://developer.ibm.com/answers/questions/177075/after-upgrading-to-oracle-12c-database-i-start-get/

This issue is reported many times within the community and has been resolved by updating the sqlnet.ora file with these two options: 
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8.

Then restart the Oracle listener (sitting on the Oracle dataserver)