Alert Log "Invalid fix_control setting" messages - anyone seen these before?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Fri, 28 Aug 2020 14:09:30 -0400
Message-ID: <CAP79kiQB+wYOE71MDx=P=LwkfEzxE22thMn3XjMO8k+8p-WDJQ_at_mail.gmail.com>



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
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=20355502.8&id=27321179.8>*
Oracle says the fix for that bug was first included in  12.1.0.2.180417 (Apr 2018) Bundle Patch for Windows Platforms
<https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=27321179.8&id=245840.1#FIXED_WIN:C102P:180417>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 28 2020 - 20:09:30 CEST

Original text of this message