Re: tcp vs tcps on Oracle ADW
From: Ludovico Caldara <ludovico.caldara_at_gmail.com>
Date: Mon, 3 Aug 2020 16:17:44 +0200
Message-ID: <CALSQGrJ1oS5H66VE0t=+zBw0Droj_DXrTxjS0XZCdk=3knLAfg_at_mail.gmail.com>
Date: Mon, 3 Aug 2020 16:17:44 +0200
Message-ID: <CALSQGrJ1oS5H66VE0t=+zBw0Droj_DXrTxjS0XZCdk=3knLAfg_at_mail.gmail.com>
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 <rkarch_at_teleran.com> ha scritto:Received on Mon Aug 03 2020 - 16:17:44 CEST
> 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