Performance Intelligence Center, Session Deletion Failed with Error: ORA-28040: No matching authentication protocol

Asset ID:	1-72-2154077.1
Update Date:	2017-11-12
Keywords:

Solution Type Problem Resolution Sure

Solution 2154077.1 : Performance Intelligence Center, Session Deletion Failed with Error: ORA-28040: No matching authentication protocol

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.5 to 10.1.5.1 [Release 10.0]
Information in this document applies to any platform.

Symptoms

Sessions cannot be deleted on a Oracle 12c DWS with error message:

JMX physical delete of Session <SESSION_NAME> failed, returned Exception: ORA-28040: No matching authentication protocol

Cause

There is a JDBC incompatibility between PIC and DWS version.

As per 401934.1, ojdbc14.jar is compatible up to Oracle 10. Oracle 12 is not compatible.

Solution

Workaround

If in doubt, open a SR to Support.

Following workaround must be applied on all both Active/Master and Standby/Master:

Log as cfguser
Stop JMX:
pm.set off JmxAgent
Wait 10 seconds to ensure it is stopped. pm.getprocs can be used to verify
Change to root user
Backup currently used driver in root home dir:
mv /usr/TKLC/TKLCdbrepl/jar/ojdbc14.jar ~
Copy updated version of the JDBC driver:
cp /usr/lib/oracle/11.2/client64/lib/ojdbc5.jar /usr/TKLC/TKLCdbrepl/jar/
Change back to cfguser:
exit
Start jmx and check there are no errors in startup sequence:
pm.set on JmxAgent; cf:follow $PROC/jmx_agent.log

Now, it is possible to delete session from NSP GUI.

Upgrade

PIC 10.2 have an updated version of the JDBC driver (jar).

References

<BUG:23662555> - SESSION DELETION ERROR: ORA-28040: NO MATCHING AUTHENTICATION PROTOCOL
<NOTE:2111118.1> - ORA-28040 Using JDBC Connection to 12c Database
<NOTE:1957995.1> - 12c: ORA-28040 After Upgrade: No Matching Authentication Protocol
<NOTE:401934.1> - Starting With Oracle JDBC Drivers

Attachments

This solution has no attachment