Re: sqlcl 19c Databases

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 1 Sep 2020 23:32:31 +0300
Message-ID: <CAOVevU7yBSE7w_CgkxzivLBc+cfW9u04RnfLA0mtBdMun_Hrjw_at_mail.gmail.com>



Hi Richard,

Try to set disable_oob=on in sqlnet.ora: https://twitter.com/xtner/status/1278174165032460288

https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-42E939DC-EF37-49A0-B4F0-14158F0E55FD

On Tue, Sep 1, 2020 at 11:11 PM Richard Ignizio <richard.ignizio_at_cbrands.com> wrote:

> Hello,
>
>
>
> I am trying to connect to a 19.6 database via sqlcl and I am getting the
> following error message:
>
>
>
> bin % ./sql -S -L user/pass_at_//scan-address:1521/service_name
>
>
>
>
>
> USER = rignizio
>
> URL = jdbc:oracle:oci8_at_//scan-address:1521/service_name
>
> Error Message = ORA-12571: TNS:packet writer failure
>
> USER = rignizio
>
> URL = jdbc:oracle:thin_at_//scan-address:1521/service_name
>
> Error Message = IO Error: Invalid argument, Authentication lapse 0 ms.
>
>
>
> When I connect to a non 19c database on the same cluster I can connect
> just fine.
>
> I have tried the different versions of java and none worked.
>
>
>
> Thanks,
>
>
>
> Richard Ignizio
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 01 2020 - 22:32:31 CEST

Original text of this message