Saturday, March 5, 2022

Oracle 21c bug fixes in Jan-2022 Quarterly Patches

 

Total 344 bugs fixed in Jan-2022 Oracle 21c updates (21.5RU)

BUG_ID
DESCRIPTION
26139817V$UNDOSTAT.UNDOBLKS SPIKES EVERY 5750 MINUTES (3 DAYS 23 HOURS 50 MIN)
26352569ORA-600 RWORUPO.2 IN WITH CLAUSE
27162036WRONG RESULT /ORA-7445 SSLNXMUL WITH COMPLEX GROUP BY ROLLUP AND SUBQUERY FACTOR
27897090ORA-13767 END SNAPSHOT ID MUST BE GREATER THAN BEGIN SNAPSHOT
28294439ORA-22922 DURING EXECCUTION OF PIPELINED FUNCTION IN PARALLEL
28632799WRITE WARNINGS TO ALERT LOG WHEN APPROACHING MAXIMUM OBJECT NUMBER
28994721SSL AUTHENTICATION FAILS IF CLIENT DN INCLUDES ESCAPED CHARACTER ,
29027914ORA-600 [KTSL_FORMAT_EHDR OBJDCHK_KCBNEW_3] AND OTHER ASSERTS SEEN DURING SF PDML TEST
29591661SR20.1RAT_REPLAY+PDBLEVEL - TRC - KOLASLREAD - ORA-600 [KOLASLREAD-3]
29617414UPGRADE FROM 11.2.0.4 TO 12.2.0.1 ON EXADATA ALTER TABLE TAB_STATS$ DROP HANGS FOR MORE THAN AN HOUR EVEN WITH PATCH 29024054 APPLIED
30082402RMAN DUPLICATE TRIES TO FLASHBACK CONTROLFILE OF SOURCE DATABASE
30481004SODA UPGRADE REGRESSION ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KKOSHDCHECKVALIDITY 1], [], [], [], [], [], [], [], [], [], [], []
30710917HIGH DATABASE CONTENTION AND VERSION COUNT ON SELECT QUERIES USING DB LINK AFTER UPGRADE FROM 11.2.0.4 TO 12.2.0.1
30961824PROCOB APP CANNOT GET ORA-2112 ON FIRST EXECUTION OF SELECT INTO STATEMENT
31006953ORA-30372 FINE GRAIN ACCESS POLICY CONFLICTS WITH MATERIALIZED VIEW WHEN CREATING ZONEMAP
31026870ASM SKIP PST RELOCATION DURING ROLLING UPGRADE
31044504AFTER UPGRADE TO 19C, PIPE ROW WITH STRING LENGTH MORE THAN 160 FAILED WITH ORA-06502
31113682ORA-1555 FOR LONG RUNNING QUERIES IF _UNDO_AUTOTUNE=TRUE
3138712318.8 DB ACTIVE STANDBY APPLY RATE IS SLOW DUE TO WAIT ON ENQ IV - CONTENTION
31488085CORE DUMP [JZNENGFSMEMITEV()+2702] [SIGSEGV] WHILE RUNNING OLTP WORKLOAD
31656601UNABLE TO LOAD CRL INTO OID / ORAPKI CRL UPLOAD RETURNS COULD NOT UPLOAD CRL TO THE DIRECTORY.
31773909ADB-D INSTANCE REGISTERS A DB SERVICE FOR JMS TOPIC SUBSCRIBERS
31780567KAP STATS AND INDEX RELATED CALLS TAKING HIGH CPU IN 19C ADB
31800139SR21.1PX_FORCE - TRC - KKQTESKIPINVALIDPH - ORA-600 [KKQTESKIPINVALIDPH]
31834677SR21.1CHAOS_V2 - TRC - QKNTQOUTEXPREG - ORA-7445 [QKNTQOUTEXPREG()]
31843716QUERY REWRITE REQUIRES NON REFERENCED COLUMNS WHEN VPD POLICY ENABLED
31843845ORA-600 [KDSGRP1] WITH COMPRESSED INDEX ACCESS TO TABLE
31844137DEADLOCK DURING EXCHANGE PARTITION A TABLE USING INMEMORY OPTION.
3184435719C AND 21C BACKPORT OF POST-19C OJVM PDB SECURITY ENHANCEMENTS
31872320WHEN USING ROW ARCHIVAL, WRONG RESULTS ARE BEING RETURNED.
31897178ADD WARNING IN ALERT LOG FOR PROBLEMATIC UNDERSCORE PARAMETERS ALONG MOS DOC DETAILS
31912834MERGE STATEMENTS FAILING WITH ORA-600 [QKSDMLMRGVIEWDESTFRO_5] AFTER MIGRATED TO 19.7
31951628RDBMS KERNEL CHANGES TO SUPPORT COMPRESSING/ENCRYPTING SBT FOR DATABASE RECOVERY SERVICE
31993051APP_VERSION OF DBA_APP_PDB DOESNT CHANGE ACCORDINGLY AFTER FLASHBACK PDB SUCCESSFULLY
31996331STANDBY DATABASE TERMINATED WITH ORA-00600 [1433] DURING REKEY OPERATION
32003908ANALYTIC VIEWS ARE NOT EDITIONABLE
32008716INEFFICIENT LOCKING AT ORACLE.SECURITY.CRYPTO.PROVIDER.TRANSITIONMODE
32009197XF21.3SELECTS6 - TRC - QKAISCOLDESCELIGIBLE - ORA-7445 [QKAISCOLDESCELIGIBLE()]
32075130IE LOGMINER BUILDER ABENDING WITH ORA-07445 [KRVUTAPRVQ_TXNADDPRIVATEQUE()+1690]
32078078SR21.3ADBS19_LKDWN - HANG - QUERY HANGS WITH ADB S LOCKDOWN
32092797DELETE OBSOLETE FROM STANDBY FAIL WITH ORA-01801 AFTER UPGRADE TO 19C
32097767AVOID RESOURCE PLAN CHANGES DURING SHUTDOWN
32102542INSTANCE CRASH WITH ORA 600 [KJXSRPLY 1]
32114746INCORRECT COLUMN METADATA VALUE FOR UDSDEF.UDSNUL RETURNED WHEN QUERY CONTAINS NVL FUNCTION
32119144LARGE BUFFER CACHE ON EXADATA DISABLES SMART SCAN OFFLOAD FOR PARALLEL QUERIES
32161381DBA_TABLESPACE_USAGE_METRICS WITH INCORRECT RESULT AFTER ADDING A DATAFILE IN PDB
32183102FIX HIGH-PARSE-TIME ISSUES IN NETSUITE
32184577PSITRP MEMORY LEAK OF PLSQL STACK IN PQ WORKER
32190419ORA-00443 BACKGROUND PROCESS IPC0 DID NOT START AT X8M-8 DB STARTUP
32198396V$SESSION.TERMINAL FOR A SESSION WITHOUT TTY ALWAYS BECOMES PTS/0
32212062GLOBAL NON-PARTITIONED INDEX REBUILD WITHOUT ONLINE OPTION
32255753AH RESILIENCE IN CDB INSTANCE RECOVERY FLOW NOC-153218 LHR E16POD ALL INSTANCES CRASHED, NOT STARTING ORA-01172 MULTI INSTANCE CRASH
32258423PERFORMANCE ISSUE WITH ENQ TS - CONTENTION AGAINST TEMP TABLESPACE ON 11.2.0.4
32277793AH AVOID CT-ENQ GET DURING FILE RESIZES, AND BCT EXTENT RESIZE - NOC-153272
32298173REGRESSION TRACKING BUG FILED FROM MERGEREQ
32298782ORA-27163 THROWN BY SELECT * FROM JSON_TABLE
32335257VIEW DBA_HIST_SERVICE_STAT MISSING ROWS
32361175OMS TRACKING BUG AUTO MOUNT
32372725GDSCTL VALIDATE SHOWS INCORRECT MESSAGE FIELD SVC_SESSION_STATE_CONSISTENCY VALUE STATIC DOES NOT MATCH THE ONE FROM GDS CATALOG STATIC
32373696HEADER FILE CHANGES NEEDED FOR OSS COMPONENT OF PMEM STRAND FILE PROJECT 73909
32380591KFED NOT WORKING FROM 19C GRID HOME
32382021REBALANCE OPERATION IN RECO DISKGROUP IS FAILING WITH ORA-59048 IN EXADATA
32417301PDB UNDO TABLESPACE ENCRYPTION FAILS IN RAC DATABASE
32428097FE2POD FRA FE2POD INSTANCE CRASH DUE TO ORA-00600 [KRCPASB_INITIAL_ALLOC_FAILURE] AND ORA-04031 (LARGE POOL,UNKNOWN OBJECT,LARGE POOL,CTWR DBA BUFFER) SINGLE
32432245LNX64-21-RAC ORA-00600 [KJXRRI3 DOWNCVT1] IN ASM LMD
32436721ADB-D DBFS TABLE PARTIONS USING INCORRECT SEGMENTS
32439726[NODP] ORA-04061 EXISTING STATE OF PACKAGE BODY SYS.DBMS_REGISTRY_SYS HAS BEEN INVALIDATED
3244112819C DB
32442229ORA-42906 CANNOT ASSIGN A NON-EXISTING OLS DATA LABEL AS ROW LABEL
32460145DBA_JOBS IS NOT BROKEN AFTER 16 FAILURES AS IT SHOULD BE
32468643MISSING TEMPFILE RESIZE/DATAFILE RESIZE ENTRY IN LOCKDOWN_PROF$ IN CDB$ROOT
32471251OMS DROP/CREATE PDBS HITS ORA-00600 [OMSFIOCLST BAD BPROCCOUNT]
32492382TOO MUCH MEMORY USED BY DATAPUMP AFTER FIX FOR BUG 28882473 ON 19 AND 21 RELEASE
32498569ORA-07445 CORE DUMP [KPRBPRS()+46] DURING ALTER DATABASE OPEN MIGRATE, WHILE CREATING THE LOCAL UNDO FOR PDB$SEED
32498752DBCA FAILED WITH ORA-600 [KSU_GET_AVAILABLE_PSO NUMA MISMATCH]
32503790MEMORY LEAK IN PEVMMSC.C 242 KOLLASG
32509814PLSQL PROCEDURE OWNER DOES NOT GET PROPAGATED TO THE SHARDS.
32526703SDO_GEOM.SDO_AREA() CALLS MDSYS.SDO_COORD_REF_SYS TOO MANY TIMES
32531647INCORRECT FNDD GUID HASHING BEVAIOUR
32540706ORA-600 [KRASDELSNAPAL_1]/ORA-600 [2162]/ORA-07445 [KRASDELSNAPAL] DURING ALTER DATABASE CONVERT TO PHYSICAL STANDBY
32551246TRACKING BUG FOR RTI 23724347
32561841SOME SSL CONFIG PARAMETERS CANNOT BE SET ON CONNECTIONS
32583692QUORUM DISKS SHOULD BE ALLOWED FOR SPARSE GRID DISK GROUPS
32585832PHX FE4POD INC BACKUP FAILING WITH ERROR ORA-01155 DATABASE IS BEING OPENED, CLOSED, MOUNTED OR DISMOUNTED
32587994ERRORS WITH LONG DDLS ( MORE THAN 4000 BYTES) CONTAINING MULTI-BYTE CHARACTERS
32597099ORA-600 [KZDTAMS KKDLGUN] IN CDB REVOKE PRIVILEGE
32602194INSTANCE SHOULD NOT CRASH IF BCT ENABLE OPERATION FAILS DUE TO ORA-4031
32603092ERROR HANDLING CODE CHECKING FOR CORRUPTION SHOULD USE KCB_ISCRRPT MACRO
32628168PATCH 31511219 HAS FAILED ORA 600 [ KZVAUD_CLI 8208 ], [4063]
32634049PDB CLONING CAUSING HARD CHECK ERRORS DURING REBALANCE
32635881FIX RARE MEMORY LEAK IN KDPFREECTX
32635931TRACKING BUG FOR TIMESTEN BUG 30727867 - CRASH WHEN USING THE PLSQL TABLE() OPERATOR
32639432ORA-979 AFTER BUG FIX 32177819
32639860TPCH ADB-S QUERY (Q11) RUNS OVER 2 HOURS AND DIDNT FINISH THE EXECUTION
32651773ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [__INTEL_AVX_REP_MEMCPY()+740] [SIGSEGV] [ADDR 0X0] [PC 0X6D20E64] [SI_KERNEL(GENERAL_PROTECTION)] [] >
32652605PLSQL STACK TRACING INSUFFICIENT
32653470DI ADD DIAGNOSTIC FOR ORA-600 [KTI_XCB_*_POOL_CORRUPT]
32677000EXTRACT() XMLTYPE FUNCTION FAILS WITH ORA-04030 (QMNFAISSUBSET0,QMEMNEXTBUF ALLO
32690400OGG APPLY SHOULD SUPPORT ATTRIBUTE COLUMNS AS KEYS FOR OBJECT TABLES
32700455ORA-30966 ORA-29400 WHEN CREATING XMLINDEX WITH UNDERLYING ORA-04030
32712916OGG REPLICAT ABENDED WITH ORA-26804 WITH EXCEPTION KCBZHNGCBK6 IN ALERT LOG
32719445FOR EXADATA STORAGE, DISABLING PDB CPURM AND INFORM THE INSTANCE IS ADB-S FROM RDBMS
32728984ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [DRNPGTM()+287] [SIGSEGV] [ADDR 0X7F8D00000001] [PC 0X68B516F] [ADDRESS NOT MAPPED TO OBJECT]
32730701QUERY REGRESSION ON V$DIAG_ALERT_EXT AFTER UPGRADE FROM 12.1 TO 19C
32733845RECREATE_INDEX_ONLINE FAILS AFTER ALTER INDEX FAST_DML
32734021ORA-29875, ORA-13031, ORA-06512 FROM UPDATE ON TABLE WITH SPATIAL INDEX
32735915CN ORA-65040 RAISED WHEN EXEC DBMS_LOGMNR_D.BUILD IN PDB
32736370ADB-D ADDITIONAL FILES GETTING CREATED ON DBFS, FILE NAME STARTING WITH .OFS_*
32740515ORA-29770 - IPC0 BACKGROUND PROCESS CONSUMING 99% CPU AND UNRESPONSIVE
32747738ASM SCRUBBING SHOULD REPAIR BADFDA7A BLOCKS
32748806ORA-16789 (MISSING CDB-LEVEL SRLS) SHOULD NOT BE ISSUED FOR DGPDB CONFIGURATIONS
32761932[NODP] COLD DB PATCHING ESOR 19.9.0.0.210317 DATAPATCH FAILED ERROR ORA-7445 [PKRCD] [SIGFPE]
32764690SEVERAL LOB CORE DUMPS IN X10 TIMESTEN GLUE CODE
32766397PSRPERF NEED OPTION TO SET EVENT 19119
32766407PSRPERF NEED OPTION TO SET EVENT 31151
32771735ADD ADDITIONAL INFORMATION WHEN ORA-600 KZRTGETCOL-PCOLP IS RAISED
32775526TLS1.2 ORA-28750 UNKNOWN ERROR CAC AUTHENTICATION 19.10 / 18.13 VERSION
32781826MODULARIZE THE KEY INITIALIZATION FUNCTIONS FOR CODE CLARITY
32790012JSON_TABLE SUPPORT COLUMN NAME 0LOC_CURRCY
32800539GSM-40130 REGISTRATION FROM UNKNOWN DATABASE RECEIVED FOR SWITCH ROLES BETWEEN SNAPSHOT AND PHYSICAL STANDBY
32801192ORA-00600 [KKQORETRANSFORM SANITY CHECK FAILED]
32801303JSON_TABLE QUERY FAILS WITH ORA-7445 [QKNLAZOPN()+37]
32806915LNX64-1911-CMT DELETE DBSYSTEM WITH FORCE CAN LEAVE BEHIND NON-OMF DIRECTORIES
32809152LNX64-1911-CMT WRONG MAPPING OF ASM FILEGROUP OBSERVED FOR DBSYSTEM DATABASE FILES
32818545CLIENT CLUSTER AUTHENTICATION FAILS WHEN ASM PASSWORD FILE WITH PERMISSION 0600
32831901ATP-D DG LOST WRITE ON DG SETUP BETWEEN HYD (PRIMARY) / YYZ (STANDBY)
32834394AIM ORA-7445 [KFGBJOIN] - KFGBJOIN
32843672LNX-21.3-RDBMS ORA-00600[[CANNOT BEGIN TRANS IN QCN SLOT]
32846876SDO_PC_PKG.SDO_PC_NN FAILS FOR SRID NON-NULL
32852504DEADLOCK DETECTED WHILE WAITING FOR RESOURCE ERROR INSERT INTO COL$
32863795LNX64-1911-CMT ASMCMD FIND OPTION DOES NOT LIST ALL FILES WITH PARTIAL PATTERN
32866089ORA-07445 PMUCSIZ WHEN PASSING COLLECTION AS BIND VARIABLE
32879447ATP ALTER PLUGGABLE DB ALL CLOSE ON DG STANDBY INSTANCE - ORA-00700 [KQRPRE_SMON_ADG_CLOSE]
32881057DBLINK FIX REGRESSION CAUSED IN SHARDING AREA AFTER THE BUG#32218831 FIX
32881462MES46 INSTANT CLIENT FAILS WITH MES 46 ON WINDOWS PLATFORM
32888458AIM ORA-700 [KSUXDL CLEANUP FAILURES], ... [], [0], [], ... - ASM NETWORK SGA LATCH
32889096LATCH ENQUEUE HASH CHAINS WHEN DATABASE VAULT IS ENABLED ON 19.7
32893951INSTANCE CRASH WITH ORA-00600 [KJBRESOURCELATCH] EVEN WITH FIX 32431290
32897184CDB LGWR HIT ORA 600 [KGLLOCKINSTANCE1] ON STANDBY AND STANDBY DB CRASHED REPEATEDLY
32897679RAC OPEN APPLICATION PDB HANG WITH CHAIN CPU OR WAIT CPU<=BUFFER BUSY WAITS ON APP ROOT
32898672ORA-26786 & ORA-26787 ERRORS ON LOGICAL STANDBY AFTER UPGRADED TO 19C
32908249TT23.1DKC OTHER ERRORS - ORA-700 [KSKDBRMTOUTACT UNEXPECTED ERROR]
32908946WRONG RESULT IN UPDATE WITH CORRELATED SUBQUERY WITH A CONSTANT CONVERTED TO JOIN
32909255HIERARCHICAL ATTRIBUTES FOR NON-DETERMINED ALL MEMBER GENERATES UNNECESARY JOINS
32910846COMPLEX QUERY FAILED WITH ORA-979 AFTER UPGRADING TO 19C
32913527AFTER 11.2.0.4 UPGRADE TO 19.8 PLAN CHANGE FROM INLIST ITERATOR WITH PRIMARY KEY TO INDEX RANGE SCAN
32914711V$ASM_OPERATION STILL SHOWS A PAUSED SCRUBBING AFTER IT FINISHED IN A REMOTE INSTANCE
32915760AIM ORA-600 [KCBZPBUF_3] - KCBZPBUF
32930665MISMATCHED TRACING FORMAT AND ARGUMENTS IN KDS
32931078DELETE-DBSYSTEM DOES NOT COMPLETELY CLEAN ASM FILES
32931941DNFS BLOCK CORRUPTION WHEN ATTEMPTING RETRY OF A WRITE IN 19C
32935932LNX-21C-RAC M004 HIT ORA-600 [KJBCVT __L] AND ORA-600 [KJBICANCEL !TOBEREPLAY]
32936402XF23.1PDML_12838 - TRC - KDU_ARRAY_UPD_BUF - ORA-600 [KDU_ARRAY_BUF NON-ZERO DELTA]
32940955ORA-4031 DUE TO LARGE SO PRIVATE SGA ALLOCATION IN ONE SHARED POOL SUBPOOL
32952285FIX TO DELETE / NO AUDIT REDUNDANT, EXTRA EXCESS AUDIT CAUSING SYSTEM WIDE AUDITS SET BY DV
32955962ATP FAILOVER WORKFLOW TERMINATES W/ ORA-03113 DUE TO ORA-00600 [KJCCQMG]
32966389WRONG RESULTS WHEN USING NVL2 FUNCTION ON ROWSETS COMING FROM LEFT JOIN HAVING ROWNUM < ROWSOURCE OF LEFT JOIN INLINE QUERY
32969863UNIFIED_AUDIT_POLICIES COLUMN IS EMPTY FOR PRIVILEGE AUDITING
32970478NEED A ZT API TO RETRIEVE PUBLIC KEY FROM MODULUS AND EXPONENT ETC
32976022PHX E12POD SEVERAL SERVICE_UPDATES HAPPENING IN SAME SECOND
32977489PROVIDE THE INTERNAL INTERFACE FOR EXTENT-BASED SCRUBBING SUPPORT
32978151QUERY GIVING WRONG RESULT WHILE USING SMART SCAN
32980826KMDRDBMSKCIRAGETROW() RETURNS INCORRECT STATUS VALUE
32983419ICX2 MEMORY LEAK IN SDO_AGGR_UNION
32983871ORA-04092 CANNOT COMMIT IN A TRIGGER FROM PLSQL CALL W/NO TRIGGERS
32984679Fix for Bug 32984679
32985908PORT ZDLRA BUG 30795348 - RMAN TAKING BACKUP WITH INCR_SCN IN PDB PITR GAP
32987004ADD LIST OF COMPOUND SRIDS
32988028STUBS ARE NOT PROPERLY DELETED WHEN DROPPING AN EDITION
32991527HIGH USAGE OF IN MEMORY 64K SEGMENT OBSERVED DURING UPDATE TABLE
32995206LNX-21.3-RDBMS ORA-00600[526], [0X892093F70] AND INSTANCE CRASH
32995242SDO_GEOM.SDO_UNION GENERATES A MULTIPOLYGON WITH OVERLAPPING GEOMETRIES
32995863SLOW PERFORMANCE IS OBJECT STORAGE EXTERNAL ACCESS USING ADW
32998659WRONG RESULT WITH _FIX_CONTROL=22904304 ON
33000440INSTANCE CRASHED AFTER LMD0 HITS ORA-00600 [KJXPDASTART DLM_RCFG!]
33000980ASMCMD SPFILE COMMANDS SHOULD USE ABSOLUTE FILE PATH WHEN THE DESTINATION PATH ONLY HAS THE DISKGROUP NAME
33010444IMPROVE DEFAULT DIAGNOSTICS FOR ORA-00600 [4511]/[4512] ASSERTS
33013379CPU USAGE IS NOT BALANCED ACROSS HOSTS AND CONNECTION NOT PROPERLY DISTRIBUTING AMONG NODES
33015716HCS HIGH PARSE TIME DUE TO HIER ATTRS FOR HIERS WITH MANY LVLS
33018951PSRPERF ONLINE MOVE OF MATERIALIZED VIEW TABLE
33020088IORM PLAN PUSH CAUSES ORA-00700 [KSKDBRMTOUTACT UNEXPECTED ERROR], [58001] DURING DATABASE SHUTDOWN
33020510SODA PL/SQL MEMORY LEAK DETECTED WHEN SODA CURSOR NEXT IS INVOKED WITHOUT HAS_NEXT CALL
33021036AFTER UPGRADE TO 19C GV$SQL_MONITOR QUERIES AND SQLMON GENERATION VERY SLOW
33021642ORA-600 [2130] ON DOING IMPDP IN THE TTS
33022140AIM ORA-600 [KJBMCLOSERES GR] - KJBMCLOSERES
33023671WRITE ALERT LOG FOR ALL TDE OPERATIONS ( ADMINISTER KEY MANAGEMENT COMMANDS) IN DATABASE
33026796INSTANCE CRASHED AFTER RS0 HITS ORA-00600 [KJMPRCFGSYNC !STEP]
33027377V$SESSION.TERMINAL IS NULL FOR CLIENTS USING PSEUDO TERMINALS ON NON-LINUX PLATFORM
3302755321C PATCHED SQLPLUS CLIENT THROWS ORA-12268 WITH SQLNET.ALLOW_WEAK_CRYPTO=FALSE,SQLNET.ENCRYPTION_CLIENT=REQUESTED AND 12.1 UNPATCHED SERVER WITH SQLNET.ENCRYPT
33028013AIM ORA-7445 [KSZ_PUT_KEY] - KSZ_PUT_KEY
33028286LNX64-1912-CMT FLEX DISKGROUP OR HIGH FOR TWO DISKS ENV GI PROVISION FAILED DCS-10001 PRGH-1063 PRCZ-4001 PRCZ-2103
33028462FAILOVER FAILED FOR MAX AVAILABILITY + FAST SYNC MODE FOR ALL DB VERSIONS
33032579OCI/ONS HANDLES IN WINDOWS KEEP INCREASING AND NOT GETTING RECYCLED OR CLOSED
33037531SET PGACTX DURING EXECUTION
33037895TRACKING BUG FOR RTI 24203651
33038479NEED FORCIBLE FAILOVER COMMAND FOR DCS AGENT
33040335CONNECTION FAILS WHEN ENCRYPTION_SERVER=ACCEPTED , AWCC=FALSE , ENCRYPTION_TYPES_SERVER = (RC4_128) AND ENCRYPTION_CLIENT=ACCEPTED
33043590PROJECT_ORDINATES_ONTO_TIN - RETURNS NULL Z WHEN PASSED SOME X,Y VALUES FROM X,Y,Z VALUES TO CREATE THE TIN
33044062KTSL_PUA_ROLLEDBACK_FREE CHUNKS ARE SET TO KTSL_PUACHK_IN_USE
33045137AIM ORA-600 [KTUREF_BAD_CTX] - KTUREF
33047827MOVE ONLINE MAY WRONGLY RAISE ORA-1 ERRORS
33049012YYZ E1POD RMAN RESTORES INCRMENTAL BACKUP WITH INCR_SCN=CREATE_SCN AS LEVEL 0 FOR RELOCATED/PLUGGED IN DATAFILES
33050626AIM ORA-600 [17114] - KGHFRH_INTERNAL
33056383ORA-00600 [KTMCQSC_WRONG_PDB_TSN_OBJD] AND [KTMBFINDBH_00] - IMC JOURNAL BUCKETS
33056579DEADLOCK ON EXCHANGING PARTITION OF INMEMORY TABLE AFTER APPLYING 31844137
33059891IE Abends With ORA-01422 After Apply 19.11DBRU
33064565UNABLE TO TRACK AND ENABLE RFS CLIENTS
33065437Fix for Bug 33065437
33065979TRACKING BUG FOR RTI 24324759 - ORA-7445 [KKQCBYISJOINCHECKOPN]
33072392AV QUERIES SLOWER WITH BINDS THAN LITERALS DUE TO CONSTANT FILTER OVER FACT SCAN
33075133TRACKING BUG FOR RTI 24247043
33075246FREEZE STEP DOES NOT SCALE BECAUSE KJMPTPA() IS COSTLY
33085296MARK FAILED TO CLEAR SYNC_KFDSK DUE TO RACING OFFLINE
33085361ASM SCRUBBING SHOULD NOT CHECK FOR CORRUPTIONS IN THE ACTIVE CHANGE DIRECTORY
33089556EXSCALE SPURIOUS CALL TO FILE_GET_ATTRIBUTES DURING FILE_OPEN
33090110LMS MISSING POST FROM LMON, CAUSING LONG (30MS) DA_RM_FREEZE STEP
33090127DDLS > 4000 CHARS AND MULTI-BYTE CHARACTERS, GSMOCI SENDS THE WRONG ENCODED STRING TO THE SHARD
33090781PASSWORD COMMAND FAILS WITH ORA-12269 WHEN CHANGING EXPIRED PASSWORD WHEN NNE IS ENABLED
33090848CONNECTED USER DB LINK FAILS WITH ORA-12599 FOR KERBEROS USERS WITH FORWARDABLE TICKETS WHEN NNE IS ENABLED .
33092087TT23.1ASAN GLOBAL-BUFFER-OVERFLOW IN PGA AT KFFGPTGET+2531
33096609FIXED USER DB LINK TO SHARED SERVER FAILS WITH ORA-03113 WITH NNE ENABLED
33097433UNIFIED_AUDIT_POLICIES COLUMN IS EMPTY FOR SET ROLE AND OBJECT GRANT STATEMENTS
33100352FADBRWT STRESS FA ORA-700 [KSWSDIAGNOSERVICE], [4], [0], [1], [EVAXKNQGPQ02_F_FD] DURING DB STARTUP
33101055RAC INSTANCE TERMINATED WITH ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KJBRWREQ LWR], [], []
33101058MAIN_LINUX.X64 LRGDBCONC181000RMAINSAUTOL RUNS WILL BE SUSPENDED 07/18/21; TOO
33102477CHECK FOR STILL-ENCRYPTED BUFFER IN CACHE DURING READ & SEND/RECEIVE ACROSS THE INSTANCES AND CORRUPTION BEFORE REDO APPLY
33105276ALTER TABLE MOVE DOES NOT SKIP CORRUPT BLOCKS MARKED BY DBMS_REPAIR.SKIP_CORRUPT_BLOCKS
33106822Fix for Bug 33106822
3310787221.3 RDBMS PRECOMP TEST ACCESS VIOLATION SEEN
33110192SODA OCI WHEN STATEMENT CACHE IS ENABLED FIND OPERATIONS ON VARCHAR2 COLLECTIONS RESULT IN CRASHES
33110992EKHA ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [KTMNPST()+948]
33113848TRACKING BUG FOR RTI 23279241 ORA-700 [ERROR_STACK_OVERFLOW] IN KFIOOFFLINEDB
33121866PROVIDE MECHANISM TO SKIP CORRUPTION ERRORS DURING INSERT
33126216RMAN BMR SHOULD PRINT TRACE NAME AND/OR UPDATE ALERT.LOG
33131526LONG ELAPSED TIMES FOR DLM LOOP DIAGNOSTIC TRIGGERS NEW DIAGNOSTIC
33135083SODA OCI WHEN STATEMENT CACHE IS ENABLED AND USING GETONE() + GETCURSOR() IN CONJUNCTION RESULTS IN CRASHES
33136252Fix for Bug 33136252
33142123KFNUSTART SHOULD BAIL OUT IF KFNUWAIT EXITS BEFORE TRANSITION
33142533MISCELLANEOUS DIAGNOSTIC IMPROVEMENTS FOR KFN
33142739ORA-00600 [IPC ASSERT] CANNOT START 19.11 DATABASE IF CPU LIST IS NOT CONTINUOUS
33145153SQL REGRESSION UPGRADE FROM 19.7 TO 19.11 NO JPPD AFTER UPGRADE
33150236DAX LOG DETECTION
33152388FA SPECTRA SPECTRA SERVICE REGISTRATION ISSUE AFTER DB BOUNCE
33153797OGG DC ROOT CAPTURE ABENDING WITH ORA 600 [INVALID MDH]
33163187CHILD CURSOR INCREASE DUE TO BIND MISMATCH EVEN WHEN USING SAME BIND VALUES
33165183TST&PERF RM OPERATION USING ASMCMD TAKES MORE TIME MAIN (23.1) VS 19.3
33166116LIMIT THE NUMBER OF CELLS THAT CAN BE UPGRADED CONCURRENTLY
33166242WALLETLESS ONE-WAY TLS SUPPORT
33168480OCCI DEMOS USING INSTANT CLIENT FAIL ON OL8
33169254ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [INVALID BUFFER PIN], [KFCRELEASEPRIV], [KFDVADSKCACHE], [13502], [1024], [], [], [], [], [], [], []
33172549KGH LRU LIST EMPTY WHEN KGHTIMESTAMP RETURNS ZERO
33172679IMPROVE THE PERFORMANCE OF _DB_BLOCK_CHECK_FOR_DEBUG WHEN DB_BLOCK_CHECKING IS MEDIUM
33178223QUORUM DISK VALIDATIONS FROM CELLCLI NOT WORKING AFTER FIX FOR 32139531
33178248Fix for Bug 33178248
33182152AH TO DUMP OBJD BLOCK DISKLOCATOR ROWID WITH ORA-600 [KOKL_KAF INVALID LOCATOR VERSION]
33182656REMOVE PROCESS_QUERY_INFORMATION FROM ORA_INSTALL GROUP
33188597Fix for Bug 33188597
33190454ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [QKSVCPOSTPROCESSGENERATEDPREDICATES()+155]
33190694LCTR UPGRADE ISSUES WITH 21C RELEASE
33191073RECTIFY_GEOMETRY NOT GENERATING VOID WITH COVEREDBY INNER RING
33196009SDO_GEOM.RELATE WITH DETERMINE RETURNS COVERS INSTEAD OF TOUCH - SPATIAL_VECTOR_ACCELERATION=TRUE
33196035SDO_GEOM.SDO_UNION WRONG RESULT WITH SPATIAL_VECTOR_ACCELERATION=TRUE
33196475TRACKING BUG FOR RTI 24371187
33197565JDK BUNDLE PATCH 21.0.0.0.211019
33205781SAGEASM-E HIT ORA 7445 [KFRCGETRBCOD]
33207143PHSB WHEN RECOVERY ENDS WITH ERROR WE TOSS AWAY MEDIA RECOVERY DIRTY BUFFERS.
33210231ORADIM MMC SNAPIN CRASHES ON CLOSING DIALOGS
33216667NZ NEEDS A CAPABILITY TO LOAD THE SYSTEMS CERTIFICATE STORE
33219840TERMINAL INFORMATION FOR PSEUDO TERMINALS ON AIX NEEDS TO BE IMPLEMENTED.
33220282SHARD WALLET NEEDS TO ALLOW ACCESS FROM MULTIPLE HOSTS
33225678DGMGRL CONVERT TO PHISICAL STANDBY FAILS AFTER TIMEOUT ORA-16713
33230882CREATE APPLIANCE DB CREATION BY RHP FAILED WITH PRGH-1107 PRCZ-4001 PRCZ-2103 DBT-15019 DBT-06002 DBT-06003
33232128DISABLING STACK DUMPS IN TRACE FILE FOR ORA-00060 DEADLOCK DETECTED
33233560ORA-700 [KJMSP1 !FOUND] WHILE CREATING MULTIPLE PDBS FOR APPLICATION CONTAINER.
33234302OMS (RMNORONH_MERGEIO) FREESPACE LOCK FIX
33235620SUPPORT SSO AUTHENTICATION WITH IAM TOKENS
33245940SUPPORT IAMS ALTERNATE DATABASE PASSWORD
33251004FSDIRECT EMULATION TESTS FAIL DUE TO PENDING KSPMX TXN CLEANUP
33253504FUSION APPS + UNIFIED AUDIT UNIFIED AUDIT RECORDS GETTING GENERATED IN PDB EVEN WITHOUT ANY AUDIT POLICY ENABLED
33261786ORA-15012 WHEN DB FAILS OVER BETWEEN ABORT AND CLOSE
33271125PDB RELOCATION DELETING SERVICES FROM TARGET DATABASE
33282971ORA-00600 [29703] CGS NAME-SERVICE FATAL ASSERT KJXGNAEFM1 WHEN QUERYING RQST FROM RIM TO HUB
33287418DI BUG DIAGS FOR ORA-00600 [KFDS_GETSEGREUSEENQ01]
33292174LNX64-1913 ORA-7445 COREDUMP AT KJXGM_PNGREQ_PREPARE()+1062
33292896CHANGE CODE-DRIVEN AMDU DUMPS TO USE DATE-TIME NAMES SUBDIRECTORY FOR DUMP.
33300422WIN/21C/RACDB- SIZE OF THE CJQ0 RDBMS TRACE FILES ARE VERY BIG (50GB+)
33304435DO NOT REGISTER MRS OR CREATE RDMA RESOURCES ON STORAGE RDMA DEVICE WHEN IPCDAT IS DISABLED
33304775DO NOT CREATE IPCDAT EP FOR PROCESSES NOT ELIGIBLE FOR RDMA
33304830AVOID UNNECESSARY LGWR WORKERS ON EXADATA ROCE SYSTEMS
33307945SDO_INTERSECTION IS WRONG WHEN IT SHOULD BE NULL
33308107ORA-600[OPIRCNTCB1] AND ORA-1 DURING AN INSERT WITH ERROR LOG TABLE USED
33317996IAM TOKEN AUTHENTICATION MAKES DN MATCHING ENABLED BY DEFAULT
33322672SDO COMPONENT IS INVALID AFTER DOWNGRADE THE DATABASE FROM 19.11 TO 12.2.0.1.0
33326105DEBIAN SUPPORT IN PRO*C CONFIGURATION FILE PCSCFG.CFG
33330508LNX-21.4-RDBMS ORA-00600[KCVFDB_OPEN_PDB KJUPDBDOMATT] WHILE PDB OPEN
33331329INTERMITTENT ORA-65345 IN CLONE PDB WHEN LOG_ARCHIVE_DEST_N=LOCATION=USE_DB_RECOVERY_FILE_DEST IS NOT SET
33334404ORA-04054 DURING FAST REFRESH OF MVIEW IN 19.12
33335941MAKING BOOL AND BOOLEAN OPTIONAL WHEN USING [DIS]ALLOW BOOLEAN TO NUMBER [CONVERSION]
33337385STOP FREQUENT ATTEMPTS TO CREATE PMEMLOG QPS WHEN THE SYSTEM HAS REACHED THE QP LIMIT
33338247USE THREAD SPECIFIC (TLS) OBJECT CACHE FOR NPD ON WINDOWS
33349744DATABASE INSTANCES CRASHED WITH ORA-15267 DURING EXACS CELL NODE PATCHING
33353474USING KSEDMPPDBASSERTNM_BEGIN/END CAUSES CUSTOM DUMPS TO BE SKIPPED
33355007TRACKING BUG FOR CILENT IN PROJECT 78813
33373644WITH IAM TOKEN BASED AUTHENTICATION, AFTER FAILOVER CONTINUE FETCHING IS THROWING ORA-3113
33381652IO LATENCY HIGH ON PDB ALPSH1 DUE TO IOT PARTITION KEEP HINT NOT PASSED DOWN TO EXADATA STORAGE
33382620WORKLOAD INCREASE LEAD TO HANG AS CKPT STUCK WITH RDBMS IPC MESSAGE
33384092INSTANCE STARTUP FAILS DUE TO ORA-1507
33384505OLTP PERF - 210823 TPCC- SERVER TEST REGRESSION DUE TO KSPGIP FUNCTION
33387767KUP-13018 IO READ FAILED SHORT READ USING PARQUET FILES IN OBJECT STORE.
33392448UCP API for configuring an IAM Token
33397495MISSING LATCH PROTECTION IN KSWSPSSN_PDB()
33407135AIM ORA-32701 POSSIBLE HANGS UP TO HANG ID=2 DETECTED (ROOT LIBRARY CACHE LOCK / IMMEDIATE / TYPE DLCK) - KWQICGOB
33408858RTI 23963346 ORA-600 [KJB_START_RECOVERY PDB_CDB
33416405M1 OCIIAM IAM TOKEN AUTHENTICATION SUPPORT IN OCI PROJECT 89657
33417828SEGV DUE TO !RDOM >> LNX-21.4-RDBMS ORA-00600[KCVFDB_OPEN_PDB KJUPDBDOMATT] WHILE PDB OPEN
33417987Integrated extract fails with ORA-07445 causing DB server crash
33421305Fix for Bug 33421305
33425127RETURN A SPECIFIC STATUS FROM NZ/ZT WHEN MES FAILS TO LOAD FIPS LIBRARIES (NEEDED SPL FOR AIX 6.1 SUPPORT IN OLDER RELEASES)
33428316TRACKING BUG FOR RTI 24488371
33435313UPDATE AUTOUPGRADE.JAR IN 21.5 TO INCLUDE CUSTOMER CRITICAL BUG FIXES
33448908REMOVE THE HEALTH CHECK IN DISKMON FOR THE CELLSRV SHUTDOWN CASE
33457584UNINITIALIZED FLAG KGLGTBO_NAMERES IN KGLGTBO()
33457842RDBMS 19.12 ORA-43914 UNABLE TO DETERMINE COLLATION ARGUMENTS HAVE UNDEFINED COLLATION
33458732TRACKING BUG FOR THE RTI 24663312 CAUSED DUE TO BUG 33208008
33471858PROXY INSTANCE NO LONGER CALLS THE CLUSTER_STATUS IOCTL
334825909.12 SDO_AGGR_UNION ON A 3D POINT-GEOMETRY
3348969919.12 UPGRADE ON PDB ORA--02393 ALTER USER ON USER WITH PROFILE RESTRICTIONS ON CPU_PER_CALL
33497132JDK BUNDLE PATCH 21.0.0.0.220118
33500486FRA E26POD BUCKET ADBS-21.10.3.2
33507610ADB-S DROP PROFILE CRASH W/ ORA-600 [KZDPFU DELETE]
33507953RTI 23688012 IN RELATION WITH BUG 29829339 AND BUG 17036357
33514179UNDEFINED SYMBOL .MAX FROM KUBSCRF.C@@/ST_RDBMS_19/4
33540746DATAPATCH FAILS
33558058WRONG RESULTS WITH INVISIBLE COLUMN ON PK
33558391BDSQL4.1.2 POSTBANK CSV FORMAT QUERY RETURNS DIFFERENT ROWS WITH CELL OFFLOADING DISABLED
33559316LNX64-1913-CMT 19.10->19.13 DBVM SERVER PATCHING FAILED, DBVM FS BECAME READ-ONLY WITH ACFS ERRORS
33563137UPDATE JAVAVM JDK8 WITH JAVASE JAN 2022 CPU CONTENT
33563167TRACKING BUG TO UPDATE BUNDLEFCP.XML IN JAN 2022 RELEASE
33599734WRONG RESULT OR ERRORS LIKE ORA-01426 OR ORA-01722 IN LATERAL VIEWS IN 19.13
33613512IAD E26POD TRBLPRODDB HIGH MEMORY CONSUME /DIRECT PATH READ IN MERGE SENTENCE USING XMLTABLE
33651003ROLLBACK CHANGES FOR BUG 32610271
33656104BDSQL4.1.2 POSTBANK CSV WORKLOAD RETURNS DIFFERENT ROWS BETWEEN CELL ENABLED VS CELL DISABLED RUN
33661960SPATIAL CPU FIX FOR CVE-2021-44228 FOR SPATIAL CLIENT SIDE JARS
33674035LOG4J 2.16 CPU FIX FOR CVE-2021-44228 FOR SPATIAL CLIENT SIDE JARS

Below script can help to capture such patch information without direct opatch command

-- 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
;

No comments:

Post a Comment