Your theory holds water, I’ll ask around to confirm.
From: Ludovico Caldara <ludovico.caldara@xxxxxxxxx>
Sent: Monday, August 3, 2020 10:18 AM
To: rkarch@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx"rkarch@xxxxxxxxxxx> 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”