PCG 7.3.3: Installation on EBS 12.2.4 on 12c Database Fails With "ORA-28040: No matching authentication protocol" (Doc ID 2041351.1)

Last updated on OCTOBER 13, 2022

Applies to:

Symptoms

On : 7.3.3 version, Install

When attempting to run DB component of PCG 7.3.3 on EBS 12.2.4 with 12c Database, the following error occurs.

ERROR
-----------------------
ValidateDBAction::validateXXLAAPPS::Instantiated DBConnection
ValidateDBAction::validateXXLAAPPS::Failed to open Connection
Exception Message : ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
  at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)

Got following ERROR at End:
---------------------------------------------
Unable to connect to the specified database
Verify the provided database details
Contact Oracle Support if this problem persists
 ->1- Enter Again
  2- Abort Install


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Verify that from EBS Application server, able to connect to XXLAAPPS and APPS users using following:
sqlplus XXLAAPPS/<xxlaapps_password>@<EBS_SID>

sqlplus APPS/apps_password>@<EBS_SID>

2. Confirm that Index Tablespace does exist in Database.

3. Verify the TNS entry.
4. Run the installer again after setting the debug variable:
export LAX_DEBUG=1
ladbinstall.bin -i console

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot proceed with PCG Installation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.