RE: catcdb.sql fails with ORA-12269: client uses weak encryption/crypto-checksumming version

Hello Nenad,

> Not sure what’s the difference.

"connect / as sysdba" uses the OS auth mechanism ($ORACLE_HOME/rdbms/lib/config.c -> #define SS_DBA_GRP “dba”) and "connect SYS/"manager" AS sysdba" uses the username/password mechanism.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Noveljic Nenad <nenad.noveljic_at_vontobel.com> hat am 04.01.2022 17:55 geschrieben:
>
>
> We’ve managed to narrow down the problem.
>
> We can reproduce the problem after running sqlplus _at_test_script.sql in a loop for a couple of minutes.
>
> The test_script.sql consists of the following single line:
>
> connect SYS/"manager" AS sysdba
> The connect string looks weird, but we just emulate how catcon runs sqlplus.
> The problem doesn’t reproduce with the “regular” connect string: “connect / as sysdba”.
> Not sure what’s the difference.
> If nobody knows, we’ll compare the code paths.

--
http://www.freelists.org/webpage/oracle-l