My Oracle Support Banner

Is there support for the TCPS protocol when Accessing The Oracle DB ? (Doc ID 2471929.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Goal

On : 8.6 version, Information Manager Console

Is there support for the TCPS protocol?

It is required the communication between Database and mid-tier should be using TCPS protocol instead TCP. After the upgrade the database connection the IM instance is failing with the following error.

3360 [ProcessChangesQueue] INFO com.inquira.foundation.utilities.Application - ABOUT TO CHECK DB
CHECKING APP STATUS
3377 [ProcessChangesQueue] WARN er.extensions.eof.ERXModelGroup - Clearing previous class descriptions
JDBCURL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = DB.qa.anycompany.com)(PORT = 3884))(FAILOVER = on)(LOAD_BALANCE = off))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Server_Machine1)))
JDBCDriver: oracle.jdbc.OracleDriver
[GC (Metadata GC Threshold) 1736731K->200474K(7851008K), 0.2097090 secs]
[Full GC (Metadata GC Threshold) 200474K->178698K(7851008K), 0.7568170 secs]
6080 [ProcessChangesQueue] ERROR com.inquira.foundation.utilities.Application - Could not retrieve database password
com.inquira.infra.security.OKEncryptionException: [ProcessChangesQueue @ Tue Jul 03 08:51:44 PDT 2018] Unable to decrypt string
  at com.inquira.infra.security.OKResourceEncryption.decryptResource(OKResourceEncryption.java:181)
  at com.inquira.foundation.utilities.Application.getDatabasePassword(Application.java:522)

How do we configure the JDBC connection?
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


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