数据库数据恢复服务热线：13764045638 QQ: 47079569

大致看了下mysql 的double write buffer概念 ：

So why doublewrite is needed ? It is needed to archive data safety in case of partial page writes. Innodb does not log full pages to the log files, but uses what is called “physiological” logging which means log records contain page number for the operation as well as operation data (ie update the row) and log sequence information. Such logging structure is geat as it require less data to be written to the log, however it requires pages to be internally consistent. It does not matter which page version it is – it could be “current” version in which case Innodb will skip page upate operation or “former” in which case Innodb will perform update. If page is inconsistent recovery can’t proceed.

Now lets talk a bit about partial page writes – what are they and why are they happening. Partial page writes is when page write request submited to OS completes only partially. For example out of 16K Innodb page only first 4KB are updated and other parts remain in their former state. Most typically partial page writes happen when power failure happens. It also can happen on OS crash – there is a chance operation system will split your 16K write into several writes and failure happens just between their execution. Reasons for splitting could be file fragmentation – most file systems use 4K block sizes by default so 16K could use more than one fragment. Also if software RAID is used page may come on the stripe border requiring multiple IO requests. Same happens with Hardware RAID on power failure if it does not have battery backed up cache. If there is single write issued to the disk itself it should be in theory completed even if power goes down as there should be enough power accomulated inside the drive to complete it. I honestly do not know if this is always the case – it is hard to check as it is not the only reason for partial page writes. I just know they tend to happen and before Innodb doublewirite was implemented I had couple of data corruptions due to it.

So how does double write works ? You can think about it as about one more short term log file allocated inside Innodb tablespace – it contains space for 100 pages. When Innodb flushes pages from Innodb buffer pool it does so by multiple pages. So several pages will be written to double write buffer (sequentially), fsync() called to ensure they make it to the disk, then pages written to their real location and fsync() called the second time. Now on recovery Innodb checks doublewrite buffer contents and pages in their original location. If page is inconsistent in double write buffer it is simply discarded, if it is inconsistent in the tablespace it is recovered from double write buffer.

 

我是这样认为的 其实oracle中也有写 partial page(block)的可能，只不过 o的redo和controlfile 检查点比较严谨， 不在需要这样一个区域了。

对于 partial page(block) 的前滚，o也有这样的情况，例如 一个已经写好的块， 增量检查点 未必更新了控制文件， o认为 这个块不是最新的， 那么o也会同样的再写一次 ，即便这个块已经是最新的。 这种机制在oracle中称为resilver write 镀银写。

 

 

Most data blocks are changed via redo and written by DBWR. These writes are coordinated by cache locks that insure there is only one current dirty buffer for any given block. If DBWR dies for any reason, its instance will also die. It will be necessary to do some form of recovery applying redo to reconstruct the blocks that were in the cache at the time of the failure. This recovery will have to either read or write any block that is both modified by redo, and might have been in the middle of a write when DBWR died. Thus, these blocks are a superset of the blocks that Oracle must resilver if it is responsible for resilvering. Hence, during recovery, Oracle will rewrite every block it examines in files it is responsible for resilvering. Since media recovery may be used to recover changes lost when an instance dies, Oracle must also resilver when doing media recovery.
Data blocks used for sorting are modified without generating any redo. They are still written by DBWR. These blocks are never read by any process other than the one doing the sort, and if its DBWR dies then it too will die. Thus it is not important that these blocks become resilvered.

 

 

mysql里叫double write, o 里叫 resilver write。 目的应该是一样的，机制不同，mysql　里知名度很高 可能是因为其可以关闭。 o里面就没人研究能不能关这个了。

目前 （2019年5月21日)似乎MOS上找不到 控制19c Automatic Indexing 自动建索引特性的Notes，大致可以通过 _optimizer_auto_index_allow 和 _optimizer_use_auto_indexes 2个参数关闭该新特性。

 col name format a40
SELECT x.ksppinm NAME, y.ksppstvl VALUE
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%index%';
NAME                                               VALUE
-------------------------------------------------- ------------------------------------------------------------
_optimizer_auto_index_allow                        AUTO
_gc_defer_ping_index_only                          TRUE
_kcl_index_split                                   TRUE
_gc_fast_index_split_wait                          0
_index_partition_large_extents                     FALSE
_index_partition_shrink_opt                        TRUE
_db_index_block_checking                           TRUE
_disable_index_block_prefetching                   FALSE
_index_scan_check_skip_corrupt                     FALSE
_index_scan_check_stopkey                          FALSE
_index_max_inc_trans_pct                           20
_index_split_chk_cancel                            5
_advanced_index_compression_trace                  0
db_index_compression_inheritance                   NONE
_index_alert_key_not_found                         FALSE
_reuse_index_loop                                  5
_reclaim_lob_index_scan_limit                      0
_ignore_desc_in_index                              FALSE
_index_load_buf_oltp_sacrifice_pct                 10
_index_load_buf_oltp_under_pct                     85
_index_load_buf_oltp_over_retry                    0
_index_load_last_leaf_comp                         85
_index_load_min_key_count                          10
_index_load_analysis_frequency                     4
_advanced_index_compression_umem_options           2147483647
_advanced_index_compression_options                0
_advanced_index_compression_cmp_options            0
_advanced_index_compression_tst_options            0
_advanced_index_compression_opt_options            0
_advanced_index_compression_options_value          0
_advanced_index_compression_recmp_cusz             90
_advanced_index_compression_recmp_crsz             10
_advanced_index_compression_recmp_nprg             10
_kdkv_index_lossy                                  TRUE
_kdkv_index_relocate                               FALSE
_kdkv_indexinvalid                                 FALSE
_domain_index_batch_size                           2000
_domain_index_dml_batch_size                       200
_odci_index_pmo_rebuild                            FALSE
_cell_index_scan_enabled                           TRUE
optimizer_index_cost_adj                           100
optimizer_index_caching                            0
_system_index_caching                              0
_index_prefetch_factor                             100
_index_join_enabled                                TRUE
_use_nosegment_indexes                             FALSE
_optimizer_compute_index_stats                     TRUE
skip_unusable_indexes                              TRUE
_delay_index_maintain                              TRUE
_disable_function_based_index                      FALSE
_globalindex_pnum_filter_enabled                   TRUE
_enable_online_index_without_s_locking             TRUE
_optimizer_fkr_index_cost_bias                     10
optimizer_use_invisible_indexes                    FALSE
_noseg_for_unusable_index_enabled                  TRUE
_px_index_sampling_objsize                         TRUE
_part_redef_global_index_update                    TRUE
_fast_index_maintenance                            TRUE
_modify_column_index_unusable                      FALSE
_indexable_con_id                                  TRUE
_optimizer_use_auto_indexes                        AUTO
_optimizer_gather_stats_on_load_index              TRUE
_optimizer_auto_index_allow
_optimizer_use_auto_indexes
SQL> alter system set "_optimizer_auto_index_allow"=0 scope=spfile;
alter system set "_optimizer_auto_index_allow"=0 scope=spfile
*
ERROR at line 1:
ORA-00096: invalid value 0 for parameter _optimizer_auto_index_allow, must be from among ALWAYS, AUTO, NEVER
alter system set "_optimizer_auto_index_allow"=NEVER scope=spfile;
alter system set "_optimizer_use_auto_indexes"=NEVER scope=spfile;
ERROR at line 1:
ORA-00096: invalid value NEVER for parameter _optimizer_use_auto_indexes, must be from among ON, AUTO, OFF
alter system set "_optimizer_use_auto_indexes"=OFF scope=spfile;

19C has a new feature database 19c is automatic indexing. How does it work?

QUESTIONS AND ANSWERS

How does automatic indexing work?
This is fully automated process. Oracle will identify candidate indexes,
verify their effectiveness, perform online validations and then implement the indexes where appropriate.

DBA does not need to do anything. Oracle internally picks the candidate indexes and validates the index or indexes.

Does any parameters need to be set for the automatic indexing to work?
Per documentation:
21.7.3 Enabling Automatic Indexing
Automatic indexing is disabled by default in an Oracle database. To enable
automatic indexing, set the AUTO_IMPLEMENT_INDEXES initialization parameter
to the Oracle database release number, for example, 19.1. You can disable
automatic indexing by setting the AUTO_IMPLEMENT_INDEXES initialization
parameter to NONE.

Database Oracle
Oracle Database Release 19
Database Administrator’s Guide

https://docs-stage.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-6E31777C-3BE3-4510-90D5-C715644E00CB

However, the parameter does not seem to exist though and cannot be used in 19.1

The parameter to control/enable automatic indexing is available in the next
refresh of the RDBMS, 19.2. per following internal bug:

Bug 29001016 – 19CBETA CANNOT USE AUTOMATIC INDEXING FUNCTIONALITY – PARAMETER MISSING

https://github.com/macleanliu/ora-easy-deploy

ora-easy-deployWORKS ON (CENTOS REDHAT ORACLE) LINUX 7
国外主机
su - root 
yum -y install git 
git clone https://github.com/macleanliu/ora-easy-deploy
wget https://www.dropbox.com/s/8097ds292gabpk9/oracle-database-ee-19c-1.0-1.x86_64.rpm
wget https://www.dropbox.com/s/x14jlgnj062nef2/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
bash ora-easy-deploy/create_db.sh
国内主机
使用浏览器下载以下2个介质并上传到服务器目录
https://download.oracle.com/otn/linux/oracle19c/190000/oracle-database-ee-19c-1.0-1.x86_64.rpm
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
su - root 
yum -y install git 
git clone https://github.com/macleanliu/ora-easy-deploy
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
rpm -ivh oracle-database-ee-19c-1.0-1.x86_64.rpm
bash ora-easy-deploy/create_db.sh
安装完成后#设置ORACLE OS账户密码
su - root
passwd oracle                     
su - oracle
lsnrctl start 
sql
alter system register;
[oracle@vultr ~]$ sql
SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 15 07:09:52 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@vultr ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-MAY-2019 07:28:31
Copyright (c) 1991, 2019, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                15-MAY-2019 07:27:06
Uptime                    0 days 0 hr. 1 min. 24 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /opt/oracle/diag/tnslsnr/vultr/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vultr.guest)(PORT=1521)))
Services Summary...
Service "PROD" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
Service "PRODXDB" has 1 instance(s).
Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully
关闭部分19c特性sql
alter system set "_optimizer_aggr_groupby_elim"=false;
alter system set "_drop_stat_segment"=1;
alter system set "_common_data_view_enabled"=false;
alter system set optimizer_adaptive_features=false;
alter system set "_optimizer_dsdir_usage_control"=0; 
alter system set "_enable_automatic_sqltune"=false scope=both; 
alter system set "_serial_direct_read"=false;
alter system set "_nlj_batching_enabled" = 0; 
alter system set "_optimizer_undo_cost_change" = '10.2.0.4';
alter system set "_optimizer_null_aware_antijoin" = false;
alter system set "_optimizer_extend_jppd_view_types" = false;
alter system set "_replace_virtual_columns" = false;
alter system set "_first_k_rows_dynamic_proration" = false;
alter system set "_bloom_pruning_enabled" = false;
alter system set "_optimizer_multi_level_push_pred" = false;
alter system set "_optim_peek_user_binds"=false; 
alter system set client_result_cache_size=0 scope=spfile;
alter system set result_cache_mode=MANUAL;
alter system set "_diag_hm_rc_enabled"=false; 
alter system set audit_trail=none scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=false scope=both; 
alter system set "_enable_shared_pool_durations"=false scope=spfile;
alter system set deferred_segment_creation=false; 
alter system set "_datafile_write_errors_crash_instance"=false ;
alter system set "_fairness_threshold"=6 scope=spfile;
alter system set "_gc_read_mostly_locking"=false scope=spfile;
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set "_gc_defer_time"=3  scope=spfile;
alter system set "parallel_force_local"=false;
alter system set "_gc_bypass_readers"=false;
alter system set "_row_cr"=false;
alter system set ddl_lock_timeout=0;
alter system set "_gby_hash_aggregation_enabled"=False scope=spfile;
alter system set "_cleanup_rollback_entries"=400 scope=spfile;
alter system set "_dbms_sql_security_level"=0                          scope=spfile;
alter system set "_bloom_pruning_enabled"=False                        scope=spfile;
alter system set "_simple_view_merging"=True                           scope=spfile;
alter system set "_enable_NUMA_optimization"=FALSE                     scope=spfile;
alter system set "_fix_control"='9344709:OFF'                           scope=spfile;
alter system set "_px_use_large_pool"=True                              scope=spfile;
alter system set "_mv_refresh_use_hash_sj"=FALSE                      scope=spfile;
alter system set "_mv_refresh_use_stats"=True                          scope=spfile;
alter system set "_like_with_bind_as_equality"=TRUE                    scope=spfile;
alter system set optimizer_secure_view_merging=false                   scope=spfile;
alter system set optimizer_capture_sql_plan_baselines=False            scope=spfile;
alter system set event="10949 TRACE NAME CONTEXT FOREVER:28401 trace name context forever, level 1"  scope=spfile;
exec  DBMS_AUTO_TASK_ADMIN.DISABLE( client_name =>  'auto optimizer stats collection', operation => NULL,window_name => NULL);
exec  DBMS_AUTO_TASK_ADMIN.DISABLE( client_name =>  'auto space advisor', operation => NULL,window_name => NULL);
exec  DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'sql tuning advisor', operation => NULL,window_name => NULL);
commit;
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');
exec DBMS_STATS.SET_PARAM( 'method_opt','FOR ALL COLUMNS SIZE 1' );
commit;
shutdown immediate;
startup ;

11g ocm 系列视频课程

ocm考试介绍1

 

 

第二讲：sql性能相关考点脚本

 

 

 

DG考点介绍

 

 

 

DataGuard_理论部分

 

 

 

11g ocm rac

 

 

 

 

Data Warehouse数据仓库部分

 

 

数据库审计与安全部分

 

 

SPA SQL Performance Analyzer

 

 

11gocm_理论_2（备份恢复）

 

 

 

oracle 11g ocm workshop-a

 

APPLIES TO:

Oracle Database – Enterprise Edition – Version 18.0.0.0 [Release 18.0]
Information in this document applies to any platform.

Bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision

This document lists the non-security bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision(RU/RUR). The information is specific to Oracle Cloud and on Oracle Exadata Environment. RU/RUR patches are cumulative and so each RU includes fixes from all previous RU patches for the same Patch Set.

For details of the RU patches please see Document:2285557.1

18.0.0.0.0 Release Update Fixes

The table below lists all of the non-security fixes included in the latest Release Update.

• Bugs are listed by category
• The version column indicates the Patch Set Update that a fix was first included in – the fix is included in that PSU and all subsequent PSU versions.
• Each bug number is hyperlinked to a Support Bug Description
• To see only fixes added in a particular RU version please click on the relevant document link in the previous section.

Advance Queuing

18.5.0.0.DBRU:190115	27645940	SHARDEDQ : JMS queue hits ora 600 [kwqifetchdata: shhdl empty] w/ delay + rules
18.4.0.0.DBRU:181016	27165231	EMON processes received ‘ORA-27452’ while submitting a scheduler job
	28226179	AQ parameter max_retries is not correctly taken into account
18.3.0.0.DBRU:180717	27652302	PGA Memory leak in array enqueue operations
	27748954	upgrade-database fails as lowercase username passed to loadjava
18.1.0.0.DBRU:190115	27645940	SHARDEDQ : JMS queue hits ora 600 [kwqifetchdata: shhdl empty] w/ delay + rules

Automatic Storage management

18.5.0.0.DBRU:190115	27510959E	ASMCMD command md_scan to evict ASM metadata from Exadata Flash Cache to avoid physical and logical corruption
	27695063	Test Case for Hardcheck Errors to Validate the Fix provided in Bug 27502420
	27793533E	SRVM Cloud APIs to Detect ODA not Working
	27869075	alter pluggable database prepare mirror copy gets stuck in preparing or dropping state.
	28489150	ORA-600 [kfcload: stale pba] During View Scan
	28617959	ACFS: Route I/O to Flash Cache on Exadata
	28755011	Server Patch fails due to failed to run root scripts.
	28805695	Incorrect Results From Views: V$ASM_FILEGROUP, V$ASM_FILEGROUP_FILE, and V$ASM_FILEGROUP_PROPERTY
18.4.0.0.DBRU:181016	26694735	ASM hit ora 600 [kffrelocateclientdata_shdw]
	27122162	exadata: asm spfile error: unable to get logical block size for spfile
	27150500	PDB prepare mirror copy gets ORA-15120 and a ORA-600 kffsrlsspmenqs!spm when db datafiles are on filesystem
	27166354	ASM hit ora 600 [kfdvaxtntvalidate_sate]
	27242616	Doskgroup rebalancing hit ORA-600 [kfdacollect01]
	27303785	Move asmcmd logs out of GI Home
	27405645	lnx-18.1-asm:ORA-7445[kffscrubasynccheckblock] in scc
	27662528	Database Hits ORA-00600 [kfioSrMsg_send:01] When Grid Disk was Inactive
	27723151	ASM Hit ORA-600 [kffscrubslsend01] while Scrubbing
	27948050	High mem/cpu due to numerous pids for asmcmd lsod/lsof with asm connection pool
	28074713	AFD Failed to Load after Node Reboot on SLES12sp1
	28218832	ASMCMD background process fails to start and connection pooling gets disabled if /var/tmp/.oracle does not exist
	28330714P	hpi_183_ins:unresolved external at asmcmdcore line 310 when root.sh on 1st node
	28571483	ASM Processes Producing Error ORA-00600 [17114]
18.4.0.0.181016DBRU	27948050	High mem/cpu due to numerous pids for asmcmd lsod/lsof with asm connection pool
18.3.0.0.DBRU:180717	26615291E	ARB0 Hits ORA-0600[ kfk_iodone_invalid_buffer] During File Resize
	26928317	SAGEASM-E ASM hang at ‘sync asm rebalance’ with underlying corruption
	27143756	Empty View V$ASM_DBCLONE_INFO When it’s Queried from the Database Instance
	27244337	Process ARB0 Hits the ORA-600[kfk_iodone_invalid_buffer]
	27274536	Online all disks signals ORA-59029 after mount operation
	27288230	ORA-600: [kfrvalacd30] in ASM SMON
	27314390	ASMB is terminated by GEN during startup
	27318869	Using DBCA after upgrade from 11.2 to 18.1 is calling KFOD OP=GROUPS that fails with KGFCHECK kgfnStmtExecute01c error when having Flex Redundancy Diskgroup
	27346329	Error ORA-0600 [kffmlock_6] Reported by the DB Instance
	27348081	Database fails to discover disks on a disk add/online operation on Quorum Disks
	27364891	Potential error reported at kfcLoad
	27372756	Error ORA-07445 [kfk_oss_cancelq_timedout()+118] Reported in Database Instance
	27502420	ARB0 reported the error ORA-600[kfk_iodone_invalid_buffer]
	27508985	ASM hit ORA-00600 [kjcv_move_set_level:wrap]
	27558861	ORA-600 [kfncCWFileEntryInsert02] during RMAN duplicate
	27599689	Dropping a Mirror Copy from one PDB Succeeds, even if the Copy was Created from a Different PDB
	27603841	ACFS: asmcmd md_backup fail to backup acfs metadata
	27709046	Flex ASM: ORA-600 [kgfdpstatus_tokfdsk:01] after db failover w/o client-assisted offline
	27945870	ORA-1405 while querying (g)v$asm_volume_stat in ASM Proxy instance
	27970265	Restart ASM hit ORA-59325 after upgrade from 12.1
	28184554P	SOLARIS: Relinking Failing while Applying July GIRU
18.2.0.0.DBRU:180417	27318869	Using DBCA after upgrade from 11.2 to 18.1 is calling KFOD OP=GROUPS that fails with KGFCHECK kgfnStmtExecute01c error when having Flex Redundancy Diskgroup
	27364891	Potential error reported at kfcLoad
	27502420	ARB0 reported the error ORA-600[kfk_iodone_invalid_buffer]

Buffer Cache Management

18.5.0.0.DBRU:190115	24903291	Tablespace Encryption/Decryption Working With Wallet Closed
	27106301	ORA-28311: Oracle Encrypted Data Block not Encrypted
	27397048	Intermittent ORA-600[kdsgrp1] Raised By Query Using Index
	27540613	ORA-600 [25026] ORA-600 [25027] in a Multitenant Database When Flashback is Enabled and Securefile Lob Operation is Performed
	27759077E	Avoid DBWR To Crash the Instance for ORA-1578 Due to Soft Corrupt Block
	28023081	Sessions Hang Due to Waits ‘gc current split’/ ‘gc index operation’
	28023482	inst reco hang followed by ORA-700 [kcbbxsv_nowritesbuf]
	28067846	KCLBSY SHOULD CONSIDER LOCK ELEMENTS WITH PING REJECTED DUE TO SPLIT AS BUSY
	28636676	LMS Process is Dumping Diagnostics During CR Server Requests
18.4.0.0.DBRU:181016	27251690	Standby Instance Crash With ORA-600[kcbo_switch_q_bg_1] In DBW0
	27284375	Database Hits ORA-600 [kclremoveundo_1] and Instance Crashed
18.3.0.0.DBRU:180717	27163928	ORA-4031 error due to leakage of ‘gc index split transaction’ permanent memory chunks
	27360126	ORA-600 [15709] Hit During Parallel Execution
	27496308	1 sec “gc buffer busy release” wait occurs for pdb’s on one node rac

Enterprise Manager Database Control

18.3.0.0.DBRU:180717

28132287

18.3: OUI HIT INS-20802 REGISTERING GI WITH EM FAILED IN EMCA

Generic

18.5.0.0.DBRU:190115	8932139	Bloom filtering efficiency is inversely proportional to DOP
	26745002	Wrong result with parallel execution with slave mapping
	27142529	ORA-600 [kksfbc-pinned-X] May Be Raised
	27197334	ORA-600 [kcblasm1_1] while running SELECT query with PX_FAULT_TOLERANCE hint
	27223075	Wait for ‘PX Deq: Join Ack’ when no active QC but PPA* slaves show as busy
	27236722	Wrong result with parallel INSERT when ORDER BY clause used
	27266245	ORA-7445 [kkqctjuxtaposegbp()+1802] during parsing a query
	27303938	Query with HASH JOIN produces additional rows with NULL values when _PX_GROUPBY_PUSHDOWN=OFF
	27983174	lnx-183-mdb:got ORA-12012, ORA-20001 and ORA-6512 err from ora$at_os_opt_sy_xxx
	28072567	Poor Performance On Distributed Query When Fix To 18304693 Is Enabled
	28088762	SQL apply stopped with ORA-26808 & ORA-16211 errors
	28194173	ORA-600 [kutyxtte_transform:failed] on top of 12.2 Database on Exadata
	28282606	Wrong Results Using CHAR Column And UNPIVOT
	28309182	ORA-01008: not all variables bound
	28708023	Wrong results occur on pl/sql procedure after apply July 2018 PSU
	28749289	Create TABLE AS SELECT Statement Fails With ORA-1723 in 12.2
	28758090
	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients
	28809909	Write callback results in LOB buffer overflow/corruption
18.5.0.0.190115DBRU	28088762	SQL apply stopped with ORA-26808 & ORA-16211 errors
	28309182	ORA-01008: not all variables bound
	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients
18.4.1.0.190115DBRUR	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients
18.4.0.0.DBRU:181016	20436508	Incorrect rows returned after DBMS_REDEFINITION on table with ROW ARCHIVAL clause
	21744603	ORA-1560 From Query Using Multi-byte Characters In LIKE Predicate
	25309116	Wrong Result Using Optimizer Adaptive Plan
	25686739	ORA-600 [rwoirw: check ret val] on ctas operation
	25882883	Inmemory Clause Not Shown Through DBMS_METADATA.GET_DDL Function For External Table
	25890002	wrong results with b-tree index and nested loop hash join adaptive join
	26422277	getting ORA-600: [kkqtutlremoveselitem_int: colvop != selopn] on ansi sql
	26521043	dbms_stats.drop_extended_stats gives ORA-20001 for numerical username
	26536320	problem in group-by sort converted from group-by hash
	26966916	deadlock detected on upgrade dbua from 11.2.0.3 to oracle 12.2
	27080874	imccust peoplesoft : hit multiple ora 600-[qkaffsindex5] while running workload
	27093423	ocigetattr can’t get correct result if desc is used when creating inex
	27151826	Adaptive plan may lead to wrong results when “_projection_pushdown”=false
	27170305	ORA-979 when a case statement is there in the “group by” expression
	27231051	nvl() fails with ORA-06502 error having the pl/sql callback function when the adaptive join is enabled
	27256000	ORA-00600 [qkainitgrpfns.3] Error on Query with Grouping, Rollup and Functional Index
	27259307	“fetch first 1 row only” has bad performance compared to “rownum <= 1”
	27416997	case insensitive queries failing due to null is not null predicate
	27421733	ORA-600 [qctcte1] with fix 26025681 present
	27466597	fa query 5mq7t02bpb9k6 regressed in 18.1
	27493674	ORA-600: [kkzfcbsu : multiple calls] during MVIEW refresh
	27505229	Wrong Results With Union All And Join Factoring
	27555481	wrong result of row archival option using outer join condition
	27601118	ORA-1031 Sometimes Occurs During Truncate Table
	27607563	ORA-7445 [qksptfprocesschainedfunc] During Package Creation
	27740424	unexpected warning is returned by db to clients Pro*C and OCI
	27898015	DBMS_REDEFINITION not honoring row archival feature – fails with ORA-42016
	27965830E	After Failover of OCI client, Client Identifier was Not Restored In The New Server
	28165545P	Catcon.pl Fails to Execute Catalog.sql Due to ORA-27041 OSD-04002
	28502403	ORACLE 18.3.0 MULTITENANT: COMPATIBILITY CHECK DOES NOT WORK
18.4.0.0.181016DBRU	27151826	Adaptive plan may lead to wrong results when “_projection_pushdown”=false
	27231051	nvl() fails with ORA-06502 error having the pl/sql callback function when the adaptive join is enabled
18.3.2.0.190115DBRUR	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients
18.3.0.0.DBRU:180717	26336101	OCI-21500: internal error code, arguments: [kolaAssign_rfc-Wrong duration], [], [], [], [], [], [], []
	26423085
	26476244	port/implement dbms_optim package on 12.2.0.1
	26785169	ORA-41417: Invalid Use Of DBMS_APP_CONT_PRVT
	26986173	Disabling of subquery unnesting with exists
	27060859	wrong results in 12.2 when _push_join_predicate is set to false
	27110878	raw hazard observed in qerwncompare causing performance degradation
	27143882	OCIStmtExecute Fails With ORA-03101 For TimeStamp Variables When DCTM_DATATYPE_CHECK=ON
	27156355	ORA-904: “A43″.”ORA_ROWSCN”: invalid identifier
	27181521	ORA-7445 [kprball()] on Active Data Guard (ADG) standby when opening all pdbs
	27210872	OCILobArrayWrite Fails With ORA-24801 Error When NULL Values Are Passed.
	27222626	ORA-600 [koklcurrentdatainline: crenv with disk] while accessing LOB
	27224987	NET-7445 [11] Signal At pthread_mutex_lock When Relocating Service
	27232983	ORA-29855, ORA-13249 when DBMS_REDEFINITION.REDEF_TABLE creates spatial index on table with VPD policy
	27244785	OCILobCreateTemporary Fails With ORA-3113 When Connections Goes Through CMAN
	27262945	ORA-600 [16515]
	27285244	XML redo is not generated for XML, anydata columns when the table contains a top-level BFILE colum
	27304410	Small trace file containing “kkzlshrinkmvlog” created upon each mview refresh
	27314206	ORA-44201 in ADG When the Fix of Bug 23521523 is Installed
	27321179E	Improvement to fix of bug 20355502
	27335682	Recommendations not given for performance issues on using existing sdr api
	27356373	ORA-07445 error while inserting PLSQL collection objects
	27364916	kge barrier violation in function jsicreatejob()
	27392187	ORA-24370 instead of ORA-1483 when binding date column
	27405242	OCIDescribeAny Fails With ORA-03113
	27471876	DBMS_CLOUD.LIST_OBJECTS returns wrong results because of the result cache
	27518227	Enable smart LOB creation when the client is a JDBC Thin Client
	27580996	rowset encrypt operator sometimes produces wrong results
	27595973	ORA-600:[kghstack_underflow_internal_1] [kkextabfunccard : text]
	27680162	Revisit 26047423 to exclude index fast full scan
	27682151	CTAS or INSERT … AS SELECT hangs when parallel select has order by and optimizer stats gathering is involved
	27705761	tracking bug to update bundlefcp xml in 18.3.0.1.180717dbru.
	27707544	Reverting inline smart LOBs for PLSQL binds
	27723002	dwcs : stats gathering for subsequent load is not working with constraints
	27739006	Dropping a unique column ONLINE fails With “ORA-14415: index in partially dropped state, submit DROP INDEX”
	27745220	Aaptive query plans are not seen when we result_cache_mode = “force”
	27773602	netsuite query failed with ORA-7445 [qctdeterminecoll()+638]
	27774320	ORA-64308: while exec dbms_spm.create_stgtab_baseline in pdbcs
	27782339	INSERT with extended syntax with incremental_level=TABLE not working properly
	27791223	ORA-00942: WHILE EXEC DBMS_SPM.CONFIGURE()
	27815347	Resource Manager Plan is not properly restored after the scheduler window ends
	27873643	Macro OCI_MINOR_VERSION Returns Wrong Version In Database with RU Patch
	27924147	OCISessionGet Takes Longer Time Than Specified Timeout Value
	27971575	set listenerlocal access fails in database ins dbms_xdb package
	27997875	Possible parse error after applying the fix of Bug 25919622
	28021205	Transaction Guard Check From OCI Client Fails In Interop mode
	28033429	wrong result is returned with inner join and left outer join from fix 22258300
18.3.0.0.180717DBRU	27392187	ORA-24370 instead of ORA-1483 when binding date column
	27971575	set listenerlocal access fails in database ins dbms_xdb package
18.2.0.0.DBRU:180417	26476244	port/implement dbms_optim package on 12.2.0.1
	27156355	ORA-904: “A43″.”ORA_ROWSCN”: invalid identifier
	27356373	ORA-07445 error while inserting PLSQL collection objects
18.0.0.0.0.DBRU	27971575	set listenerlocal access fails in database ins dbms_xdb package
	28194173	ORA-600 [kutyxtte_transform:failed] on top of 12.2 Database on Exadata
	28708023	Wrong results occur on pl/sql procedure after apply July 2018 PSU
	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients

High Availability

18.5.0.0.DBRU:190115	26115103E	Report Obsolete Not Showing Old Datafile Copy in 12.2
	27164352	Setting Parameter _kswsas_num_jp_slaves Fails
	27229389	ORA-756 / ORA-600 [3020] KCOX_FUTURE by Recovery In a Low Block number 2,3,4,5,6,7,8 after Add Datafile in Source
	27404668	LMS Crashes Instance with ORA-600 [kjbmprlst:shadow]
	27613530	dg broker integration issues with dbms_rolling.finish_plan
	27617978	ORA-600[kjbrbrmreplay:nmsg] in RSnn process
	27733415	ASM instance shutdown [NORMAL|IMMEDIATE] fails with ORA-15138
	27931299	Large LMS trace files even after applying fix of 25747569
	27975778E	The kjznhang_resp_out field is never cleared when the hang occur whose verification has timed out
	27995248E	pdb slow switchovertime is unacceptable
	27999638	ORA-600 [kjbrpickcur:!cur]
	28022101	list backup doesn’t show multisection backup of 32 tb datafile
	28180464	RMAN Duplicate with Section Size Does Not Create PDB Files Under ASM GUID Path
	28305362*	adwc: rman incremental apply overwrites good block with old content in exadata
	28361787	xdb stress::xdb-json hit ora 600 [kss_link_check]
	28621470	Fixing bad date string for RA job ids
	28685371	DIA0 Crashes with ORA-7445 [kjznctfschktfexists()+69] [SIGSEGV] If Patch For 28130048 Is Installed.
	28960211	INSERT WAITS FOR GC CURRENT REQUEST ON 6NODE RAC
18.4.0.0.DBRU:181016	23061453	ORA-600 [krbvalmrange_invalid_range] during RMAN INDEX_BACKUP Task on ZDLRA
	25644811	dbms_backup_restore takes absolute path/filename argument
	27037839	frequent full resyncs by rman during channel allocation
	27220937	“pdb close abort completion” wait during pdb opening
	27228786E	hm: improve performance of force test macros
	27351628	compressed backupset of datafilecopy not optimized for tde
	27449814	rolling upgrade failing during start_plan during LAD enable instruction
	27452046	dba_feature_usage_statistics incorrectly shows adg usage on logical standby
	27454722	v$restore_range does not have any data when connected to cdb$root
	27504770	ORA-600 [ksfdhardchk_err] by XTTS Compressed Backup
	27698953	rman validate copy of datafile failed with ORA-1426
	27757888	rman Segmentation fault when executing stored script for zdlra
	27759457	LogMiner Does Not Replicate Tables With Triggers Using Array Insert
	27918832	Enable _ksws_java_patching Orchestration to Java Patching Systems
	28000269	rman-06052 with incremental backup strategy for recovery of copy
	28187706	uninitialised memory in krmcprocessbackups
	28209341	The list of java services collected by srvm and the jp00(ksws) could be out of sync impacting OJVM.
	28320399	ORA-16059 encountered in RFS during log shipping
	28390273	RMAN: KRB traces in trace directory on running every command
18.3.0.0.DBRU:180717	25743479	ORA-19914 ORA-28361 by RMAN Encryption, CDB Backup
	26818960E	Hang Manager Reports a Session Waiting for Enqueue TS
	26822620	RAC Instance Crash: ORA-600 [[kjbmiconsign:ws] on 11.2.0.4
	26843558E	18.1 Hang Manager heuristic changes: Hang is flagged as unresolvable only if the immediate waiter is waiting for the CF enqueue
	26846077	OJVM upgrade gets ORA-4031 with LMD having message – MMAN has gone, stop allocating memory
	26956033	GoldenGate Extract Abends With ORA-4031 On Startup
	26992964E	The default number of LMS is too low for 100GB SGA environment
	27028251	Alert log message “An internal routine has requested a dump of selected redo.” for an expected error like ORA-1013
	27061736	Capture Fails To Restart LogMiner Due To ORA-1555
	27090765	Potential FSFO Split-brain when Primary in Standby is Unobserved.
	27126666	PDB_DOMAIN::CDB user process may get ORA-600 [kjucll:!attached] during reconfiguation when node is joining/leaving
	27199245	Excessive I/O from Archiver Process When FRA Is Full
	27215007	ORA-60 Deadlock During DML when Shadow Lost Write Protection Is Enabled
	27236052E	Incorrect “DLM RCFG HA STATS” for Domain Action Reconfiguration
	27241221E	Internal Enhancements to TS and CF Enqueues
	27254851
	27263996	ORA-29770/ORA-700 kjbldarmrpst resulting instance crash when run workloads at PDB level
	27270197	Variable not Initialized at kjznccIsHngCrsClsBlkd
	27274456
	27275776	RAC Database Getting Hung
	27282707E	Provide an Option to Stop Script Immediately After First Switchover in Rolling Upgrade Script physru.sh
	27283960	LMS hits ORA-600[kjbrchkmode:last] During Reconfiguration
	27301308	ORA-600 [kco_redo_compat_check_1] Compatible Check Missing For Alter Database Set Standby Nologging
	27304936	ORA-600 [kcblsy_1] By Direct Load Client After Standby Changes
	27334316	Additional Wait ID Detail Added to the Early Warning Hang Messages
	27339115E	hm: incorrect pointer/increment usage could cause memory corruption
	27339483	LogMiner Session Terminates Due to ORA-600 [KRVULCK]
	27358241	Several Processes Hit ORA-00600[kjbrmnode:!lms]
	27365139	ORA-00700 [kjbmocvt:b] During Reconfiguration
	27398080	RAC: Hang Manager deadlock resolution could cause unnecessary instance termination
	27426363	Recreate Control File May Fail with ORA-1210: Data File Is Corrupt and ORA-1189 in Multitenant Database
	27434193	SQL Apply Stopped W/ ORA-16211: Unsupported Record W/ Widetable Workload
	27439835	Incorrect Collection of Diagnostics for Hangs in RAC Environment
	27445330	Rolling Upgrade/Ogg Views Show Incorrect Support Info for Sharded Queue Tables
	27447687	ORA-600 [kcbr_apply_change_11] In Standby Database by Recovery Apply Slave for Direct Path Operation
	27450355	RMAN backup_restore.nid* APIs Does Not Perform Validation Done by dbnewid
	27457891	Downstream Integrated Extract stuck waiting for dictionary logs during startup.
	27486253	DBA_GOLDENGATE_SUPPORT_MODE Does Not List INTERNAL Tables
	27487795E	Undo DRM Performance Issue on Single Instance
	27504190	CDB: LMON getting ORA-600 [kjfcrfg:!cdbrcvinst] WITH INSTANCE CRASH
	27511196	LMS crashes instance with ORA-600 [kjbmocvt:b]
	27520900	ORA-3185 INMEMORY_ADG_ENABLED Parameter Does Not Change Dynamically in Primary Database
	27523368	DBMS_ROLLING.START_PLAN Retunrs Control Before Dictionary Build
	27525909E	Hang Manager Metrics do not Give Sufficient Time for System Recovery
	27544030	ORA-7445 kjbcropen() in CDB with PDB local undo feature in use
	27558557E	Code Improvement in the Shadow Lost Write Protection Area
	27558559E	Code Improvement in the Shadow Lost Write Protection Area
	27560702	ORA-7445 [krvxsawtx_agewritetx()]
	27585755	ORA-245 DBMS_ROLLING.START_PLAN Fails in Rac Configuration During Control File Creation
	27602091	Ignore Excluded Tablespaces During RMAN PDB Restore
	27607805	ORA-7445 [krvxrcalf()+159] From Golden Gate
	27617522	RMAN-6618 due to Version Incompatibility Between 18.2.0 and Rdbms 18.1.0
	27663370	ORA-600 [kjccgmb:1]
	27688099	RMAN-6055 in PDB PITR or Frashback but Archivelog Was in Obj Store
	27693713	PDB PITR Does Not Apply Incrementals When Local Undo Is Enabled
	27701795E	disable ksws java patching
	27719187	Hitting ORA-600 [ksvgeneratename: no space] During OGG Maxboundary Test
	27751006	ORA-26787 Transitioning a Physical Standby to a Logical Standby Could Miss a DML in a Multitenant Environment
	27757567	Data Divergence For CTAS To IOT Table Without , But With ADT/XML OR
	27783289	ORA-16538 From EM by Data Guard Broker While Getting Site Information for RAC
	27813267E	Hang Manager: ‘cross boundary (asm/db) blocking sessions’ statistic not always incremented
	27832643	Instance crashes If CSS returned No member while checking member kill victims
	27934468	ORA-29770 caused by lmd/mman/ckpt deadlock
	27993289	Tracking Bug for a CI into 18.3
28174827	RMAN Unconditional KRB Trace File After Installing Fix Of Bug 22700845
28264172E	Incomplete fix 27263996
18.2.0.0.DBRU:180417	26843558E	18.1 Hang Manager heuristic changes: Hang is flagged as unresolvable only if the immediate waiter is waiting for the CF enqueue
	26956033	GoldenGate Extract Abends With ORA-4031 On Startup
	27263996	ORA-29770/ORA-700 kjbldarmrpst resulting instance crash when run workloads at PDB level
	27270197	Variable not Initialized at kjznccIsHngCrsClsBlkd
	27283960	LMS hits ORA-600[kjbrchkmode:last] During Reconfiguration
	27301308	ORA-600 [kco_redo_compat_check_1] Compatible Check Missing For Alter Database Set Standby Nologging
	27304936	ORA-600 [kcblsy_1] By Direct Load Client After Standby Changes
	27339115E	hm: incorrect pointer/increment usage could cause memory corruption
	27365139	ORA-00700 [kjbmocvt:b] During Reconfiguration
	27398080	RAC: Hang Manager deadlock resolution could cause unnecessary instance termination
	27511196	LMS crashes instance with ORA-600 [kjbmocvt:b]
	27617522	RMAN-6618 due to Version Incompatibility Between 18.2.0 and Rdbms 18.1.0

Oracle JVM

18.4.0.0.DBRU:181016	28211734	OJVM:UJS NOT WORK AS EXPECTED WHEN ROLLBACK OJVM PATCH IN ROLLING WAY
	28258608	OJVM: CRASH LAST INSTANCE WILL CAUSE JAVA SERVICE DISABLE ON ALL NODES
18.3.0.0.DBRU:180717	27520070	Jersey Jars Licence Headers Containing GLP/CDDL To Be Changed To Oracle Headers

Oracle Multitenant

18.5.0.0.DBRU:190115	28752599	Plug of 12.1.0.2 PDB to 18.4 upgraded CDB causes ORA-3113, ORA-7445 [_IO_vfprintf()]
18.4.0.0.DBRU:181016	28210192	Dynamic sampling should not be disabled for NO_CROSS_CONTAINER cases
18.3.0.0.DBRU:180717	21766220	ORA-600 followed by ORA-603 when dropping a common user
	25824236	UTL_HTTP should be able to use network ACLS in CDB$ROOT for all PDBs
	27310092	hot clone of pdb with a read-only plugin tablespace fails with ORA-283/ORA-1184
	27345498	DB upgrade is slower because pdb$seed is upgraded in a batch of its own
	27378103	DBA_LOCKDOWN_PROFILES.CLAUSE_OPTION column has an extra trailing null character
	27384222	CMAN fails with TNS:connect request rejected based on current filtering rules
	27425507	standby does not instantiate source pdb with big file tablespace
	27450400	VPD layer does not handle fixed tables to retrieve object name
	27469329	relocate pdb to original POD fails ORA-65012: pluggable database already exists
	27496224	need to fire the PDB close trigger earlier rather than waiting for sessions to exit
	27498477	ORA-4036 during concurrent workload
	27533819	ADWC: PDB load data failed with ORA-65114 after PDB restore
	27563629	Cloned DB instance may crash with ORA-00600 [kcfbsy_offline_with_enq] error
	27602488	lockdown profile’s “option all except” clause does not work as expected
	27608669	describe of a fixed object in a closed db leads to ORA-1219
	27649707	update the lockdown profile to allow creation of validated constraints in ADWC
	27679806	ADWC: stack corruption in kpdbocGetObject()
	27950708	Query on CDB_TAB/ROLE_PRIVS takes 8.5 hrs and consumes 10 GB of PGA
	28059199	Local undo does not work after CDB upgrade from version 12102
18.2.0.0.DBRU:180417	21766220	ORA-600 followed by ORA-603 when dropping a common user
	25824236	UTL_HTTP should be able to use network ACLS in CDB$ROOT for all PDBs
	27425507	standby does not instantiate source pdb with big file tablespace

Oracle Net Services

18.5.0.0.DBRU:190115	28614072	Tracking bug for memory leak fix done in ngsmsl_build_topology2
18.4.0.0.DBRU:181016	26960097P	CMAN : in pro*c reexecuting plsql function with cursor throws ORA-1001
18.3.0.0.DBRU:180717	27060167	CRSD Process Becomes Unresponsive and OHASD (agent) Cannot Clean Resource
	27506774	dctm feature name should be reflected in the banner and error messages
	27772815	Query execution hangs from Windows Client using JDBC OCI with TCPS protocol against 11.2.0.4 database
	27926113	18.3: incorrect listener copy right version for 18.3 database
18.2.0.0.DBRU:180417	27060167	CRSD Process Becomes Unresponsive and OHASD (agent) Cannot Clean Resource

Oracle OLAP

18.3.0.0.DBRU:180717	27448162	OLAP: Increase inplace LOB overwrite for update performance
	27818871	OLAP Analytic Workspace component is INVALID in DBA_REGISTRY after applying the 18.2 Release Update

Oracle Portable ClusterWare

18.3.0.0.DBRU:180717

27315159E

Optimized CHM local JSON dump

Oracle Secure Files

18.5.0.0.DBRU:190115	28365111	LOB is stored as a securefile when db_securefile is set to permitted
18.0.0.0.0.DBRU	28365111	LOB is stored as a securefile when db_securefile is set to permitted

Oracle Security

18.5.0.0.DBRU:190115	25607397	Allow Wallet to Open in the Mounted State for United Mode PDB
	28713840	tracking bug to fix the regression caused by ci backport bug 28169168
18.4.0.0.DBRU:181016	25303284	Audit Policy Enabled with ‘except’ Clause should Honor the Newly Created users
	28290434	ORA-600:[kkdoilsf1] Error On Clean_audit_trail In Sharding Setup
18.3.0.0.DBRU:180717	24689376	Secure application role in 12.1.0.2 standard edition (se2) fails with ORA-00439
	24925863	gen0 reports error barrier and ORA-1403 during startup
	26961415	ORA 7445 [kprcdt] during dbms_inmemory.populate
	27026401	set role is not being tracked in session tracking – superseded
	27294480	ORA-01658 while executing cleanup of the Unified audit trail
	27301568	ORA-28382: global wallet operation in rac may signal for certain secure external password store for TDE
	27334648	TDE: open database failed with ORA-15124 on one RAC instance
	27430802	ORA-28365 wallet is not open while creating the DBMS credential or enabling dictionary encryption
	27447452	dwcs: ORA-46661: keystore not open in root container
	27460675	ORA-1031 on create pdb using external store
	27483974	alter user privilege issue in kzu.c
	27522245	password verification function (pvf) not calculating the password length in byte
	27550341	password verification function(pvf) does not work with nls multibyte characters
	27952762	jdbc::mt hit ora 600 [kglgetso-null-parent]
	28057267	alter user command erros with ORA-28008 when replace clause is used for sys in 18c
18.2.0.0.DBRU:180417	24689376	Secure application role in 12.1.0.2 standard edition (se2) fails with ORA-00439
	27301568	ORA-28382: global wallet operation in rac may signal for certain secure external password store for TDE
	27334648	TDE: open database failed with ORA-15124 on one RAC instance
	27430802	ORA-28365 wallet is not open while creating the DBMS credential or enabling dictionary encryption

Oracle Security Service

18.3.0.0.DBRU:180717	27339495E	Support for FIPS compliance in Oracle Wallet and ORAPKI
18.2.0.0.DBRU:180417	27339495E	Support for FIPS compliance in Oracle Wallet and ORAPKI

Oracle Space management

18.5.0.0.DBRU:190115	21095391	Space background latch contention after DML
	27801337	Expired Bytes Not Reused On LOB Insert
	28420457E	Enable HCC on ACFS Configured on ODA
	28673203	new olint warnings
18.5.0.0.190115DBRU	28673203	new olint warnings
18.4.1.0.190115DBRUR	28673203	new olint warnings
18.4.0.0.DBRU:181016	14221306	alter index modify partition shrink space requires exclusive lock
	24971597	ORA-600 [ktfbn_alloc_stat] from insert
	27255377	ORA-00600 [kteupropagatetime:clsviol_kcbgcur_9]
	27350267	ORA-00600 [kdblkcheckerror]
	28328895	A BigFile tablespace created in a container DB may grow beyond the DB size limit imposed by Oracle Express Edition
	28344964	Check the PDB total storage space during startup on 18c XE
	28483184	ORA-600 [PITL1] / ORA-600 [kdt_bseg_srch_cbk PITL1] Errors During DML on Compressed Table
	28527416	new olint warnings introduced by the fix of Bug 28344964
18.4.0.0.181016DBRU	14221306	alter index modify partition shrink space requires exclusive lock
	27350267	ORA-00600 [kdblkcheckerror]
	28328895	A BigFile tablespace created in a container DB may grow beyond the DB size limit imposed by Oracle Express Edition
	28344964	Check the PDB total storage space during startup on 18c XE
	28527416	new olint warnings introduced by the fix of Bug 28344964
18.3.0.0.DBRU:180717	9062315	Compression ratio For QUERY HIGH or QUERY LOW seems to vary if DB_BLOCK_SIZE=32K
	24737581E	ORA-8102 on DML against IOT if there is a Function Based Index (FBI)
	26226953	Workload hits ORA-7445 [kdzdcol_init_2()+57]
	26598422	w000 Hits ORA-600 [ktsla_cache_check_dups-1] And ORA-600 [ktcpoptx:!cmt top lvl]
	27038986	seg$ is still not updated frequently for changes in index or lob segment
	27292213	diag:dump information specific to issue kdblrmtldrins
	27346709	ORA-600 [504] When Close Abort PDB
	27359368	Oracle XE: storage space does not take into account the closed PDBs
	27367194	securefile LOB segment growth
	27375542	ORA-600 [kcbzwb_4]
	27747869	ORA-7445 in kokl on alter table move w/ pushdown for compressed lobs
18.0.0.0.0.DBRU	21095391	Space background latch contention after DML
	27292213	diag:dump information specific to issue kdblrmtldrins
	27801337	Expired Bytes Not Reused On LOB Insert

Oracle Storage Server Service Layer

18.4.0.0.DBRU:181016	28321446	ORA-00600: internal error code, arguments: [13030], [20]
18.3.0.0.DBRU:180717	21806121	cc2 Enhancement: DLMs not Working when Rowids Needed
	27240246	sageasm-e balance phase skipped due to resilvering
	27240570	imccust:ge:stcs_mxvc: workload hangs
	27338912	Trace Files May Get Filled With kcfis Diagnostic Data

Oracle Streams

18.5.0.0.DBRU:190115	23761724	GoldenGate Apply Server waiting on “library cache pin” – deadlock
	27200959	ORA-942 in dba_capture when starting Database/Instance via srvctl
	27320576	IE abends with ora 7445 [knlogc_find_obj_by_name] upon startup
	27680669	Performance issues seen in goldengate integrated replicat
	27825241	PGA memory leak in apply server replicating PL/SQL procedures
	28120951	Incorrect auto conflict resolution for piecewise lob operation in Integrated Replicat
	28215510	longs are truncated when replicating from al32utf8 (variable length charset)
	28281094	OGG integrated replicat fails with ORA-00600 [kghalo4] error
	28302049	Open Cursors leak in replicat process
	28361221	Classic replicat apply DML not treated as user dml for AutoCDR tables
	28369092	ORA-600 [knaspplsqlentry809] reported in rti 21440197
18.4.1.0.DBRUR:190115	28369092	ORA-600 [knaspplsqlentry809] reported in rti 21440197
18.3.0.0.DBRU:180717	27284499	ogg:cdr: replicat abend w/ ogg-01296 error mapping with cdr in 3 way
	27379233	Integreated Replicat fails with ORA-600 [knglprc_copy:*dst]

Oracle Transaction Management

18.5.0.0.DBRU:190115	27544973	Reco Process Fails with ORA-603 ORA-3106 in oracle 12.2
18.4.0.0.DBRU:181016	27169888	ORA-600 :[4511] in OLTP XA transaction workload on a CDB enviroment
18.3.0.0.DBRU:180717	27349393	18.1im_adg: hit ora 600 [ktma_insert_inv_0]
	27964051	“_imtxn_table_max_inc_per_slt” should be set to 1
18.2.0.0.DBRU:180417	13554903	cdb: flashback query in pdb fails due to missing undo tbs

Oracle Utilities

18.5.0.0.DBRU:190115	28508053	placeholder for tfa collector version 18.3.2 + bug 28654050 inclusion in january 2019 bundles
	28993590E	Include ORAchk 18.4.0 in Jan 2019 RU/PSU Patches
18.4.0.0.DBRU:181016	27210263	TTS Export with DataPump Hits ORA-7445 [lnxsni]
	27441980	A Physical Directory Corresponding to DATA_PUMP_DIR Object Isn’t Created on Disk
	27620808	SQL LOADER USING “LLS” OPTION NOT LOADING LOB CORRECTLY
	27772093	18.1 DB PREUPGRADE TO CHECK FOR SYMLINKS USED BY UTL_FILE PACKAGE
	27810967E	Include ORAchk 18.2.0 in July 2018 PSU/RU
	27861452	ADD PREUPGRADE CHECK FOR SYMLINKS IN DIRECTORY OBJECTS
	27998003	wrong results using recnum column
	28305001	tracking bug to include orachk 18.3.0 in october 2018 ru/psu
	28354603E	Placeholder for TFA Collector Version 18.2.1
	28403295	startup XE database fails with ORA-39712 when nls_calendar=”japanese imperial” in init.ora
	28420042	ORA-29400 From External Table Preprocessor
	28455212	SP2-0310: Unable to Open File “dbms_registry_extended.sql” during Database Downgrade
	28508557	ORA-904: “decl_obj#”: invalid identifier During Downgrade Reload in 12201 DBRU
	28679454E	Placeholder for TFA Collector for October 2018 Bundle Patches
18.4.0.0.181016DBRU	28403295	startup XE database fails with ORA-39712 when nls_calendar=”japanese imperial” in init.ora
18.3.0.0.DBRU:180717	24489904	Hit ORA-600 [kupaxfsi_bad_granule_value] with DATA_PUMP Access Driver
	25943740*	UPGRADE: CDB UPGRADE FUNCTIONALITY TEST FAILED ON RAC
	27321834	UPGRADE OF 12201 PROXY PDB HAS ORA-01017/ORA-12541
	27457666	Unable To Kill Data Pump Worker Sessions
	27473800	DataPump Import Using External_Table Errors Out With ORA-39079 And ORA-931
	27484556	Datapump Expdp/Impdp Crash With Attach Parameter When Command Line Very Long (> 2000 bytes)
	27489719	Query On V$SESSION In Datapump Worker Process Returns Wrong Results
	27523800*	REMOVE DBMS_REGISTRY_BASIC.SQL FILE AND MODIFY PREUPGRADE TOOL ACCORDINGLY
	27547732*	DBUA: “CAN NOT OPEN WALLET ” POST UPGRADE DBUA IN SILENT MODE
	27577758	External Table Parsing Fails With KUP-04029
	27591842*E	ADD BUILD_DESCRIPTION AND BUILD_TIMESTAMP TO DBMS_REGISTRY.RU_APPLY
	27604293	ORA-7445 [_IO_vfprintf()+15964] Core Dump With External Modify Debug Option
	27634676*	CATCON TRIES TO OPEN PDBS ON THE DEFAULT INSTANCE WHICH ARE ALREADY OPEN
	27679664*	CATCON SHOULD ONLY OPERATE ON PDBS WITH NEW OR NORMAL STATUS
	27847259E	Placeholder for TFA Collector Version 18.1.2 Inclusion in July 2018 bundles
	27861909	External Table With ignore_header=3 Causes ORA-3113 and ORA 7445 [skudmic]
	27892488*	[18.1 CDB STANDBY] PREUPGRADE.JAR FAILS WITH ORA-16000
	27941896*	DBMS_OPTIM_BUNDLE INVALID OBJECT FOUND AFTER DB IS DOWNGRADED FROM 18.3 TO 11204
18.2.0.0.DBRU:180417	27457666	Unable To Kill Data Pump Worker Sessions

Oracle Virtual Operating System Services

18.5.0.0.DBRU:190115	25736428	Improve dnfs retry and backoff in cases of nfs delays/errors
	27111780	ipc_bench latency raises asserts
	27179264	EXAFUSION_ENABLED parameter does not report any trace in Alert log
	27181897E	Insert into objauth$ leading ORA-600 [6816] during stats gathering
	27400416	Instance may crash with ORA-604 and ORA-2393 by GEN0 process
	27623844	If slave is enabled after ksfdshare, io may not use slave causing regression.
	28695694	IMPROVE DNFS RETRY AND BACKOFF IN CASES OF NFS DELAYS/ERRORS
18.4.1.0.DBRUR:190115	28695694	IMPROVE DNFS RETRY AND BACKOFF IN CASES OF NFS DELAYS/ERRORS
18.4.0.0.DBRU:181016	25911069P	win-osd for xmem support on windows
	26297826E	ORA-600 [KGHALO4] During Workload in 18.1
	26895149	ORA-7445 [ksfqwr()+197] Occurs in Dataguard During Remote PDB Clone with Database Link
	27599927	kgdsdsts() is Failed to Print Short Call Stack Trace Record on Windows
	27691920	When using exadata and configured with multiple network paths it was possible for monitoring to use different ports, thus only validating the sending side and leaving gaps in the overall path health.
	27691939	SKGXP Sends Early Notification when at least one Path is Still Healthy
	27960021	Exadata: Restart ASM on one node hit ORA-27553: incompatible ipc settings
	27994325	Workload Hang on RDS on Converged Ethernet When More than 1 IP is Used
	28024347	Event 10261 Fails for 2GB and Larger Sizes
	28111583	RAC Instance Crashes due to High Traffic
	28338399	ORA-4031 During Startup Due To kghalf Not Using Reserved Extents
	28385102P	update visual c++ redist for vs2013 to latest version for win x86
18.4.0.0.181016DBRU	28385102P	update visual c++ redist for vs2013 to latest version for win x86
18.3.0.0.DBRU:180717	25287072	LMS1 hits ORA-7445 [gsignal()+53] [sigiot] during switch reboot
	27112686	Using JDBC and Switching Service Looses the Service Domain
	27135647	ORA-29370 while executing dbms_resource_manager.create_pending_area
	27210038	Hit ORA-7445 [pc:0x0] in ASM Instance
	27216224	PDB Flash Cache Capacity Changed When Closing It
	27259983	18.1 CDB-RAC: Hang During PDB Read Only Restricted Force Open And Instance Crash
	27345450	ORA 7445 [ksmem_free] & ORA 7445 [kopdarnew]
	27352600	ORA-600 [IPC Assert], [ipclw_rc.c:13582 : (0)]
	27425622	dwcs: dbrm should report the killed session details in pdb alert log
	27441326P	Optimize SLCPU To Avoid Redundant getrusage Calls Within Kernel Frequency
	27505603
	27512439	ADWC: ORA-4036 During Concurrent DataPump Imports
	27563767	LMON is Spinning in recvmsg()
	27586895	PDB Close Hangs With ‘OFS operation completion'<=’enq: FO – file system operation contention’
	27732323	Error ORA-00600: [IPC Assert], [ipclw_rc.c:13684 : (0)]
	27812593	OFSD RECEIVER THREAD DEATH CAUSES HANGS ON INSTANCE SHUTDOWN
	28072130	Remove exadata/cloud restriction that was introduced in 18.1
18.2.0.0.DBRU:180417	27216224	PDB Flash Cache Capacity Changed When Closing It
	27425622	dwcs: dbrm should report the killed session details in pdb alert log
	27441326P	Optimize SLCPU To Avoid Redundant getrusage Calls Within Kernel Frequency

PL/SQL

18.5.0.0.DBRU:190115	28528349	ORA-600 [18088] Reported in 12.2
18.4.0.0.DBRU:181016	26399691	Alter Package… Compile Fails With ORA-00001 When The Package Contains Overloaded Cursor
	27293599	Forms Compilation Fails With “Internal error (*** ASSERT at file pdz2.c ***)
	28312508	Disable Checks Introduced by Bug 24334094
18.3.0.0.DBRU:180717	27086821	XML related packages are marked as side effects
	27401637	PLS-00707 [2648] Internal Error When Using PRAGMA DEPRECATE With Type Objects
18.3.0.0.180717DBRU	27086821	XML related packages are marked as side effects

Patch Automation

18.4.0.0.DBRU:181016

27849825

ERRORS IN DATAPATCH POST ROLLBACK ON 18.2RU FOR OJVM

Server Manageability

18.5.0.0.DBRU:190115	27593501	automatic mainenance jobs get enabled during upgrade – even if disabled before
	28580528	184.181016giru:apply/rollback patch hang at mdb sqlpatch
	28919145	invalids seen when exec catawrpdbvw.sql
18.4.1.0.DBRUR:190115	28919145	invalids seen when exec catawrpdbvw.sql
18.4.0.0.DBRU:181016	25487146	svrm : mmon slave performance: keiutflushslv slave performance degradation
	27876671	apps rt1227 replay client crashed with segmentation fault (core dumped)
18.3.2.0.DBRUR:190115	28919145	invalids seen when exec catawrpdbvw.sql
18.3.0.0.DBRU:180717	27395794	save state in a closed pdb throws an error ORA-65011
	27410595	wrong sql id computed by dbms_sqltune_util0.sqltext_to_sqlid()
	27433870	cdb : awr getting generated has negative values
	27442041	wcr: replay hangs at ‘wcr: replay clock’
	27458164	report_analysis_task report zero execution metric w/ num_rows_to_fetch is set
	27545630	Database replay failed with ORA-4030 and ORA-7445 [kecp_pbdispatcher]
	27592466	Column ip_address is not masked in view dba_hist_cluster_intercon
	27740844	tracking bug for rti 20854424
	27833369	ORA-600 [kecppP1AfterFileParse: unknown status] RAT_REPLAY
	27984028	[pdcdb] replay hang caused by two commits that both have same post commit scn

XML Utilities

18.5.0.0.DBRU:190115	27694261	refactor jznu.c into multiple files for maintenance
	28229360	lpxbuf.c fails parsing large utf16 le content
	28514693	jzntools.h needs to include lx.h
	28535272	json rendering of number incorrect for negative values with > 38 digits
18.5.0.0.190115DBRU	27694261	refactor jznu.c into multiple files for maintenance
	28229360	lpxbuf.c fails parsing large utf16 le content
	28514693	jzntools.h needs to include lx.h
	28535272	json rendering of number incorrect for negative values with > 38 digits
18.4.0.0.DBRU:181016	27654521	path engine doesn’t handle null cases properly
18.4.0.0.181016DBRU	27654521	path engine doesn’t handle null cases properly
	27694261	refactor jznu.c into multiple files for maintenance
18.3.0.0.DBRU:180717	27119621	json wrong result after apply db bundle patch on 12.1 or upgrade to 12.2
	27241247	revise json/xml xdk character conversion function calls.
	27398660	ORA-600 [kdmv_check_row], [4286265] w/ nls_numeric_characters=,.
	27450783	large number of digits in numeric exponent gives wrong results
	27459909	json renderer omits leading 0 on fractional values
	27501465	jznqbe returns incorrect path expression if used with datatype or order fields
	27518310	jzn0domunlinkfield lacking length check leading to removal ofdom node
	27537472E	soda c qbe needs error clause flags for $orderby and spatial ops
	27579353E	lpxfsm.c overflow handling should use memmove
	27631506	event recorder may overallocate buffer for start object/array events
18.3.0.0.180717DBRU	27119621	json wrong result after apply db bundle patch on 12.1 or upgrade to 12.2
	27241247	revise json/xml xdk character conversion function calls.
	27398660	ORA-600 [kdmv_check_row], [4286265] w/ nls_numeric_characters=,.
	27450783	large number of digits in numeric exponent gives wrong results
	27459909	json renderer omits leading 0 on fractional values
	27501465	jznqbe returns incorrect path expression if used with datatype or order fields
	27518310	jzn0domunlinkfield lacking length check leading to removal ofdom node
	27537472E	soda c qbe needs error clause flags for $orderby and spatial ops
	27579353E	lpxfsm.c overflow handling should use memmove
	27631506	event recorder may overallocate buffer for start object/array events

XML database

18.5.0.0.DBRU:190115	27381498	xmltype of oracle object(type) fails with ORA-31011 in 12.2 works 11.2.0.3
	27480784	xdb stress::xdb-json hit ora 600 [kghuclientasp_04]
	27896443	sql/json path needs to have recursive descendant path step
	27948153	oci soda bulk insert and get returns non-null pointers even in case of an error
	28036487	xdb stress::xdb-json hit ora 4030 [256064]
	28108898	json search index: no post-filter for array access [0] causes wrong results
	28214943	after object in array, sdata values are not indexed
	28338999	json_object clob input over 32k raises ORA-6502: pl/sql: numeric or value error
	28503484	memory leak calling ocisodacollcreatewithmetadata()/ocisodacolldrop() repeatedly
	28544633	regression: lob from soda api is not freed as only ocidescriptoralloc is used
	28545687	error:odpi soda cursor yields unstable resultset propogating to py/node drivers
	28670445	invalid format exception when using dot notation support for blob with json data
18.5.0.0.190115DBRU	27381498	xmltype of oracle object(type) fails with ORA-31011 in 12.2 works 11.2.0.3
	27480784	xdb stress::xdb-json hit ora 600 [kghuclientasp_04]
	27896443	sql/json path needs to have recursive descendant path step
	27948153	oci soda bulk insert and get returns non-null pointers even in case of an error
	28036487	xdb stress::xdb-json hit ora 4030 [256064]
	28108898	json search index: no post-filter for array access [0] causes wrong results
	28214943	after object in array, sdata values are not indexed
	28338999	json_object clob input over 32k raises ORA-6502: pl/sql: numeric or value error
	28503484	memory leak calling ocisodacollcreatewithmetadata()/ocisodacolldrop() repeatedly
	28544633	regression: lob from soda api is not freed as only ocidescriptoralloc is used
	28545687	error:odpi soda cursor yields unstable resultset propogating to py/node drivers
	28670445	invalid format exception when using dot notation support for blob with json data
18.4.0.0.DBRU:181016	27700466	ORA-600: internal error code, arguments: [qjsnplsgetkeys_obj: ociobjectnew]
	27767081	data guide not maintained when inserting into json column
18.4.0.0.181016DBRU	27700466	ORA-600: internal error code, arguments: [qjsnplsgetkeys_obj: ociobjectnew]
	27767081	data guide not maintained when inserting into json column
18.3.0.0.DBRU:180717	21547051	ORA-600 [qmxfindxobparent] registering sdmx 2.1 schemas
	27005278	SODA qbe apis return incorrect result due to invalid binding of filter
	27053044	xdb: query dataguide from view hit error ORA-40586
	27233563	sql function json_dataguide raises (not helpful) error for long varchar2 input
	27249215	dbms_json.get_index_dataguide failed with nls_numeric_character=”, “
	27275136	running xquery prints empty rows due to parser error:[lpxerrmsg 210 lpxerr_not_expected]
	27341036	query on json search index fails w/ ORA-29902 if nls_numeric_characters=,.
	27359178	getclobval to regexp_replace results in ORA-12727
	27395416	lsx-00204 error when validating an xml file on 12c and working on 11g
	27396672	ogg: replicat abend w/ ORA-907 if attribute value updated
	27444727	xdb stress::xdb-json hit ora 7445 [kokqpoqb]
	27501413	win64: rti 20952244 : ORA-7445 [pc:0x6c816be1b0] [access_violation]
	27586810	soda: indexnulls field in the b-tree specification is always ignored
	27593389	json dataguide only domain index has to do delayed maintenance
	27613080	xml parsing returns no result after ru patch 12.2.0.1.180116 (27105253) installe
	27664702	ORA-1741 on executing “dbms_json.create_view_on_path”
	27679961	after alter index rebuild, json search index is not populated
	27718914P	lrgsrgdbcon2 regress diffs: ORA-29902: error in executing odciindexstart()

Miscellaneous Issues

18.5.0.0.DBRU:190115	25591292	Adding a standby PDB as a shard fails with ORA-32000
	26083489P	ODP: IndexOutOfRangeException When Deriving Parameters For Associate Array
	27054231	txtinx cursor leak during text queries execution
	27386467	contention between sync index and dml due to sync_upd user lock
	27469245	ORA-600 [ktcrab: caller passed invalid xcb] / ORA-8103 with ZONEMAP
	27578007	gdsctl deploy fails to deploy standby PDB shards with error ORA-02019
	27658186	txtupgr hit ora 600 [kdsgrp1]
	27658205	ORA-2019 in cdb mode in standby shards for multiple scenarios like describe table etc
	27688036	Bytes_not_populated In V$im_segments Returns Negative Value
	27756900	upper of unistr(‘\026a’) results in null value
	27761402P	ODP.Net Fails With “Value cannot be NULL” For Output Parameter Binding of NULL UDT.
	28085865	plsqlassociativearray parameter with precision not working
	28392168	seps: wallet_location not support environment variable in sqlnet and app config
	28434028	Auto Upgrade fails with a version mismatch error
	28493478	Create index on sharded table with blank partition name has junk characters in error message
	28584193P	ODP.Net core: First Connection Fails and Subsequent Connections Succeeds
	28627255E	Make GIMR Optional During a Standalone Cluster Installation
	28714058	.NET Core System.InvalidOperationException when using ProcessTimeZone
18.5.0.0.190115DBRU	27054231	txtinx cursor leak during text queries execution
	27386467	contention between sync index and dml due to sync_upd user lock
	27658186	txtupgr hit ora 600 [kdsgrp1]
	27756900	upper of unistr(‘\026a’) results in null value
	28434028	Auto Upgrade fails with a version mismatch error
18.4.0.0.DBRU:181016	25958554P	odpu-ccp-auto-tuning is not compatible with ccp via oraaccess.xml
	27006664E	LNX-181-MDB: HIT ORA-20001 & ORA-06510 & ORA-29913 ERRORS IN MGMTDB’S ALERT LOG
	27035653P	18.1:w2k12_r2:odpm: session drainage issue in planned ha (stopping service )adg
	27160360P	odpu: memory corruption issue with 12.2 driver with descriptor-based types
	27276231	Archived rows are still visible via SQL using a PL/SQL FUNCTION
	27288894P	ODP UnManaged driver Takes Longer Time To Execute The Stored Procedure Having User Defined Type
	27302714	incorrect base64 encoded values returned for char type shard key
	27394086P	connection failure to XA interface
	27462994P	MAPMUNG TAKES LONGER TIME FOR ORAROOTAGENT.MAP
	27690513P	18.1: ODPU – RLB FUNCTIONALITY SEEMS TO BE BROKEN AS USER CALLS/SEC
	27757794	new API to tell if a directory path contains symlink
	27766324E	Bug 27766324: Internal fix (External table support improvement)
	27843646P	new API to tell if a directory path contains symlink on Windows
	27971503	ODPM:Wallet Environment Support For TNS_ADMIN from App.config : Getresolvedfilelocation
	27977039	ODPM: Connection FailOver Bug 22480200 Backport to 18.1
	28004853P	ode-ccp: new a oraclexmltype get system.nullreferenceexception
	28090453*	RDBMS_MAIN PREFLIGHT: LRGISM5/LRGISM5A
	28103600	change database product version to 18.4.0.0.0
	28104361P	ODP UnManaged: Access Violation With Connection Open/Close Test With 100 Threads
	28174951	CDB: ORA-19729 Datafile Not Created Automatically On ADG
	28227512P	odpm – oracledecimal.converttoprecscale method throws ORA-16550 error
	28285766	Datapatch Ungraceful Terimnation After Patching
	28304709	lrg-20796023
	28315995	ODPC: Provide App.Config/Web.Config Alternative for ODP.NET Core Provider
	28391582	18.4-SEP-ID: DATAPATCH FAILED DURING 18.4 GIRU PATCH ROLLBACK
	28393678	invalids seen in 18.4.0.0.180814dbid due to fix :26427905
	28445741	spatial install scripts should exclude objects that depend on xdb
	28475164	Code Improvement for Cloning and Gold Image Creation
	28478676	Datapatch fails while Upgrade From 18.2.1 RUR to 18.4 RU
	28504545P	AIX: ‘gridSetup -printImageInfo’ Prompts for rootpre Execution
	28553468	Datapatch Fails to Patch Mgmtdb: Undefined Value as an Array Reference
18.4.0.0.181016DBRU	27394086P	connection failure to XA interface
	27757794	new API to tell if a directory path contains symlink
	27766324E	Bug 27766324: Internal fix (External table support improvement)
	27843646P	new API to tell if a directory path contains symlink on Windows
	28103600	change database product version to 18.4.0.0.0
	28304709	lrg-20796023
	28393678	invalids seen in 18.4.0.0.180814dbid due to fix :26427905
	28445741	spatial install scripts should exclude objects that depend on xdb
18.3.0.0.DBRU:180717	23310101	OIT: DRG-11428 When Creating Text Index On PDF File Which Uses Certain Full Width Characters
	25348956	Intermittent ORA-60 (deadlock) with concurrent running of sqlpatch and MMON ilm cleanup
	26654411	Cannot populate HIVE/HDFS external table into In-Memory
	26966120	PDML workload reports ORA-7445 [kdmsfree] / ORA-00600 [4000]
	27058530	No Data Found Returns Wrong SQLCODE (1403) When MODE=ANSI For LOB Read Statement In Precompilers
	27066451P	18.1 ODPU : CCP Distributed Transaction : Sessions Not Getting Drained On Planned HA
	27066519P	18.1 ODPM Distributed Transaction : Sessions Not Getting Drained On Planned HA.
	27073066	profiling new areas for 19.1 – imc specific
	27101652	ORA-7445 [kdzdcol_theta_sep]
	27153641E	QOPIPREP.BAT USES INCORRECT SHELL VARIABLE EXPANSION
	27169796	EXABM : 12.1.0.2 DATAPATCH FAILS IF HOSTNAME AND INSTANCE NAME MORE THAN 60 CHAR
	27208953	ORA-13249: multiple entries in sdo_index_metadata table
	27214085	ORA-00600: [hcsMDObjRslvrAssert: object can not resolve] Creating Attribute Dimension Using Multi Keys And Joins.
	27226913	spatial create index with enabled vpd policy on base table creates corrupt index
	27250547	Memory leak in lfimknam() from liborapkcs.so when loaded in DB
	27283029E	RUID CHANGED DATAPATCH REQUIREMENTS
	27305318	Key Vectors Overexpand When Reducing Their Offset
	27329812	select sdo_anyinteract() ORA-600: [kghstack_underflow_internal_2]
	27339396	regression tracking bug filed from mergereq
	27345190	facets slow for more than 1k results
	27345231	dml blocked by concurrent sync index which acquires exclusive lock on $k table
	27365993	update httpcomponents core 4.4
	27368850PE	ENABLE ROOH ON S/W HOME DOES NOT WORK IN A GRID/SIHA WITH DB FROM ANOTHER HOME
	27376871	av create fails with ORA-600 calc with plsql function referencing av calc
	27389352	direct-row-access reset during spatial create index and collect statistics
	27396813	ORA-600 [ktmaaddcmtnode_2b] When Ran IMDB Test Using MIRA Under CDB Environment
	27412805*	tracking bug for rti 20891325
	27417186E	CREATE GOLD IMAGE TAR FORMAT SHOULD HAVE FILES PATH STARTING FROM SUBDIR NOT DOT
	27423251	Switchover failed on 18c DB when IMC is used on ADG
	27427805E	GI CVU_PREREQ.XML IS INSTALLED IN DB HOME
	27432338E	CREATEGOLDIMAGE FLAG TO KEEP ABSOLUTE PATH TO ORACLE HOME ON THE GOLDIMAGE FILE
	27432355E	CREATEGOLDIMAGE FLAG TO ZERO OUT FILES THAT ARE CREATED DURING LINKING PHASE
	27434486	change database product version to 18.2.0.0.0
	27445462	A query with level_name predicate fails with ORA-00600 [hcsMDObjRslvrAssert: object can not resolve] error
	27452760	Hit ORA-7445 [kdmu_getheader()] When Query GV$IM_HEADER On ADG – superseded
	27467543	LNX-191-SIHA: SHOULD DISABLE DB SOFTWARE LOACTION SELECTION DURING INSTALL
	27472969	united pdb plug doesn’t work when keystore_config is hsm/okv
	27479358	impdp failed with ORA-12805 and ORA-31623 during retry
	27501327E	facet navigation is missing custom range bucketing
	27570318P	PL18.1PORTSPECIFIC: LIBCLNTSH.SO LINKING ISSUE IN INSTANTCLIENT MODE ON AIX
	27587672*	ARUQA:BUG DB18:Datapatch failed with invalid month error for production patch
	27615608	ORA-600 results in mdx when cbdim alias not used in query
	27616657	tkzcetpkg02.dif occurs sometimes after a recent bug fix
	27625620	tracking bug for rti 20823770 which fixes a regression caused by 27044403
	27644757	Adding mutex-acquire timeout
	27679488	change database product version to 18.3.0.0.0
	27691809	ORA-4031 error due to qesxlHashAllocMemb() crash during memory pressure
	27697092	csq ends with ORA-600 [qerrmoxi2e1] with lob bind
	27744211P	18.1:Windows 2012 R2 : ODPU : OCP : HA / RLB Registration Failed
	27774539	remove oit deprecated apis
	27779886	short profile workload feature during partial build
	27780562	ORA-7445 in facets stress test
	27786772	SQL PATCH IS NOT GETTING EXECUTED DURING ROLLBACK USING OPATCHAUTO FOR OOP
	27803665	open cve found in property_graph
	27840386	ORA-7445 [ldidatetoarrayi()+83]
	27882176E	DATAPATCH SHOULD NOT PROCESS FILES WITH MISSING COMPONENTS
	27994333P	SETUP.EXE LAUNCHER TO BE AVAILABLE FOR IMAGE INSTALLERS
	27999597	REMOTE GIMR PATCHING FAILS DUE TO DATAPATCH ERROR IN PREREQ CHECKS ORA-01031
	28022847	EXECUTION PROFILE NOT WORKING ON CLOUD DEPLOYMENT
	28098865	18.3:CLSRSC-180: AN ERROR OCCURRED WHILE EXECUTING THE COMMAND MGMTCA APPLYSQL
	28174951	CDB: ORA-19729 Datafile Not Created Automatically On ADG
	28320117	Configure an Oracle Domain Service Cluster Fails Using Chinese Language due to DataPatch Issue
18.2.0.0.DBRU:180417	27169796	EXABM : 12.1.0.2 DATAPATCH FAILS IF HOSTNAME AND INSTANCE NAME MORE THAN 60 CHAR
	27283029E	RUID CHANGED DATAPATCH REQUIREMENTS
	27368850PE	ENABLE ROOH ON S/W HOME DOES NOT WORK IN A GRID/SIHA WITH DB FROM ANOTHER HOME
	27417186E	CREATE GOLD IMAGE TAR FORMAT SHOULD HAVE FILES PATH STARTING FROM SUBDIR NOT DOT
	27427805E	GI CVU_PREREQ.XML IS INSTALLED IN DB HOME
	27432338E	CREATEGOLDIMAGE FLAG TO KEEP ABSOLUTE PATH TO ORACLE HOME ON THE GOLDIMAGE FILE
	27432355E	CREATEGOLDIMAGE FLAG TO ZERO OUT FILES THAT ARE CREATED DURING LINKING PHASE
	27434486	change database product version to 18.2.0.0.0
	27467543	LNX-191-SIHA: SHOULD DISABLE DB SOFTWARE LOACTION SELECTION DURING INSTALL
	27786772	SQL PATCH IS NOT GETTING EXECUTED DURING ROLLBACK USING OPATCHAUTO FOR OOP
18.1.0.0.DBRU:190115	26083489P	ODP: IndexOutOfRangeException When Deriving Parameters For Associate Array

 

Generic

18.4.1.0.190115DBRUR	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients
18.3.2.0.190115DBRUR	28785022	ORA-22275: invalid LOB locator specified
	28805612	Temp LOB length is set to 0 when PGA usage is 75% and incorrect locator length returned to OJVM clients

Oracle Space management

18.4.1.0.190115DBRUR

28673203

new olint warnings

Oracle Streams

18.4.1.0.DBRUR:190115

28369092

ORA-600 [knaspplsqlentry809] reported in rti 21440197

Oracle Virtual Operating System Services

18.4.1.0.DBRUR:190115

28695694

IMPROVE DNFS RETRY AND BACKOFF IN CASES OF NFS DELAYS/ERRORS

Server Manageability

18.4.1.0.DBRUR:190115	28919145	invalids seen when exec catawrpdbvw.sql
18.3.2.0.DBRUR:190115	28919145	invalids seen when exec catawrpdbvw.sql

 

 

• ‘*’ indicates that an alert exists for that issue.
• ‘+’ indicates a particularly notable issue / bug.

 

• See Note:1944526.1 for details of other symbols used

APPLIES TO:

Oracle Database – Enterprise Edition – Version 18.0.0.0 to 18.0.0.0[Release 18.0]
Information in this document applies to any platform.

Bugs fixed in each 18.0.0.0.0 Grid Infrastructure Release Update

• See Note:854428.1 for information about Patch Set Updates
• See Note:1683799.1 for Support Status and Alerts affecting 12.2.0.1 releases.

All GI RU are packaged with the Database RU. The GI RU patch zip file includes separate sub-directories for clusterware RU and Database RU components. Instructions for applying GI RU are different from instructions for applying the Database RU alone. Please carefully review the GI RU readme before applying any patch.

This document lists the non-security bugs fixed in the Grid Infrastructure component of each 18.0.0.0.0 Grid Infrastructure Release Update (GI RU). The information is specific to Oracle Cloud and on Oracle Exadata Environment.
For details of fixes in the Database portion of the RU please see Document:2245178.1
For details of the RU patches please see Document:2285557.1

GI RU patches are cumulative and so each GI RU includes fixes from all previous GI RU patches for the same Patch Set.

18.0.0.0.0 Grid Infrastructure Release Update Fixes

The table below lists all of the non-security fixes included in the clusterware component of the latest Grid Infrastructure Release Update. Please see Document:2245178.1 for the Database RU contents.

• Bugs are listed by category
• The version column indicates the GI Release Update that a fix was first included in – the fix is included in that RU and all subsequent GI RU versions.
• Some bug numbers are hyperlinked to a Support Bug Description which may give more information on a specific issue
• To see only fixes added in a particular GI PSU version please see the README supplied with the patch .

Oracle Portable ClusterWare

18.5.0.0.OCWRU:190115	25385515	Invalid GIPC attribute messages
	26051615	ASM Diskgroup is Auto Mounts A User Force Dismounted diskgroup
	26754328	CTSS Fails to set Time due to Invalid Argument to settimeofday
	27186837	UEK4: OUI Prereq Fails to Check/Fix limits.d/90-nproc.conf
	27292107	AIX:java.lang.stackoverflowerror when creation of gns client data file
	27297582E	custom defined asm local_listener reverting to default value after cluster restart
	27334569	CRSD’s orarootagent coredump when performing deep check for ora.gns
	27388201E	Date Format Wrong in CVU HTML HealtCheck Report
	27507494	oraagent Constantly Setting REMOTE_LISTENER and Reporting ORA-32022
	27536738	Diskgroups Take Long Time To Become Online When Running “srvctl start asm”
	27664844	clsce_publish_internal() leaks memory
	27712736	srvctl start service -role fails with java NullPointerException
	27872519	12.2 GI Upgrade to 18.1 Fails if OracleBase is Reused
	27899060E	RHP: rhpctl Should Not Allow RAC Owner to Move GI Home under RAC home
	27908559	182RU: Local Mode Move gihome with -revert Can’t Specify Together with -desthome
	27970426	12.2 rootupgrade.sh fails due to CRS-2922 when registering ora.tmpvip_cluster_vip_net2.type
	27989546	When patched node is rebooted, OHASD fails to start.
	28011878	18.3:12201 Upgrade Core Dump [libclntshcore.so.19.1+0xd5c3b] lwsfdsev+0x3eb
	28030440	CRS Downgrade is Changing ASM Flex Cluster Mode to Disabled
	28053462	18.3giru-gh:zdu from 11204 to 183 fail due to service already enabled after dbua
	28071462	Activeversersion not getting set even after rootupgrade.sh completed on all node
	28080005	Incorrect Output when Grid Infrastructure Patching is succeeded with Local Node option
	28097951E	Clusterware shutdown the database instances before RHPHELPER on Oracle Linux 7 machines
	28105136	18c RHP Fails to Move a 11.2.0.4 Database
	28127661	Failed to Find Network Interface through oifcfg While doing Grid Infrastructure Upgrade
	28143609	rhp_sourcepath=null – causing issue on useraction
	28170016P	aix-183-inst: root script fail on remote node because rootpre.sh does not run
	28220651	RHP to have the option to force start database in upgrade mode for datapatch
	28223325	AGENT UPDATE RESULTS IN PARSING ISSUE IN LISTENER.ORA
	28252270	Configuring GRID fails in root.sh after Patching a Software only Home.
	28263822	rhpctl move gihome fails to start crs
	28281248	RHP: rhpctl move database with -node option move database on all nodes
	28287371	PRGH-1113 : Pre-upgrade checks of database <sid> at Oracle home location <ORACLE_HOME>failed
	28295102	RHP move database on standalone node fails with PRGO-1069 internal error
	28347262	Disable pstack collection of CSSD agent by CHM
	28368177	Rapid home provisioning fails to resolve ORACLE_HOME when using REST API. This results in failure to add grid working copy remotely using REST API root ssh equivalence.
	28375138	RHP – QUERY WORKING COPY TAKES TOO LONG
	28393555	TLS with Zero Downtime Update on 12.2 RHPC Fail at srvmhelper copydir with PRCR-1178
	28404050P	AIX: Defunct Processes Spawned by ohasd orarootagent
	28404125	crs-8503 [_znk8cls_agfw3cmd11getresourceev()+11] after skip gns
	28410447	RHP Zero Downtime Upgrade Fails During Precheck with erorr prgo-2351
	28424981	ASMCA Failed in Creating ACFS [DBT-30095] Asm Custer File System Creation
	28427848	GI Upgrade from 12.1/12.2 -> 18.3 hangs and fails in ODA Environment
	28430491E	SRVCTL start java service cannot be set enable after crash down last instance
	28504730	While Moving 12102 GRID using RPHCTL w/ batches failed with PRCC-1000
	28509660	When trying to import a higher (newer) version image from a lower (older) version, it fails indicating it is unable to find the Version object.
	28526389	Provisioning should retry the failed step when the problem is due to intermediate status.
	28535778	Rapid Home Provisioning Add Workingcopy Does Not Check If The Path Contains File
	28544237	OCSSD is Stuck During Patching
	28558622	RUNCLUVFY CORE DUMPS & ERRORS PRVG-11891 : CONNECTIVITY FAILED BETWEEN INTERFACE
	28578962	Patch automation skips post user actions if patching restarted
	28587400	Grid Home Startup Database Fail With LRM-00109 on 181-18.3 gi Patching Since “S” Bit is Lost
	28593407	Hit Many “command not found” Errors in CVU trace logs
	28710722	18.4.0.0.181016giru:oclumond dumpnodeview failed after disable 1 cpu core
	28792815P	AIX 18.4 Fresh Install of GI iin PowerHA Envonment the OUI Failed to Get node_list
	28874529	ASM Fails to Start with clsrsc-117 during Grid Infrastructure Upgrade from 12.1.0.2 to 18c
	28887933	RHP GI Software Only Install Reports PRGO-1277
18.5.0.0.OCWRU:181023	27936173	PRCR-1070 : Failed to check if resource ora.chad is registered
18.4.0.0.OCWRU:181016	26716493	RHP: Import 12.2.0.2 Grid Infrastructure image from 12.2.0.1 RHPS fails with PRKC-1137
	27020218	db instance crash due to volume resource offline during zip
	27162982	RHPCTL Replicate Image Fails with PRGO-2083
	27202669E	RHP Audit ID is not Consistent Sometimes
	27212273E	Top consumers are empty after shrinking CHM repository
	27400210	This fix enables CHM (cluster health monitor) to detect dynamic changes in cpu configuration.
	27404261PE	HAS build – link error: *** invalid ./bin/dockeroracleinit
	27427831	prevent enable of java services during patching with ojvm
	27516078	cluvfy comp healthcheck – reports ethernet jumbo frames failed when MTU is greater than 9000
	27530270	OHASD Fails to Start if Directory /var/tmp/.oracle is Missing
	27535098	Errors PRCT-1402 and PRKC-1137 During Upgrade to 18.1 From 12.2.0.1
	27554304	CRS startup messages are reported as error in system logs
	27555886	Failes to Stop Exportfs in HANFS Configuration
	27561716	Running “rootcrs.sh -postpatch” Identifies ‘first’ Node Incorrectly
	27566153	rhpctl move database with -eval and -ignorewcpatches options fail
	27591035	AFD: ORA_CRS_HOME Instantiation is Incorrectly Reset in AFD Utility Files
	27609795	“rhpctl add workingcopy” fails if directory exists on local node.
	27624923	HAIP Not Failver to Available NIC if the Cable for Current NIC was Unplugged
	27666818	Add db Working Copy on ACFS only Update Inventory on node with ora.rhpserver run
	27704335	RHP nfs mount not preferable in customer and cloud env
	27808734	RHPCTL ZDTupgrade Database Fails with PRGO-1914 Failed to Create an ASM Cluster File System (ACFS) Snapshot
	27833486	During Install or Upgrade CVU Prechecks Fails on OL7 for Release 11.2
	27849995	RHP 11.2 GI (SIHA) provisioning didn’t configure asm
	27871981	“rhpctl move database -node XXXXX” failed with PRGO-1493
	27873967	Start of cssd hit internal error when do zip through RHP
	27880388	OHASD Failed to Start on Single Instance High Availability (SIHA), due to incorrect socket file directory permission
	27883625	Name Change for Daemon from Cross-Domain Protocol to Cross-Cluster Dependency Proxies
	27890657	crsd_oraagent Crash Due to cdpc resource Action Time-Out
	27923324E	PRCG-1036 with cmd rhpctl register workingcopy -h
	27936173	PRCR-1070 : Failed to check if resource ora.chad is registered
	27953102	PDB Services do not always Start Automatically after a Database Role Switcherover in Dataguard.
	27965004	CRSD Constantly Stopping/Restarting CRS-8503
	27972271	Grid Infrastructure java process using high CPU in server which belogs CVU
	27973640	Incorrect Message Upgrading Database Using RHP
	27990479P	Modify diagsnap.pl priority from 20 to 40 on aix
	27991743	RHP: PRGO-1188 failed to add client on RHPS because no GNS configured in RHPS
	28044154	rhpctl upgrade gihome fails due to remnant checkpoint file
	28050201E	PCW stack fails to come up in development setup because of missing oracle-ohasd.service for OL7
	28084656	RHP – Unable to Upgrade GI Home without Credentials
	28090740P	srvctl stop instance -f command failed due to java errors. This prevented OJVM patching out of place rolling mode from working.
	28107405	srvctl stop db instance failed on last node when apply patch out-of-place. Force option required.
	28132317	lnx-18.3-ojvm: instance on last node can be stopped before pujs complete
	28142478	Unable to communicate to 2nd cluster node while running rootupgrade.sh script
	28183055	OJVM: ‘srvctl stop instance’ Waits For PUJS When There Is No Java Service
	28191222P	AIX: RHP Move RAC Database Failed With PRGO-1598
	28204437P	AIX:RHP Move GIHOME Fails With “Could not load module libexpat.so”
	28224602P	AIX: Adding Workingcopy Failed as The Image has Some Invalid Symlink
	28266751*E	Remove pstack for OCSSD and GIPCD in CHM. This bug is alerted in Note:2422509.1
	28455423	During a Clusterware Upgrade the Command ‘srvctl upgrade model’ Fails
	28462215	The Process diagsnap.pl is Restarted Every 2 Minutes
	29170230	12.1.0.2 – CLUVFY COMP HEALTHCHECK REPORTS FAILURE FOR SOLARIS PKGS
18.3.0.0.OCWRU:180717	12816839E	OCR Cache Inconsistency During Delete
	18701017	Memory Leak with osysmond.bin
	22734786	Grid Infrastructure Upgrade to 12c Fails on Last Node
	26299684E	Register and RHP Image Takes a Long Time
	26313403	RHP: RHPC running rhpctl add database with option -dbtype SINGLE fails with error INS-04004
	26527054	Stopping the Clusterware Hangs and Causes CSSDAGENT to Terminate the Node
	26586174E	Rapid Home Provisioning Support to Execute Customer Remote Execution Solutions
	26587652E	12.2.0.1 Single Instance Database Registered with Clusterware Does not Add Entry in oratab
	26647619P	WINDOWS: Grid Infrastructure Installation Fails using French language
	26827699	after upgrade the relocate of RACONE CDB having PDB fails with PRCD-1222 ORA-09925
	26882126E	Remove Unnessesary ‘crsctl check’ Calls when Starting CRS
	26882316	18c Standalone Clusterware Installation Fails if /mnt is not Accessible
	26943660E	Diagsnap should not run pfiles on CRSD
	26996813E	RHP: Support patching of Oracle Restart in 12.2
	27012915	RHP: check for path of sudo binary is being performed on local node instead of the target node
	27032726	RHP Upgrade GI Home Should Add RHPCLIENT Even if Post Upgrade CVU Errors
	27079545	WS2012_122_UD(11204->122): ASM RELATED CHECK FAILED IN PREREQ CHECK STEP
	27080748	CLUVFY -Vote Disk Check Fails After Downgrade
	27092991E	RHPhelper does not allow Pre-defined Drain Timeout
	27106915	OLCUMON dumpnodeview reports error CRS-9125
	27144533	RHP: inventory not getting updated in non-rhps node
	27153755	Failover of a PDB Service was not Performed
	27174948	RHP: rhpctl move database fails with PRGO-1069 after RHPS is upgrade from 12.1
	27177852	CHM: oclumon dumpnodeview fails with CRS-9125 right after end of GI upgrade
	27220610	RHP: DB patching failed with CRS-5051 PRGH-1012 PRCP-1178 with -nonrolling option specified
	27238258P	WINDOWS: OUI Hangs When Add Node with not Enough Disk Space
	27249544E	RHP: Rerun upgrade database not able to start from the point it failed
	27265816P	WINDOWS: After upgrading to 18.1, addnode.bat Fails in prereq Checks
	27267992E	Remove IMCP and PING Requirement for Node Liveness
	27271876	CVU OS group consistency check fails during pre dbinst command execution
	27274143	Process init.ohasd Fails to Start after Machine Panics
	27285557	DSC: Execution of rootupgrade.sh on Member Cluster node fails with CRS-2883 CRS-8503 coredump
	27299455	RHP Option “-revert” fails
	27300007	PDB: Doing DG role switchover the svc resource fails to start with ORA-01155 as services are started prior to pluggable database being opened
	27302415	Plugin MGMTUA: GIMR upgrade fails when GI upgrade is started up from different node where mgmtdb is not running
	27309182	RHP: Incorrect arguments to option addnfs
	27315159E	Optimized CHM local JSON dump
	27320985E	Command “oclumon manage -repos changerepossize” Falsely Reported as Failed
	27334353	ADVM Volume may not Star if Resource ora.proxy_advm is Offline
	27346984	RHP: GI upgrade from 12.1.0.2 to 18.1 when RHPC is configured fails with PRCR-1065
	27358232	CRS Agent waits for 60 seconds before setting listener_networks for GNS to update SCAN names
	27362190P	Internal Fix for Clusterware
	27370933	Perform nonrolling Patching Implicitly on One Node Clusters
	27378959	CLUVFY stage pre check warned with PRVE-10184
	27379846	RHP: UPGRADE OF TDE ENABLED DATABASE USING RHP FAILS WITH ORA-28365
	27379956E	RHP: unable to provide DBUA upgrade other optional args when using RHP
	27399762	CRSD ORAAGENT crashes during upgrade
	27401618	SOLSP-18.1-UD: UPGRADE GI FROM 12.2.0.1 TO 18.1 HIT PRCT-1011 IN EVAL
	27404599	OSYSMOND going Down is not Releasing its Memory Correctly
	27426277	rhpctl move gi with -sourcehome on a managed home causes wc metadata error
	27428790	Failed to Add a Cross-Domain Protocol When Root’s Primary Group is not Root
	27458829	CRS internal code build issue due to regressed Bug 27154833
	27465480	Cluster Node unable to join after reboot
	27475272E	Report Messages “gipcWait failed” Properly
	27481406P	WINDOWS: During Upgrade OUI Complains ‘set acl’s for specified user failed’
	27492916	Upgrading to 18c Reports the Error PRVG-0820, PRVG-2046 and PRVG-2047
	27496806	Database 12.1 Fails to Start if Grid Infrastructure Version is Higher (18.1)
	27503318P	ZLinux: Removal of a VOTEDISK caused node REBOOT on RedHat 6.6 and SLES 12SP1
	27519708PE	AIX: Cluster Health Monitor (CHM) Reports Misleading Metrics on AIX LPARs
	27526362E	preserve target for resource being stopped
	27528204	HAIP is not moving the IP address when the Network Interface Fails on Second node
	27532009	Grid Infrastructure Upgrade Fails Due to Port numbers
	27534289	TARGET of DBs and services is set as OFFLINE if not specified
	27560562	Rapid Home Provisioning Move Multiple Databases, Second one Failed at sqlpatch step
27560735	Exadata Fast Node Death Detection Skipped
27573154	Process OSYSMOND Coredumps at LpxmGERefToText()
27573408	OSYSMOND dumps coredump at crfjson_convert_sample
27577122E	RHP: DATAPATCH FOR ALL DBS RUN ON SAME INSTANCE AFTER MOVE DATABASE
27581484	Rapid Home Provisioning – After Fixing a CVU discovered failure owner/group permissions are incorrect.
27593587	“crsctl query crs activeversion” Fails when Clusterware is Down
27595801P	Linux: CVU reports failure PRVG-11976 on UEK5 since ‘deadline’ scheduler defaults to ‘mq-deadline’
27600706	ASM Listener Creation Failure During OPC Environment Upgrade
27609819	“rhpctl move database” fails with PRCT-1003 when tnsnames.ora has invalid entries
27625010	RHP Repository Update Fails With PRCG-1079
27625050	Rapid Home Provisioning – During GI Upgrade, Config Tools Step Fails due to RHP Repository Space Failure
27654039	Incorrect connect string passed to datapatch on Member Cluster
27657467	Process OHASD ORAROOTAGENT Leaks Memory (Around 800 kb per hour)
27668379	OPC: ASM listener failed to start during Grid Infrastructure upgrade when subnet is empty
27691717	‘rootcrs.sh -prepatch’ Failed to Stop and Unlock Grid Infrastructure Home
27702244	huge trace files with repeat messages like gipcInternalSetAttribute: failed during gipcInternalSetAttribute
27703242	PRCF-1027 : Error while trying to create file
27708711	Failure During Upgrade -eval for RHP Cloned Home
27714373	RHP: Single instance database move to desthome with rhpctl failed in -eval with error PRKH-1009
27725967	chactl fails to import 12.2 models into higher release
27727843	WS2012_191_UD(11204->191): ASM RELATED CHECK FAILED IN PREREQ CHECK STEP
27731346	GNSD Should not Throw Internal Error if CRSD is not Running
27734470E	Improvements for Out-Of-Place Patching
27735534	HAIP fails to Move IP Address
27739957	CLUVFY fails during verifying resolv.conf integrity
27740854	CHA USER MODELS NEED TO BE EXPORTED/IMPORTED IN STANDALONE CLUSTER GI UPGRADE
27747407E	Code improvement for rhphelper
27757979*	Applying a Bundle Patch Incorrectly Reset the AFD (ASM Filter Driver) Configuration file. This bug is alerted in Note 2379442.1
27766679	RHP: rhpctl move database fails to copy password file
27768034	Memory Leak Produced by CVU ORAJAGENT
27778433	RHP Fails to Create Service
27782464PE	Linux: Command to disable and enable the RHPhelper
27786699	18.2:Add node script failed while adding the cluster node after Out Of Place Patching
27801774	cdp: CDPPROXY still online after dismount of diskgroup on DSC node
27811439	RPH – move db fails due to datapatch error on dbvault
27839732	CDPC: crsctl start res ora.diskgroup1.dg.cdpc command returns failed error code
27850736E	Optimize gipcgetpassthrough api()
27862636P	Linux: ASM AFD fails to load after system reboot when run yum update that upgrades to OL7.5
27864737	mgmtca failed during Grid Infrastructure software upgrade from 12.2 to higher version
27865439	RHP: getting MGTCA-1140 during upgrade
27889841	Member Cluster upgrade fails as post_gimr_ugdg.pl needs execution with root privilege
27896388	Grid Infrastrucure upgrade: CHA models need to be imported in srvmhelper
27897639	RHP: Move Database Completes With PRGO-2470 Error
27906509	CVU trace file reports Java NullPointerException at printGlobalAlertLog
27931506	DSC: PRCR-1001 : Resource ora.qosmserver does not exist while applying an RU on 18.3 Application Cluster
27935826	RHP: rhpctl -root execution fails with PRCT-1003 & PRCZ-2103
27941514	rootupgrade.sh failed when upgrading from 11.2 if net2 second network is present
27957892	core dumps in gpnptool/crsct/oifcfg clusterware commands
27978668	CRSD core dump on some nodes during doing zip
27984314	CVU Failed with NullPointerException gettextlength(matcher.java:1283)
27993298E	stage -pre crsinst command now supports software_only flag
28023410	GI rolling upgrade fails with CLSRSC-404
28025398	cluvfy execution fails with error PRCR-1154
28032758	Clluvfy fails with error PRVG-6085 during dbca execution
28039471	GI rootupgrade rerun will fail with CLSCH-2005 if MGMTDB is down
28039953P	CLSRSC-46 CLSRSC-152 error for ‘jlib/jewt4.jar’ during RU (Release Update) patch rollback
28045209	MGMTUA does not return error in case of failure at remote execution
28099592	cluvfy crsinst precheck shows Verifying Network Time Protocol (NTP) …FAILED with empty error code and description
28109698	CVU creates unexpected directories under database home
28146584P	SOLARIS: Upgrade to 18.3 Fails to Identify Installed Patch
28174926	Grid Infrastructure Upgrade to 18c Failed with Errors: PRVG-2044, PRVF-5155 and PRVG-2035
28182503	Rapid Home Provisioning Database Move Operation Fails on Solaris
28204423	Datapatch Fails in 18.3 RU Patching on a Member Cluster
28205874	CLSRSC-408: (Bad argc for has:clsrsc-408)
28239335	WS2012_183_UD(12102->183):OLOGGERD KEEPED RESTARTING AFTER UPGRADE
28240153E	Cluster Verification Utility Trace Files Showing: “syntax error near unexpected token”
28295055P	HP-UX: rootupgrade.sh Failed with ORA-03113 Accessing ASM
28359337	AIX-183-INST:PROVISION 183 ACTIVE GI FAILED IN POSTCONFIG WITH ASMCA FAILED
28362584	SOL-183-CVU: FALSE POSITIVE ON DISKS DURING POST UPGRADE CHECK (BREAK UPGRADE)
28376542	AIX-183-HAIP:HAIP ADDRESS FAILED BACK WHEN INFINIBAND/ETHCHANNEL NIC REMAIN DOWN
18.3.0.0.OCWRU:180417	23698980P	WINDOWS: CRSD oraagent increases its memory consumption
	25709124	Import Oracle Golden Gate Image from ZIP File Fails with Errors PRGH-1004 and PRCT-1414
	25724089	Database Upgrade fail due to datafile on ACFS mount points
	26433972	PRGO-1718 does not report the relevant DB names
	26860285	OHASD Fails To Start With CRS-4124 CRS-4000 If /var/tmp/.oracle Directory Does Not Exist
	27034318P	AIX: ASM fails to start after Upgrade to 18.1
	27040560	RHP Deleting a Node Database Reports PRCD-1120
	27086406	RHP GI Provisioning cannot continue due to a Warning message
	27098733	RHP: RHPCTL MOVE GIHOME HUNG WITH 122010814 RHPC
	27114112	RHP: Fail to add a Working Copy to RHP Client with root umask 0077
	27121566	CLUVFY check for SSA fails with error[INS-13013] for quorum disks in Exadata
	27133637	CRS-9013-Error manage: Invalid data received from the Cluster Logger Service
	27166715P	Solaris: CRS-5050 in Grid Infrastructure alert log every 5 seconds with multiple IPV6 nic configured as private network
	27174938	Error PRGO-1069 querying provisioned 12.1 workingcopies
	27177551P	18.1 Windows: Password File created in local mount instead of dnfs location
	27182006	Auxiliary commands generated by DIAGSNAP spin CPU
	27182064	RHP Incorrect Version of Image Was Created
	27184253	Rapid Home Provisioning – rhprepo Export Fails with PRGR-154 When No Extention is Provided In The -expfile Option
	27204476	RHP: upgrade from 12c to 18.1 with rhpclient failed due to PRCT-1429 PRCG-1093
	27212837	Rootcrs.pl is Not Compatible With Perl 5.26 Following Upgrade of Grid Infrastructure Home
	27213140	RHP: RHPS Useraction With Runscope ONENODE Fails With PRCF-2071
	27222423	CVU fails with PRVG-1512 when period “.” in the interface name was being considered as wild card
	27222938	RHP Add Workingcopy fails due to Permission Denied
	27238077	OHASD Orarootagent memory keeps increasing about 8 MB per day
	27252023E	CHM enhancement to display platform name and enhance disk data statistics for oclumon dumpnodeview -v output
	27257509P	WINDOWS: INS-35433 RAC RDBMS home software install on ACFS fails after GI upgrade to 18.1
	27263677	RHP: add node gihome fails after move gihome showing in-appropriate cluster name as “null”
	27314512P	ORAROOTAGENT prints: ‘sIsIfFailed net0 is FAILED’ every second
	27377219	PRGO-1493 In Oracle Restart When Moving Database Using RHPCTL
	27393421P	HP-UX: During Upgrade to 18.1 a Missing Route Prevents ASM Instance from Starting
	27398223P	WINDOWS: ‘Mgmtca Applysql’ fails with MGTCA-1189
	27399499	Cluvfy Failed to get ASM Discovery String and Did Not Fall Back to Default Discovery String
	27399985P	INS-30515 insufficient space error duirng exdended cluster deployment
	27430219E	RHP Provisioning via REST API Fails when skipCopy Option Used
	27430254	RHP Rest API Unsupported Options Shown in the Error Message
	27433163P	Upgrade to 18.1 hang at GIMR setup prompting Oracle Home user password on Windows environment
	27452897	PRCZ-1010 when executing gridSetup.sh -downgrade
	27481765P	HP-UX: rootupgrade.sh failed with CLSRSC-694 when upgrading to 18.1
	27503413P	HP-UX Itanium: DB/ASM failed to start up with ORA-3113 when upgrading 12c to 18.1
	27508936	tracking bug to backport jbhati_lrg-20793653
	27508984	Spfile uses the wrong seperator on Windows
	27513114P	Solaris: CRS-5050 in alert log every 5 seconds with two IPv6 interfaces
	27574335P	Forward merge bug fix for 27465480
	27579969	Internal Fix
18.2.0.0.OCWRU:180417	23698980P	WINDOWS: CRSD oraagent increases its memory consumption
	23840305	Root script should copy configuration files for patch and move operations
	25709124	Import Oracle Golden Gate Image from ZIP File Fails with Errors PRGH-1004 and PRCT-1414
	25724089	Database Upgrade fail due to datafile on ACFS mount points
	26433972	PRGO-1718 does not report the relevant DB names
	26860285	OHASD Fails To Start With CRS-4124 CRS-4000 If /var/tmp/.oracle Directory Does Not Exist
	27018734	OPC: SCAN listener does not register first instance
	27034318P	AIX: ASM fails to start after Upgrade to 18.1
	27040560	RHP Deleting a Node Database Reports PRCD-1120
	27086406	RHP GI Provisioning cannot continue due to a Warning message
	27098733	RHP: RHPCTL MOVE GIHOME HUNG WITH 122010814 RHPC
	27114112	RHP: Fail to add a Working Copy to RHP Client with root umask 0077
	27121566	CLUVFY check for SSA fails with error[INS-13013] for quorum disks in Exadata
	27133637	CRS-9013-Error manage: Invalid data received from the Cluster Logger Service
	27166715P	Solaris: CRS-5050 in Grid Infrastructure alert log every 5 seconds with multiple IPV6 nic configured as private network
	27174938	Error PRGO-1069 querying provisioned 12.1 workingcopies
	27177551P	18.1 Windows: Password File created in local mount instead of dnfs location
	27182006	Auxiliary commands generated by DIAGSNAP spin CPU
	27182064	RHP Incorrect Version of Image Was Created
	27184253	Rapid Home Provisioning – rhprepo Export Fails with PRGR-154 When No Extention is Provided In The -expfile Option
	27204476	RHP: upgrade from 12c to 18.1 with rhpclient failed due to PRCT-1429 PRCG-1093
	27212837	Rootcrs.pl is Not Compatible With Perl 5.26 Following Upgrade of Grid Infrastructure Home
	27213140	RHP: RHPS Useraction With Runscope ONENODE Fails With PRCF-2071
	27222423	CVU fails with PRVG-1512 when period “.” in the interface name was being considered as wild card
	27222938	RHP Add Workingcopy fails due to Permission Denied
	27238077	OHASD Orarootagent memory keeps increasing about 8 MB per day
	27252023E	CHM enhancement to display platform name and enhance disk data statistics for oclumon dumpnodeview -v output
	27257509P	WINDOWS: INS-35433 RAC RDBMS home software install on ACFS fails after GI upgrade to 18.1
	27263677	RHP: add node gihome fails after move gihome showing in-appropriate cluster name as “null”
	27314512P	ORAROOTAGENT prints: ‘sIsIfFailed net0 is FAILED’ every second
	27377219	PRGO-1493 In Oracle Restart When Moving Database Using RHPCTL
	27393421P	HP-UX: During Upgrade to 18.1 a Missing Route Prevents ASM Instance from Starting
	27398223P	WINDOWS: ‘Mgmtca Applysql’ fails with MGTCA-1189
	27399499	Cluvfy Failed to get ASM Discovery String and Did Not Fall Back to Default Discovery String
	27399985P	INS-30515 insufficient space error duirng exdended cluster deployment
	27403244	A Database Instance is restarted After a Previous Failure
	27430219E	RHP Provisioning via REST API Fails when skipCopy Option Used
	27430254	RHP Rest API Unsupported Options Shown in the Error Message
	27433163P	Upgrade to 18.1 hang at GIMR setup prompting Oracle Home user password on Windows environment
	27452897	PRCZ-1010 when executing gridSetup.sh -downgrade
	27481765P	HP-UX: rootupgrade.sh failed with CLSRSC-694 when upgrading to 18.1
	27503413P	HP-UX Itanium: DB/ASM failed to start up with ORA-3113 when upgrading 12c to 18.1
	27508936	tracking bug to backport jbhati_lrg-20793653
	27508984	Spfile uses the wrong seperator on Windows
	27513114P	Solaris: CRS-5050 in alert log every 5 seconds with two IPv6 interfaces
	27574335P	Forward merge bug fix for 27465480
	27579969	Internal Fix
	27627992	root.sh fails during HAIP startup due to Fatal signal 11 has occurred in program orarootagent thread
	27657920	OPatchauto Rollback Failed due to Stack have not been Started
	27783059	The Permission Of GI_HOME is Not set back to ROOT.
	27786669	Diagsnap is running from old home after Out-of-place patching

 

Oracle Universal Storage Management

18.5.0.0.ACFSRU:190115	27349312	ACFSUTIL log -C Does Not Work
	28012328P	TEST_GENERATOR NEEDS TO RUN ON ALL SRG RUNS
	28058466	acfs 12.2 is slower than acfs 12.1 in exadata environment
	28270298	ACFS Performance Issue due to Excessive fsyncs
	28333396	AFD Failed to Remove Symlinks on uninstall (can appear during upgrade)
	28381121	server crash with oracleoks call stack
18.4.0.0.ACFSRU:181016	25354206	kernel crash during afd excessive logging (stack overflow corruption)
	27298996	ACFSUTIL LOCKSTATS Command Should not be Hidden
	27655018	Port numbers are now logged consistently using host format for improved diagnosability
	27877050	ASM Hangs Stopping the Instance after Applying Patch 27200956 and using AFD (ASM Filter Driver)
	27955239P	AIX: ACFS Causing Memory Swapping
	27962890E	Recursive IOs on Exadata for ACFS/ADVM
	27982730	acfsutil Upgrade Primary with Manual-mode Failed
	28027810	CPU softlock messages when mounting ACFS filesystem
	28031109	Best matched ACFS/ADVM drivers installed automatically if newer kernel or os detected
	28069955P	Retpoline support for RH – ACFS – USM – Spectre
	28111958P	AIX: ACFS-11022 drivers fail to load on AIX systems with more than 255 processors
	28136863	ACFS: TimeofCreation is not Updated on the Disk
	28137677	Create SNAPDB With 3% Free Space Hit Kernel Panic:Fatal Exception
	28142134	Provide Retpoline Compiled Modules for SLES
	28171094P	ACFS Support for Kernel 4.1.12-103
	28242640	BUG: soft lockup – CPU#11 stuck for 22s! [ofsFcbPrCb:14492]
	28376306	Backup on ACFS filesystem Making the Host to Hang / Crash
18.3.0.0.ACFSRU:180717	27016503P	Linux: Grid Home deinstall (or acfsroot uninstall) removes weak-updates directory that was originally created by OS kernel
	27077948E	Add handling of over-subscription for pre-kilosnaps to ACFS fsck (File System Check)
	27131377	When Using ACFS, fsck May Inadvertently Signal Error ACFS-07577
	27192754	ACFS: Memory leak with fsck
	27243810E	ACFS Remote Configuration: Issues Related to ‘advmutil transport’
	27318988E	Kernel Panic in asmDeleteDevice()
	27321575	ACFS failed to stop after Replication is initialized
	27331069	ACFS repl init is failing with ACFS-05236 if security is enabled on primary and standby as a mount point
	27339654	Possible Memory Corruption at KsPlogAddPlogInfoMsg
	27341181E	“acfsutil lockstats” accepts invalid combination of options and invalid values for options
	27472898	ACFS: FSCK gives error ACFS-07565 that snap_clone_id structure has invalid flags value 0x2
	27538461	ACFS induced Kernel Panic or Hang due to Soft Lockup
	27593263PE	LINUX:SLES12 SP3 support for ACFS
	27614272	ACFS: FSCK shows ACFS-07438
	27670484	ASMAFD: asmcmd afd_refresh crashed with core file
	27738679	acfsutil snap info fails with ACFS-03044
	27788520	s55acfssihamount error occurred resulting in server machine boot failure
	27868727	ACFS cannot find another contiguos block to write after snapshot
	27911160	acfsroot uninstall fails due to hard coded /bin/find
	27919283E	ACFS: memory leak discovered in FSCK
18.3.0.0.ACFSRU:180417	26987877	acfs stuck on kswaitevent stuck on mm_struct.mmap_sem
	26990202P	Linux : ORA-00227 Provision failed corrupt block detected in control file with Intel NVMe
	27065091P	oks_conn Process Warning on Both Nodes of the Cluster – Possible Socket Leak
	27101273	read operation hung on frozen ACFS
	27124867	Processes hung in ACFS after a node joins or leaves the cluster
	27163313	Using ACFS on UEK4 fails to start the Database Instance
	27164122	ACFS: compression log flooded acfs log
	27204133	ACFS on Member Cluster is hung after enabling auto-resize
	27212208	ACFS shrink hang when defrag,freeze&thaw,extend&shrink parallel
	27223171	On ODA Creating a Database on ACFS after Upgrade to 12.2.0.1 Fails
	27230645	ACFS Defrag Hang or Run Indefinitely on a Compressed File
	27284286E	ACFS: oks Hang Manager report hung when running shrink
	27307934	ACFS acfsutil repl init primary failed due to can’t start repl daemons
	27331374	ACFS: assert failure while creating db on ACFS with compatible.advm=11.2.0.2 for dg
	27333978E	Improve code on OfsCompareDataExtents_NoMCB
	27339165	acfsutil info storage core dump
	27392256	TGIP: db instance crash due to check acfs resource abort during zip
	27503208P	AIX: DB upgrades to 18.1 fails with ORA-12801 ORA-29913 when on ACFS
	27534651P	SOLARIS: tracking bug for 18.1 for bug 27464880 – M8 – crash 2nd node due to missing Oracka installation
18.2.0.0.ACFSRU:180417	26987877	acfs stuck on kswaitevent stuck on mm_struct.mmap_sem
	26990202P	Linux : ORA-00227 Provision failed corrupt block detected in control file with Intel NVMe
	27065091P	oks_conn Process Warning on Both Nodes of the Cluster – Possible Socket Leak
	27101273	read operation hung on frozen ACFS
	27124867	Processes hung in ACFS after a node joins or leaves the cluster
	27163313	Using ACFS on UEK4 fails to start the Database Instance
	27164122	ACFS: compression log flooded acfs log
	27204133	ACFS on Member Cluster is hung after enabling auto-resize
	27212208	ACFS shrink hang when defrag,freeze&thaw,extend&shrink parallel
	27223171	On ODA Creating a Database on ACFS after Upgrade to 12.2.0.1 Fails
	27230645	ACFS Defrag Hang or Run Indefinitely on a Compressed File
	27284286E	ACFS: oks Hang Manager report hung when running shrink
	27307934	ACFS acfsutil repl init primary failed due to can’t start repl daemons
	27331374	ACFS: assert failure while creating db on ACFS with compatible.advm=11.2.0.2 for dg
	27333978E	Improve code on OfsCompareDataExtents_NoMCB
	27339165	acfsutil info storage core dump
	27392256	TGIP: db instance crash due to check acfs resource abort during zip
	27463879E	tracking bug for recompiling usm drivers with latest gcc
	27503208P	AIX: DB upgrades to 18.1 fails with ORA-12801 ORA-29913 when on ACFS
	27534651P	SOLARIS: tracking bug for 18.1 for bug 27464880 – M8 – crash 2nd node due to missing Oracka installation
	27573409	ACFS: I/O errors experienced when accessing ACFS sparse files affects ODA vm image file after upgrade ODA to 12.2.1.2

 

Miscellaneous Issues

18.3.0.0.DBWLMRU:180717

27701279P

aix-18.1-dbwlm:qos nonconforming data on em dashboard

 

• ‘*’ against a bug indicates that an alert exists for that issue.
• ‘+’ indicates a particularly notable bug.
• ‘P’ indicates a port specific bug.
• ‘E’ indicates an “Enhancement” (as opposed to a bug fix).
• ‘D’ indicates that the bug fix is disabled by default.

 

[Read more…]

prm dul恢复oracle数据库最简模式                                           http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20database%20easiest%20way.mp4
prm dul使用数据搭桥传输Oracle表数据                                       http://zcdn.parnassusdata.com/prm%20dul%20databridge%20transfer%20oracle%20table.mp4
prm dul在损坏数据库使用exportddl导出建表语句、索引、存储过程、函数等代码     http://zcdn.parnassusdata.com/prm%20dul%20export%20ddl%20from%20corrupted%20oracle%20database.mp4
prm dul恢复oracle中被delete的数据                                        http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20deleted%20rows.mp4
prm dul恢复oracle中被truncate的数据                                      http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20truncated%20table.mp4
prm dul用户级别的数据搭桥                                                 http://zcdn.parnassusdata.com/prm%20dul%20schema%20level%20databridge.mp4
prm dul在ASM存储情况下的最简模式                                          http://zcdn.parnassusdata.com/prm%20dul%20easiest%20way%20with%20ASM%20storage.mp4
prm dul恢复oracle中被drop掉的表                                          http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20dropped%20table.mp4
prm dul恢复oracle 12c以后可拔插数据库PDB/CDB中的数据                      http://zcdn.parnassusdata.com/prm%20dul%20work%20with%20oracle%2012c%20pdb%20pluggable%20database%20container%20database.mp4
prm dul恢复被恶意加密的Oracle数据文件                                     http://zcdn.parnassusdata.com/prm%20dul%20recover%20malware%20ransomware%20corrupted%20oracle%20datafile.mp4
prm dul recover oracle database easiest way                             https://youtu.be/mU3uip66DmY
prm dul databridge transfer oracle table                                https://youtu.be/yzvVSBnQ23g
prm dul export ddl from corrupted oracle database                       https://youtu.be/5l2hO5k5-PQ
prm dul recover oracle deleted rows                                     https://youtu.be/hIYutqNcVBI
prm dul recover oracle truncated table                                  https://youtu.be/KGrCi25sD3c
prm dul schema level databridge                                         https://youtu.be/RocbEFlPr3o
prm dul easiest way with ASM storage                                    https://youtu.be/EaMsSaCtje4
prm dul recover oracle dropped table                                    https://youtu.be/mdPGSjDvX6o
prm dul work with oracle 12c pdb pluggable database container database  https://youtu.be/QyDMsdmRfqU
prm dul recover malware/ransomware corrupted oracle datafile            https://youtu.be/jOT6k-KF8Hg
Using ORACLE PRM-DUL recover undelete deleted records/rows from table  https://www.youtube.com/watch?v=EQeClR4sxUM
PRM-DUL untruncate Oracle Tables ,recover truncated oracle table data  https://www.youtube.com/watch?v=p7KQVt0raro
PRM For Oracle Database Schema Level DataBridge Key Feature            https://www.youtube.com/watch?v=XF57QJg89NI
How to recover truncated table without backup in oracle                https://www.youtube.com/watch?v=z02YvkNP040
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group    https://www.youtube.com/watch?v=rum9euHYuzw