How to Configure DataExport with Oracle 12c Database ?

Asset ID:	1-71-2157444.1
Update Date:	2016-10-05
Keywords:

Solution Type Technical Instruction Sure

Solution 2157444.1 : How to Configure DataExport with Oracle 12c Database ?

Applies to:

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

Goal

With the default configuration, DataExport process is not able to export XDRs from an Oracle 12C database. This is typically the case with PIC 10.1.5 when using an ODA as DWS, in such a case any attempt to export XDRs will result in Oracle error:

ORA-28040: No matching authentication protocol

Solution

In order to fix the authentication issue between DataExport and Oracle Database 12c, the /opt/TKLCdataexport/prod/bin/runDataExport script must be replaced by the one attached to this Knowledge document.

Here is how to proceed:

Log on the IXP base server as cfguser and stop dataexport process:

pm.set off DataExport
Replace /opt/TKLCdataexport/prod/bin/runDataExport with the one attached to this document
To avoid Windows/Unix text file issue convert it:

dos2unix /opt/TKLCdataexport/prod/bin/runDataExport
Start datatexport process:

pm.set on DataExport
Verify that export as processed properly

Attachments

This solution has no attachment