Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IIB integration with oracle database with SSL(TSL)

RajatNovaApr 12 2016 — edited Apr 13 2016

Hi Gurus

We have a requirement to establish a SSL prtection for an interface between IIB(IBM integration bus) with Oracle database. As per my understandings enabling SSL on database requires advances security options "https://docs.oracle.com/cd/B28359_01/network.111/b28530/asossl.htm" with additional licesning.  --> The above is possible.

If we have an SSL enabled on database, can we configure the IIB interface using the description provided in the below link.

https://www.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/bk58070_.htm

Sample odbc.ini file ----

;# Oracle using SSL stanza

[ORACLESSLDB]

Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so

Description=DataDirect 7.1 ODBC Oracle Wire Protocol

HostName=<Your Oracle Server Machine Name>

PortNumber=<Port on which Oracle is listening on HostName>

ServiceName=<Your Oracle Service Name>

CatalogOptions=0

EnableStaticCursorsForLongData=0

ApplicationUsingThreads=1

EnableDescribeParam=1

OptimizePrepare=1

WorkArounds=536870912

ProcedureRetResults=1

ColumnSizeAsCharacter=1

LoginTimeout=0

AuthenticationMethod=1

EncryptionMethod=1

KeyPassword=<Your SSL Key Password>

KeyStore=<Your fully qualified key store file name>

KeyStorePassword=<Your SSL Key Store Password>

TrustStore=<Your fully qualified trust store file name>

TrustStorePassword=<Your SSL Trust Store Password>

ValidateServerCertificate=1

Any info around this info will be of great help!

Thanks in advance

Raj.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2016
Added on Apr 12 2016
3 comments
2,425 views