Oracle Database 21.4.0 dictionary changelog

On this page, you can find the Oracle Database 21.5.0 dictionary changelog. This is a fully automated process, that basically does a diff on many important sys dictionary objects from this release with the previous one.

Please leave in the comments if you think that anything would worth to be included.

Have you enjoyed? Please leave a comment or give a 👍!

21.4.0 vs. 21.3.0


Underscore Parameters

Included in X$KSPPI (3)

NAME TYPE DEFAULT_VALUE ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC DESCRIPTION
_bug32823692_hang_parsing_hangs_resolution_interval 3 0 FALSE IMMEDIATE FALSE TRUE FALSE FALSE Hang Manager parsing hangs resolution interval
_hang_analyze_oradebug_time_limit 3 900 FALSE IMMEDIATE FALSE TRUE FALSE FALSE timeout for oradebug invoked hang analysis
_tkh_in_fsc_per_ts 3 5 FALSE IMMEDIATE FALSE TRUE FALSE FALSE Max tkh records stored in FSC per tablespace

Removed from X$KSPPI (3)

NAME TYPE DEFAULT_VALUE ISSES_MODIFIABLE ISSYS_MODIFIABLE ISPDB_MODIFIABLE ISINSTANCE_MODIFIABLE ISDEPRECATED ISBASIC DESCRIPTION
_fourteenth_spare_parameter 3   TRUE IMMEDIATE TRUE TRUE FALSE FALSE fourteenth spare parameter - integer
_hang_int_spare1 3 0 FALSE IMMEDIATE FALSE TRUE FALSE FALSE Hang Management int 1
_thirteenth_spare_parameter 3   TRUE IMMEDIATE TRUE TRUE FALSE FALSE thirteenth spare parameter - integer

Changed on X$KSPPI (5)

NAME COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
_dbrm_dynamic_threshold DEFAULT_VALUE 989922280 17302504
_dbrm_runchk DESCRIPTION Resource Manager Diagnostic Running Thread Check DBRM kskrunstatechk thresholds
_dbrm_runchk DEFAULT_VALUE 32769000 32798000
_rm_superlong_threshold DESCRIPTION DBRM superlong threshold setting DBRM kskrunstatechk superlong threshold
_rm_superlong_threshold DEFAULT_VALUE 0 300000

System Privileges

Removed from DBA_SYS_PRIVS (6)

GRANTEE PRIVILEGE ADMIN_OPTION COMMON INHERITED
GGSYS SELECT ANY DICTIONARY NO YES NO
GGSYS CREATE ANY TABLE NO YES NO
GGSYS CREATE DATABASE LINK NO YES NO
GGSYS ALTER ANY TABLE NO YES NO
GGSYS SELECT ANY TABLE NO YES NO
GGSYS ALTER ANY INDEX NO YES NO

Table Privileges

Included in DBA_TAB_PRIVS (9)

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
PUBLIC SYS sun/java2d/ReentrantContext SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/ReentrantContextProvider SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/pipe/AAShapePipe$TileState SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/ReentrantContextProvider$HardReference SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/ReentrantContextProviderTL SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/ReentrantContextProviderTL$1 SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/pipe/AAShapePipe$1 SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS java/util/HashMap$UnsafeHolder SYS EXECUTE NO NO NO JAVA CLASS NO
PUBLIC SYS sun/java2d/ReentrantContextProviderCLQ SYS EXECUTE NO NO NO JAVA CLASS NO

Removed from DBA_TAB_PRIVS (3)

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERARCHY COMMON TYPE INHERITED
GGSYS SYS DDL_REQUESTS SYS INSERT NO NO YES TABLE NO
GGSYS SYS DDL_REQUESTS_PWD SYS INSERT NO NO YES TABLE NO
PUBLIC SYS sun/awt/SunToolkit$OperationTimedOut SYS EXECUTE NO NO NO JAVA CLASS NO

List of Fixes

Included in Fixes (229)

BUG_ID PATCH_ID BUG_DESC
24559425 33239276 ET12.2OPTIM ORA-600 [KKQCSCPOPNWITHMAP 0] ON A QUERY EXPLAIN PLAN
25562258 33239276 JPPD IS NOT HAPPENING WHEN CREATING FUNCTION BASED INDEX WITH JSON_QUERY
28882751 33239276 ORA 600 [KDZC_COPY_COLGRP DECOMPBUF OVERFLOW]
29587488 33239276 CREATE VIEW OF COMPLEX QUERY FAILS WITH ORA-04030 AFTER 18C UPGRADE
30610097 33239276 IMPLICIT DATA CONVERSION FROM BLOB TO RAW GIVES WRONG DATA.
30722105 33239276 QUERY INVOLVING ROWID FAILS WITH ORA-600 [RWORUPO.1] ON 19C
30808364 33239276 ORA 7445 [QOSPBLKCNTS] AFTER CTAS INSERT RANGE-LIST PARITIONED TABLE
30876666 33239276 ORA-07445 [KKPAPITOPEN()+1541] [SIGSEGV] [ADDR 0X28] [PC 0X2A01FA5] [ADDRESS NOT MAPPED TO OBJECT ]
31006259 33239276 DBA_FEATURE_USAGE_STATISTICS MISREPORTING PARTIONING(USER) WHEN MDSYS IS NOT PRESENT
31251325 33239276 SPURIOUS ORA-2290 USING DATE COL AS VIRTUAL PARTITIONING COLUMN
31287296 33239276 WRONG RESULTS ON SELECT COUNT FROM A VIEW
31414524 33239276 DISABLE THE AUTOTASK GATHERING SQL PLAN INFO FROM THE CURSOR CACHE AND INTO AUTO STS
31526250 33239276 FIX FOR 31010670 CAUSES REGRESSIONS IN TIMESTEN PRO*C CURSOR BEHAVIOR
31615736 33239276 TIMESTEN ODBCTEST/DSREGCS (TTOCI) FAILOVER TEST CORE DUMP IN X10ALLBUNDLED()
31731407 33239276 RAC 21C IN DOCKER CONTAINERS ENCOUNTERS ORA-27302 FAILURE OCCURRED AT SKGPIIDCOMPA
31800059 33239276 SR21.1PX_FORCE - TRC - KCB_OBJDCHK_ASSERT - ORA-600 [KTSFBFMT OBJDCHK_KCBNEW_3]
31824792 33239276 ORA-00600 [KKQCSCPOPNWITHMAP 0] INTERNAL ERROR FOR QUERY USING AWR TABLES
31834214 33239276 SR21.1CHAOS_V2 - TRC - KSKRUNSTATECHK - ORA-700 [K SKRUNSTATECHK_MISBEHAVE_RUNNING]
31841210 33239276 DIAGNOSTIC TRACING IMPROVEMENT IN RAM DATA AREA
31844557 33239276 ORA-00322 AND ORA-00312 ON PHYSICAL STANDBY DATABA SE
31923463 33239276 AIM ORA-7445 [_INTEL_FAST_MEMCMP] - KOLRCOMP
31927078 33239276 ONLINE TABLE MOVE GENERATES AN ORA-60 IN ALERT.LOG BUT COMMAND IS SUCCESSFUL
31932042 33239276 ADD TIMEOUT POLICY TO HANGANALYZE
31933842 33239276 UNINITIALISED VARIABLE IN X10ERRSETVARARGS OF X10ERR.C 160
31933846 33239276 UNINITIALISED VARIABLE IN X10VERVERSION OF X10VER.C 301
31933914 33239276 COMPARISON OF VALUES WITH DIFFERENT ENUM TYPES IN NULL OF X10AUT.C 754
31938116 33239276 GDSCTL VALIDATE THROWS ERROR WHEN COMMON SERVICE EXIST IN MORE THAN ONE GDS POOL
31959140 33239276 DIA-48216 FIELD LEN EXCEEDS MAX FIELD LENGTH AFTER UPGRADE FROM 12.2 TO 19.8
31982879 33239276 WRONG RESULT IN INSERT AS SELECT WITH TO_CHAR(SYSD ATE)
31988833 33239276 PARSE TIME INCREASE WITH DML ACTIVITY FROM 8 S TO 160S IN 30 DAYS
31992615 33239276 ORA-00942 RAISED IN SEM_APIS.GRANT_NETWORK_SHARING_PRIVS DBA CALL
31994298 33239276 GG extract write 0 in tail for EHCC Float datatype columns
31997660 33239276 SR21.3ADBS19_INIT_ORA - TRC - ORA-600 [15593]
32008408 33239276 ADB-CC DG ACL CONFIG FAILS WITH ORA-46988 ACCESS CONTROL PROPAGATION TIMED OUT.
32020701 33239276 USERS WITH SYSTEM AS LOCAL_TEMP_TABLESPACE AFTER UPGRADE TO 19.8
32056529 33239276 PGA MEMORY LEAK ON ALLOC ENVIRONM CHUNK WITH FAST REFRESH OF ON-COMMIT MVIEW
32057565 33239276 AQAH DECODE AND DUMP KDI RETURN CODES FOR IOT OPER ATIONS
32069508 33239276 HIGH LATCH CACHE BUFFERS CHAINS CONTENTION IN STANDBY DATABASE
32071457 33239276 EXACC BB DB UPGRADE DB DOWNGRADE 19C TO 18C FAILS BECAUSE [FATAL] [DBAAS-54007]
32081381 33239276 ISSUE WITH FIX FOR BUG 29050886
32114541 33239276 BUG FOR MAIN - DB STARTUP FAILS WITH ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [IPC_RECREATE_QUE_2] AFTER DISABLING TOPOSVC
32132504 33239276 ALL SESSIONS HANG. LOG FILE SWITCH CHECKPOINT INCO MPLETE
32178966 33239276 UPGRADE TO 19.8 FROM 12.1 - SYS.FILE_WATCHER JOB/SCHEDULE MISSING
32183756 33239276 REGRESSION TRACKING BUG FILED FROM MERGEREQ
32184235 33239276 PET ORA-600 [25027] ERROR WHILE EXCHANGE PET WITH INTERNAL TABLE
32185296 33239276 WRONG RESULTS ON SELECT STATEMENT
32198292 33239276 EGUL-DEV1|SQLEXCEPTION ORA-00600 INTERNAL ERROR CODE |US2GD6IV1
32199681 33239276 OPENING PDB SHUTS DOWN THE INSTANCE WITH ORA-07445
32219835 33239276 PERFORMANCE DEGRADED WITH LIBRARY CACHE MUTEX X WITH DATABASE VAULT ENABLED 19C
32225117 33239276 ON CDB UPGRADES, CATCTL.PL SHOULD GATHER INVENTORY INFORMATION ONLY ONCE
32225742 33239276 GATHERING DATABASE STATISTICS IN PRIMARY NODE RESULTS IN ORA-4061/ORA-04065 IN SECONDARY NODES.
32249371 33239276 EXCESSIVE LOG FILE PARALLEL WRITE OUTLIERS DUE TO SINGLE HCA BOTTLENECK ON 8-SOCKET DB NODE
32254686 33239276 INSTANCE CRASHED AFTER CL PROCESS HITS ORA-00600 [ KSS_TO_PRIVATE_SO]
32292805 33239276 FADBRWT NOTSTRESS FA HANG WHEN CHANGING PASSWORD FOR COMMON USER
32297469 33239276 DB CREATION WITH ASM TEMPLATE SUPPORT THROWS ORA-6 5180
32297849 33239276 XF21.3OPT_OR_EXPAND - TRC - EVAITN - ORA-600 [1233 8]
32300822 33239276 DBCA FAILED ORA-27138 UNABLE TO ALLOCATE LARGE PAGES WITH CURRENT PARAMETER SETTING IN CRDB IN EX ADATA
32312412 33239276 NEED TO ENABLE FIX CONTROL FOR THIS BUG# 29738374
32342345 33239276 ORAPKI WALLET COMMAND TO CONVERT PKCS12_TO_JKS RETURNS NULL WHEN WALLET LOCATION IS NOT SPECIFIED
32346254 33239276 HANDLE FPLIB ERROR HANDLING OF ENCRYPT/DECRYPT CAL LS.
32346649 33239276 X10 LAYER IS MISSING OCI_ATTR_PREFETCH_ROWS AND _MEMORY ATTR SETTINGS
32357412 33239276 FOLLOW ON CHANGES 31427102 - AH BLOCK CHECK ERRORS IN FATAL BACKGROUNDS SHOULD BE PDB LOCAL REGRESSION ALERT
32361677 33239276 WHEN _REMESSAGE_DBWRS SET TO NON-DEFAULT VALUE PERFORMANCE DEGRADES ON 18.6 TO 19C
32365085 33239276 ORA-07445 CORE DUMP [PC 0X0] [SIGSEGV] [ADDR 0X0] [PC 0X0] [ADDRESS NOT MAPPED TO OBJECT] - KSEDST() +109
32366303 33239276 MULTIPLE PDB UPGRADE IN PARALLEL FAILING
32368480 33239276 UNDO_RETENTION VALUE IS NOT KEEP IN PDB AFTER APPLYING OCT 2020 19.9 PATCH
32386720 33239276 SPORADIC WRONG RESULT FROM A QUERY IN 19C SE2
32390629 33239276 WRONG RESULTS FOR COUNT() WITH BUG 24761824 FIX
32394623 33239276 LNX64-21.3-RAC,DB HIT ORA-322,ONE INST CAN`T OPEN
32396326 33239276 ADVANCED COMPRESSION USES _LIMIT_ITLS AFTER 24453200, CAUSING SPACE INCREASE
32408640 33239276 QUERY ON INTERVAL PARTITIONED TABLE IS NOT OFFLOADING DUE TO INCORRECT OBJECTS SIZE CALCULATI ON.
32423985 33239276 MESSAGES ARE NEVER MOVED TO THE EXCEPTION QUEUE WHEN ROLLED BACK IN SHARDED QUEUE USING JMS/JAVA
32426213 33239276 NSGR NETWORK DATA VALIDATION SHOULD HAPPEN REGARDLESS OF TRACING LEVEL
32427158 33239276 ORA-43914 AFTER UPGRADING FROM 12.1 TO 19C
32427953 33239276 SR21.3MFSR_CONC_PDB_OPS - TRC - KZTSMMUMKH - ORA-600 [KZTSMSS INVALID PDB SPECIFICATION]
32431251 33239276 ORA-600 [QCTOTMF1] CREATING A VIEW
32432078 33239276 AIM ORA-600 [INSSETOPNINFO 1] - INSSETOPNINFO
32436460 33239276 ALERT LOG PRINT DOES NOT REFLECT SCOPE USED IN ALTER SYSTEM
32441671 33239276 ASM REBALANCE FAILED WITH ORA-600 [KSFDHARDCHK_ERR] WHILE RUNNING RESTORE FORCE FROM TAG COMMANDS
32462153 33239276 RDBMS UPGRADE FROM 12.1.0.2 TO 19.7.0.0
32465193 33239276 AIM ORA-700 [KSKDBRMTOUTACT UNEXPECTED ERROR] - KS KDBRMTOUTACT
32465209 33239276 SUM AGGREGATE FUNCTION GENERATING WRONG RESULTS IN 19C
32465495 33239276 INSTANCE CRASH WITH ORA-00600 [KGHVALIDATE_LAST]
32471100 33239276 W2K16 21C/GI/INSTALL CLUVFY POST CRSINST FAILED WITH PRVF-5157 COULD NOT VERIFY ASM VOTE DISK DUE TO KFOD EXECUTION FAILURE
32478452 33239276 OGG process abends with ORA-00600 [733] and [600]
32481807 33239276 PGA LEAK FOR MMON SLAVES WITH BUGS 31695062 AND 31425761 FIXED
32506473 33239276 DOWNGRADE THE DATABASE FROM 19C TO 11.2 HANG DUE TO DELETE FROM COLLECTION$
32507542 33239276 HA IS CONFIGURED THROUGH NEXT_HOP IN CMAN.ORA. WHILE TCP USED IN CMAN IT FAILOVER TO THE NEXT HOP BUT WHEN TCPS BEING USED IT IS NOT FAILING TO NEXT HOP
32515850 33239276 ORA-00922 AFTER CHANGING PASSWORD OF THE SHARDED USER USING SPECIAL CHARACTERS
32523613 33239276 WRONG RESULT(NULL) WAS RETURNED WHEN THERE WAS A CHECK CONSTRAINT
32529396 33239276 UNIFIED_AUDIT_POLICIES COLUMN EMPTY FOR SOME ENTRI ES
32530202 33239276 WRONG RESULT IN CORRELATED SUBQUERY WITH FIX 27864 047
32533461 33239276 PHSB FAILOVER GETS ORA-3113, INSTANCE CRASHES ORA-1093 (STANDBY_DB_PRESERVE_STATES=ALL)
32538824 33239276 FADBRWT STRESS IDCS AQ_CLIENT HIGH EXECUTION COUNT AND CPU USAGE OF DBMS_AQIN.SET_MULTI_RETRY AND DBMS_AQIN.SET_DEQ_SORT SEEN
32544740 33239276 SCHEDULER JOB (CLEANUP_NON_EXIST_OBJ) CONSUMING EXCESSIVE RESOURCES
32556165 33239276 LEAK IN /XDK/MESG/LSXUS.MSB IN SHARED SERVER MODE
32579075 33239276 [DI] CDB_RAC_IM ORA-600 [KTRGTC2 KCBZ_OBJDCHK] WHILE RUNNING THE WORKLOAD IN CONCURRENT SESSION
32580852 33239276 QUERY USING CATSEARCH HANGS ON 19.9RU
32583315 33239276 GENERIC KRC EXTENT PRE-ALLOCATION DURING BITMAP SWITCH MAY CAUSE CT GLOBAL ENQUEUE CONTENTION.
32583355 33239276 Fix for Bug 32583355
32584375 33239276 INSTANCE STARTUP FAILURE WITH ORA-600[17090] / ORA-00604 / ORA-04024
32587793 33239276 APPLICATION USING ODPU 19.1 CRASHES INTERMITTENTLY WITH OCI-22303
32588656 33239276 BUGS IN RDBMS PREVENT UPGRADE OF TIMESTEN TO RDBMS 19C
32594965 33239276 MERGE STATEMENT ON REMOTE TABLE IN CONJUNCTION WITH FORALL FAILS SILENTLY, DOES NOT RAISE PLS-007 39
32597637 33239276 INSTANCES WITH PATCH 31858113 STILL CRASHED WITH ORA-7445[KGSKENTSCH] DURING INCREASING OCPU
32602990 33239276 SQL FAILS WITH AN ORA-7445[KKOPPJT()+250] ERROR
32607991 33239276 LOTS OF KJGCR_SLAVEACTIONCBK ECALL ERROR GCR TRACE FILES
32608583 33239276 FPLIB ORA 600 [KDZFPERFORMCRYPTOONMETADATA COL_OFF SET]
32610271 33239276 IN PRODUCTION THE SET ROLE TAKES A LONG TIME IN CONCURRENT SESSION AFTER UPGRADE TO 19.10
32618819 33239276 RTI 23517807 ORA-03113
32619195 33239276 JSON DATE/TIME PARSE SHOULD TOLERATE ISO FORMS
32620859 33239276 VOLUME FILEGROUP CANNOT INHERIT TEMPLATE FILEGROUP PROPERTIES
32621140 33239276 ODAVM RMCC FAILS TO DELETE FILES FROM ORPHAN CLIEN TS
32621309 33239276 KUP-04001 ERROR WHILE ACCESSING EXTERNAL TABLE WITH SHARED SERVER CONNECTION
32626756 33239276 WRONG RESULT IN A SQL WITH CAST AFTER FIX 27828892
32626830 33239276 XSLT PROCESSOR CAN GROW LARGE WITH INTERNAL STACK MEMORY
32629028 33239276 SR21.1CHAOS_V2 - TRC - NAM1_KKSEV - ORA-7445 [NAM1 _KKSEV()]
32642587 33239276 QUERY HAVING UNION ALL PERFORM POORLY AFTER UPGRADE TO 19.10.0.0 FROM 11.2.0.4
32645139 33239276 ADB-D ORA-4031 IN ATPD PREVIEW 2 CLUSTER - HALF RA C
32651063 33239276 RESYNC USING VAM NEEDS TO ROUND ROBIN ON DISK
32662165 33239276 ORA-12801 & ORA-22922 NONEXISTENT LOB VALUE ON EXADATA RAC WHEN CREATING INDEX IN PARALLEL
32672057 33239276 CREATE CTXCAT INDEX WITH CHINESE_VGRAM_LEXER FAILS WITH ORA-12899 IN 19C
32675095 33239276 LOSING DATA PERFORMING A DISTRIBUTED TRANSACTION FROM ORACLE 12 TO ORACLE 19 AND ORACLE 12 DATABASE S
32685286 33239276 JDK BUNDLE PATCH 21.0.0.0.210420
32692372 33239276 XMLURL.C MISHANDLES LOWERCASE HEX CHARACTERS DURING URL DECODE
32698508 33239276 DATABASE CRASH WITH ORA-00600 [KCLGENERATECR_3]
32701048 33239276 MEMORY CORRUPTION IN SPREADSHEET (MODEL CLAUSE) WITH ANALYTIC FUNCTIONS
32704013 33239276 AVOID CFT IOS WHEN FILE BITMAP SWITCH IS NOT NEEDE D
32710534 33239276 XQUERY FAILS WITH ORA-19114 XPST0003, ORA-19202, XVM-00651 VM STACK OVERFLOW
32720344 33239276 CONTROLLED DESTRUCTIVE CONCURRENT WORKLOAD ON RAC HITS ORA-700 [KJSOS2M TOPCVT FWDED]
32734171 33239276 EXADATA DANPXI6840DB04 GOT EVICTED WHILE CRSCTL STOP CRS -F IS IN PROGRESS
32734800 33239276 ORA-22993 IS RAISED WHEN KOLARS IS COPIED TO TEMPORARY LOB
32737969 33239276 HIGH ROW CACHE MUTEX WAIT WITH SPATIAL QUERIES
32743290 33239276 CREATE OR REPLACE VIEW DOESNT WORK PROPERLY IN ORACLE DATABASE 19.9
32753472 33239276 MANY SLOWDOWNS IN GCS DRM FREEZE IN ENTER SERVER MODE EACH DAY
32755517 33239276 HIGH VERSION COUNT DUE TO USER_BIND_PEEK_MISMATCH AFTER FLUSH SHARED POOL
32761294 33239276 ORA-4030 DURING MGA ALLOCATION SHOULD DUMP PGA SUMMARY AS WELL AS MGA STATS
32763050 33239276 DGPDB RECOVERY WILL RESTART CONTINUALLY IF FAILS DURING APPLY
32768752 33239276 RMAN DUPLICATE ON RACONENODE FAILED WITH ORA-24544 EVEN THOUGH THERE IS NO OTHER DB UP
32769880 33239276 XMLELEMENT LEADS TO HIGH CONSUMPTION OF PGA LEADS TO ORA-04036 OR ORA-4030
32775512 33239276 Fix for Bug 32775512
32776891 33239276 Fix for Bug 32776891
32789228 33239276 SQL QUERY AGAINST LARGE RANDOM FOREST MINING MODEL TAKES TOO LONG
32797486 33239276 ORA-39707 COMPATIBILE PARAMETER 19.10.0. TOO HIGH FOR DOWNGRADE TO 19.0.0.0
32800137 33239276 ALLOW FK-PK CONSTRAINT BETWEEN SHARDED TABLE AND DUPLICATED TABLE UNDER AN EVENT.
32801337 33239276 TIMESTEN ERROR MESSAGES INCORRECT AFTER TRANEY_BUG -19665562
32803807 33239276 UPDATE RSA BSAFE MES 4.5 TO MES 4.6 VERSION
32810125 33239276 VIO PROCESSES SHOULD PASS CACHE HINT RETURNED BY OSS TO ADVM
32822847 33239276 UNINITIALIZED VARIABLE IN KOLE_LOB_LOB_COMPARE()
32823692 33239276 HM ENABLE RESOLUTION OF HANGS INVOLVED IN HARD PARSING SQL
32827206 33239276 LNX64-21C ORA-600 ARGS [KCLCLS_2], ORA-600 ARGS [K CLCLS_12]
32829563 33239276 DATABASE INSTANCE HANG WITH ENQ KO - FAST OBJECT C HECKPOINT
32831451 33239276 DROPPING COMMON USER DOESNT CLEANUP COMMONLY GRANTED PRIVILEGES
32838028 33239276 AUOTUPGRADE TO ORACLE19C FAILED DUE TO REALM VIOLATION ISSUE
32838533 33239276 PARAMETER TO DISABLE READAHEAD FEATURE FOR FETCHBY ROWID IN 256K ALLIGNED FILES
32848816 33239276 LNX64-23C ORA-7445 CORE DUMP AT IPCGXP_ALARM_WRAPP ER()+14
32857881 33239276 RECOVER WITH ALLOW 1 CORRUPTION NOT WORKING FOR ORA-00600 [KDBBLKCHECKERROR]
32868369 33239276 DG BROKER REINSTATEMENT OF BYSTANDER STANDBYS
32874773 33239276 EXASCALE KSFDX.C I/O PERFORMANCE FIXES.
32875003 33239276 FNDD HITS IPCDAT_RESIZE_CQ CRASH DUE TO CONCURRENT CALLS INTO IPCDAT IN SINGLE-THREADED MO DE
32875118 33239276 CTWR FAILED WITH ORA-600 [KRCCFL_CHUNK] WHILE OPENING PDB JUST PLUGGED
32880390 33239276 ORA-04020 DEADLOCK DETECTED WHILE TRYING TO LOCK OBJECT SYS._NEXT_OBJECT.?
32883252 33239276 ORA-43907 REPORTED USING WITH AS AND VIRTUAL COLUM NS
32891500 33239276 ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [17182] - KFFFILEDESTROY()
32898971 33239276 SIGNIFICANT INCREASE IN SQL VERSION COUNT POST UPGRADE FROM 18C TO 19.11 DUE TO DATA REDACTION
32903472 33239276 STILL NO PCODE AGGREGATION WITH DUPLICATE FACT COLUMN REFERENCES
32903625 33239276 ORA-24102 INVALID PREFIX FOR GENERATE_JOB_NAME FOR LOGMINER PURGE JOB
32907741 33239276 REMOVE OCIPING CALL FROM TEXT INDEX SCAN CLOSE
32915747 33239276 LOAD FILES FROM OH FOR RUR ROLLBACKS IN DATAPATCH
32915847 33239276 ASSERT KGLGETSESSIONUOL SESS-MISMATCH IN KGLGETSES SIONUOL()
32916025 33239276 [NODP] FADBRWT STRESS FA STACK INVALID SPATIAL COMPONENT AFTER APPLYING DATAPATCH IN 19.9.0 + RDBMS MLR210514
32918585 33239276 JDK BUNDLE PATCH 21.0.0.0.210720
32922090 33239276 IAD E19POD HANG SESSIONS DETECTED
32930360 33239276 ORA-7445 [KSVWORKMSGFREE() IN TMON PROCESS
32936005 33239276 19.11 CMU FIRST CONNECTION FAILS AS ORA-01017 EVEN WITH PATCH 32885732,31404487
32947264 33239276 ENSURE DATAPATCH AUTO RECOMPILE RUNS AS SYS
32962378 33239276 TRACKING INT DIF IN SRGDBCONF2 ORA-7445_KSFDX_GET_ EFD.DIF
32965460 33239276 ORA-17500 WHEN STARTING THE DATABASE USING SQLPLUS / AS SYSDBA.
32968221 33239276 RTI 24236006 UPGRADE FAILS WITH ORA-01722 EVEN IF ONE OF THE WALLET IS IN OPEN STATE.
32972633 33239276 EXASCALE SRVCTL ADD FILESYSTEM FAILS IN EDV ENVIRONMENT WITH ERROR PRKF-1431 EDV VOLUME DEVICE PATH /DEV/EXC/DUMMY IS NOT SUPPORTED ON AN ORACLE ADVM CLUSTER ENVIRONMENT AFTER STARTING ASM INSTANCE
32973406 33239276 DIAGNOSTIC BUG INSTANCE CRASHED WITH ORA-00600 [KC L_SHRINK_ANTI_BG_1]
32983750 33239276 INSTANCE CRASH WITH ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KJMSP1 !FOUND],
32987308 33239276 WITH SUPPLIMENTAL LOGGING ORA-600 [KDLWFLUSHRETRYSETUP PREPARE NO SAVEPOINT
32993522 33239276 SHOULD NOT CLEAR KJZNSESS_FB_* FIELDS WHEN FINAL BLOCKER INFO IS CLEARED - RTI 24197458 TRACKING BU G
32999086 33239276 KGHFND_IN_FREE_LISTS IS VERY SLOW DURING THE FIRST HARD PARSE OF A COMPLEX PROCEDURE OR COMPILE
33005831 33239276 EXASCALE XDMG PROCESS NOT STARTING ON ASM INSTANCE WHEN EXASCALE INSTALLED.
33009224 33239276 FADBRWT STRESS FA ARCHIVE LOGS FILLED WITH QUERIES ON FLASHBACK SYSTEM TABLE - SYS_FBA_BARRIE RSCN.
33009351 33239276 19.11 ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KCLCLS_2], [181],
33011198 33239276 OCI DB UPGRADE DBUA EXITING WITH STATUS 6 THOUGH COMPONENT UPGRADE FAILED
33026533 33239276 ODH-CLOUDSQL QUERYING ALL_HIVE_TABLES IS FAILING AGAINST ODH CLUSTER.
33027525 33239276 AFTER UPGRADE TO 19C GROUP BY WITH GROUPING SETS GIVES WRONG VALUE FOR SUM
33035201 33239276 ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KJBRMNOT WN] WITH FIX 31965391 IS ALREADY APPLIED .
33042780 33239276 KDZSGETMINMAX() SHOULD SKIP DELETED ROWS
33060161 33239276 ORA-600 [15264] DURING DBMS_PDB.CLEANUP_TASK
33061339 33239276 19CCUSTOMERUPGRADE DATABASE DOWN ORA-07445 EXCEPTION ENCOUNTERED CORE DUMP [KTFBNB_CHANGE_FFB ()+6223]
33063919 33239276 EXCEPTION [TYPE SIGSEGV, ADDRESS NOT MAPPED TO OBJECT] [ADDR 0XFFFFFFFFFFFFFFEF] [PC 0X14FB529F, KGHFRF()+687]
33069366 33239276 OGG CDB PR INTEGRATED ABEND W/ OGG-01296 ERROR MAPPING DUE TO LOGMINERS DUPLICATE PK UPDATES
33105656 33239276 ORA-14631 AFTER PATCHING TO 19.10.0.0
33109335 33239276 FADBRWT SCHEDULER JOBS FOR AUTO SYNC OF TEXT INDEXES ARE SEEN TO BE FAILING WITH ORA-01031 WITH DV ENABLED
33110580 33239276 WRONG RESULT IN STORAGE INDEX MIN QUERY
33111729 33239276 HM LSR STILL NOT TRIGGERED FOR ALL SINGLETONS WAITING ON GC WAITS
33114640 33239276 IPC LABEL SIDE OF THE FIX IN BUG 32848816
33120828 33239276 ORA-64388 ON NUMA SYSTEMS WITH DEFERRED SGA
33121880 33239276 AC CANNOT FAILOVER FROM EARLIER 19 RU TO 19.11/19.12 ORA-41451 WHEN NOT REPLAYING
33123985 33239276 DBW PROCESS GENERATE HUGE TRACES WITH DUMPING DBWR PROCESS STATE AFTER DBRU 19.11
33127141 33239276 AIM ORA-7445 [KKQSTSAMEOPNDATATYPES] - KKQSTSAMEOP NDATATYPES
33131742 33239276 NNE PATCHED CLIENTS VS 11.2 PATCHED SERVER GET ERROR CHECKSUM FAIL WHEN USING RC4_128/RC4_256 OR KERBEROS+MD5
33134819 33239276 Fix for Bug 33134819
33156632 33239276 TRACKING BUG FOR RTI 22393174
33166560 33239276 TRACKING BUG FOR RTI 23755718 (ORA-05774 MALICIOUS TIME 27-JUL-21 03.01.51.489 AM +00 00 DE TECTED)
33172631 33239276 TRACKING BUG FOR RTI 23747863 ORA-600 [16609],
33185773 33239276 ENABLING BCT AFTER 19.11 UPGRADE CAUSE BCT FILE SIZE TO INCREASE TO 32GB IN SECS
33211160 33239276 CANDIDATE REGRESSION TRACKING FOR BUG 17777718
33212112 33239276 ORA-600 [KCLLREM_2], (RTI 24370784)
33218194 33239276 ORA-17500 ODM ERR ODM ERROR V-41-4-1-182-21 IS A D IRECTORY
33223248 33239276 Fix for Bug 33223248
33242408 33239276 SCL POOR PERFORMANCE OF SCL APPCTRL-1 SERVER BECAUSE OF HUGE ORA PROCESS COUNT .
33252648 33239276 TRACKING BUG TO UPDATE BUNDLEFCP.XML IN OCT 2021 R ELEASE
33278133 33239276 ORA-4031 (STREAMS POOL,UNKNOWN OBJECT,STREAMS POOL,FIXED ALLOCATION CALLBACK)
33278509 33239276 REGRESS DIFS FOR LABEL RDBMS_18.1.0.0.0_LINUX.X64_ 210824
33289442 33239276 Fix for Bug 33289442
33295267 33239276 TRACKING BUG FOR REGRESSION RTI 24451917 CAUSED BY RANKALIK_BUG-32368480 APPROVED/INCLUDED IN 19.0.0.0 DBRU
33317279 33239276 LNX-19C-GI ASM DISKGROUP REBALANCE FAILED WITH ORA-00600 INTERNAL ERROR CODE, ARGUMENTS [KFDVAXTNTMIGRATE_BN] FOLLOWING AN ADD DISK OPERAT ION
33325981 33239276 QUERY LOSES SUBQUERY UNNESTING FROM PLAN IN 19.9 AND ABOVE
33332891 33239276 TRACKING BUG CATXDBTM.SQL IS MESSING WITH TTS EXPORT BY CONDITION INTRODUCED IN BUG 29716491
33338891 33239276 FRA E17POD JSON RELATED APPLICATION FAILURES POST DBHOME PATCHING
33367909 33239276 ON 19.12 ORA-7445 [KAUXALO] WITH JSON TABLE/INDEX
33388473 33239276 OGG-02092 Unexpected condition in indexOutOfRangeError at line 50. Index 40 out of range. Number of elements 25
33480963 33239276 UPGRADED PDBS NOT GETTING 21.4 RU APPLIED (SILENT FAILURE)

Fix Control

Included in V_$SYSTEM_FIX_CONTROL (5)

BUGNO VALUE SQL_FEATURE DESCRIPTION OPTIMIZER_FEATURE_ENABLE EVENT IS_DEFAULT
29738374 0 QKSFM_MVIEWS_29738374 delete orphan rows in sys.snap_logdep$ during mview refresh   0 1
31988833 0 QKSFM_CBO_31988833 Enable global caching of IMC stats per original qb   0 1
32408640 0 QKSFM_FIRST_ROWS_32408640 correct settings when switching between Kmode and Amode   0 1
32800137 0 QKSFM_DDL_32800137 allow sharded table reference duplicated table   0 1
33325981 0 QKSFM_UNNEST_33325981 allow unnesting in some cases previously restricted   0 1

Non-binary files

Included in Oracle Database Home (11)

PATH MD5_HASH
./inventory/oneoffs/33239276/etc/config/actions.xml 402C5B6E9E4A959768FC55B6B93896CE
./inventory/oneoffs/33239276/etc/config/inventory.xml 899464976FBDF5CB4C0E950B957808FA
./jdk/bin/ControlPanel 2FA50A6D3C0A1BD4A607E813FB974926
./jdk/jre/bin/ControlPanel 2FA50A6D3C0A1BD4A607E813FB974926
./rdbms/admin/backport_files/bug_32583355_apply.sql 0CE6559A63D7DDB211E8113F082909FC
./rdbms/admin/backport_files/bug_32610271_apply.sql C8A0C69C9699853DB5CE5005775993C0
./rdbms/admin/backport_files/bug_33109335_apply.sql 0FC96F8A7EF47C6D432704A3866CBCA0
./rdbms/admin/backport_files/bug_33109335_rollback.sql 2ACE3830C1BF6101E7CD48BE194C297F
./rdbms/admin/bug_32953737_pre_rollback.sql A47EDF341837A6B37A588D8F855938BB
./rdbms/admin/kspapv3.var AFC43950FC34FD9CF110F68CA58F8813
./rdbms/admin/kspapv4.var 5FB4A1541EBF36D485B5890426CE43D2

Removed from Oracle Database Home (1)

PATH MD5_HASH
./lib/libcryptocme.sig B57423676A11A5353FA122D213079E80

Changed on Oracle Database Home (63)

PATH COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
./ctx/admin/ctxval.sql MD5_HASH 05E7F91C7E43707F796BD4AC88F79EDA 828881808D31B1F29C3A989095990CE7
./ctx/admin/s2101000.sql MD5_HASH 7BB235C86D45E52AA5F2BC84FEA060E6 025D5A5448DC7628349423AF9A7B6E8A
./inventory/ContentsXML/oui-patch.xml MD5_HASH 07E41D7F37ECAAAF2AEEE5A6572D4F01 97CDAC65E363355CEB5BA58EDBFCB07E
./inventory/invDetails.properties MD5_HASH 81E998E2F44759A037832598A785F4DE B888DBF270E913AC936E2383166AB9C8
./javavm/install/jvmrui.sql MD5_HASH 520EC256FEB1858C696255EE8B63327C A474D7E8E3E9BE4DE0977A98B56AB159
./javavm/jdk/jdk8/lib/security/java.security MD5_HASH 199EA711E68B73145FD4D7F50B290E7D 495A7215E508ADDA266F97F76F0B0108
./jdk/jre/legal/javafx/glib.md MD5_HASH 2D583CBB663BB8DFAB9DC68BCB8509CD 2F5DA791FAC72CA43257E7B4A8949DA5
./jdk/jre/legal/javafx/gstreamer.md MD5_HASH F3EE88BB0506667696435C1F82A680DE B607FE45849B90CF6B5A2B444E14C8FF
./jdk/jre/legal/javafx/icu_web.md MD5_HASH BFE5D82CDBDA0F70EDAC1A28C2603B1C EEF6B594C4124198EC8D1EFBD58A2F2B
./jdk/jre/legal/jdk/bcel.md MD5_HASH 29D63D3EB2736A8173E059D1DD821B4D C757C788479F6912FDDD5624208100B1
./jdk/jre/legal/jdk/lcms.md MD5_HASH 6F01E9D461092507E7952CCDDA30A431 2B7984B19F6A2C8174591C077B4A85D1
./jdk/jre/lib/javafx.properties MD5_HASH F067B627CF6EB8D666CEACFE907A7C4B 50D36C906494AFD805EDF96C67E00FAF
./jdk/jre/lib/security/java.security MD5_HASH CDA16FFE3EFA64B10EEA1102FA6E3B78 FCD64FBD65D4493ADEA22626A37104DE
./jdk/legal/javafx/glib.md MD5_HASH 2D583CBB663BB8DFAB9DC68BCB8509CD 2F5DA791FAC72CA43257E7B4A8949DA5
./jdk/legal/javafx/gstreamer.md MD5_HASH F3EE88BB0506667696435C1F82A680DE B607FE45849B90CF6B5A2B444E14C8FF
./jdk/legal/javafx/icu_web.md MD5_HASH BFE5D82CDBDA0F70EDAC1A28C2603B1C EEF6B594C4124198EC8D1EFBD58A2F2B
./jdk/legal/jdk/bcel.md MD5_HASH 29D63D3EB2736A8173E059D1DD821B4D C757C788479F6912FDDD5624208100B1
./jdk/legal/jdk/lcms.md MD5_HASH 6F01E9D461092507E7952CCDDA30A431 2B7984B19F6A2C8174591C077B4A85D1
./jdk/release MD5_HASH 45CE6B7C5A6ACE289C0B4AEE949E8645 9001DEEEC207602C5FCE6EB0160DD49E
./lib/clntsh.map MD5_HASH FB5A15CFB32D917FA32EA6982EEEC7DB 2B4F170EDA4755C3169F15E8B3E04155
./lib/clntshcore.map MD5_HASH 3A4F2B0166EEDF22E0DBC67112B88E75 011758BA7C6F9256B28FC11000ECF4D3
./md/admin/sdordfa.sql MD5_HASH A38F3114B1C4A23C05ECD88B83EE73FA BCE10DFC5056C497E97553AF456D9DEA
./md/admin/sdordfai.plb MD5_HASH E10327B7CC19FF17CF8E6A8D54DDC51D 75AC4BC17951D48FCE092FAAAEADB6B6
./md/admin/sdordfb.plb MD5_HASH 1FEE0EFC2587E7D05D3A1B949B43E019 7C368EAC5B8988C531F1B6CDDCCEB4AF
./md/admin/sdordfsys.plb MD5_HASH 5165244258B86CC1D4951E7B27E5DCBC A1C907CBCB7DEEEE8110D270FB7CE760
./md/admin/sdosemutlb.plb MD5_HASH F7750A9EB265DC026CE886F088E39701 03D01421111ADAE5E4E1E2BD63CD25E5
./plsql/mesg/pcmus.msg MD5_HASH 1251588570E60940AA111180D61C2CB6 9D5F94F225BCF33A530A899B6CDB5443
./rdbms/admin/a1202000.sql MD5_HASH 7149611A274963D800CEDDEE2CEFE25F 559FE3BD42E9EE6A00E222514EA68333
./rdbms/admin/backport_files/bug_17777718_apply.sql MD5_HASH 127EDC3DC204A45247E7FEEA2EB58F91 9B70DE1E476810A1AAFFB6748F2BE58F
./rdbms/admin/backport_files/bug_31892889_apply.sql MD5_HASH D62EB3A4BFF53CFAA0F6D0D528BEAAA0 FED4687612039FE859140B758859976A
./rdbms/admin/backport_files/bug_32190284_apply.sql MD5_HASH 2756C75737E8FF5B53CA5440EF63E676 A75D4513CE24E7482340B434EE8414D2
./rdbms/admin/backport_files/bug_32353641_apply.sql MD5_HASH 8E02AD9FAA831A4A32C84C7974B07B88 3433A5FC0B727E6B2A3EF6049DAA4512
./rdbms/admin/backport_files/bug_32404591_apply.sql MD5_HASH EFF703E3C3EC5B9B3FE537E02D347A2E 9962289CA3E36498CCB4094008B69935
./rdbms/admin/bundlefcp_DBBP.xml MD5_HASH C246032EF875A89C2C1FC2D2C17EC323 CD29B99D61E3187E48DDB258E2E0261C
./rdbms/admin/c1202000.sql MD5_HASH ECD0630A6E56071E662A1D413AED087B C5FDA3FA022334010E4A13DCCFCEFC9A
./rdbms/admin/catconst.pm MD5_HASH DA56A6FB4B9BCA89EE5771B980A2F23F 94C72165BD38A9E1552E4B837F309632
./rdbms/admin/catctl.pl MD5_HASH E94476913D297F880ABFF2512E8C23E0 AEBFF941494BBAD6AF7E30BE8310B48E
./rdbms/admin/catdwgrd.sql MD5_HASH 4546E4E16A84B41648DD9583770BF835 EDC604C0A2D7941D421A185E30AC180C
./rdbms/admin/catfusrg.sql MD5_HASH 8654BFEEC8BCCB2028D881B2C76C1D8A EDE41AFA3F14741C506987D12EB40663
./rdbms/admin/catggshard.sql MD5_HASH C999D0A43B15932ECDD31BF59686DA73 28F0CE44E8B9434FAA58E1D23AA0E3E6
./rdbms/admin/catupstr.sql MD5_HASH 5F46BD9B25676A1041F2CAF086A6E290 7444E4392552EEF9CA97A3F860BD1F2B
./rdbms/admin/catxdbtm.sql MD5_HASH 13B718D58C54B0730712458CB060589D A1F976E2B4B9840A2A8155F69827ABE6
./rdbms/admin/dbms_registry_basic.sql MD5_HASH 94144E5E4193FF92F64F780045D3890D F54A870309D8BFC1A24CED71587365BF
./rdbms/admin/dbmsbkrs.sql MD5_HASH 4B83057D1F96663AFD91EB3625C1F5B7 A7C023951178D3119E15857A9FE97124
./rdbms/admin/dbmsocm.sql MD5_HASH DC994E5CCF1B7B9206C662E2E3A56F80 75EA6B8DD0C4FBBC781765A2810B10CA
./rdbms/admin/dcore.bsq MD5_HASH 89EB0A3545269B397294F114BAE23BBD 19D378B2AF67C5BA4E54F62DBA202479
./rdbms/admin/dmisc.bsq MD5_HASH B4257B35087B201B3E8370B3157567F8 9354D61B180A597104589FACD8C10BE1
./rdbms/admin/dvu122.sql MD5_HASH 1CAEEC3284DFC71AFD8AA14A6C36D194 64A1C5DEE14E151CB9A271503F926479
./rdbms/admin/dvu20.sql MD5_HASH 7E57DEEC2B5D97DCDBC852C395153B62 34ED90583793D1C978CCFDA9D6FA31CF
./rdbms/admin/e18.sql MD5_HASH EBF8D24F78A8D2A9486763778ADC18B8 0C906807523459706DC1A54E393F0AE3
./rdbms/admin/f1202000.sql MD5_HASH 2C1B8AF0F8A057679C599770BDAC1421 DACA05707EF681E5B76932586B8A466D
./rdbms/admin/prvtlmsb.plb MD5_HASH 6C7FD04770D3DCF7BBBD18A34A08623E 2B37EAACCA4C675852693D4FF9C673C0
./rdbms/admin/prvtocm.sql MD5_HASH 7B269E5229D1684E88DF0B195CF2951D D294CD772A7476C5E3B81968F31F230A
./rdbms/admin/prvtplts.plb MD5_HASH 3E9CB7D0EB4C3DE429E57E6E161B85D1 FB8BC87C4DE822A4C1240F6CB982D81E
./rdbms/admin/prvtrmns.plb MD5_HASH 0BE2DD24F88460C020E93AADF4AAD4CF 80FB995010489B0D8658B18855EEAB9C
./rdbms/admin/rdbms_postapply.sql MD5_HASH 6E6C7D5A457634DD5F3EA493D1B77883 4C3227B575AB6B35C3688F12AF2D1717
./rdbms/admin/rdbms_preapply.sql MD5_HASH DB846A43C756A779E28F860C94E03BCF CCE84828A4A92D76F3E5895738F66CBD
./rdbms/admin/recover.bsq MD5_HASH 3198881D326BAFC0A6F8D7129CF2049F B74C03B48CC20873DCD549DF330208CC
./rdbms/admin/utlusts.sql MD5_HASH 2F44257DE06485556CDCABF77DD744F3 D9EC08F945356DEF9B843DDF6DF3134C
./rdbms/lib/oracle.map MD5_HASH F49FCBCDE6E07266B3CABDF8DD667CFE 970FAA0CACDDBFFF5EC1ECC2AF864686
./rdbms/mesg/oraus.msg MD5_HASH 069D6D2CF7A7EF9E92A25E9F6CB391EF 9FBF4E45705B13BAD6B89F5D1D6E9E84
./sdk/include/xmlxvm.h MD5_HASH EEBFBC344F87BCA22B6CF32F2E5943EB D050A87938D306C2D663E0B18D3C9E98
./xdk/include/xmlxvm.h MD5_HASH EEBFBC344F87BCA22B6CF32F2E5943EB D050A87938D306C2D663E0B18D3C9E98

Coded Objects

Changed on DBA_SOURCE/DBA_VIEWS (16)

OWNER NAME TYPE COMPARE_COLUMN_NAME OLD_VALUE NEW_VALUE
MDSYS RDF_APIS PACKAGE MD5_HASH C35E6F3CA363AD0F23A8B38E503E21A2 FE6F36FB6AA2187B928D9219A1AA490D
MDSYS RDF_APIS PACKAGE BODY MD5_HASH 8937685E961D5B6DD37EBB534915276B B208199E47DB6213B0EB720BC66852E9
MDSYS SEM_RDFSA_IR PACKAGE BODY MD5_HASH 3B51B32332EBC18C15894E385550B916 8E8A6B8120D6DE970215FB04286FFCAD
MDSYS SDO_SEM_UTL PACKAGE BODY MD5_HASH 43ECAF866F8A1ED388BAAB7F0B4EA465 2150BA3D5DA6D25C25C1BDD4675F860A
MDSYS SDO_RDF_TRIPLE_S TYPE MD5_HASH 2A594CCCEC4DE8D82B8721127DDEF106 14B0014F397555D6C304EDA554B7E2DC
MDSYS SDO_RDF_INTERNAL PACKAGE BODY MD5_HASH B9D216FCC153B5C27B413279B0BA533D 39A3CF3FCEA0FBD9F7A5BC585C03E717
MDSYS RDF_APIS_INTERNAL PACKAGE BODY MD5_HASH 9ABDD6FAE1048CAEFF5C90B3B500D2AD 7891F77D30F073E582EF6E28132C4347
MDSYS RDF_APIS_INTERNAL PACKAGE MD5_HASH 4A882F7E7CC760508260C9D2236DE544 6E9CB6C37C590BC7BFC42EE74BFB7F04
SYS DBMS_BACKUP_RESTORE PACKAGE MD5_HASH 8675E9ADD38E89ADAB43F1312AA96FBC E6587B2D71B381A202EB37FC61076751
SYS DBMS_REGISTRY PACKAGE MD5_HASH 0FBCB124EA285E26F33EE5478D8F9F92 A9A223D31CD4C4169D6D29F24DB73C9C
SYS DBMS_RCVMAN PACKAGE BODY MD5_HASH 72A4FAE6F5B08D60D2FFA613C29B7552 5CCDF6F0920358CEF8392164C8B721CE
SYS DBMS_PLUGTS PACKAGE BODY MD5_HASH AC08F0F312471379F0E254740E119FE7 819E2ADC6A407758907500BAE9D1ECD5
SYS DBMS_LOGMNR_SESSION_INT PACKAGE BODY MD5_HASH 1E63367BE6B8EEDA8CF628DE7CC9551B 1A44039374229F8A656763E40481D88E
SYS DBMS_FEATURE_PARTITION_USER PROCEDURE MD5_HASH 23ACD8183E781937CFD1D2E04399E499 DB2A8997F9D27D5DBFAE75430D75F891
SYS DBMS_EXTENDED_TTS_CHECKS PACKAGE BODY MD5_HASH 1CD9A1286B8719AC8A115DE674B8A207 3D6635BA089CB855A3DAC6C872D7DECB
SYS SDO_RDF_SYS PACKAGE BODY MD5_HASH 30DA4D1FF23F228EB7FBA02486E34AF9 7A9027ABD522E2458BDD43326E650189

ORA-NNNNN Errors

Included in ./rdbms/mesg/oraus.msg (6)

ORAERR RESERVED MESSAGE CAUSE ACTION NOTE
5026 0 "cannot delete or update parent key referenced by sharded table" *Cause: An attempt was made to delete or update a row from a duplicated table when a foreign key constraint existed in a sharded table referencing this duplicated table and the constraint was ENABLED. *Action: DISABLE NOVALIDATE the constraint before attempting to delete or update rows from the duplicated table. When a sharded table references a duplicated table, deleting a parent row is only allowed when the constraint is in DISABLE state. This means rows from the child sharded table are not looked up for violation. The constraint state can later be changed to ENABLE VALIDATE if there are no rows in sharded table violating the constraint and after duplicated table is refreshed on all shards. // *Document: Yes
5027 0 "cannot use ON DELETE clause for this constraint" *Cause: A foregin key constraint was being created or altered in a sharded table referencing a duplicated table with ON DELETE clause. *Action: Remove the ON DELETE clause. // *Document: Yes
11402 0 "Oracle Data Guard site entry not found" *Cause: The SYS.DATA_GUARD_SITE$ table in ROOT did not contain the requested site details. *Action: If it is not obvious from the context of the error then the site name or database ID used to lookup up the site can be found in the tracefile of the process originally reporting the error. Oracle Data Guard Broker is the prefered method to maintain the site configuration data. Try removing and adding the site again.  
11403 0 "Oracle Data Guard site data invalid or incomplete" *Cause: The SYS.DATA_GUARD_SITE$ row contained incorrect or incomplete details used to form a connection to the site. The previous error on the error stack should give more insight into what is incorrect or incomplete. For example, an ORA-27476 indicates the defined or defaulted credential could not be accessed. *Action: If it is not obvious from the context of the error which site site entry is causing the problem or which piece of data from the entry is incorrect or incomplete then more details can be found in the trace file of the process that originally reported the error. Oracle Data Guard Broker is the prefered method to maintain the site configuration data. Try removing and adding the site again.  
11404 0 "user has no privilege to create a standby from the source" *Cause: The Oracle user used to connect to the source CDB was not granted SYSDG privilege in the source PDB. *Action: Either grant the user the privilege, use a different user by modifying the Oracle Data Guard site configuration data, or modify the command being used to create the standby.  
11405 0 "remote Oracle Data Guard site is not ready" *Cause: Contact was made with the remote Oracle Data Guard site, but the following error was raised when an attempt was made to use the site. *Action: Examine the error folling this one and attempt to rectify the issue. For example, ORA-03150 likely means the remote site is mounted but not open, and therefore attempt the operation again once the site open.  

Leave a Reply

Your email address will not be published.