11g ocp ocm考证信息

2019/04/12 by Leave a Comment

 

11g ocm 相关博文：

 

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

 

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

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

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

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

 

Filed Under: Oracle

11g ocm 系列视频课程

2019/04/12 by Leave a Comment

11g ocm 系列视频课程

ocm考试介绍1

 

 

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

 

 

 

DG考点介绍

 

 

 

DataGuard_理论部分

 

 

 

11g ocm rac

 

 

 

 

Data Warehouse数据仓库部分

 

 

数据库审计与安全部分

 

 

SPA SQL Performance Analyzer

 

 

11gocm_理论_2（备份恢复）

 

 

 

oracle 11g ocm workshop-a

 

Filed Under: Oracle

Database 18 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2369471.1)

2019/04/12 by Leave a Comment

APPLIES TO:

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

Bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision

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

For details of the RU patches please see Document:2285557.1

18.0.0.0.0 Release Update Fixes

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

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

Advance Queuing

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

Automatic Storage management

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

Buffer Cache Management

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

Enterprise Manager Database Control

18.3.0.0.DBRU:180717 28132287 18.3: OUI HIT INS-20802 REGISTERING GI WITH EM FAILED IN EMCA

Generic

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

High Availability

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

Oracle JVM

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

Oracle Multitenant

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

Oracle Net Services

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

Oracle OLAP

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

Oracle Portable ClusterWare

18.3.0.0.DBRU:180717 27315159E Optimized CHM local JSON dump

Oracle Secure Files

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

Oracle Security

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

Oracle Security Service

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

Oracle Space management

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

Oracle Storage Server Service Layer

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

Oracle Streams

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

Oracle Transaction Management

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

Oracle Utilities

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

Oracle Virtual Operating System Services

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

PL/SQL

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

Patch Automation

18.4.0.0.DBRU:181016 27849825 ERRORS IN DATAPATCH POST ROLLBACK ON 18.2RU FOR OJVM

Server Manageability

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

XML Utilities

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

XML database

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

Miscellaneous Issues

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

 

Generic

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

Oracle Space management

18.4.1.0.190115DBRUR 28673203 new olint warnings

Oracle Streams

18.4.1.0.DBRUR:190115 28369092 ORA-600 [knaspplsqlentry809] reported in rti 21440197

Oracle Virtual Operating System Services

18.4.1.0.DBRUR:190115 28695694 IMPROVE DNFS RETRY AND BACKOFF IN CASES OF NFS DELAYS/ERRORS

Server Manageability

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

 

 

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

 

  • See Note:1944526.1 for details of other symbols used
Filed Under: Oracle

Grid Infrastructure 18 Release Updates and Revisions Bugs Fixed Lists (Doc ID 2384954.1)

2019/04/12 by Leave a Comment

APPLIES TO:

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

Bugs fixed in each 18.0.0.0.0 Grid Infrastructure Release Update

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

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

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

 

Filed Under: Oracle

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

2019/03/10 by Leave a Comment

[Read more…]

Filed Under: Oracle

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

2019/02/20 by Leave a Comment 
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
Filed Under: Oracle

oracle 19c X$MESSAGE

2019/01/24 by Leave a Comment

oracle 19c X$MESSAGE

 

 

SQL> select description , dest from x$messages order by dest;

DESCRIPTION															 DEST
-------------------------------------------------------------------------------------------------------------------- 
run all timeout and interrupt actions for this background
KSB action for X-instance calls 												 *
KSB action for bast checking													 *
generic shutdown background													 *
ksim instance group membership notifier 											 *
KSB action for ksbxic() calls													 *
enter / exit graph test specified wait												 *
Monitor Cleanup 														 *
svr actn for shrd grp reg/dereg 												 *
attach processes to dlm 													 *
init function for LCK1														 *
check for KJCI cross-instance requests												 *
Scumnt mount lock														 *
Poll system events broadcast channel												 *
database close in progress													 *
kfk FD cleanup															 *
Auto BMR message														 ABMR
Auto BMR Listener														 ABMR
ACMS Watchdog Task														 ACMS
ACMS initialization														 ACMS
ASM to slave BG msg														 ARB*
ARCH initialization														 ARC*
Archiver wakeup 														 ARC*
Archiver disconnect														 ARCH
Archiver shutdown														 ARCH
Job Queue Interrupt														 CJQ*
Job Queue Interrupt														 CJQ*
Job Queue Interrupt														 CJQ*
Job Queue Timout														 CJQ*
Shutdown Job Queue Process													 CJQ*
Check for async in-memory job messages												 CJQ0
Check for async messages from other instances											 CJQ0
Coordinator send broadcast timeout												 CJQ0
kcbz update TSE bh														 CKPT
CKPT reuse range call continuation												 CKPT
update recovery-based i/o statistics												 CKPT
Db Checkpt Request check													 CKPT
Db Checkpt Compl check														 CKPT
Get Proxy Lock															 CKPT
read CCID on standby														 CKPT
readable standby CKPT channel													 CKPT
start change tracking in ckpt													 CKPT
hold alert level														 CKPT
Flashback barrier														 CKPT
subscribe/unsubscribe to flashback broadcast channel										 CKPT
Cleanup move operations 													 CKPT
get (XR,4,0) enqueue														 CKPT
release (XR,4,0) enqueue													 CKPT
mira CKPT channel														 CKPT
KKX: drop ncomp dll action													 CKPT
Compile Environment Monitor													 CKPT
get RAC load enq in NULL													 CKPT
kfc CKPT mount disk group													 CKPT
kfc CKPT dismount disk group													 CKPT
kfc CKPT driver 														 CKPT
ASM-DB communication interrupt action												 CKPT
ASM-DB communication timeout action												 CKPT
unlock an extent map														 CKPT
CKPT stat update timeout action 												 CKPT
CKPT reuse call completion action												 CKPT
CKPT reuse range call														 CKPT
CKPT reuse call continuation													 CKPT
CKPT subscribe reuse block range channel											 CKPT
CKPT subscribe object channel													 CKPT
close control file														 CKPT
CPU dynamic reconfiguration													 CKPT
identify control file														 CKPT
change tracking message 													 CTWR
change tracking timeout action													 CTWR
shutdown DBRM															 DBRM
do RM action in DBRM														 DBRM
subscribe to quiesce channel													 DBRM
unsubscribe to quiesce channel													 DBRM
DBRM ADG in-memory state refresh												 DBRM
DBRM Timeout Actions														 DBRM
RM running count check														 DBRM
Check for MDBRM to LDBRM message												 DBRM
Check for LDBRM to MDBRM message												 DBRM
DBRM Active Session Limit Event 												 DBRM
Check queuing policy														 DBRM
SQL Memory Management Calculation												 DBRM
check for quiesce messages													 DBRM
unquiesce the instance during database close											 DBRM
mount/dismount all db files													 DBW*|BW*
get/release open thread enqueue 												 DBW*|BW*
DBWR monitor checkpoint 													 DBW*|BW*
DBWR write buffers														 DBW*|BW*
Refresh Snapshot														 DBW0
sync PDB															 DBW0
Release startup spfile lock													 DBW0
Get startup spfile lock 													 DBW0
kfcb Poke DBW0															 DBW0
kfcb force dismount disk group													 DBW0
kfc mount disk group														 DBW0
kfc dismount disk group 													 DBW0
kfc invalidate file extent													 DBW0
Reserve lock name space lock													 DBW0
Release lock name space lock													 DBW0
complete Release space call													 DBW0
periodic shadow lost write													 DBW0
unit test															 DBW0
close and unlock db file													 DBW0
offline db file 														 DBW0
verify/invalidate all db files													 DBW0
foreign key invalidation													 DBW0
recovery db file verification													 DBW0
DBWO timeout kcbifc														 DBW0
Message to flush IMU txns													 DBW0
Db Instance Lock Mgmt														 DBW0
Db File check															 DBW0
Db mount lock															 DBW0
identify db file														 DBW0
lock db file															 DBW0
acquire enq during pdbopen by HARIM												 DBW0
Process new DBs that join ASM locally												 DIA*
poradebug commands														 DIAG
perform process diagnostic													 DIAG
hanganalyze request														 DIAG
Clusterwise dump request													 DIAG
DMON do critical instance eval and registration 										 DMON
DMON Wakeup															 DMON
DMON Interrupt Routine														 DMON
DMON shutdown															 DMON
DMON Verify Standby shutdown for PM violation											 DMON
DMON Execute Task Message													 DMON
DSKM check for message from master DiskMon											 DSKM
IORM action															 DSKM
DSKM action															 DSKM
DSKM fini															 DSKM
DSKM init															 DSKM
DSKM procures HCA loadavg and computes offloaded write thresh									 DSKM
SAGE CC Action															 DSKM
FSFP Wakeup															 FSFP
FSFP Register Observer Message													 FSFP
FSFP Shutdown Message														 FSFP
Inactive Account Time Job													 GEN0
Heartbeat action for HSM connectivity												 GEN0
Periodic Remove Old Key From Standby												 GEN0
GEN0 Master Check														 GEN0
XStream timeout action														 GEN0
Diskgroup Resource Action													 GEN0
kfk timeout action in GEN0													 GEN0
ASM UFG health check timeout													 GEN0
kill client															 GEN0
initiate block repair														 GEN0
ASM kffil check timeout 													 GEN0
Volume Resource Action														 GEN0
UTS Async Dump															 GEN0
PDB SGA init															 GEN0
PDB close abort 														 GEN0
GWM RAC affinity action 													 GEN0
pdb event stats action														 GEN0
Wait Outlier thresholds 													 GEN0
Process wait outlier														 GEN0
KSU GUID MAC Address update													 GEN0
event nfy timeout action													 GEN0
KSM SGA slaves spawn														 GEN0
UM Background action														 GEN0
Parameter spfile sync														 GEN0
check for parameters from other instances											 GEN0
test kspset() from within bg													 GEN0
Action-Based process Test													 GEN0
Spawn processes on behalf of someone else											 GEN0
Direct NFSv4 RENEW lease operation												 GEN0
DTrace based Kernel IO	Outlier  Processing											 GEN0
Auxilary ipc init gen0 action													 GEN0
Auxilary ipc finish gen0 action 												 GEN0
Auxilary ipc timedout gen0 action												 GEN0
Auxilary ipc intr gen0 action													 GEN0
Auxilary ipc message gen0 action												 GEN0
prespawn init check														 GEN0
prespawn timeout check														 GEN0
prespawn clean check														 GEN0
Start Exadata specific backgrounds												 GEN0
GEN0 willl check for DSKM health												 GEN0
KSVMSVC timeout action														 GEN0
quarantine cdb actions														 GEN0
quarantine per-pdb actions													 GEN0
event nfy timeout action													 GEN0
KSNS background action														 GEN0
check instance runtime														 GEN0
ITM background action														 GEN0
Hang Manager parameters 													 GEN0
SGA memory tuning parameter update - GEN0											 GEN0
kcb L2 cache verify file header 												 GEN0
kcbz background redodump													 GEN0
kcb DW object cooling														 GEN0
kcb Cloud ENCTS check														 GEN0
kcl initiate persistent read mostly												 GEN0
kcl update persistent read mostly info												 GEN0
kcl downconvert object locks													 GEN0
periodic PDB tasks														 GEN0
clear preserved buffers and sessions												 GEN0
BA container GEN0 action													 GEN0
get quiesce enqueue														 GEN0
release quiesce enqueue 													 GEN0
GEN0 Timeout KCQ cleanup													 GEN0
prcoessing object/range redo markers												 GEN0
Prepare flashback log														 GEN0
																 GEN0
Fetch recent RCVID list 													 GEN0
CLI Create All Slave Tasks													 GEN0
CLI Create One Slave Task													 GEN0
MGA CMI background action													 GEN0|IPC0
AWR Raw Metrics Capture 													 GEN1
session param update action													 GEN1
MGA Stat refresh background action												 GEN1
Create vatopa mapping														 GEN1
KSB GEN1 init															 GEN1
ksusehst kill slave														 GEN1
KFFG sync timeout action													 GEN1
pcs timeout action														 GEN1
kspcs Oradism init														 GEN1
kspcs Oradism close														 GEN1
ksusehst record session usage action												 GEN1
ksusehst predict session usage action												 GEN1
session update action														 GEN2
GMON async DB messaging interrupt action											 GMON
GMON async DB messaging timeout action												 GMON
update PST															 GMON
update PST status														 GMON
check PST															 GMON
query PST															 GMON
update PST on reconf														 GMON
PST dismount disk group 													 GMON
set heartbeat sensing														 GMON
sense a heartbeat														 GMON
timeout 															 GMON
refresh 															 GMON
shutdown process														 GMON
Run unit test on all mounted groups												 GMON
emulate i/o errors on a disk													 GMON
Dump PST															 GMON
Global Txn SHUTdown														 GTX*
K2Q Timeout action														 GTX*
free instance lock														 GTX*
convert instance lock														 GTX*
get instance lock														 GTX*
IMCO cycle action														 IMCO
IMCO init															 IMCO
IMCO action															 IMCO
IMCO FastStart Defer Write Scheduler												 IMCO
IMCO Trickle Repopulate 													 IMCO
IMCO global dictionary action													 IMCO
IMCO ADO action 														 IMCO
IMCO worker action														 IMCO
INSV Shutdown Message														 INSV
INSV Receive Message														 INSV
INSV Interrupt															 INSV
KSGL timeout															 IPC0
PMON notify IPC0 of process failure												 IPC0
KSGL node join															 IPC0
KSGL node exit															 IPC0
KSRMA mount															 IPC0
KSRMA Recovery Log Allocation													 IPC0
KSRMA RMA OP															 IPC0
KSWL PMON notify IPC0 of process failure											 IPC0
KTURMA Message action														 IPC0
KSGL mount in IPC0														 IPC0
KSGL initialize service 													 IPC0
MGA CMI background init action													 IPC0
KSIPC MGA Segment Check 													 IPC0
KSIPC finish action														 IPC0
KSIPC Grp Refresh action													 IPC0
KSIPC reconfig action														 IPC0
KSIPC shutdown action														 IPC0
KSIPC msg action														 IPC0
KSIPC interrupt action														 IPC0
KSIPC initialize server 													 IPC0
KSIPC timeout action														 IPC0
KJFM update process heartbeat													 LCK*|DIA*|LGWR|CKPT|DBRM|IPC0|ARC*
kxfp signal recv function													 LCK0
ksim reg/dereg instance group													 LCK0
ksim query instance group													 LCK0
ksim polling interrupt action													 LCK0
ksim get value															 LCK0
ksim cache line update														 LCK0
KSB Rolling Migration interrupt action												 LCK0
KSR Control message service routine												 LCK0
KSXP look for slow sends													 LCK0
Cross-instance broadcast message												 LCK0
KSXR remote instance died													 LCK0
KSXR finialize															 LCK0
Get java patching locks 													 LCK0
Free java patching locks													 LCK0
Check SCN adjust														 LCK0
gc global ckpt timeout														 LCK0
gc policy timeout														 LCK0
gc policy interrupt														 LCK0
kcl stop gcscn bcast														 LCK0
kcl start gcscn bcast														 LCK0
get TS enq for sort segment													 LCK0
release TS enq for sort segment 												 LCK0
sequence bckgrnd instance lock													 LCK0
Get instance lock														 LCK0
Escalate Lock															 LCK0
Get instance lock for recovery													 LCK0
Release instance lock														 LCK0
Recalled lock															 LCK0
kea signal recv function													 LCK0
ksim LCK0 functions														 LCK0
get and hold global enqueue													 LCK0
KQLM interrupt action														 LCK1
KQLM invalidation instance lock operation											 LCK1
kfr Poke LGWR															 LGWR
kfr Incr Ckpt															 LGWR
kfr ACD relocation														 LGWR
kfr Disable Reloc CIC														 LGWR
LGWR Set DCON bit														 LGWR
LGWR failure															 LGWR
LGWR re-eval member locks													 LGWR
Redo writer IO's														 LGWR
Redo writer post action 													 LGWR
Redo writer log switch operations												 LGWR
Redo writer heartbeat														 LGWR
Redo writer generate offline immed marker											 LGWR
Cache all logfiles														 LGWR
Advance RTA boundary														 LGWR
Suspend Redo Gen														 LGWR
Suspend Redo Gen														 LGWR
LGWR initialization														 LGWR
LGWR flush workers														 LGWR
Open/close/mount/dismount thread												 LGWR
readable standby LGWR channel													 LGWR
Standby media recovery info cleanup												 LGWR
Switchover/PDB relocate message channel subscribe										 LGWR
Redo writer quiesce IMC on standby												 LGWR
Redo writer advance query scn on standby											 LGWR
Redo Writer end query scn on standby												 LGWR
action to cleanup mira context													 LGWR
dml_locks = 0 global enforcement												 LGWR
get KTU instance lock														 LGWR
convert KTU instance lock													 LGWR
free KTU instance lock														 LGWR
LGWR to Start DMON														 LGWR
kfr mount disk group														 LGWR
kfr Dismount disk group 													 LGWR
KJBFP PBR writer main														 LMFC
KJBFP increment PRI														 LMFC
Complete deferred initialization of components											 MMAN
Reset advisory pool when advisory turned ON											 MMAN
Handle sga_target deferred request delete											 MMAN
Handle mem_target resize													 MMAN
Handle sga_target resize													 MMAN
SGA deferred allocated granules Initialization											 MMAN
Memory Management														 MMAN
SGA deferred allocated granules move												 MMAN
tune undo retention														 MMNL
Get current scheduling delay													 MMNL
MMNL Periodic MQL Selector													 MMNL
AWR Raw Metrics Capture 													 MMNL
MMNL DB close															 MMNL
ASH Sampler (KEWA)														 MMNL
Sweep PL/SQL incidents														 MMON
Process staged incidents													 MMON
DDE Periodic Dump Scheduler													 MMON
DDE MMON action to schedule async action slaves 										 MMON
Execute GWM MMON task														 MMON
AWR Auto Flush Task														 MMON
AWR PDB Auto Flush Task 													 MMON
AWR UMF Auto Flush Task 													 MMON
AWR Auto Purge Task														 MMON
AWR PDB Auto Purge Task 													 MMON
AWR Auto DBFUS Task														 MMON
AWR Auto CPU USAGE Task 													 MMON
KEWR SlavePool Test MMON Main													 MMON
ASH Emergency Flusher (KEWA)													 MMON
ASH Progressive Flusher (KEWA)													 MMON
Advisor delete expired tasks													 MMON
MMON Initialization action													 MMON
MMON Post-Initialization action 												 MMON
MMON Remote action Listener													 MMON
MMON Local action Listener													 MMON
MMON Completion Callback Dispatcher												 MMON
MMON set edition interrupt action												 MMON
MMON ping action														 MMON
MMON testing action 2														 MMON
MMON testing slave														 MMON
run-once action driver														 MMON
shutdown MMON															 MMON
MMON DB open															 MMON
MMON DB close															 MMON
MMON periodic cleanup														 MMON
MMON Autotask Action														 MMON
metrics monitoring														 MMON
threshold reconciliation													 MMON
threshold reloading														 MMON
ADDM (KEH)															 MMON
sql tuning hard kill defense													 MMON
autotask status check														 MMON
Maintain AWR Baseline Thresholds Task												 MMON
WCR: Record Action Switcher													 MMON
WCR: Record State Check 													 MMON
WCR: Record SharedDir Check													 MMON
WCR: Capture Stats Update													 MMON
WCR: Abort capture on IO error													 MMON
KEC Create directory														 MMON
WCR: Replay Action Switcher													 MMON
WCR: Replay State Check 													 MMON
WCR: Replay Deadlock Detection													 MMON
WCR: Replay Stats Update													 MMON
WCR: Replay Admin Alive Check													 MMON
WCR: Replay Send References													 MMON
WCR: Replay remote clock propagation												 MMON
WCR: Replay remote posts													 MMON
SQL Monitoring Garbage Collector												 MMON
Report Capture Daemon														 MMON
Report Capture Test (KERPI)													 MMON
Real-Time ADDM Trigger														 MMON
Index usage tracking statistics flush												 MMON
Execute on-demand tuning task (KESTS)												 MMON
Check for sync messages from other instances											 MMON
Check for autostart messages from other instances										 MMON
Coordinator autostart timeout													 MMON
Job Autostart action force													 MMON
ADR Auto Purge Task														 MMON
ADR Space Management Statistics Flush												 MMON
ADR PDB Auto Purge Task 													 MMON
Schedule slave to update incident meter 											 MMON
Update KGSTM Translation													 MMON
Update shared pool advice stats 												 MMON
Refresh active service cache													 MMON
reload failed KSPD callbacks													 MMON
reconfiguration MMON action													 MMON
MMON request to purge LTXID history table											 MMON
SGA memory tuning parameter update												 MMON
SGA memory tuning														 MMON
flashcache object keep monitor													 MMON
deferred controlfile autobackup action												 MMON
recovery area alert action													 MMON
Flashback Marker														 MMON
SMON_SCN_TIME Copy to PDBs													 MMON
undo usage															 MMON
UNDO MMON ACTION														 MMON
Block Cleanout Optim, Undo Segment Scan 											 MMON
BCO:																 MMON
Flashback Archive RAC Health Check												 MMON
Flashback Archive RAC action													 MMON
CLI AutoPartition														 MMON
ILM segment access flush													 MMON
ILM row access flush														 MMON
tune undo retention lob 													 MMON
MMON Periodic LOB  MQL Selector 												 MMON
MMON Periodic LOB Spc Analyze													 MMON
tablespace alert monitor													 MMON
ILM check															 MMON
ILM cleanup															 MMON
Column-Level Statistics flush													 MMON
Cleanup of unpinned KGL handles 												 MMON
OLS Cleanup															 MMON
Triton Session Cleanup														 MMON
ASM Audittrail cleanup														 MMON
dblink logon table cleanup													 MMON
Sample Shared Server Activity													 MMON
JAVAVM poll for JIT														 MMON
Shutdown JAVAVM JIT														 MMON
Compute cache stats in background												 MMON
SPM: Auto-purge expired SQL plan baselines											 MMON
SPM: Check SMB size														 MMON
SPM: Delete excess sqllog$ batches												 MMON
flushing workload information for optimizer											 MMON
cleaning up workload information for optimizer											 MMON
light-weight checks for optimizer statistics advisor										 MMON
SQLQ: Auto-purge expired SQL quarantine configurations										 MMON
PQ: Adjust Slave Pool														 MMON
KSXM Advance DML Frequencies													 MMON
KSXM Broadcast DML Frequencies													 MMON
PGA Max Size (QESMM)														 MMON
Cleanup client cache server state in background 										 MMON
MMON TSM Cleanup														 MMON
alert message cleanup														 MMON
alert message purge														 MMON
Network Server shutdown 													 NSS*
Network Server forced														 NSS*
Network Server wakeup														 NSS*
NetSlave Shutdown Message													 NSV*
NetSlave Initialize Message													 NSV*
NetSlave Interrupt Function													 NSV*
NetSlave Wakeup Message 													 NSV*
pmon dtp init															 PMON|CLMN
scrub for timedout processes													 PSP0
measure scheduling delay													 PSP0
KSO initialize PSP0														 PSP0
fork new processes														 PSP0
KSO finalize PSP0														 PSP0
kxfp remote slave spawn recv function												 PXMN
free PX memory chunks in background												 PXMN
periodic PDB tasks														 PXMN
DSKM to master BG msg														 RBAL
register to node local process group												 RBAL
Interrupt Action														 RBAL
Timeout interrupt action													 RBAL
ASM to master BG msg														 RBAL
ASM to BG mesg															 RBAL|GMON
BG load lib msg 														 RBAL|PSP0
distributed recovery shutdown													 RECO
distributed recovery wakeup													 RECO
RMON BG Driver															 RMON
Payload action to BG														 RMON
RMON Init Action														 RMON
shutdown RMON process														 RMON
action for buddy instance													 RMS0
do work for new gpnp instances													 RMS0
action to cleanup buddy instance context											 RMS0
RSM Wakeup															 RSM0
RSM Set Parameter														 RSM0
RSM Interrupt Routine														 RSM0
shut down															 RSMN
main																 RSMN
Test Driver wakeup														 RTTD
RTTD initialization														 RTTD
Open/close flashback thread													 RVWR
RVWR IO's															 RVWR
SMCO Action															 SMCO
SMCO Timout															 SMCO
ASM instance recovery														 SMON
Reliable Test Dummy Call													 TEST
Test managed actions														 TEST
TEST initialization														 TEST
Check TEST initialization complete												 TEST
Initiate KSBCITST														 TEST
Monitor initialization														 TMON
Monitor wakeup															 TMON
TPZ initialization														 TPZ*
Test Process wakeup														 TPZ*
Multi procs per DTP														 UTMU
Action to process msgs from instance processes											 XDMG
Diskgroup timeout actions for Exadata disks auto manage module									 XDMG
Infrequent timeout actions for Exadata disks auto manage module 								 XDMG
Interrupt actions for Exadata disks auto manage module										 XDMG

530 rows selected.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_FULL
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BANNER_LEGACY																			     CON_ID
---------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production													  0
Filed Under: Oracle

prm dul supports all version oracle pluggable database

2019/01/24 by Leave a Comment

prm oracle recovery software supports oracle 12cR1 12cR2 18c 19C PDB CDB Container database pluggable database

Filed Under: Oracle, Oracle数据恢复、数据库恢复、灾难恢复

PRM-SCAN extract datafile from corrupted asm disk group

2019/01/24 by Leave a Comment

PRM-SCAN extract datafile from corrupted asm disk group

let ‘s go !

asmcmd
lsdsk
lsdg

let corrupt the asm disk header by manual

dd if=/dev/zero of=/dev/vdb1 bs=1024k count=10 conv=notrunc

this will write zero to asm header 10M

SQL> alter diskgroup data mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup “DATA” cannot be mounted
ORA-15040: diskgroup is incomplete

fail to mount the corrupted asm disk group

ok

use PRMSCAN to scan the failed asm diskgroup’s disk

this only require read-only permission

it will take long time to scan , up to the disk size

java -jar PRMScan.jar –outputsh o1.sh

this command will output lots of dd command , help you extract datafiles blocks and merge them into datafiles

let see it

some datafiles may need to be ignored , find out your datafiles !!

execute the shell will generate datafiles under your current directory !

if you have multiple db’s system01.dbf store on same diskgroup , you may need to distinguish them by yourself, or you can call parnassusData service

let’s extract data from the datafile using prm !!

prm scan can work on

1. corrupted asm diskgroup ,failed to mount
2. corrupted / formatted filesystem
3. deleted datafile from asm diskgroup
4. deleted datafile from filesystem

filesystem(ntfs,ext 2/3/4,xfs whatever filesystem type)

we provide prm scan as a product (bundle with prm) or a service .

contact us service@parnassusdata.com !!

Filed Under: Oracle, Oracle数据恢复、数据库恢复、灾难恢复

RHEL/CENTOS 7中需要注意的OS设置 会影响ORACLE数据库实例运行

2019/01/06 by Leave a Comment

 

 

 

 

1、 Oracle Linux 7和Redhat Linux 7：/var/tmp/.oracle中的socket文件被删除

Oracle Database – Enterprise Edition – 版本 11.2.0.4 和更高版本
Linux x86-64

症状

Oracle Linux 7和Redhat Linux 7：/var/tmp/.oracle中的socket文件被神秘删除.

更改

无

原因

Oracle Linux 7和Redhat Linux 7都有一个内核服务systemd-tmpfiles-clean.service，由systemd管理并删除临时位置的文件。

上述服务删除：

  1. 在/tmp 中的文件/目录超过10天没有访问的（在tmp.conf中定义）
  2. 在/var/tmp中的文件/目录超过30天没有访问的（在tmp.conf中定义）

通过检查文件/目录的所有atime/mtime/ctime来确定“没有访问”。

 

解决方案

排除套接字文件被内核服务systemd-tmpfiles-clean.service删除

要排除tmp目录中的套接字文件被tempfile clean服务删除，请更改/usr/lib/tmpfiles.d/tmp.conf的内容并添加

x /tmp/.oracle*

x /var/tmp/.oracle*

x /usr/tmp/.oracle*

上面的“x”选项指示systemd-tmpfiles-clean.service排除列出目录中的文件。

注意：目录/var/tmp/.oracle包含许多“特殊”套接字文件，本地客户端使用这些文件通过IPC协议（sqlnet）连接到各种Oracle进程，包括TNS监听器，CSS，CRS和EVM守护进程甚至是数据库或ASM实例。在Clusterware运行时删除套接字文件时  ，会出现Doc ID 391790.1的症状

 

 

 

 

 

ALERT: Setting RemoveIPC=yes on Redhat 7.2 and higher Crashes ASM and Database Instances as Well as Any Application That Uses a Shared Memory Segment (SHM) or Semaphores (SEM) (Doc ID 2081410.1)

 

ontroled by the option RemoveIPC in the /etc/systemd/logind.conf configuration file,
see man logind.conf(5) for details.

The default value for RemoveIPC in RHEL7.2 and higher is yes.

As a result, when the last oracle or grid user disconnects, the OS removes shared memory segments and semaphores for those users.
As Oracle ASM and Databases use shared memory segments for SGA, removing shared memory segments will crash the Oracle ASM and database instances.

Please refer to the Redhat bug 1264533  – https://bugzilla.redhat.com/show_bug.cgi?id=1264533

OCCURRENCE

The problem affects all applications including Oracle Databases that use the shared memory segments and semaphores; thus, both, Oracle ASM and database instances are affected.

Oracle Linux 7.2 avoids this problem by setting RemoveIPC to no explicitly on /etc/systemd/logind.conf configuration file,
but if /etc/systemd/logind.conf is touched or modified before the upgrade started, the yum/update will write the correct/new configuration file (with RemoveIPC=no) as logind.conf.rpmnew,
and if user retains their original configuration file, then most likely the failures described in this note will occur.
To avoid this problem, after the upgrade be sure to edit the logind.conf and set RemoveIPC=no.  This is documented in the Oracle Linux 7.2 release notes.

SYMPTOMS

1) Installing 11.2 and 12c GI/CRS fails, because ASM crashes towards the end of the installation.

2) Upgrading to 11.2 and 12c GI/CRS fails.

3) After Redhat Linux is upgraded to 7.2 and higher, 11.2 and 12c ASM and database instances crash.

 

The removal of the IPC objects by systemd-logind may happen at any time, as such the failure patterns can vary greatly, here are some examples of how failures may look like:

 

Most common error that occurs is that the following is found in the asm or database alert.log:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

 

The second observed error occurs during installation and upgrade when asmca fails with the following error:
KFOD-00313: No ASM instances available. CSS group services were successfully initilized by kgxgncin
KFOD-00105: Could not open pfile ‘init@.ora’

 

The third observed error occurred during installation and upgrade:
Creation of ASM password file failed. Following error occurred: Error in Process: $GRID_HOME/bin/orapwdEnter password for SYS:

OPW-00009: Could not establish connection to Automatic Storage Management instance

2015/11/20 21:38:45 CLSRSC-184: Configuration of ASM failed
2015/11/20 21:38:46 CLSRSC-258: Failed to configure and start ASM

 

The fourth observed error is the following message is found in the /var/log/messages file around the time that asm or database instance crashed:
Nov 20 21:38:43 testc201 kernel: traps: oracle[24861] trap divide error
ip:3896db8 sp:7ffef1de3c40 error:0 in oracle[400000+ef57000]

 

WORKAROUND

1) Set RemoveIPC=no in /etc/systemd/logind.conf

2) Reboot the server or restart systemd-logind as follows:
# systemctl daemon-reload
# systemctl restart systemd-logind

PATCHES

Migrating to Oracle Linux 7.2 and higher from Redhat 7.2 and higher resolves this problem.

If migrating to Oracle Linux 7.2 is not possible, please use the above workaround by setting RemoveIPC=no in /etc/systemd/logind.conf

Filed Under: Oracle

沪ICP备14014813号-2

沪公网安备 31010802001379号