RE: tcp vs tcps on Oracle ADW

Your theory holds water, I’ll ask around to confirm.

From: Ludovico Caldara <ludovico.caldara_at_gmail.com> Sent: Monday, August 3, 2020 10:18 AM
To: rkarch_at_teleran.com
Cc: oracle-l_at_freelists.org
Subject: Re: tcp vs tcps on Oracle ADW

Hi,

I do not have the implementation details, but I know that ADB uses CMAN to proxy the connections instead of exposing the TCPS endpoint directly from the database.

It might be that CMAN hops the connection internally without using TCPS but just TCP... Just a random idea.

-- 

Ludo

Il giorno lun 3 ago 2020 alle ore 15:52 Robert Karch <HYPERLINK "mailto:rkarch_at_teleran.com"rkarch_at_teleran.com> ha scritto:

I have been struggling with setting up and communicating with an Oracle Database using SSL/TLS. In order to verify that I have the client side set up properly I have been testing with Oracle’s Autonomous Data Warehouse. I have had some success and some failures (already reported to Oracle). I encountered an unexpected result from my testing. When I execute the SQL:

SELECT SYS_CONTEXT('USERENV','NETWORK_PROTOCOL') FROM DUAL  

Oracle’s ADW it returns:           

tcp

rather than tcps which is what I would expect when connecting using (PROTOCOL=TCPS) and knowing that the connection requires a wallet. The same query issued on an on-prem database returns the tcps value. Is there a reason for this or is it a bug?

Kindest Regards,

Rob Karch

Software Architect

Teleran Technologies, Inc.

“Understanding Usage Is Everything”

--

http://www.freelists.org/webpage/oracle-l Received on Mon Aug 03 2020 - 16:37:18 CEST