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

have you compiled a list of the function names in the trace file, and searched for the, in MOS?

On Wed, Dec 1, 2021 at 09:04 Noveljic Nenad <nenad.noveljic_at_vontobel.com> wrote:

> We've created hundreds of 19.13 CDB databases in the last couple of
> months. Every now and then, catcdb.sql fails with "ORA-12269: client uses
> weak encryption/crypto-checksumming version". The subsequent execution runs
> without a problem.
>
>
>
> catcdb.sql runs the Perl program catcon.pl which, in turn, runs sqlplus
> scripts. The connection is bequeath.
>
>
>
> We setup the environment variables, so that Perl in Oracle home is used:
>
>
>
> CATCDB_SYS_PASSWD:....
>
> CATCDB_TEMPTS:TEMP
>
> LC_CTYPE:C.UTF-8
>
> LD_LIBRARY_PATH:/u00/oracle/orabase/product/19.13.0.0.211019_a/lib
>
> LIB_PYTHON:/export/home/oracle/workspace_xxxx/oracle_linux_tools/libpython
>
> ORACLE_BASE:/u00/oracle/orabase
>
> ORACLE_HOME:/u00/oracle/orabase/product/19.13.0.0.211019_a
>
> ORACLE_SID:CDBNAME
>
>
> PATH:/u00/oracle/orabase/product/19.13.0.0.211019_a/bin:/u00/oracle/orabase/product/19.13.0.0.211019_a/perl/bin:
>
> PWD:/export/home/oracle/workspace_vbnov/oracle_linux_tools/libpython
>
> SHLVL:2
>
> TNS_ADMIN:/u00/oracle/orabase/network/admin
>
>
>
> The captured call stack:
>
>
>
> ORA-12269: client uses weak encryption/crypto-checksumming version
>
> ----- SQL Statement (None) -----
>
> Current SQL information unavailable - no cursor.
>
>
>
> ----- Call Stack Trace -----
>
> calling call entry argument values in hex
>
> location type point (? means dubious value)
>
> -------------------- -------- --------------------
> ----------------------------
>
> ...
>
> kgeade()+392 call dbkePostKGE_kgsf() 7F37492729C0
> 7F3749110050
>
> 000002FED 000000000 ?
>
> 7FFEFBFA3748 ?
> 000000082 ?
>
> kgerelv()+137 call kgeade() 7F37492729C0 ?
> 7F3749272C08 ?
>
> 7F3749110050 ?
> 000002FED ?
>
> 000000000 000000000
>
> kserecl0()+189 call kgerelv() 7F37492729C0 ?
> 7F3749110050 ?
>
> 7F3749110050 ?
> 0134B62F0 ?
>
> 000000000 ? 000000000 ?
>
> ksulbem()+454 call kserecl0() 7F37492729C0 ?
> 7F3749110050 ?
>
> 7F3749110050 ? 0000007FF
>
> 000000000 006E9AD80
>
> opitsk()+3292 call ksulbem() 000000001 ? 000002FED ?
>
> 7FFEFBFA4E20 ?
> 0000007FF ?
>
> 000000000 ? 006E9AD80 ?
>
> opiino()+936 call opitsk() 000000000 000000000
>
> 7FFEFBFA4E20 ?
> 0000007FF ?
>
> 000000000 ? 006E9AD80 ?
>
> opiodr()+1202 call opiino() 00000003C 000000004
>
> 7FFEFBFA8F98 0000007FF ?
>
> 000000000 ? 006E9AD80 ?
>
> opidrv()+1094 call opiodr() 00000003C 000000004
>
> 7FFEFBFA8F98 ? 000000000
>
> 000000000 ? 006E9AD80 ?
>
> sou2o()+165 call opidrv() 00000003C 000000004
>
> 7FFEFBFA8F98 000000000 ?
>
> 000000000 ? 006E9AD80 ?
>
> opimai_real()+422 call sou2o() 7FFEFBFA8F70 00000003C
>
> 000000004 7FFEFBFA8F98
>
> 000000000 ? 006E9AD80 ?
>
> ssthrdmain()+417 call opimai_real() 000000000 7FFEFBFA9788
>
> 000000004 ?
> 7FFEFBFA8F98 ?
>
> 000000000 ? 006E9AD80 ?
>
> main()+256 call ssthrdmain() 000000000 000000002
>
>
>
> Any ideas how to approach this?
>
>
>
> Best regards,
>
>
>
> Nenad
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
>
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version.
> Please note that all e-mail communications to and from the Vontobel Group
> are subject to electronic storage and review by Vontobel Group. Unless
> stated to the contrary and without prejudice to any contractual agreements
> between you and Vontobel Group which shall prevail in any case,
> e-mail-communication is for informational purposes only and is not intended
> as an offer or solicitation for the purchase or sale of any financial
> instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Oracle ACE Alumni
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill

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