My Oracle Support Banner

OFSAA Database Master Screen not Able to Connect Using Sockets Direct Protocol (SDP) (Doc ID 2283479.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.3 and later
Information in this document applies to any platform.
OFSAA - Oracle Financial Services Analytical Applications
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
SDP - Sockets Direct Protocol

Symptoms

On OFSAA 8.0.3, it appears that the OFSAA database master screen is not able to connecting with Sockets Direct Protocol (SDP).

The new requirement is to change TCP to SDP protocol.

When attempting to change this in the OFSAA 8 Database Master screen, an error message is displayed.

ERROR
Current JDBC Connection String* -> jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = <SERVICE NAME>)))

New SDP string :-> jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = SDP)(HOST = <HOST NAME/IP>)(PORT = 1522))(ADDRESS = (PROTOCOL = SDP)(HOST = <HOST NAME/IP>)(PORT = 1522)) (ADDRESS = (PROTOCOL = SDP)(HOST = <HOST NAME/IP>)(PORT = 1522)) (ADDRESS = (PROTOCOL = SDP)(HOST =<HOST NAME/IP>)(PORT = 1522))) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = <SERVICE NAME>)))

Error message is also thrown in the App Server log file:

[UMMLOG] May 15,17 13:25:04 : [SMSSERVICES]IO Error: The Network Adapter could not establish the connection (See attached log for more details)

Changes

 

Cause

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
Symptoms
Changes
Cause
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.