Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 8217A1003E1AF4 for ; Fri, 28 Aug 2020 20:11:18 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1DC7921B80; Fri, 28 Aug 2020 14:11:17 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1598638277; bh=BEhzJBKYWswuZmsp/FScl/1eNRjMUmpurhpEnwJr034=; h=From:Sender:Sender:From; b=RTPySMWNGpWnpGYKpQJw9nj744kyhKsFCDG6jjXeVY1aR5mGCM7j0+qeYlAz73wvP KF70WSTyEenKqtNKLKmxYIsvb0X9wwBHbnekh1KhlV/Ny8nBFHwuxLhxfClI7fu7+w KKbHHg9co2mFDFdQFeWqL0winZhn+OOeFnqTSm4g= X-Virus-Scanned: Debian amavisd-new 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 iL162CW4nNW6; Fri, 28 Aug 2020 14:11:16 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8733122A13; Fri, 28 Aug 2020 14:10:28 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1598638272; bh=BEhzJBKYWswuZmsp/FScl/1eNRjMUmpurhpEnwJr034=; h=From:Sender:Sender:From; b=mVGI+CXrZa7sOkv7E5kvzLytqqN5SBR+e9GrGVANtYkMRCPhGcrOcEmGhNv9VgA7D uBBaHh+HaVXUf8f3tSUQI8mj456y9yQJ35G1XCNVI8VTarpV3r2DoA3F3ndhKekTXe nfpBXmJ6uA6SD/GKQ7rB+94zBEoE/sJp88d/SSE8= Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 28 Aug 2020 14:09:43 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D95929609 for ; Fri, 28 Aug 2020 14:09:43 -0400 (EDT) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.b="lPhV4wvZ"; 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 rok8dpqDtnp4 for ; Fri, 28 Aug 2020 14:09:43 -0400 (EDT) Received: from mail-io1-f51.google.com (mail-io1-f51.google.com [209.85.166.51]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 110E0295FA for ; Fri, 28 Aug 2020 14:09:42 -0400 (EDT) Received: by mail-io1-f51.google.com with SMTP id l8so2311410ios.2 for ; Fri, 28 Aug 2020 11:09:42 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=6ar13h+BVuBGM/ukNY/IlDwzRHQH30vqPy/pWSnyZ98=; b=GewXkpEmKGOUA7htEOPXEPoRwlt6zatC3ZLnDnudL9H6vUvHzq31RI8o0N97ajyFJr Z8KK3/27kXmaYyQgnwln54Q+fTfYjqH7OKxWRjJntP78APwHzMC7yY4xXG58WOIhKDsJ qAjusYfOQhnsHnbpWThaTYhru7jF6aY3D/0LTQpqEWIwA+rApMkSVpf6QjzjwI5vlNhq fI9eR1iQBB0I3sAPyl2NTYz4uIqQ9CdeIfr75AmfWiBX5GHmg/tO5fCHaq6QGJZ45bE1 WKhg/MwHRax+mvaVxHxkErRHmxQO1ChD7RBAFCX7nDT0ZspTKoVxutTZZglbq1OiAA8H 4YRA== X-Gm-Message-State: AOAM532ucbkQUHEW89iLc2BlwZmpxeBzgP3fq0VoP31arJwV/dROBWSJ rAlxF9Fx23GvGrzqj07AZ5i81Yp3JaxNP+gQrARY8UQQKf8= X-Google-Smtp-Source: ABdhPJxtjUMkD9bfmIKe1gO/Bl7H3P7ZbdcoAoIqNtYSytKJn4+AG8Z6G+7YZicGx6rA46mzVlFhly2Ya0qN7ogr4XI= X-Received: by 2002:a02:cce8:: with SMTP id l8mr2275475jaq.67.1598638182053; Fri, 28 Aug 2020 11:09:42 -0700 (PDT) MIME-Version: 1.0 From: Chris Taylor Date: Fri, 28 Aug 2020 14:09:30 -0400 Message-ID: Subject: Alert Log "Invalid fix_control setting" messages - anyone seen these before? To: ORACLE-L Content-Type: multipart/alternative; boundary="000000000000f73aaa05adf3f41a" X-archive-position: 77613 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: christopherdtaylor1994@gmail.com Precedence: normal Reply-To: christopherdtaylor1994@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 --000000000000f73aaa05adf3f41a Content-Type: text/plain; charset="UTF-8" Env: 12.1.0.2 Linux x86-64 We just applied the JUL2020 Patch for 12.1.0.2 for a database that had previously been on 2018.07 BP. (JUL 2018) Now I'm seeing these messages in the alert log. Looking at the patch for Bug (20355502) says it was superceded by *Bug:27321179 * Oracle says the fix for that bug was first included in 12.1.0.2.180417 (Apr 2018) Bundle Patch for Windows Platforms Looking at our Current Oracle Inventory (source database) I see: Patch 29043782 : applied on Thu Jan 10 12:31:17 EST 2019 Unique Patch ID: 22622184 Created on 13 Dec 2018, 17:26:13 hrs PST8PDT Bugs fixed: 17969866, 18650065, 18793246, 20236523, 20493163, 20548904, 20636003 20807398, 21117072, 21128593, 23182225, 25139545, 26151631, 26196152 27321179, 27487279 This patch overlays patches: 27547374 This patch needs patches: 27547374 as prerequisites That Patch is: Patch 29043782: MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.180717 FOR BUGS 28317860 17969866 So here's my question. Do I need to go find the equivalent of that Merge Request for the JUL2020 BP ? Also I'm wondering if I could just remove the fix control setting for these hinted SQL_IDs ? Invalid fix_control setting 20355502:8 found in hint: sql_id=d7brauqmax202 Invalid fix_control setting 20355502:8 found in hint: sql_id=9g8883366b6ut Invalid fix_control setting 20355502:8 found in hint: sql_id=ark2vjdbuhqzq Invalid fix_control setting 20355502:8 found in hint: sql_id=02f8wphr22kmn Invalid fix_control setting 20355502:8 found in hint: sql_id=9avncq0yk5huc Invalid fix_control setting 20355502:8 found in hint: sql_id=5p60s25btd9vw Invalid fix_control setting 20355502:8 found in hint: sql_id=d3njq4dvvfcp3 Invalid fix_control setting 20355502:8 found in hint: sql_id=b4xhw7j41rzq0 Invalid fix_control setting 20355502:8 found in hint: sql_id=0cxs1f8xtfgrq Invalid fix_control setting 20355502:8 found in hint: sql_id=2p8c7d9u4j567 --000000000000f73aaa05adf3f41a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Env: 12.1.0.2=C2=A0 Linux x86-64

W= e just applied the JUL2020 Patch for 12.1.0.2 for a database=C2=A0that had = previously been on 2018.07 BP. (JUL 2018)

Now I'm = seeing these messages in the alert log.

Looking at the= patch for Bug (20355502) says it was superceded by=C2=A0=C2=A0Bug:27321179
Oracle says the fix for that b= ug was first included in
=C2=A012.1.0.2.180417 (Apr 2018) Bundle Patch for Windows= Platforms

Looking at our Current Oracle Inventory (source = database) I see:

Patch =C2=A029043782 =C2=A0 =C2=A0 : = applied on Thu Jan 10 12:31:17 EST 2019
Unique Patch ID: =C2=A022622184<= br>=C2=A0 =C2=A0Created on 13 Dec 2018, 17:26:13 hrs PST8PDT
=C2=A0 =C2= =A0Bugs fixed:
=C2=A0 =C2=A0 =C2=A017969866, 18650065, 18793246, 2023652= 3, 20493163, 20548904, 20636003
=C2=A0 =C2=A0 =C2=A020807398, 21117072, = 21128593, 23182225, 25139545, 26151631, 26196152
=C2=A0 =C2=A0 =C2=A0273= 21179, 27487279
=C2=A0 =C2=A0This patch overlays patches:
=C2=A0 =C2= =A0 =C2=A027547374
=C2=A0 =C2=A0This patch needs patches:
=C2=A0 =C2= =A0 =C2=A027547374
=C2=A0 =C2=A0as prerequisites

<= div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif= ">That Patch is:=C2=A0=C2=A0<= td class=3D"gmail-xve" style=3D"font-family:Tahoma,Verdana,Helvetica,sans-s= erif;padding:0px;overflow:hidden;white-space:nowrap;vertical-align:middle;d= isplay:block;font-weight:bold;font-size:14px">

Patch 29043782: MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2= .180717 FOR BUGS 28317860 17969866

=C2=A0=

So here= 's my question.=C2=A0 Do I need to go find the equivalent of that Merge= Request for the JUL2020 BP ?

Also I'm wondering i= f I could just remove the fix control setting for these hinted SQL_IDs ?


Invalid fix_control setting 20355502:8 foun= d in hint: sql_id=3Dd7brauqmax202
Invalid fix_control setting 203= 55502:8 found in hint: sql_id=3D9g8883366b6ut
Invalid fix_control settin= g 20355502:8 found in hint: sql_id=3Dark2vjdbuhqzq
Invalid fix_control s= etting 20355502:8 found in hint: sql_id=3D02f8wphr22kmn
Invalid fix_cont= rol setting 20355502:8 found in hint: sql_id=3D9avncq0yk5huc
Invalid fix= _control setting 20355502:8 found in hint: sql_id=3D5p60s25btd9vw
Invali= d fix_control setting 20355502:8 found in hint: sql_id=3Dd3njq4dvvfcp3
I= nvalid fix_control setting 20355502:8 found in hint: sql_id=3Db4xhw7j41rzq0=
Invalid fix_control setting 20355502:8 found in hint: sql_id=3D0cxs1f8x= tfgrq
Invalid fix_control setting 20355502:8 found in hint: sql_id=3D2p8= c7d9u4j567
--000000000000f73aaa05adf3f41a-- -- http://www.freelists.org/webpage/oracle-l