git npm brew yarn 配置proxy



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中类似的机制

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

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考证信息

 

11g ocm 相关博文:

 

数据库恢复的配置 https://www.askmaclean.com/archives/11g-ocm-student-guide-backup-restore.html
配置备份的规范 https://www.askmaclean.com/archives/dbdao-11g-oracle-ocm-2.html
使用RMAN创建备份 https://www.askmaclean.com/archives/oracle-11g-ocm-rman.html
使用RMAN执行恢复 https://www.askmaclean.com/archives/oracle-11g-ocm-master-rman-restore.html
SPA https://www.askmaclean.com/archives/oracle-11g-ocm-spa.html
SQL执行计划管理 https://www.askmaclean.com/archives/oracle-11g-ocm-spm.html
grid control 架构 https://www.askmaclean.com/archives/oracle-11g-ocm-grid-control-architecture.html
grid control 安装 https://www.askmaclean.com/archives/oracle-11g-ocm-grid-control-install.html
配置EMGC https://www.askmaclean.com/archives/oracle-11g-ocm-setemgc.html
Oracle Data Guard 介绍 https://www.askmaclean.com/archives/oracle-11g-ocm-dg.html
使用SQL和RMAN命令来创建一个物理备库 https://www.askmaclean.com/archives/oracle-11g-ocm-create-dg.html
oracle Data Guard Broker:概述 https://www.askmaclean.com/archives/oracle-data-guard-broker.html
配置 DataGuard 保护模式 https://www.askmaclean.com/archives/oracle-11g-ocm-data-mode.html
grid 安装 https://www.askmaclean.com/archives/oracle-11g-install-grid.html
管理Oracle 集群 https://www.askmaclean.com/archives/oracle-11g-ocm-manage-clusterware.html
RAC数据库安装 https://www.askmaclean.com/archives/oracle-11g-ocm-rac-install.html
数据库安全与审计 https://www.askmaclean.com/archives/oracle-11g-ocm-audit.html
物化视图和分区表 https://www.askmaclean.com/archives/oracle-11g-ocm-materializedview.html
并行和传输表空间 https://www.askmaclean.com/archives/oracle-11g-ocm-parallel.html
SQL*Loader和外部表 https://www.askmaclean.com/archives/oracle-11g-ocm-sqlloader.html
手动建库和基本数据库管理 https://www.askmaclean.com/archives/oracle-11g-ocm-createdatabase.html

 

11g OCP 考试题库中英分析:

【诗檀学院】Oracle 11g OCP-051考试题库中英文对照详解

【诗檀学院】Oracle 11g OCP-052考试题库中英文对照详解

【诗檀学院】Oracle 11g OCP-053考试题库中英文对照详解

 

11g ocm 系列视频课程

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)

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)

APPLIES TO:

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

Bugs fixed in each 18.0.0.0.0 Grid Infrastructure Release Update

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

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

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

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

18.0.0.0.0 Grid Infrastructure Release Update Fixes

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

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

Oracle Portable ClusterWare

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

 

Oracle Universal Storage Management

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

 

Miscellaneous Issues

18.3.0.0.DBWLMRU:180717 27701279P aix-18.1-dbwlm:qos nonconforming data on em dashboard

 

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

 

2017年初量子号 釜山 长崎邮轮之旅

[Read more…]

prm dul 恢复oracle数据库视频教程

prm dul恢复oracle数据库最简模式                                           http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20database%20easiest%20way.mp4
prm dul使用数据搭桥传输Oracle表数据                                       http://zcdn.parnassusdata.com/prm%20dul%20databridge%20transfer%20oracle%20table.mp4
prm dul在损坏数据库使用exportddl导出建表语句、索引、存储过程、函数等代码     http://zcdn.parnassusdata.com/prm%20dul%20export%20ddl%20from%20corrupted%20oracle%20database.mp4
prm dul恢复oracle中被delete的数据                                        http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20deleted%20rows.mp4
prm dul恢复oracle中被truncate的数据                                      http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20truncated%20table.mp4
prm dul用户级别的数据搭桥                                                 http://zcdn.parnassusdata.com/prm%20dul%20schema%20level%20databridge.mp4
prm dul在ASM存储情况下的最简模式                                          http://zcdn.parnassusdata.com/prm%20dul%20easiest%20way%20with%20ASM%20storage.mp4
prm dul恢复oracle中被drop掉的表                                          http://zcdn.parnassusdata.com/prm%20dul%20recover%20oracle%20dropped%20table.mp4
prm dul恢复oracle 12c以后可拔插数据库PDB/CDB中的数据                      http://zcdn.parnassusdata.com/prm%20dul%20work%20with%20oracle%2012c%20pdb%20pluggable%20database%20container%20database.mp4
prm dul恢复被恶意加密的Oracle数据文件                                     http://zcdn.parnassusdata.com/prm%20dul%20recover%20malware%20ransomware%20corrupted%20oracle%20datafile.mp4

prm dul recover oracle database easiest way                             https://youtu.be/mU3uip66DmY
prm dul databridge transfer oracle table                                https://youtu.be/yzvVSBnQ23g
prm dul export ddl from corrupted oracle database                       https://youtu.be/5l2hO5k5-PQ
prm dul recover oracle deleted rows                                     https://youtu.be/hIYutqNcVBI
prm dul recover oracle truncated table                                  https://youtu.be/KGrCi25sD3c
prm dul schema level databridge                                         https://youtu.be/RocbEFlPr3o
prm dul easiest way with ASM storage                                    https://youtu.be/EaMsSaCtje4
prm dul recover oracle dropped table                                    https://youtu.be/mdPGSjDvX6o
prm dul work with oracle 12c pdb pluggable database container database  https://youtu.be/QyDMsdmRfqU
prm dul recover malware/ransomware corrupted oracle datafile            https://youtu.be/jOT6k-KF8Hg


Using ORACLE PRM-DUL recover undelete deleted records/rows from table  https://www.youtube.com/watch?v=EQeClR4sxUM
PRM-DUL untruncate Oracle Tables ,recover truncated oracle table data  https://www.youtube.com/watch?v=p7KQVt0raro
PRM For Oracle Database Schema Level DataBridge Key Feature            https://www.youtube.com/watch?v=XF57QJg89NI
How to recover truncated table without backup in oracle                https://www.youtube.com/watch?v=z02YvkNP040
PRM 3.1 For Oracle ASM Extract Datafile From Damaged ASM Disk group    https://www.youtube.com/watch?v=rum9euHYuzw


沪ICP备14014813号

沪公网安备 31010802001379号