为什么可以恢复这些被加密的ORACLE数据库数据文件？
因为这些文件一般比较大，超过300MB。导致恶意加密软件要加密它们时要花费大量时间和CPU，因此这些勒索软件一般仅部分加密其内容。
通过PRM-DUL的强大功能，可以恢复出其中绝大部分未被加密的内容。
PRM DUL download: https://zcdn.parnassusdata.com/DUL5108.zip
常用软件下载地址
2019/07/07 by Leave a Comment
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
git npm brew yarn 配置proxy
2019/06/14 by Leave a Comment
all export https_proxy=http://127.0.0.1:6152 export http_proxy=http://127.0.0.1:6152 export all_proxy=socks5://127.0.0.1:6153 git npm brew yarn 配置代理 //git列出 git config --global http.proxy //git设置 git config --global http.proxy 'socks5://127.0.0.1:6153' //git取消设置 git config --global --unset http.proxy npm //列出所有配置 npm config ls -l //列出 npm config list //设置 npm config set https-proxy http://127.0.0.1:6152 npm config set proxy http://127.0.0.1:6152 //npm 取消配置 npm config list delete https-proxy npm config set proxy //yarn 列出 yarn config list //yarn 设置 yarn config set proxy http://127.0.0.1:6152 yarn config set https-proxy http://127.0.0.1:6152 //yarn 取消配置 yarn config delete proxy yarn config delete https-proxy //brew 列出 all_proxy=socks5://127.0.0.1:6153 brew install mysql
关于MySQL的doublewrite与Oracle中类似的机制
2019/05/22 by 2 Comments
大致看了下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里面就没人研究能不能关这个了。
19c Automatic Indexing 自动建索引 控制隐藏参数 _optimizer_auto_index_allow _optimizer_use_auto_indexes
2019/05/21 by Leave a Comment
目前 （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
快速部署ORACLE 19C
2019/05/21 by Leave a Comment
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 ocp ocm考证信息
2019/04/12 by Leave a Comment
11g ocm 相关博文：
- Oracle 11g/12c OCM大师考试认证的价格/费用问题 https://www.askmaclean.com/archives/ocm-expense.html
- Oracle 11g OCM Master考试指南汇总 https://www.askmaclean.com/archives/oracle-11g-ocm.html
- Oracle数据库11g ocm认证大师考试信息 https://www.askmaclean.com/archives/oracle-master-exam-11g-ocm.html
- 11g OCM 自评 https://www.askmaclean.com/archives/11g-ocm-%e8%87%aa%e8%af%84.html
- 升级到ORACLE 11G OCM 一些思索 https://www.askmaclean.com/archives/%e5%8d%87%e7%ba%a7%e5%88%b0oracle-11g-ocm-%e4%b8%80%e4%ba%9b%e6%80%9d%e7%b4%a2.html
- 11g OCM目前的考试环境 https://www.askmaclean.com/archives/11g-ocm%e7%9b%ae%e5%89%8d%e7%9a%84%e8%80%83%e8%af%95%e7%8e%af%e5%a2%83.html
- OCM 11g认证升级考前准备 https://www.askmaclean.com/archives/ocm-11g%e8%ae%a4%e8%af%81%e5%8d%87%e7%ba%a7%e8%80%83%e5%89%8d%e5%87%86%e5%a4%87.html
- Oracle 11g OCM考纲复习：数据库备份恢复的配置 https://www.askmaclean.com/archives/11g-ocm-student-guide-backup-restore.html
- 我是如何准备11g OCM考试的 https://www.askmaclean.com/archives/%e6%88%91%e6%98%af%e5%a6%82%e4%bd%95%e5%87%86%e5%a4%8711g-ocm%e8%80%83%e8%af%95%e7%9a%84.html
- Oracle 11g OCM 考试介绍 https://www.askmaclean.com/archives/dbdao-com_oracle-11g-ocm-%e8%80%83%e8%af%95%e4%bb%8b%e7%bb%8d.html
- Oracle 11g OCM考纲Streams单向流复制 https://www.askmaclean.com/archives/11g-ocm-streams.html
- 如何准备Oracle数据库11g OCM认证考试 https://www.askmaclean.com/archives/%e5%a6%82%e4%bd%95%e5%87%86%e5%a4%87oracle%e6%95%b0%e6%8d%ae%e5%ba%9311g-ocm%e8%ae%a4%e8%af%81%e8%80%83%e8%af%95.html
- Oracle认证：经常问到的问题(OCA, OCP, OCE, OCM) https://www.askmaclean.com/archives/oracle%e8%ae%a4%e8%af%81%ef%bc%9a%e7%bb%8f%e5%b8%b8%e9%97%ae%e5%88%b0%e7%9a%84%e9%97%ae%e9%a2%98oca-ocp-oce-ocm.html
- Oracle OCM考试全球日程表 https://www.askmaclean.com/archives/oracle-ocm%e8%80%83%e8%af%95%e5%85%a8%e7%90%83%e6%97%a5%e7%a8%8b%e8%a1%a8.html
- Oracle 11g OCM的通过祝贺信 https://www.askmaclean.com/archives/oracle-11g-ocm%e7%9a%84%e9%80%9a%e8%bf%87%e7%a5%9d%e8%b4%ba%e4%bf%a1.html
- Oracle 11g ocm考试手册 https://www.askmaclean.com/archives/dbdao-com-oracle-11g-ocm%e8%80%83%e8%af%95%e6%89%8b%e5%86%8c.html
11g OCP 考试题库中英分析：
【诗檀学院】Oracle 11g OCP-051考试题库中英文对照详解
【诗檀学院】Oracle 11g OCP-052考试题库中英文对照详解
【诗檀学院】Oracle 11g OCP-053考试题库中英文对照详解
11g ocm 系列视频课程
2019/04/12 by Leave a Comment
11g ocm 系列视频课程
ocm考试介绍1
第二讲：sql性能相关考点脚本
DG考点介绍
DataGuard_理论部分
11g ocm rac
Data Warehouse数据仓库部分
数据库审计与安全部分
SPA SQL Performance Analyzer
11gocm_理论_2（备份恢复）
oracle 11g ocm workshop-a
Database 18 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2369471.1)
2019/04/12 by Leave a Comment
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
Grid Infrastructure 18 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2384954.1)
2019/04/12 by Leave a Comment
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.1GI 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.
