Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 55F761003020A4 for ; Sun, 26 Dec 2021 19:19:54 +0100 (CET) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 6F1754038D; Sun, 26 Dec 2021 18:19:52 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 56E0A46EC0; Sun, 26 Dec 2021 18:19:52 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1640542792; bh=T8fg1XH1nTJA9uJHf2jUgOY9MHg4cuQzu/gIeY3/6LM=; h=From:Sender:Sender:From; b=lGJPhXafEvbIM1QiMvCOJc8s7FwzjhZymYOdoXXYquBPpMEhT5s1mQ+f+ivKlrYgr BgN2n9wQmHxtB12DR46017H53zTf8bElNOVNrojVcjlnKLjgNOlqOLLTPFO9hKyDKm 8KfFSDCiYwVeAKMxqzcLwnRn132eV81sgbi4VagI= X-Virus-Scanned: by FreeLists at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0tNKjHp3kYt9; Sun, 26 Dec 2021 18:19:52 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 2F7F946EC5; Sun, 26 Dec 2021 18:19:49 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1640542790; bh=T8fg1XH1nTJA9uJHf2jUgOY9MHg4cuQzu/gIeY3/6LM=; h=From:Sender:Sender:From; b=eyX2cVYdYv4dvkF7ySoCqSi711gCLEQ6G4vKMMTJ2m3UylcPd/yc3aYAEHT/XncIT kE7gERnXu8QIlQfjnnWEPZpLPfiBUCXNovred4H+D6xW1qp8OPJLKW1EyIf/Nxppwr DA2rW2pUF2wNK28mtWnJJ5a7RiHrwj1Knn4b/elI= Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 26 Dec 2021 18:19:47 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 54CA246EC0 for ; Sun, 26 Dec 2021 18:19:47 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.a=rsa-sha256 header.s=20210112 header.b=bK14qPpb; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id eXAEv8M71j-y for ; Sun, 26 Dec 2021 18:19:47 +0000 (UTC) Received: from mail-pl1-f170.google.com (mail-pl1-f170.google.com [209.85.214.170]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id 4174646EBE for ; Sun, 26 Dec 2021 18:19:47 +0000 (UTC) Received: by mail-pl1-f170.google.com with SMTP id h6so6158396plf.6 for ; Sun, 26 Dec 2021 10:19:47 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=OnlBh+4484yGajGzQoj9gBCssBvSvy4AA9jhgH5CCVs=; b=vmEPs5A8AEmX4aKGjoky4ODfZSCPujFW62bpk29pt/07VRGKsZS3hsbbVf10x0GCXn xpUJ4nCElCw9DH7zzsdO2X78cRtjQrIEO/NUrvbpPPurhUxFrh7qyDzoSKRDKunT69sR kAI3SVZFptX35wBx9k5FKKfd9DWXtmX4oXx+aKhZY2Npg2r2BJ70Zp59+UnlBZt2rTDO S0Qkboifo0ZNp1HE3pxJtxOYHPkX65o23jKLq69je/+UH8gU2UXd+2ACC5ufdfHapcuX n7hNHlRTqnNPF1zg8MavcuX2QFmrIF6hLjp5HsEI0CIQVZwUvp+U+guxLhjFOGGVSUtp eFDA== X-Gm-Message-State: AOAM532tJm6k1wolcP/IpftXO018j8XjLXkgobnWLJMla4d5CF4oJNUP ne+d6RPIF2vs8esN5Y7bmJyo1YBHOJ5x3R0QjXkBYXx4PJsg2g== X-Google-Smtp-Source: ABdhPJyi8qB7Ie9UbmXDpqyWy7/gelfMI1b/eUyBQ8vgDgLIAde8M0VR/c89YaJRFFmYRSWiIytUJ5oEfW0CZn9GRKU= X-Received: by 2002:a17:90b:4b41:: with SMTP id mi1mr5648163pjb.213.1640542786241; Sun, 26 Dec 2021 10:19:46 -0800 (PST) MIME-Version: 1.0 References: <407734b81ca34fe78ebc53e94e8dfae5@vontobel.com> <9f93ff0d83e54cdabf7574f63761e759@vontobel.com> <889e0ad677b3493bafe20a205031b6c0@vontobel.com> In-Reply-To: <889e0ad677b3493bafe20a205031b6c0@vontobel.com> From: Jared Still Date: Sun, 26 Dec 2021 10:19:34 -0800 Message-ID: Subject: Re: catcdb.sql fails with ORA-12269: client uses weak encryption/crypto-checksumming version To: Noveljic Nenad Cc: "Mark J. Bobak" , ORACLE-L Content-Type: multipart/alternative; boundary="0000000000000348f305d410a29a" X-archive-position: 81633 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --0000000000000348f305d410a29a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable A 10079 trace may be useful First set 10046 to create the trace file, then 10079, with level 1 for network ops. /* 10079, 00000, "trace data sent/received via SQL*Net" *Cause: *Action: level 1 - trace network ops to/from client level 2 - in addition to level 1, dump data level 4 - trace network ops to/from dblink level 8 - in addition to level 4, dump data */ -- all attempts to set with alter session result in ora-0131 insufficient privileges --alter session set events '10079 trace name context forever, level 1'; oradebug setmypid oradebug event 10079 trace name context forever, level 1 I haven't tried this in a couple years, but when I did, the 10046 event was necessary to create the tracefile. 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 On Wed, Dec 1, 2021 at 11:16 PM Noveljic Nenad wrote: > It=E2=80=99s bequeath. It should, though, work in both cases. > > > > The problem isn=E2=80=99t reproducible at will. > > > > *From:* Mark J. Bobak > *Sent:* Donnerstag, 2. Dezember 2021 07:35 > *To:* Noveljic Nenad > *Cc:* ORACLE-L ; Jared Still > *Subject:* Re: catcdb.sql fails with ORA-12269: client uses weak > encryption/crypto-checksumming version > > > > **** E-Mail from outside Vontobel:* Do not click on links or open > attachments unless you know the content is safe. *** > > Ok, another question: > > Is it BEQUEATH or IPC? > > > > If it's IPC, it still goes through the listener, and at least some of > the. SQL*Net settings/parameters still apply... (I think...) > > > > I think it's at least worth taking a closer look... > > > > > > ____________________________________________________ > > 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 addresse= e > 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. Al= so > 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 us= e > is excluded. You are advised that urgent and time sensitive messages shou= ld > 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 agreement= s > between you and Vontobel Group which shall prevail in any case, > e-mail-communication is for informational purposes only and is not intend= ed > 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 legitimat= e > interest to develop a commercial relationship with you, as well as your > consent to forward you commercial communications. You can exercise, at an= y > time and under the terms established under current regulation, your right= s. > 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 gro= up > entity the corporate e-mail signature. For further information about data > privacy at Vontobel Group please consult www.vontobel.com. > --0000000000000348f305d410a29a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
A 10079 trace may be useful

= First set 10046 to create the trace file, then 10079, with level 1 for netw= ork ops.

/*
=C2=A010079, 00000, "trace data sen= t/received via SQL*Net"
=C2=A0*Cause:
=C2=A0*Action: level 1 - t= race network ops to/from client
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 level= 2 - in addition to level 1, dump data
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 level 4 - trace network ops to/from dblink
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 level 8 - in addition to level 4, dump data
*/

-- all = attempts to set with alter session result in ora-0131 insufficient privileg= es
--alter session set events '10079 trace name context forever, lev= el 1';
oradebug setmypid
oradebug event 10079 trace name con= text forever, level 1

I haven't tried this= in a couple years, but when I did, the 10046 event was necessary to create= the tracefile.


Jared St= ill
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal C= onsultant at Pythian
Oracle ACE Alumni


On Wed, Dec 1, 2021 at 11:16 PM Noveljic Nenad <nenad.noveljic@vontobel.com> wrot= e:

It=E2=80=99s bequea= th. It should, though, work in both cases.

=C2=A0

The problem isn=E2= =80=99t reproducible at will.

=C2=A0

From: Mark J. Bobak <mark@bobak.net>
Sent: Donnerstag, 2. Dezember 2021 07:35
To: Noveljic Nenad <nenad.noveljic@vontobel.com>
Cc: ORACLE-L <oracle-l@freelists.org>; Jared Still <jkstill@gmail.com>
Subject: Re: catcdb.sql fails with ORA-12269: client uses weak encry= ption/crypto-checksumming version

=C2=A0

*** E-Mail from outside Vontobel:= =C2=A0Do not click on links or open attachments unless you know the content is safe. ***

Ok, another question:

Is it BEQUEATH or IPC?

=C2=A0

If it's IPC, it=C2=A0 still goes through=C2=A0 t= he listener,=C2=A0 and at least=C2=A0 some of the. SQL*Net=C2=A0 settings/p= arameters still apply... (I think...)

=C2=A0

I think it's at least worth taking a closer look= ...

=C2=A0

=C2=A0

_________= ___________________________________________

Please co= nsider 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 conf= idential or privileged information. If you are not the named addressee you = should in particular not disseminate, distribute, modify or copy this e-mai= l. Please notify the sender immediately by e-mail, if you have received thi= s message by mistake and delete it from your system.
Without prejudice to any contractual agreements between you and us which sh= all prevail in any case, we take it as your authorization to correspond wit= h 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 t= ime 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 p= rocessing of incoming e-mails cannot be guaranteed. All liability of Vontob= el Holding Ltd. and any of its affiliates (hereinafter collectively referre= d to as "Vontobel Group") for any damages resulting from e-mail u= se is excluded. You are advised that urgent and time sensitive messages sho= uld 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 a= re subject to electronic storage and review by Vontobel Group. Unless state= d to the contrary and without prejudice to any contractual agreements betwe= en you and Vontobel Group which shall prevail in any case, e-mail-communica= tion 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 con= sent to forward you commercial communications. You can exercise, at any tim= e 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 corpora= te e-mail signature. For further information about data privacy at Vontobel Group please consult= =C2=A0www.vontobel.c= om.

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