Sunday, January 22, 2023

Total 73 bugs fixed in Jan-2023 Oracle 21c updates (21.9RU)

 

Total 73 bugs fixed in Jan-2023 Oracle 21c updates (21.9RU)

BUG_ID
DESCRIPTION
31649223COMPILE WARNINGS IN SKGCE.C
32115403DB STARTUP FAILS WITH ORA-600 [IPC ASSERT], [IPCOR_MEM.C 381 SZ > 0] AFTER APPLYING A MERGE PATCH 31940707
32372554PROVIDE ABILITY TO CONFIGURE CUSTOM DNS SERVICE PROVIDER ON A PER CONNECTION BASIS
32573197XF23.1SEC_UNIAUD_FGA - DIF - TKDP - > ORA-28112 FAILED TO EXECUTE POLICY FUNCTI
32651773ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [__INTEL_AVX_REP_MEMCPY()+740] [SIGSEGV] [ADDR 0X0] [PC 0X6D20E64] [SI_KERNEL(GENERAL_PROTECTION)] [] >
32763544ALTER SYSTEM SET INMEMORY_SIZE = SCOPE = ON PDB LEVEL RESULTS IN ORA-02096
32770651SITE$ TABLE NEEDS TO BE UPDATED WHEN DBID, CONNECT IDENTIFIER, ETC. ARE CHANGED
32897679RAC OPEN APPLICATION PDB HANG WITH CHAIN CPU OR WAIT CPU<=BUFFER BUSY WAITS ON APP ROOT
32912828PATH ENGINE NEEDS TO ALLOW ANYSCALAR RETURNS
32926513GOLDEN GATE LOG MINER IS NOT GIVING PREFERENCE TO FRA LOGS
32935045JSON STRESS SIGNIFICANTLY HIGHER MEMORY (POSSIBLE MEMORY LEAK) RESULTING IN ORA-4036 USED BY APIS WORKING ON GEO SPATIAL DATA WHILE RUNNING MONGO DRIVER WORKL
32958616OPTIMIZE CONTROL FILE I/O UNDER KCCREC_RBL<-KCCREC_READ_WRITE<-KCCUGG?KCCGTS?KRTCKTT?KPDBASWITCHOPENCLOSE
32966389WRONG RESULTS WHEN USING NVL2 FUNCTION ON ROWSETS COMING FROM LEFT JOIN HAVING ROWNUM < ROWSOURCE OF LEFT JOIN INLINE QUERY
32974802JDBC PROXY USER AUTHENTICATION IS IGNORED WITH KERBEROS AUTHENTICATION
33001615CN DEADLOCK LIBRARY CACHE LOCK?<=LIBRARY CACHE LOCK? (CYCLE) AFTER UPGRADED TO 19.10.
33026313DGPDB RECOVERY SIGNALS ORA-600 [KCV_LAST_OFFLINE_REC_OF_INC-1]
33185231NEED TO CHECK VERSION OF STANDBYS FSFO STATE FOR UNSYNC ACK
33312816java.lang.ClassCastException class oracle.ucp.UniversalConnectionPoolException
33313554JSON_QUERY RESULTS FOR ARRAYS ARE INCONSISTENT
33417828SEGV DUE TO !RDOM >> LNX-21.4-RDBMS ORA-00600[KCVFDB_OPEN_PDB KJUPDBDOMATT] WHILE PDB OPEN
33525448LNX64-19.13-RAC,DB HANG AT CPU OR WAIT CPU<=LOG FILE SWITCH (CHECKPOINT INCOMPLETE)...
33527663AMDU FAILS TO DUMP METADATA FROM STRIDES > 4
33559316LNX64-1913-CMT 19.10->19.13 DBVM SERVER PATCHING FAILED, DBVM FS BECAME READ-ONLY WITH ACFS ERRORS
33596364JZNENGDOMEMITCOLVALUE DOESNT HANDLE JZNVAL_ID TYPE
33705050ORA-12899 VALUE TOO LARGE FOR COLUMN SYS.DBMS_SQLPATCH_FILES.ACTUAL_FILE
33742827Fix for Bug 33742827
33809642ORA-46372 ERROR WHILE STARTING DATABASE AFTER JAN 2022 RU ROLLBACK
33809904DOWNGRADE RELOAD FROM 23C TO 21C, CATRELOD.SQL -> UTLIP.SQL -> ORA-06554 PACKAGE DBMS_STANDARD MUST BE CREATED BEFORE USING PL/SQL
33928944DATABASE PERL UPDATE FOR 21C TO V5.32-1 (CVE-2022-23990 - LIBEXPAT UPDATE)
33945728EXCLUDE_DISTANCE NEEDED TO SPECIFY IN SDO_WITHIN_DISTANCE
33993386CRASHES IN VARIOUS PROCESSES DUE TO INCLUSION OF CICTYPE.H
34139110NRT
34162325ISSUE WITH SDO_WITHIN_DISTANCE AND EXCLUDE_DISTANCE
34177554SR23.1ADBS_OMS_PIB5 - TRC - KTMPJAVLUPDATENODECBK - ORA-600 [KTMPJAVLNODEUPDATE_COLCNT_MISMATCH]
34191990POLYGON WITH EXCLUDE_DISTANCE RETURN WRONG.
34208572UNIFIED_AUDIT_POLICIES COLUMN IS EMPTY FOR AUDIT RECORDS FOR CTAS STATEMENT
3423369421C OSON DECODER NEEDS TO BE ABLE TO DECODE RELATIVE OFFSET ENCODED OSON FROM 23C SERVER
34248786FG IS NOT POSTED BY DBRM DURING INSTANCE SHUTDOWN
34256867Fix for Bug 34256867
34257221Fix for Bug 34257221
34276007Fix for Bug 34276007
34279907Fix for Bug 34279907
34314448ENHANCE ASM SMART REBALANCE TO HANDLE SECOND DISK FAILURE IN ONE FAILURE GROUP
34339511QESMA ALLOCATIONS KEEP HAPPENING WHEN KOKLICCX IS CALLED
34366627DNFS IO HANG DURING STRESS TEST
34411060TRACKING BUG FOR RTI - 25393951 INTERMITTENTLY MISSING AUDIT RECORDS FOR NEW AUDIT POLICY ENABLED
34422622JDK BUNDLE PATCH 21.0.0.0.221018
34454450Fix for Bug 34454450
3453648019U DATA REDACTION, ORA 7445 [KZDMINSC] ORA 600 [28065]
34545148UCP Add system property to disable smooth pool shutdown and provide static method to do this manually
34545238STABLE_E2POD LGWR WAITS FOR EVENT ENQ CF - CONTENTION FOR 532 SECS. KRBM.C 13489
34559195INFINITE LOOP WHEN JDBC RECONNECT TO ATP-S DB STOPPED THEN RESTARTED
34574048POD EEHO-DEV5 UNABLE TO SWITCHOVER ODS DB
34580665Fix for Bug 34580665
34587326Fix for Bug 34587326
34598617MAIN DATA REDACTION, ORA-00600 [KZDMTMFW_REGEXP INDEX OUT OF RANGE]
34604941TLSV1.3 USAGE RESULTS IN A HANDSHAKE ERROR.
34651385TST&PERF DELETE QUERY ON SYS.SNAP_LOGDEP$ ADDS TO THE OVERALL ELAPSED TIME OF MATERIALIZED VIEW REFRESH IN MAIN 23C
34659006PASSWORD IN WALLET CONFLICTS WITH TOKEN FOR AUTHENTICATION
34680126Fix for Bug 34680126
34692403abandonedConnectionTimeout connection property is not honored in 19c and 21c versions of UCP
34698475Fix for Bug 34698475
34700228DISPATCHER PDB SERVICES ARE NOT HANDLED PROPERLY WHEN DB OPENED READ ONLY
34713413OGG 19C DB 19.16 EXTRACT FAILING WITH OGG-02028 ORA-01292 LOGMINER FOR UPSTREAM CAPTURE CANNOT FIND LOG FILE
34714760Fix for Bug 34714760
34715072Fix for Bug 34715072
34738737AWR EXADATA RENAME PMEM TO XRMEM
34786432Fix for Bug 34786432
34810533Fix for Bug 34810533
34830523Fix for Bug 34830523
34839112Fix for Bug 34839112
34843376PERL BUNDLE PATCH 21.0.0.0.230117
34929834CVE-2022-3510 & 3509 FROM 21.9 OSCS SCAN REPORT FOR PROTOBUF-JAVA-3.19.3.JAR

73 rows selected.

IS NOT NULL where apropriate
Fix Control
SQL Feature
Description
31988833:1QKSFM_CBO_31988833Enable global caching of IMC stats per original qb
32856375:1QKSFM_CBO_32856375convert simple CASE to
32913527:0QKSFM_CBO_32913527do not populate log costs if not already populated on inspection
33323903:1QKSFM_CBO_33323903no redundant visits of query blocks for virtual column processin
32800137:0QKSFM_DDL_32800137allow sharded table reference duplicated table
32408640:1QKSFM_FIRST_ROWS_32408640correct settings when switching between Kmode and Amode
31912834:1QKSFM_JPPD_31912834skip filter push predicate into outer join subquery view for MER
32754044:1QKSFM_JPPD_32754044allow JPPD with LOB column when max_string_size = EXTENDED
33297275:1QKSFM_JPPD_33297275avoid double costing e.g. of pushed views under OJPPD
29738374:1QKSFM_MVIEWS_29738374delete orphan rows in sys.snap_logdep$ during mview refresh
32212062:0QKSFM_MVIEWS_32212062Rebuild index online with redef online
28044739:1QKSFM_OBJ_EXT_28044739allow collection iterator predicates to be pushed
32302470:1QKSFM_OR_EXPAND_32302470Try LORE after ORE rejected for subquery correlated to non-paren
32851615:1QKSFM_OR_EXPAND_32851615allow Legacy ORE correction to more cost-based ORE cases
31545400:1QKSFM_PQ_31545400Delay in setting QERTBTEMPCSH when kxttIsIMCDTEnabled is safe to
31843716:0QKSFM_QUERY_REWRITE_31843716remove expression col from frocol if NOT referenced in the query
30771009:1QKSFM_SQL_PLAN_MANAGEMENT_30771009enable adaptive cursor sharing for SPM
29413205:1QKSFM_TRANSFORMATION_29413205fix the traversal of view columns in an operator tree
33145153:1QKSFM_TRANSFORMATION_33145153allow CBQT in presense of pseudo-column
33325981:1QKSFM_UNNEST_33325981allow unnesting in some cases previously restricted
31880080:0QKSFM_XML_REWRITE_31880080disable rewrite for XMLTABLE and OUTER JOINS
32766397:0QKSFM_XML_REWRITE_32766397handle invalid characters by replacing or removing them

22 rows selected.

create view my_patch_view
as
with a as (select dbms_qopatch.get_opatch_bugs patch_output from dual)
  select x.*
    from a,
         xmltable('bugInfo/bugs/*'
            passing a.patch_output
            columns
               bug_id number path '@id',
               description varchar2(160) path 'description'
         ) x
;

execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');

select p.value, f.sql_feature, f.description
from v$spparameter p join v$system_fix_control f
on substr(p.value,1,length(p.value)-2)=f.bugno
where p.name='_fix_control'
order by f.sql_feature;

SQL> set serveroutput on;
SQL> execute dbms_optim_bundle.ListBundlesWithFCFixes;
bundleId: 211019,  bundleName: 21.4.0.0.211019DBRU
bundleId: 220118,  bundleName: 21.5.0.0.220118DBRU
bundleId: 220419,  bundleName: 21.6.0.0.220419DBRU
bundleId: 220719,  bundleName: 21.7.0.0.220719DBRU

PL/SQL procedure successfully completed.
SQL> set serveroutput on;
SQL> execute dbms_optim_bundle.getBugsforBundle;

21.7.0.0.220719DBRU:
    Bug: 30771009,  fix_controls: 30771009
    Bug: 29413205,  fix_controls: 29413205
    Bug: 28044739,  fix_controls: 28044739
    Bug: 33089096,  fix_controls: 31545400

PL/SQL procedure successfully completed.
SQL> execute dbms_optim_bundle.getBugsforBundle(220118);

SQL> execute dbms_optim_bundle.getBugsforBundle(220719);

21.4.0.0.211019DBRU:
    Bug: 31988833,  fix_controls: 31988833
    Bug: 32800137,  fix_controls: 32800137
    Bug: 32408640,  fix_controls: 32408640
    Bug: 32312412,  fix_controls: 29738374
    Bug: 33325981,  fix_controls: 33325981

21.5.0.0.220118DBRU:
    Bug: 32913527,  fix_controls: 32913527
    Bug: 32766397,  fix_controls: 32766397
    Bug: 31912834,  fix_controls: 31912834
    Bug: 33145153,  fix_controls: 33145153
    Bug: 31843716,  fix_controls: 31843716
    Bug: 32212062,  fix_controls: 32212062
    Bug: 33613512,  fix_controls: 31880080

21.6.0.0.220419DBRU:
    Bug: 32856375,  fix_controls: 32856375
    Bug: 33297275,  fix_controls: 33297275
    Bug: 33323903,  fix_controls: 33323903
    Bug: 32302470,  fix_controls: 32302470
    Bug: 32851615,  fix_controls: 32851615
    Bug: 32754044,  fix_controls: 32754044

21.7.0.0.220719DBRU:
    Bug: 30771009,  fix_controls: 30771009
    Bug: 29413205,  fix_controls: 29413205
    Bug: 28044739,  fix_controls: 28044739
    Bug: 33089096,  fix_controls: 31545400

PL/SQL procedure successfully completed.


SQL> execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');
SQL> execute dbms_optim_bundle.enable_optim_fixes('ON','BOTH', 'YES');
DBMS_OPTIM command:  dbms_optim_bundle.enable_optim_fixes('ON', 'BOTH', 'YES')

Bundles _fix_control setting as per action:ON
31988833:1  32800137:0	32408640:1  29738374:1	33325981:1  32913527:0	32766397:0  31912834:1	33145153:1  31843716:0	32212062:0  31880080:0	32856375:1  33297275:1	33323903:1  32302470:1
32851615:1  32754044:1	30771009:1  29413205:1	28044739:1  31545400:1

Taking current instance orcl21c as base, details on _fix_control setting for CON_ID 1 :

1) Current _fix_control setting for spfile:
31988833:1  32800137:0	32408640:1  29738374:1	33325981:1  32913527:0	32766397:0  31912834:1	33145153:1  31843716:0	32212062:0  31880080:0	32856375:1  33297275:1	33323903:1  32302470:1
32851615:1  32754044:1	30771009:1  29413205:1	28044739:1  31545400:1

2) Final _fix_control setting for spfile considering current_setting_precedence is YES
31988833:1  32800137:0	32408640:1  29738374:1	33325981:1  32913527:0	32766397:0  31912834:1	33145153:1  31843716:0	32212062:0  31880080:0	32856375:1  33297275:1	33323903:1  32302470:1
32851615:1  32754044:1	30771009:1  29413205:1	28044739:1  31545400:1

3) Current _fix_control setting in memory:
31988833:1  32800137:0	32408640:1  29738374:1	33325981:1  32913527:0	32766397:0  31912834:1	33145153:1  31843716:0	32212062:0  31880080:0	32856375:1  33297275:1	33323903:1  32302470:1
32851615:1  32754044:1	30771009:1  29413205:1	28044739:1  31545400:1

4) Final _fix_control setting for memory considering current_setting_precedence is YES
31988833:1  32800137:0	32408640:1  29738374:1	33325981:1  32913527:0	32766397:0  31912834:1	33145153:1  31843716:0	32212062:0  31880080:0	32856375:1  33297275:1	33323903:1  32302470:1
32851615:1  32754044:1	30771009:1  29413205:1	28044739:1  31545400:1

PL/SQL procedure successfully completed.
select p.value, f.sql_feature, f.description
from v$spparameter p join v$system_fix_control f
on substr(p.value,1,length(p.value)-2)=f.bugno
where p.name='_fix_control'
order by f.sql_feature;

SQL> select value from v$spparameter where name='_fix_control';

        VALUE
_____________
31988833:1
32800137:0
32408640:1
29738374:1
33325981:1
32913527:0
32766397:0
31912834:1
33145153:1
31843716:0
32212062:0
31880080:0
32856375:1
33297275:1
33323903:1
32302470:1
32851615:1
32754044:1
30771009:1
29413205:1
28044739:1
31545400:1

22 rows selected.
SQL> select bugno, value ,sql_feature, description from v$system_fix_control where bugno in (30771009);

     BUGNO	VALUE SQL_FEATURE						       DESCRIPTION
---------- ---------- ---------------------------------------------------------------- ----------------------------------------------------------------
  30771009	    1 QKSFM_SQL_PLAN_MANAGEMENT_30771009			       enable adaptive cursor sharing for SPM

SQL> select bugno, value ,sql_feature, description from v$system_fix_control where bugno in (29413205);

     BUGNO	VALUE SQL_FEATURE						       DESCRIPTION
---------- ---------- ---------------------------------------------------------------- ----------------------------------------------------------------
  29413205	    1 QKSFM_TRANSFORMATION_29413205				       fix the traversal of view columns in an operator tree

SQL> select bugno, value ,sql_feature, description from v$system_fix_control where bugno in (28044739);

     BUGNO	VALUE SQL_FEATURE						       DESCRIPTION
---------- ---------- ---------------------------------------------------------------- ----------------------------------------------------------------
  28044739	    1 QKSFM_OBJ_EXT_28044739					       allow collection iterator predicates to be pushed

SQL> select bugno, value ,sql_feature, description from v$system_fix_control where bugno in (33089096);

no rows selected
create table MY_PATCH_21_9 as select * from my_patch_view;
set pages 999
set linesize 200
set trimout on
set trimspool on
select '|'||bug_id||'|'||description||'|' from 
(select * from MY_PATCH_21_9 minus select * from MY_PATCH_21_8) order by bug_id;


select '|'||p.value||'|'||f.sql_feature||'|'||f.description||'|'
from v$spparameter p join v$system_fix_control f
on substr(p.value,1,length(p.value)-2)=f.bugno
where p.name='_fix_control'
order by f.sql_feature;

1 comment: