Sunday, November 6, 2022

Total 94 bugs fixed in Oct-2022 Oracle 21c updates (21.8RU)


BUG_ID
DESCRIPTION
31987922SUPPORT SHA-2 FOR PKENCRYPT/PKDECRYPT IN DBMS_CRYPTO
32674819XMLTYPE VIEW COLUMNS ARE MARKED AS CONTIGUOUS ARRAYS IN CROSS-PDB QUERIES
32719456OUI SHALL OFFER OPTION FOR ALTERNATE CVU SOFTWARE LOCATION DURING INSTALL AND UPGRADE
32989794Fix for Bug 32989794
33053538AIM ORA-600 [KJBDOMFND DOMIDX] - KJBDOMFND
33061152AC JDBC-STRESS 19.12 DBRU NOUCP workload hang at checkMemoryPressureAndLog
33068672LNX64-21C ORA-600 ARGS [KYWMSTARTSWRF], ORA-7445 [KYWMPCIDX()+69]
33157547NEED TO ENABLE SAFE CREDENTIAL PASSING ON DBUA
33166125RDS/TCP ON ROCE HITS ORA-29770 AND 29771
33181498EXASCALE DBW0 HIT ORA-7445[KSFDX_GET_EFD()+367]
33243077LRGSRGDBCONF HAS DIFS + ORA-7445 WHEN RUN ON OL8U4 FARM HOST
33273598LISTENER FAILS WITH TNS-01166 WHEN AN EMPTY ACL LIST IS SENT
33357283UPDATE JACKSON-* JAR SYMLINK TO 2.12.3 AND SSHD-* JAR SYMLINK TO 2.7.0 JAR IN ORACLE LABEL
33393503WRONG RESULT IN CORRELATED SUBQUERY WITH REMOTE TABLES
33463044SCHED SCHEDSTRESS HIT ORA 600 [723] WHILE STOPPING DB SERVICES - JSKSCFBC 10 CHUNK LEAKING
33513526Fix for Bug 33513526
33575100SSLTEST IN FIPS MODE DOESNT PRINT TRACE LOGS WITH FIPS RELATED MESSAGES
33676296UNCONDITIONALLY SETTING SA_CACHETHIS IN NFS4.1 SEQUENCE OP CAUSES IO ERRORS
3371115121.5 DBVM DCS-10001 FAILED TO COPY PASSWORD FILE FOR DATABASE COPY PWFILE TO SHARED STORAGE FAILED
33726682CORRECT THE ERROR MESSAGE AND IMPROVE DIAGNOSTICS IN GET_LAST_ARCHIVE_TIMESTAMP PROCEDURE
33734040Fix for Bug 33734040
33737965Fix for Bug 33737965
33759379EXASCALE [INTUMT] - DBCA FAILED WHILE SETTING UP DB ON EXASCALE VAULT ([FATAL] PRCR-1079 FAILED TO START RESOURCE ORA.DBWQR.DB)
33770960Fix for Bug 33770960
33785175XF23.1TSWTZ_COL - TRC - QERANDVROP - ORA-600 [QERANDVROP.MIN.CVL]
33814415HUGE TRACE FILES WITH KOTGTBTPO ERR=21700
33817746PRINT REQUIRED TDE CONFIG DETAILS FOR ORA-28365 WALLET IS NOT OPEN ERROR
33833554Fix for Bug 33833554
33843512UPDATE RSA BSAFE MES 4.6.0 TO MES 4.6.1 VERSION
33848060CN ORA-600[KTRGTC2 OBJDCHK_KCBGTCR_5] IN STANDBY ENVIRONMENT
33860895LNX-19.12 MEMBER CLUSTERS ASM CLIENTS DID NOT RECONNECT TO THE HEALTHY ASM INSTANCE WHEN THE OTHER ASM INSTANCE WAS FAILING
33863150PROVIDE DATABASE SERVER SIDE WAY TO INFLUENCE THE CLIENT SIDE PREFETCH ROWS
33866472WRITE BOTH DEBUG AND ERROR MESSAGES WHEN DBMS_AUDIT_MGMT TRACE LEVEL SET WITH TRACE_LEVEL_DEBUG
33867451NEED TO ENABLE THE FLAG TO REMOVE THE HIDDEN PARAMETERS AS PART OF THE UPGRADE OPERATION
33867491DBUA FAILS TO FORMAT CORRECTLY THE _DBMSUMF$$1X PARAMETER
33876357EGSLIB SHOULD RETURN OSS_ERRCODE_REID_FENCED TO CLIENTS
33886862ORA-29024 CERTIFICATE VALIDATION FAILURE CAUSES SCAN LISTENER (PORT 1535) TO BE BLOCKED
33890694SR23.1OMS_PIB3 - TRC - KSFDX_ODM_IO - ORA-600 [KSFDX_ODM_IO_150]
33901168EXASCALE INFORM RDBMS WE NEED RESILVERING WRITES DURING RECOVERY (ODM_PERM_RESILVER)
33915925DB CREATION FAILURE DURING OEDA DEPLOYMENT WITH ASM SCOPED SECURITY ENABLED ON HYBRID CLUSTERS
33937705REMOVE NON-ERROR PATH TRACING FROM LIBCELL & ENROLLMENT PATH
33947548DBMS_METADATA_HACK NOT DROPPED AFTER DOWNGRADE FROM 23C TO 21C
33959377CELLSRV HITS ORA 600 CACHE INVALIDTARGETDEVICE - IO SENT INCORRECTLY ON MANAGEMENT DEVICE
33959383OSS_ENROLL NEEDS TO CORRECTLY INITIALIZE THREAD LEVEL DIAG CONTEXT
33978449Fix for Bug 33978449
33987734ORA-600_UNEXPECTEDHPKLIBRARYVERSION DURING HAS UPGRADE TESTS FROM 21 TO 23
34004063AIM ORA-7445 [KCIOPTISNULLSAFETEXTEXPR] - KCIOPTISNULLSAFETEXTEXPR
34010877ORA-04031 (STREAMS POOL,UNKNOWN OBJECT,APPLY SHARED T,KNGLCOLX)
34019087CVE-2020-36518 UPDATE JACKSON 3P TO 2.13.2/2.13.2.2 FOR OUI
34024924WRONG RESULT USING SDO_FILTER
34033430LRGRHEXAPROVCLUSTER_ONPREM - ORA-600 [EGSLIBFORUM UNABLE TO CREATE A WALLET CONTEXT]
34034279UTL_HTTP CALL FAILS WITH ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [STRLEN]
34054215MAKE TLS HANDSHAKE BE NON-BLOCKING - BACKPORT BUG
34069959LIBCELL CLIENTS TO HANDLE ENROLLMENT FAILURE REPLIES - BACKPORTING BUG
34088194Fix for Bug 34088194
34100909RDBMS KERNEL CHANGES TO FIX PERFORMANCE ISSUES IN COMPRESSING/ENCRYPTING SBT FOR DATABASE RECOVERY SERVICE
34103647NEW DIFFS FOR ASMCMD KEYSTORE COPY TESTS IN OPENSSL FULL RUN
34106567MTA AGTCTL AND MTA EXTPROC DO NOT SUPPORT ROOH
34110724EXASCALE HANDLE INSTANCE FENCING IN EXASCALE STORAGE SIMILAR TO HOW DONE IN ASM - DUMP STACK, TERMINATE PROCESS
34116531Fix for Bug 34116531
34118219LNX64-1915-CMT ORA-15260 IN ASM ALERT LOG DURING DB CREATION IN FLEX DISKGROUP ENV
34146833HM EXCESSIVE LE DUMPS AND LSR TRIGGERS DUE TO MANY SESSION WAITING ON SOME GC WAITS
34170459EXASCALE HONOR EDSLIB_ERROR_FAC_ORIGIN IN ERROR MESSAGES FROM EDSLIB.H
34229442EXASCALE DB HANG 32701 WITH SINGLE FAILURE TEST - SP_LIST IOCTL IS VERY SLOW
34238278MULTI-COLUMN CORRELATED SUBQUERY IN UPDATE IS CALLED MULTIPLE TIMES FOR EACH ROW
34238626EXASCALE PDB CLONE CREATION FAILED WHEN HAVING MULTIPLE OMF FILES IN A TABLESPACE
34244147ACCELERATE ENROLLMENT (BACKPORT BUG)
34264633BACKOUT CHANGES DONE IN BUG 31023680
34266633EGSLIB CLIENT FAILOVER FASTER WITH LEADER HINT
34271874EDSLIB ASSERTS AT VAULT/FILE OPERATION IF THERE IS NO SYSTEM DATASTORE
34291104OSS COMPONENT OF REMOVING PGA USE FROM KXDCM FIXED TABLE CALLBACKS
34301719INVALIDATE EDSLIB CACHED URLS OF EDS/BSM AT ACCESS ERRORS
34304388ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP WHILE UPGRADING GUEST NODES WITH DB ON EDV CONFIGURATION
34309783LIBEGS NEEDS TO FAIL I/OS WHEN THERE IS COMPLETE DATA LOSS ON THE NORMAL AND/OR HIGH REDUNDANCY RINGS
343103043 SESSIONS WAITING FOR GC CURRENT REQUEST FOR LONG TIME
34319499EXASCALE CLONE ATTEMPTING TO OPEN PDB IN STANDBY AFTER STOPPING APPLY RETURNS ORA-1113
34324384RANGE DROP REAP REQUEST ERROR DURING EXASCALE RESYNC TEST
34324942PROCURE_WALLET NEEDS TO TAKE A SHARED LOCK IF IT DOESNT EXPLICITLY CREATE A NEW WALLET
34326245BACKPORT TXN EVLACHOS_BACKPORT_LIMIT_ENROLLMENT_REQUESTS_2
34330164ENFORCE V1 EDSLIB FOR CLIENTS
34339332Fix for Bug 34339332
34351706SERVER CHANGES FOR CLIENT_PREFETCH_ROWS TO ENABLE BACKPORT
34363214Fix for Bug 34363214
34387852MAKE 32924796 FIX RAC ROLLING ON 19.15 DBRU
34398456Fix for Bug 34398456
34400514REMOVE DEBUG STATEMENT ADDED EARLIER
3442105312.1.0.2 DB INSTANCE STARTUP FAILING WITH ORA-7445 EXCEPTION
34461697Fix for Bug 34461697
34473578Fix for Bug 34473578
34491739SQL WITH SQL PLAN BASELINE FAILS WITH ORA-16000 ON PHYSICAL STANDBY
34509863TRACKING BUG FOR REGRESSION CAUSED BY CI BUG 32317587 INCLUDED IN 21.3
34570620WRONG RESULTS WITH CBQT ORE AND LEFT OUTER JOIN.
34574650SYS_CONNECT_BY_PATH STILL RETURNS WRONG RESULT AFTER FIX 34405413
34596863OCT2022 EXACS OCI DG DB UPGRADE IS FAILING IN PRIMARY WITH ORA-16026 PARAMETER LOG_ARCHIVE_DEST_2 WITH COMMA

94 rows selected.

Fix Control
SQL Feature
Description
31988833:1QKSFM_CBO_31988833Enable global caching of IMC stats per original qb
32856375:1QKSFM_CBO_32856375convert simple CASE to IS NOT NULL where apropriate
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.

No comments:

Post a Comment