WCI Portal Fails to Start When Enabling Connection To Oracle DB Over SSL (Doc ID 1353669.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle WebCenter Interaction - Version 10.3.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2014***

Symptoms

After configuring WebCenter Interaction (WCI) to connect to an Oracle database using SSL, the portal fails to start and generates the following error in PTSPY:

54 portal.tnp10301oi.Administrator 12-23-2009 13:33:42.312 Error OpenKernel.Database .NET #1 com.plumtree.openkernel.impl.db.DatabaseService Exception acquiring database connection
DDTek.Oracle.OracleException: [542] TNS-00520 TNS:SSL Handshake failed
at DDTek.Oracle.Wire.OracleCommunication..ctor(OracleSession session, TnsAddress address, String sslServerName, Int32 timeout)
at DDTek.Oracle.OracleSession.MakeConnectionHelper(TnsConnectDescriptorconnectDescriptor)
at DDTek.Oracle.OracleSession.MakeConnection()
at DDTek.Oracle.OracleSession.ConnectAndAuthenticate(Int32 combination)
at DDTek.Oracle.OracleSession.Connect()
at DDInt.Common.CommonSession.Open()
at DDInt.Common.CommonSessionPool.GetSession(Transaction transaction)
at DDInt.Common.CommonSessionFactory.GetSession(Object owningObject,CommonConnectionOptions connectionOptions, Boolean skipLicCheck)
at DDTek.Oracle.OracleConnection.Open()
at com.plumtree.openkernel.impl.db.DatabaseService.GetConnection() in e:\buildroot\Release\openmanagement\4.1.x\opendb\build\x86\src\csharp\com\plumtree\openkernel\impl\db\DatabaseService.cs:line 1348

Changes

Follow these steps to reproduce this problem:

1. Configure the Oracle DB to accept SSL connections.
2. Configure the WCI Portal to connect to the Oracle DB over SSL with
settings like these:

<setting name="database-connection:ssl-enable">
   <value xsi:type="xsd:boolean">true</value>
</setting>
<setting name="database-connection:tnsnames-file">
   <value xsi:type="xsd:string">F:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora</value>
</setting>
<setting name="database-connection:tnsnames-data-source">
   <value xsi:type="xsd:string">PLUM10SSL</value>
</setting>
<setting name="database-connection:truststore-location">
   <value xsi:type="xsd:string">f:\oracle\client_wallet</value>
</setting>
<setting name="database-connection:truststore-password">
   <value xsi:type="xsd:string">Welcome1</value>
</setting>


3. Try to start the portal.
4. Observe the error TNS-00520 TNS:SSL Handshake failed in PTSPY.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms