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

putty                                        https://zcdn.askmaclean.com/putty.exe
teamviewer 14                        https://zcdn.askmaclean.com/tv14.exe
xmanager 4                              https://zcdn.askmaclean.com/Xme4.exe
xmanager 6                             https://zcdn.askmaclean.com/Xme6.exe
cmder                                         https://zcdn.askmaclean.com/cmder.zip
sqldeveloper                             https://zcdn.askmaclean.com/sqldeveloper-19.1.0.094.2042-no-jre.zip
chrome win                                https://zcdn.askmaclean.com/chrome-win.zip

bbed linux                              https://zcdn.askmaclean.com/linux%20bbed.zip

bbed windows                          https://zcdn.askmaclean.com/9ibbedfull.zip

everything                          https://zcdn.askmaclean.com/Everything.exe

notepad++                        https://zcdn.askmaclean.com/npp.7.3.1.Installer.exe

touch.exe                                https://zcdn.askmaclean.com/touch.exe

winscp                                  https://zcdn.askmaclean.com/winscp564setup.exe

vncviewer                         https://zcdn.askmaclean.com/vncviewer.exe

 

PRM DUL  https://zcdn.parnassusdata.com/DUL5108.zip

 

 

 

JDK

 

JDK 1.8 DOWNLOAD URL:
AIX JAVA SDK: http://zcdn.parnassusdata.com/Java8_64.sdk.8.0.0.527.tar.gz
AIX JRE: http://zcdn.parnassusdata.com/Java8_64.jre.8.0.0.527.tar.gz
LINUX X86: http://zcdn.parnassusdata.com/jdk-8u201-linux-i586.rpm
LIUNX X86-64: http://zcdn.parnassusdata.com/jdk-8u91-linux-x64.rpm
Windows X86: http://zcdn.parnassusdata.com/jdk-8u201-windows-i586.exe
Windows X86-64: http://zcdn.parnassusdata.com/jdk-8u181-windows-x64.exe
HPUX Itanium: http://zcdn.parnassusdata.com/Itanium_JDK_8.0.16_December_2018_Z7550-63506_java8_18016_ia.depot
squirrel-sql-3.9.0: http://zcdn.parnassusdata.com/squirrel-sql-3.9.0-standard.jar
db-derby-10.14.2.0: http://zcdn.parnassusdata.com/db-derby-10.14.2.0-bin.zip
Derby IJ Connection setting:
Windows:
C:\> set DERBY_INSTALL=C:\Apache\db-derby-10.14.2.0-bin
C:\> set CLASSPATH=%DERBY_INSTALL%\lib\derby.jar;%DERBY_INSTALL%\lib\derbytools.jar;.
C:\> cd %DERBY_INSTALL%\bin
C:\Apache\db-derby-10.14.2.0-bin\bin> setEmbeddedCP.bat
LINUX/UNIX
$ export DERBY_INSTALL=/opt/Apache/db-derby-10.14.2.0-bin
$ export CLASSPATH=$DERBY_INSTALL/lib/derby.jar:$DERBY_INSTALL/lib/derbytools.jar:.
$ cd $DERBY_INSTALL/bin
$ . setEmbeddedCP
java org.apache.derby.tools.sysinfo
java org.apache.derby.tools.ij
connect 'jdbc:derby:\dbinfo\parnassus_dbinfo_DB_20190127144050';
show schemas;
show tables;
clash for windows:   https://zcdn.askmaclean.com/Clash.for.Windows-0.6.0-win.zip
surge :              https://zcdn.askmaclean.com/Surge-latest.zip
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
prmscan oracle数据块重组恢复解决方案                                         http://zcdn.parnassusdata.com/prmscan.mp4

大致看了下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