11g ocp ocm考证信息

 

11g ocm 相关博文:

 

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

 

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

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

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

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

 

11g ocm 系列视频课程

11g ocm 系列视频课程

ocm考试介绍1

 

 

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

 

 

 

DG考点介绍

 

 

 

DataGuard_理论部分

 

 

 

11g ocm rac

 

 

 

 

Data Warehouse数据仓库部分

 

 

数据库审计与安全部分

 

 

SPA SQL Performance Analyzer

 

 

11gocm_理论_2(备份恢复)

 

 

 

oracle 11g ocm workshop-a

 

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

APPLIES TO:

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

Bugs fixed in each 18.0.0.0.0 Release Update and Release Update Revision

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

For details of the RU patches please see Document:2285557.1

18.0.0.0.0 Release Update Fixes

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

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

Advance Queuing

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

Automatic Storage management

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

Buffer Cache Management

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

Enterprise Manager Database Control

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

Generic

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

High Availability

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

Oracle JVM

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

Oracle Multitenant

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

Oracle Net Services

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

Oracle OLAP

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

Oracle Portable ClusterWare

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

Oracle Secure Files

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

Oracle Security

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

Oracle Security Service

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

Oracle Space management

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

Oracle Storage Server Service Layer

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

Oracle Streams

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

Oracle Transaction Management

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

Oracle Utilities

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

Oracle Virtual Operating System Services

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

PL/SQL

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

Patch Automation

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

Server Manageability

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

XML Utilities

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

XML database

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

Miscellaneous Issues

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

 

Generic

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

Oracle Space management

18.4.1.0.190115DBRUR 28673203 new olint warnings

Oracle Streams

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

Oracle Virtual Operating System Services

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

Server Manageability

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

 

 

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

 

  • See Note:1944526.1 for details of other symbols used

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

APPLIES TO:

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

Bugs fixed in each 18.0.0.0.0 Grid Infrastructure Release Update

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

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

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

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

18.0.0.0.0 Grid Infrastructure Release Update Fixes

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

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

Oracle Portable ClusterWare

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

 

Oracle Universal Storage Management

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

 

Miscellaneous Issues

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

 

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

 

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

[Read more…]

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

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

Oracle 11.2.0.4 LINUX WINDOWS AIX下载

请注意,如果你有support.oracle.com账号,那么严格从官网下载介质。如果实在没有,那么从互联网上下载介质一定要验证SHA1,避免介质被修改。

 

ORACLE 11.2.0.4 Windows 64bit:

链接:https://pan.baidu.com/s/1DtU0rQxEPryxopotN85Icw
提取码:29rx
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_MSWIN-x86-64_1of7.zip 1.2 GB (1327046969 bytes) 
SHA-256 9C6E1235D1B0EE6C36E3F82FEBDC74160BB9766900579FC7EBBFACECD6E8F4B2 
SHA-1 893475AFA9C6758FB14E8269EF05F6D485445F28 
p13390677_112040_MSWIN-x86-64_2of7.zip 1.1 GB (1152431908 bytes) 
SHA-1 6EE067D16F80061B03CFD63603B3F5E454B6152D 
SHA-256 6343B2EA4F47C4E85FD4DC1B5C2EA0B86294E48FAD90DE1820C3F9DF906675F3 
p13390677_112040_MSWIN-x86-64_3of7.zip 735.0 MB (770723774 bytes) 
SHA-256 EC47CFF4D500BD357982C57D9F84F893293A3DBB79A62FC7AE66E2144BEFFF6C 
SHA-1 AA69BD12E01BECBD249C71F8682D75BB2FA003DB 
p13390677_112040_MSWIN-x86-64_4of7.zip 600.7 MB (629885092 bytes) 
SHA-256 10D708F6C3FA12466486BDBB3B1FB235EEEAF1AAB39B67B86C42648F8F49FB33 
SHA-1 821CD458D76672DD10A3C377196C6CE52CBB1BBF 
p13390677_112040_MSWIN-x86-64_5of7.zip 525.6 MB (551173867 bytes) 
SHA-1 E975AA77E4D79B2A22F0F341CBA97EE696B5ADD1 
SHA-256 25FB15F2031C4C82EC09D001023103A9267BC2D34D0F1731E0EBFCDA0495C72E 
p13390677_112040_MSWIN-x86-64_6of7.zip 484.2 MB (507686306 bytes) 
SHA-1 C899797A782DE2A09EC90C57A1117D3490CEAA65 
SHA-256 4A2EF2B9FB3656009320676B2DDFB13A81777B6F2E70ECCA37606637EF796043 
p13390677_112040_MSWIN-x86-64_7of7.zip 108.3 MB (113590540 bytes) 
SHA-1 DCA23E6583527F7ABC19846D1FD51D56DE4C4111 
SHA-256 4BF2626A281C006331846C174790EF63D744C7A0BAC309CAAB48548596476701 

 

 

ORACLE 11.2.0.4 Linux 64bit:

链接:https://pan.baidu.com/s/1uJt7OrgXU-600U7teZKp-Q
提取码:27ud
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_Linux-x86-64_1of7.zip 1.3 GB (1395582860 bytes) 
SHA-256 0B399A6593804C04B4BD65F61E73575341A49F8A273ACABA0DCDA2DFEC4979E0 
SHA-1 983461D6442B0833630475EC4885278588585651 
p13390677_112040_Linux-x86-64_2of7.zip 1.1 GB (1151304589 bytes) 
SHA-1 2E628D8CAC5D1C6FFF15E728B1F227747BF2DED8 
SHA-256 73E04957EE0BF6F3B3E6CFCF659BDF647800FE52A377FB8521BA7E3105CCC8DD 
p13390677_112040_Linux-x86-64_3of7.zip 1.1 GB (1205251894 bytes) 
SHA-1 8C0CD2D7BB2DD73E965A90CD053828D7A52AE7E7 
SHA-256 09C08AD3E1EE03DB1707F01C6221C7E3E75EC295316D0046CC5D82A65C7B928C 
p13390677_112040_Linux-x86-64_4of7.zip 625.6 MB (656026876 bytes) 
SHA-1 1ACF8F785313D3C5CF631A0077416C22348B9DF8 
SHA-256 88B4A4ABB57F7E94941FE21FA99F8481868BADF2E1E0749522BBA53450F880C2 
p13390677_112040_Linux-x86-64_5of7.zip 571.4 MB (599170344 bytes) 
SHA-256 F9C9D077549EFA10689804B3B07E3EFD56C655A4ABA51EC307114B46B8EAFC5F 
SHA-1 8D68764AB38804A9B9C9E80BF5AE0F3D6C397151 
p13390677_112040_Linux-x86-64_6of7.zip 465.7 MB (488372844 bytes) 
SHA-256 B2E08F605D7A4F8ECE2A15636A65C922933C7EF29F7AD8B8F71B23FE1ECBACA8 
SHA-1 79533E2FF40664A4640616BD559903ED616F2633 
p13390677_112040_Linux-x86-64_7of7.zip 114.0 MB (119521122 bytes) 
SHA-256 1CB47B7C0B437D7D25D497ED49719167A9FB8F97A434E93E4663CFA07590E2BA 
SHA-1 B23A8CED6D47664F20C116ABA9A2C77D65B2DD6D 

ORACLE 11.2.0.4 AIX  64bit:

链接:https://pan.baidu.com/s/1kY9AozQGCctxiVLJUcqYfQ
提取码:2322
复制这段内容后打开百度网盘手机App,操作更方便哦

 

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_AIX64-5L_1of7.zip 1.7 GB (1801653734 bytes) 
SHA-256 0F74D947F7B8E7E3B1FB4CCC4CB36506E3D1D2DF68E1526AEB7CCB23798F704F 
SHA-1 6A8A7238A796322C6B6AD584805661BC3C368DD1 
p13390677_112040_AIX64-5L_2of7.zip 1.1 GB (1170882875 bytes) 
SHA-1 AE628A661616887E7BA96A2122FB6C62C9B9B6E0 
SHA-256 BD8AAC4DFAFD84840918CDC655D8328AB96EFE1CEB056F843BC75F11BB7AAEC0 
p13390677_112040_AIX64-5L_3of7.zip 2.0 GB (2127071138 bytes) 
SHA-1 BCEDB9007F768A8701406BFE2465E486AF288D52 
SHA-256 CE95498EB70D264E969C48609E5FD036EFF296994725E35AC8E1458B7C8EE9E0 
p13390677_112040_AIX64-5L_4of7.zip 996.5 MB (1044886145 bytes) 
SHA-256 31DD509123F83D414FF1B299E413EF062E4E6F1B48816156AB78CECAF9EEBC83 
SHA-1 FFD1AE113AD645F7891A9C4EB35BDC4BFCBB0A3A 
p13390677_112040_AIX64-5L_5of7.zip 851.6 MB (892976067 bytes) 
SHA-1 AE89F9F347218A8B5FBEE3BB0279099234E65D1A 
SHA-256 54339444BB29B202AB319AB77F00CBB78DD052D558320139CED9E97EC6ACC0F3 
p13390677_112040_AIX64-5L_6of7.zip 543.3 MB (569688642 bytes) 
SHA-256 E64D165372B17F23F5D756381CAAD3FD057A80EAE0CD786589B91982A6993322 
SHA-1 BA3B3BF26B08ADC7A95B94E4E43044A79113524B 
p13390677_112040_AIX64-5L_7of7.zip 215.4 MB (225860409 bytes) 
SHA-256 5D1364CAB9241B7A71EF286D0E86CAC256878E771E9FDDC8CB1CF0E16FB99EAD 
SHA-1 BA37C387373001DF7F3BDF2725301D45519FC00D 

 

 

 

注意,如果没有特殊要求,没有理由使用32bit版本了!!

 

ORACLE 11.2.0.4 Linux 32bit:

链接:https://pan.baidu.com/s/1IORUFF94mmbbIWnGfsYsng
提取码:aci0
复制这段内容后打开百度网盘手机App,操作更方便哦

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_LINUX_1of7.zip 1.3 GB (1380374377 bytes) 
SHA-1 A525E17F3C62659AC11ACB39A20711972B1EC22E 
SHA-256 A9D644CA07D043DEB363DC76D385212090527F72B27A802E2FD2965299CD2FF8 
p13390677_112040_LINUX_2of7.zip 1.1 GB (1142436991 bytes) 
SHA-256 BA1D4CB4C186FF3DC40B682AF5134EA7B6FE252A415B61EEA0C42F820C7223EC 
SHA-1 5B8FCE0253EB4549F149DCB9BB9B2646F8755ECD 
p13390677_112040_LINUX_3of7.zip 814.3 MB (853856456 bytes) 
SHA-256 BE9435F8BE3724D2404EBF37150F6B61B45D23970A11CCF661521F29D503B3CF 
SHA-1 50CF20E8C25F3CA723B94699392262F12E090FB9 
p13390677_112040_LINUX_4of7.zip 613.5 MB (643298224 bytes) 
SHA-256 C4ACE48647B045D831516DEE3805BA1F9A40A50E357D6AE5D8E8D141A91410BF 
SHA-1 7657A2DE446D8F016DDC9CE985948F22A66F61F7 
p13390677_112040_LINUX_5of7.zip 560.2 MB (587370432 bytes) 
SHA-256 5BB47B213C8D239133C8E147A6601C4E0EE45C0D6CAD842042F1168640870FA0 
SHA-1 B2F6DF0624DE740B3684383F3CDE25E4D7741F7C 
p13390677_112040_LINUX_6of7.zip 465.1 MB (487722197 bytes) 
SHA-1 FC8E0AC37CED34F0270D36AB4DFF994E2FB3E4BA 
SHA-256 3BAA0F29DA8E1D1E6D70CE6CD4659CD7E0F60F3ADD0C142FEACE816BD0E5F756 
p13390677_112040_LINUX_7of7.zip 113.3 MB (118788536 bytes) 
SHA-1 8E556FC5A5A624CDBA5EF05A47EC10BE607172E9 
SHA-256 5C99E47D01AE4379A63F9DA7BA5F03BCFEF0BD1F80E0C2D4D4142184BB0060C4 

 

 

ORACLE 11.2.0.4 WINDOWS 32bit:

链接:https://pan.baidu.com/s/1mtVVX7cVfFuYRqD8qjbVng
提取码:b3mj
复制这段内容后打开百度网盘手机App,操作更方便哦

11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset)
p13390677_112040_WINNT_1of6.zip 1.2 GB (1303780058 bytes) 
SHA-256 1F1CBB0FCD230CD4E78162A652B2777430B622EA39DE74AD2D67F8E5046DE5A0 
SHA-1 6A0BEB102E2326DE6C0EEB84818FC89AEA1F6518 
p13390677_112040_WINNT_2of6.zip 1.1 GB (1137477960 bytes) 
SHA-256 D12BD4C070A094154FCBDB34F05A7EC0FA7D45B69F6BC7FF0B2DEFEECE1E0873 
SHA-1 821D0B636D4055138CD9B3D4FCA1BA521EA3009B 
p13390677_112040_WINNT_3of6.zip 578.6 MB (606695219 bytes) 
SHA-1 D47447F5FFA46C524B09A635071D3684DC96DA52 
SHA-256 90AAD65DEBFB36A72EF9F515707A0353E38F4ED0F441AFA795D25D82273DCDFE 
p13390677_112040_WINNT_4of6.zip 504.4 MB (528911211 bytes) 
SHA-256 A36FBB370C3A6718611033FDD048BF1155559A9725AFB8D7D5ADD6265EEE0362 
SHA-1 F5C153542F4322B90A92AC47A4EEB732055E0FEA 
p13390677_112040_WINNT_5of6.zip 475.4 MB (498466574 bytes) 
SHA-1 A6F25F4DC426CED3F53C38E584AC2705FD516138 
SHA-256 36ED3410E296F53656ABA6E0FE4BAB69A8059488B5751F9BFD8D2F7F4BDE10A2 
p13390677_112040_WINNT_6of6.zip 105.0 MB (110100340 bytes) 
SHA-1 0A8046C4970B0AAFBFA9A77905EC81B04021F93A 
SHA-256 06093886948C9F7EA33B4E4A73CB7115EBA5B05E924F3A4C2B44B84C74ECB06D 

 

12C 中,发生脑裂时,节点保留策略 (Doc ID 2047632.1)

适用于:

Oracle Database – Enterprise Edition – 版本 12.1.0.2 和更高版本
Oracle Database Cloud Schema Service – 版本 N/A 和更高版本
Oracle Database Exadata Cloud Machine – 版本 N/A 和更高版本
Oracle Database Exadata Express Cloud Service – 版本 N/A 和更高版本
Oracle Cloud Infrastructure – Database Service – 版本 N/A 和更高版本
本文档所含信息适用于所有平台

用途

理解 12.1.0.2 开始,脑裂问题发生后,节点保留策略。

详细信息

在 11.2 及早期版本,在脑裂发生时,节点号小的会保留下来。然而从 12.1.0.2 开始,引入节点权重的概念。从 12.1.0.2 开始,解决脑裂时,权重高的节点将会存活下来。

2014-11-24 14:25:41.140603 : CSSD:1117321536: clssnmrCheckNodeWeight: node(1) has weight stamp(0), pebble(0)
2014-11-24 14:25:41.140609 : CSSD:1117321536: clssnmrCheckNodeWeight: node(2) has weight stamp(311972654), pebble(3)
2014-11-24 14:25:41.140612 : CSSD:1117321536: clssnmrCheckNodeWeight: stamp(311972654), completed(1/2)
2014-11-24 14:25:41.140615 : CSSD:1117321536: clssnmrCheckSplit: Waiting for node weights, stamp(311972654)
2014-11-24 14:25:41.188880 : CSSD:1084811584: clssnmvDiskKillCheck: not evicted, file /dev/raw/raw2 flags 0x00000000, kill block unique 0, my unique 1416805718
2014-11-24 14:25:41.558921 : CSSD:1114167616: clssnmvDiskPing: Writing with status 0x3, timestamp 1416810341/1022717334
2014-11-24 14:25:41.731912 : CSSD:1086388544: clssnmvDHBValidateNCopy: node 1, node1, has a disk HB, but no network HB, DHB has rcfg 311972655, wrtcnt, 9527468, LATS 102 2717514, lastSeqNo 9527467, uniqueness 1416808381, timestamp 1416810341/1022722074
2014-11-24 14:25:41.731928 : CSSD:1086388544: clssnmvReadDskHeartbeat: manual shutdown of nodename node1, nodenum 1 epoch 1416810341 msec 1022722074
2014-11-24 14:25:41.732266 : CSSD:1117321536: clssnmrCheckNodeWeight: node(2) has weight stamp(311972654), pebble(3)
2014-11-24 14:25:41.732273 : CSSD:1117321536: clssnmrCheckNodeWeight: stamp(311972654), completed(1/1)
2014-11-24 14:25:41.732294 : CSSD:1117321536: clssnmCheckDskInfo: My cohort: 2
2014-11-24 14:25:41.732299 : CSSD:1117321536: clssnmRemove: Start
2014-11-24 14:25:41.732306 : CSSD:1117321536: (:CSSNM00007:)clssnmrRemoveNode: Evicting node 1, node1, from the cluster in incarnation 311972655, node birth incarnation 311972654, death incarnation 311972655, stateflags 0x225000 uniqueness value 1416808381 The number of the resource executing on each node and others are considered by the weight. Reference

 

 

11g:调度程序维护任务或 Autotasks (Doc ID 1526120.1)

适用于:

Oracle Database Cloud Schema Service – 版本 N/A 和更高版本
Oracle Database Exadata Express Cloud Service – 版本 N/A 和更高版本
Oracle Database Exadata Cloud Machine – 版本 N/A 和更高版本
Oracle Cloud Infrastructure – Database Service – 版本 N/A 和更高版本
Oracle Database Backup Service – 版本 N/A 和更高版本
本文档所含信息适用于所有平台

用途

本文档提供了关于自动维护任务或 AUTOTASK 作业的更多信息,这些作业是 11g 系统自动生成的新设置。

本文档介绍了 10g 和 11g 之间关于维护任务的一些主要差异。

适用范围

本文档与 Oracle 11g 相关,目标受众是 Oracle DBA 和支持分析人员。

详细信息

 

Introduction

Oracle 11g 数据库有三个预定义自动维护任务:

Automatic Optimizer Statistics Collection(自动优化器统计信息收集)

收集数据库中所有无统计信息或仅有过时统计信息的 Schema 对象的 Optimizer(优化器)统计信息。SQL query optimizer(SQL 查询优化器)使用此任务收集的统计信息提高 SQL 执行的性能。

Automatic Segment Advisor(自动段指导)

识别有可用回收空间的段,并提出如何消除这些段中的碎片的建议。您也可以手动运行 Segment Advisor 获取更多最新建议,或获取 Automatic Segment Advisor 没有检查到的那些有可能做空间回收的段的建议。

Automatic SQL Tuning Advisor(自动 SQL 优化指导)

检查高负载 SQL 语句的性能,并提出如何优化这些语句的建议。您可以配置此指导,自动应用建议的SQL profile。

Note 466920.1 – 11g New Feature: Health Monitor

Note 755838.1 – New 11g Default Jobs

 

实施

它们在 Oracle10g 中为独立作业,且在 DBA_SCHEDULER_JOBS.JOB_NAME 中可见。

这在 Oracle11g 中有所更改。相关视图为 DBA_AUTOTASK_WINDOW_CLIENTS。
现在,这些作业只有当被真正执行时,才在 DBA_SCHEDULER_JOBS 中可见,且名称为系统生成的名称。

SQL> desc DBA_AUTOTASK_WINDOW_CLIENTS
Name                                      Null?    Type
—————————————– ——– —————————-
WINDOW_NAME                               NOT NULL VARCHAR2(30)
WINDOW_NEXT_TIME                                   TIMESTAMP(6) WITH TIME ZONE
WINDOW_ACTIVE                                      VARCHAR2(5)
AUTOTASK_STATUS                                    VARCHAR2(8)
OPTIMIZER_STATS                                    VARCHAR2(8)
SEGMENT_ADVISOR                                    VARCHAR2(8)
SQL_TUNE_ADVISOR                                   VARCHAR2(8)
HEALTH_MONITOR                                     VARCHAR2(8)

select * from DBA_AUTOTASK_WINDOW_CLIENTS;

WINDOW_NAME
——————————
WINDOW_NEXT_TIME
—————————————————————————
WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M
—– ——– ——– ——– ——– ——–
MONDAY_WINDOW
08-DEC-08 10.00.00.000000 PM EUROPE/VIENNA
FALSE ENABLED ENABLED ENABLED ENABLED DISABLED

SUNDAY_WINDOW
07-DEC-08 06.00.00.000000 AM EUROPE/VIENNA
FALSE ENABLED ENABLED ENABLED ENABLED DISABLED
7 rows selected.

要启用或禁用所有窗口的所有自动维护任务,在不使用任何参数的情况下调用 ENABLE 或 DISABLE 程序。

SQL> execute DBMS_AUTO_TASK_ADMIN.DISABLE;

要禁用特定维护任务,使用 DISABLE 程序,如下所示:

SQL> BEGIN
dbms_auto_task_admin.disable(
client_name => ‘sql tuning advisor’,
operation => NULL,
window_name => NULL);
END;
/

要再次启用该特定维护任务,使用 ENABLE 程序,如下所示:

SQL> BEGIN
dbms_auto_task_admin.enable(
client_name => ‘sql tuning advisor’,
operation => NULL,
window_name => NULL);
END;
/

client_name 参数使用的任务名称列在 DBA_AUTOTASK_CLIENT 数据库字典视图中。

示例:

auto optimizer stats collection
auto space advisor
sql tuning advisor

另一个差异是预定义调度程序窗口:

  •   Oracle10g : WEEKNIGHT_WINDOW and WEEKEND_WINDOW
  •   Oracle11g : MONDAY_WINDOW …. SUNDAY_WINDOW.

为了向下兼容,WEEKNIGHT_WINDOW 和 WEEKEND_WINDOW 仍然存在。

窗口打开持续的时间在 11g 中有所更改。星期一到星期五从晚上 10 点到凌晨 2 点,星期六到星期日从上午 6 点到凌晨 2 点。

您可以使用 DBMS_SCHEDULER.SET_ATTRIBUTE 程序调整预定义维护窗口时间,使其适用于您的数据库环境。
示例:以下脚本将 WEEKNIGHT_WINDOW 改为每个工作日从午夜至上午 8 点(窗口持续时间为 8 小时不变):
EXECUTE DBMS_SCHEDULER.SET_ATTRIBUTE(
‘WEEKNIGHT_WINDOW’,
‘repeat_interval’,
‘freq=daily;byday=MON, TUE, WED, THU, FRI;byhour=0;byminute=0;bysecond=0’);

每个窗口还有一个名为 DEFAULT_MAINTENANCE_PLAN 的预定义资源计划,一旦打开相关窗口,该计划将激活。这是 10g 和 11g 之间的另一个差异。


SQL> select window_name, resource_plan from dba_scheduler_windows;

WINDOW_NAME                    RESOURCE_PLAN
—————————— ——————————
MONDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
TUESDAY_WINDOW                 DEFAULT_MAINTENANCE_PLAN
WEDNESDAY_WINDOW               DEFAULT_MAINTENANCE_PLAN
THURSDAY_WINDOW                DEFAULT_MAINTENANCE_PLAN
FRIDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
SATURDAY_WINDOW                DEFAULT_MAINTENANCE_PLAN
SUNDAY_WINDOW                  DEFAULT_MAINTENANCE_PLAN
WEEKNIGHT_WINDOW
WEEKEND_WINDOW

9 rows selected.

SQL> select * from dba_rsrc_plans where plan=’DEFAULT_MAINTENANCE_PLAN’
PLAN_ID PLAN NUM_PLAN_DIRECTIVES
———- —————————— ——————-
CPU_METHOD MGMT_METHOD
—————————— ——————————
ACTIVE_SESS_POOL_MTH PARALLEL_DEGREE_LIMIT_MTH
—————————— ——————————
QUEUEING_MTH SUB
—————————— —
COMMENTS
——————————————————————————–
STATUS MAN
—————————— —
11187 DEFAULT_MAINTENANCE_PLAN 4
EMPHASIS EMPHASIS
ACTIVE_SESS_POOL_ABSOLUTE PARALLEL_DEGREE_LIMIT_ABSOLUTE
FIFO_TIMEOUT NO
Default plan for maintenance windows that prioritizes SYS_GROUP operations and a
llocates the remaining 5% to diagnostic operations and 25% to automated maintena
nce operations.
YES
SQL> select * from DBA_RSRC_PLAN_DIRECTIVES where plan=’DEFAULT_MAINTENANCE_PLAN’;

PLAN GROUP_OR_SUBPLAN TYPE
—————————— —————————— ————–
CPU_P1 CPU_P2 CPU_P3 CPU_P4 CPU_P5 CPU_P6 CPU_P7
———- ———- ———- ———- ———- ———- ———-
CPU_P8 MGMT_P1 MGMT_P2 MGMT_P3 MGMT_P4 MGMT_P5 MGMT_P6
———- ———- ———- ———- ———- ———- ———-
MGMT_P7 MGMT_P8 ACTIVE_SESS_POOL_P1 QUEUEING_P1 PARALLEL_DEGREE_LIMIT_P1
———- ———- ——————- ———– ————————
SWITCH_GROUP SWITC SWITCH_TIME SWITCH_IO_MEGABYTES
—————————— —– ———– ——————-
SWITCH_IO_REQS SWITC MAX_EST_EXEC_TIME UNDO_POOL MAX_IDLE_TIME
————– —– —————– ———- ————-
MAX_IDLE_BLOCKER_TIME SWITCH_TIME_IN_CALL
——————— ——————-
COMMENTS
——————————————————————————–
STATUS MAN
—————————— —
DEFAULT_MAINTENANCE_PLAN SYS_GROUP CONSUMER_GROUP
100 0 0 0 0 0 0
0 100 0 0 0 0 0
0 0
FALSE
FALSE

Directive for system operations
NO

DEFAULT_MAINTENANCE_PLAN OTHER_GROUPS CONSUMER_GROUP
0 70 0 0 0 0 0
0 0 70 0 0 0 0
0 0
FALSE
FALSE

Directive for all other operations
NO

DEFAULT_MAINTENANCE_PLAN ORA$AUTOTASK_SUB_PLAN PLAN
0 25 0 0 0 0 0
0 0 25 0 0 0 0
0 0
FALSE
FALSE

Directive for automated maintenance tasks
NO

DEFAULT_MAINTENANCE_PLAN ORA$DIAGNOSTICS CONSUMER_GROUP
0 5 0 0 0 0 0
0 0 5 0 0 0 0
0 0
FALSE
FALSE

Directive for automated diagnostic tasks
NO

10g 与 11g 之间变化的摘要:

主题 10g 11g
作业 在 DBA_SCHEDULER_JOBS 中独立作业 AUTOTASKS 有命名前缀“ORA$AT”,且只有作业执行后才可见
维护窗口 2 个窗口:WEEKNIGHT 和 WEEKEND 每天有不同的窗口
Resource manager 默认不启用 每个窗口都有预定义资源计划

相关视图:

DBA_AUTOTASK_CLIENT
DBA_AUTOTASK_CLIENT_HISTORY
DBA_AUTOTASK_CLIENT_JOB
DBA_AUTOTASK_JOB_HISTORY
DBA_AUTOTASK_OPERATION
DBA_AUTOTASK_SCHEDULE
DBA_AUTOTASK_TASK
DBA_AUTOTASK_WINDOW_CLIENTS
DBA_AUTOTASK_WINDOW_HISTORY

如何选择或更改数据库字符集 (NLS_CHARACTERSET) (Doc ID 1525394.1)

适用于:

Oracle Database – Enterprise Edition – 版本 8.1.7.4 和更高版本
Oracle Database – Standard Edition – 版本 8.1.7.4 和更高版本
本文档所含信息适用于所有平台

用途

本文章概述了更改数据库字符集或在具有不同 NLS_CHARACTERSET 的数据库之间导出/导入前进行检查的方法。

当前的 NLS_CHARACTERSET 在 NLS_DATABASE_PARAMETERS 中可以看到。

conn / as sysdba
select value from NLS_DATABASE_PARAMETERS where parameter=’NLS_CHARACTERSET’;

NLS_CHARACTERSET(“字符集”)定义了“普通”的 CHAR, VARCHAR2, LONG 以及 CLOB 字段的编码。

NLS_NCHAR_CHARACTERSET(“国家字符集”)定义了 NCHAR, NVARCHAR2 以及 NCLOB 字段的编码。从 9i 以后都是 Unicode 编码。如果没有使用 NCHAR, NVARCHAR2 以及 NCLOB 字段,那么 NLS_NCHAR_CHARACTERSET 的设置不会被使用或者说不相关。详见 Note 276914.1 The National Character Set in Oracle 9i , 10g and 11g

要更改 Oracle Application 数据库的 NLS_CHARACTERSET请参阅 Note 124721.1 Migrating an Applications Installation to a New Character Set.
这是 Oracle Application 唯一支持的方法。如果您有任何疑问,请开一个 Oracle Applications SR 以寻求帮助。

适用范围

尝试更改 NLS_CHARACTERSET 的所有用户。

现在仍然有数据库管理员尝试通过修改 props$ 来更改 NLS_CHARACTERSET NLS_NCHAR_CHARACTERSET。我们不支持使用这种方法因为这将会损坏您的数据库。这是破坏整个数据集的最直接方式之一。如果您已经做了这个操作,那么第一件事就是从备份中完全恢复数据库.如果没有做任何备份,那么Oracle Support 可以尝试帮助您进行恢复 Oracle 不能保证可以恢复数据也不能保证恢复后的数据完全正确。我们会要求您执行完全导出操作,并重新建立整个数据库。

 
切勿更新 props$

详细信息

 

A) 数据库字符集 (NLS_CHARACTERSET)

Oracle 数据库的 NLS_CHARACTERSET 定义了数据库中哪些字符可以存储在 CHARVARCHAR2LONG  CLOB 数据类型中。字符集不定义语言而是定义字符的特定范围。任何语言只要它使用包含在该字符集中的字符即可存储在数据库中。

需要注意的是 NLS_LANGUAGE 和 NLS_TERRITORY 同数据库是否有能力存储某种字符没有任何关系。
一个使用 NLS_CHARACTERSET 为 WE8MSWIN1252 并且 NLS_LANGUAGE/NLS_TERRITORYJAPANESE 为 JAPAN 的数据库是不能存储日文的,因为 WE8MSWIN1252 中不包含日文字符的定义。
一个使用 NLS_CHARACTERSET 为 AL32UTF8 并且 NLS_LANGUAGE/NLS_TERRITORY 为 AMERICAN AMERICA 的数据库能存储日文 (或者从某种意义上说任何世界上其它的语言).

如果您准备修改数据库的字符集,并且当前使用的某些字符在新的字符集中没有定义,或者当前字符集的设置是不正确的,那么在字符集修改之后就可能发生数据丢失。
在更改字符集前应始终使用 Character Set Scanner (Csscan) 检查是否存在这种情况。
使用导出/导入操作或 Expdp/Impdp 时也一样。

Note 458122.1 Installing and Configuring Csscan in 8i and 9i (Database Character Set Scanner)
Note 745809.1 Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner)
Note 444701.1 Csscan output explained

切勿在字符数据类型(CHARVARCHAR2LONGCLOB)中存储二进制(加密)数据。
如果将二进制数据作为 CHARVARCHAR2LONG  CLOB 数据类型存储/处理,则可能会丢失数据,特别是在使用 AL32UTF8 数据库时(即使没有使用导出/导入操作)。或者,可能会出现 ORA-29275 ORA-600 [kole_t2u], [34] 等错误。

请参阅 Note 1297507.1 Problems with (Importing) Encrypted Data After Character Set Change Using Other NLS_CHARACTERSET Database or Upgrading the (client) Oracle Version

 

B) 选择新数据库字符集

对于大多数客户,Unicode 字符集 (AL32UTF8) 是最好的选择。
使用AL32UTF8字符集的数据库,你可以存储/查询世界上所有的语言
请参阅 Note 333489.1 Choosing a database character set means choosing Unicode 以及 Note 1051824.6 What languages are supported in an Unicode (UTF8/AL32UTF8) database?

需要注意的是,在选择 Unicode(AL32UTF8) 数据库前,您需要确认应用程序是否支持。这个不是 Oracle 技术支持能检查或确认的。

请检查对应的应用程序文档,或咨询应用程序提供商及支持团队,以确认应用程序同 AL32UTF8 或 UTF8 的认证关系。我们强烈建议这么做。

不需要特意安装Unicode或其它字符集,因为所有Oracle的字符集包括Unicode,都已经默认安装了.

您不能将 AL16UTF16 作为 NLS_CHARACTERSET,AL16UTF16 只能作为 NLS_NCHAR_CHARACTERSET,请参阅 Note:276914.1 The National Character Set in Oracle 9i 10g and 11g
人们经常会有一个错误的认识,认为简单的使用NCHAR, NVARCHAR2 和 NCLOB就可以让应用程序变得Unicode化,并且比改变NLS_CHARACTERSET花费的工作更少.
但是一般的N-类型在编程语言以及应用的角度上的支持是很差的.为了使用N-类型,应用程序需要显式的支持.
所以Oracle一般建议使用NLS_CHARACTERSET, CHAR, VARCHAR2 , LONG 和 CLOB 这样的数据类型,而不是N-类型的数据类型.

对于非 Unicode 字符集,最佳选择是 xx8MSWIN125x 字符集,即使数据库自身在 Unix 平台上运行。原因很简单:大多数客户端都是基于 Windows 系统的,因此最适合数据库的非 Unicode 字符集是可以存储这些客户端能够识别的所有字符的字符集,即 xx8MSWIN125x 字符集:

EE8MSWIN1250 , CL8MSWIN1251, WE8MSWIN1252, EL8MSWIN1253 ,TR8MSWIN1254, IW8MSWIN1255, AR8MSWIN1256, BLT8MSWIN1257。

对于亚洲语言推荐的字符集是 VN8MSWIN1258, TH8TISASCII, JA16SJIS , KO16MSWIN949, ZHS16GBK, ZHT16MSWIN950 , ZHT16HKSCS31。

详细讨论,请参阅 Note 264294.1 Choosing from WE8ISO8859P1, WE8ISO8859P15 or WE8MSWIN1252 as db character set.

如果想知道哪些语言可以存储在大多数常用字符集中,请参阅 Note 62421.1 Which Character Set Supports Which Language

如果想知道特定字符集中包含哪些字符,请参阅 Note 282336.1 Charts of most current mono-byte Character sets
或者使用 Locale Builder 打开 Oracle 字符集定义,请参阅 Note 223706.1 Using Locale Builder to view the definition of character sets

这里有一个非常优秀的外部资源: http://www.eki.ee/letter/. 在该网站中选择某个语言后,它将显示包含此语言所需的全部字母的所有字符集概览。
请注意,Oracle 不保证该网站中的信息完全正确。

* 对数据库(RDBMS)的升级是不会改变 NLS_CHARACTERSET 的,所以将数据库从 9i 或 10g 升级到 11g 或 12c 后 NLS_CHARACTERSET 还会是原来的值。

* 如果您计划将数据库从一个不推荐的8位字符集(比如US7ASCII 或 WE8ISO8859P1),改为一个推荐的8位字符集(比如WE8MSWIN1252),请参见 C3 中提供的步骤。在没有对源数据库运行 csscan 前,不要尝试做 export 和 import!

 

从版本 11g 开始,DBCA 默认提供“推荐”字符集列表用作 NLS_CHARACTERSET,出于上述相同的原因,列表中不包含类似于 WE8ISO8859P1 的字符集。请注意,Oracle仍然对这些字符集提供支持,并且根据需要,也可以使用“非推荐”字符集。有关更多信息,请参阅 Note 306411.1 Character Set Consolidation for Oracle Database 11g以及如下文档的”Locale Data” , “Character Sets”部分
11.2. : http://docs.oracle.com/cd/E11882_01/server.112/e10729/applocaledata.htm#NLSPG585 
12.1: http://docs.oracle.com/database/121/NLSPG/applocaledata.htm#NLSPG584 

如果在 11g 中必需使用 DBCA 中的一个“非推荐”字符集(如 US7ASCII 或 WE8ISO8859P1)创建数据库,则在 11g DBCA 的步骤 9(共 11 个)”Character Sets”选项卡中,钩掉”show recommended character sets only”,然后选择”Choose from the list of character sets”。

在 12c 的 DBCA 中,选择” create a database”,在第2步中选择”advanced mode”,第10步在”Character Sets”选项卡中,钩掉”show recommended character sets only”,然后选择”Choose from the list of character sets”,之后就可以选择不推荐的字符集(比如 US7ASCII 或 WE8ISO8859P1)作为数据库的字符集(NLS_CHARACTERSET)。

 

 

关于 ORA-xxxx 错误的语言问题,请参照文档 Note 985974.1 Changing the Language of RDBMS (Error) Messages

 

C) 在8i, 9i, 10g 和 11g 中更改数据库字符集。

请注意,如果一开始就更改数据库字符集,很有可能*无法*解决显示问题。
因此,请先检查是否可以使用 SQLdeveloper 存储/检索数据,这款工具是无需进行 NLS 配置的“好客户端”。
note 1628060.1 How to diagnose losing characters , getting “funny” output when inserting or selecting other than A-Z,a-z data ( = non English data like Chinese, Russian, Hebrew , insert any language here to the list that is not English) CHAR, VARCHAR2, LONG or CLOB

需要注意的是重建 control 文件不会改变 NLS_CHARACTERSET。CREATE CONTROLFILE DATABASE … RESETLOGS ….CHARACTER SET <NLS_CHARACTERSET> 中的字符集(从 ALTER DATABASE BACKUP CONTROLFILE TO TRACE..得到的)需要同数据库的 NLS_CHARACTERSET 一致。

要确保数据库中没有使用字符集相关的数据类型(CHAR, VARCHAR2, LONG, CLOB)来存储二进制的文件(pdf , doc, docx, jpeg, png等文件)或者加密的数据(passwords).
如果二进制文件(如PDF , doc, docx, jpeg, png等)或者加密的数据(passwords)存成了CHAR, VARCHAR2, LONG 或 CLOB ,那么就很可能会发生数据的丢失,尤其当使用AL32UTF8的数据库的时候(就算没有使用exp/imp)
或者像ORA-29275 或 ORA-600 [kole_t2u], [34]这样的错误就会发生.
唯一支持存储二进制数据或加密的数据的数据类型是LONG RAW 或者 BLOB.
如果你想把二进制数据或加密的数据存储在CHAR, VARCHAR2, LONG or CLOB数据类型里,那么它们在application端必须被转换成”characterset safe”的形式,比如base64.
Note 1297507.1 Problems with (Importing) Encrypted Data After Character Set Change Using Other NLS_CHARACTERSET Database or Upgrading the (client) Oracle Version

 

 

C1) 运行 Oracle Application (EBS) 或 PeopleSoft 系统的 数据库字符集转换

请参见文档: Note 124721.1 Migrating an Applications Installation to a New Character Set.

这是唯一的 Oracle applications 提供支持的方法。如果您有任何疑问请创建一个 Oracle Applications 的 SR 以寻求协助。

对于一个Oracle PeopleSoft的数据库,请参照文档note 703689.1 Converting PeopleSoft Systems to Unicode Databases
如果您有任何疑问请创建一个 Oracle PeopleSoft 的 SR 以寻求协助。

 

C2) 在8i, 9i, 10g 和 11g 中使用“export/import”操作(在 10g 及更高版本中使用Datapump操作)。

您只需导出当前的数据库,然后使用新字符集新建一个数据库,并将数据导入到该数据库中。Export/import (原来的 exp/imp tools 或者 expdp/impdp) 适用于原字符集中的字符在新字符集中都有定义(但它们可能有不同的编码)。

需要注意的是您要存储的字符仍需在原字符集中有正确的定义。

很多时候这个条件都是无法满足的,所以需要通过对源数据库使用 csscan检测这些错误,因此在使用 exp/imp 时,我们建议始终用 Csscan 检测是否存在问题。

数据丢失(字符在 export/import 之后变成 ? 或者 ¿ )在 export/import 的过程中是不会报错的。

请务必参阅 C3) 或尽早使用 csscan 来避免问题的发生。

如果 csscan 报告有可能发生数据丢失,那么不要使用 export/import

如果要在现有数据库之间导出/导入特定的用户或表,且其中一个数据库是 UTF8 或 AL32UTF8 数据库,则请参阅:Note 1297961.1 ORA-01401 / ORA-12899 While Importing Data In An AL32UTF8 / UTF8 (Unicode) Or Other Multibyte NLS_CHARACTERSET Database.

在所有 10g 版本(包括 10.1.0.5 和 10.2.0.3)和 11.1.0.6 中,使用数据抽取时,将 8 位字符集更改为 UTF8 / AL32UTF8 或其他多字节字符集可能会损坏数据。除非已应用 Patch 5874989 ,否则 Impdp 可能会损坏数据。
“旧”的导出/导入功能可以正常工作。10.2.0.4 和 11.1.0.7 补丁集中已修正此问题。

以下链接中包括了此故障的所有现有补丁集:https://updates.oracle.com/download/5874989.html

对于 Windows,修正程序包括在
10.1.0.5.0 Patch 20 (10.1.0.5.20P) 或更高版本中 ( Note 276548.1 )
10.2.0.3.0 Patch 11 (10.2.0.3.11P) 或更高版本中 ( Note 342443.1 )

从技术角度看,只需要在 impdp 端应用补丁集,但是如果您在不同的字符集之间使用 expdp/impdp,我们建议您对所有系统应用补丁集。

注意对于 Transportable tablespaces 的局限: note 297396.1  The Character Set Check Performed When Plugging In a Transportable Tablespace 或者文档 http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#i1007233

 

C3) 组合使用 ALTER DATABASE CHARACTER SET(8i、9i)/ CSALTER(10g 和 11g)与 “export/import” 操作

在大多数情况下 Csscan 会指出有些数据需要转换为新的字符集(“Convertible”数据),而方法 c2 又会占用太多时间。
在这些情况下,通常可以混合使用 export/import 和 ALTER DATABASE CHARACTER SET(8i、9i)/ CSALTER(10g 和 11g):

a) 导出 Csscan 列出的表中的“Convertible”数据(即代码在当前字符集和新字符集之间会发生转换的字符)
b) truncate 或 drop 掉这些表。
c) 再次运行 csscan,以确保所有数据现已准备好直接移到新字符集中,如果确实已准备就绪,则使用 ALTER DATABASE CHARACTERSET(8i、9i)/CSALTER(10g 和 11g)命令更改数据库的字符集。
d)由于字符集现已更改,我们只需导入在步骤 (a) 导出的数据。导入操作将转换该数据,并使用该新字符集的正确字符代码进行存储。

在 8i、9i、10g 和 11g 中的 8 位字符集之间执行字符集转换的分步指南 。

下面这些文章会指导您完成一些常用的转换操作,其中介绍了如何将上述“组合方法”(如果需要)付诸实践以及如何进行额外的校验:

从 US7ASCII 更改为 WE8MSWIN1252 或从其他 xxIOS8859Pxx 更改为 xx8MSWIN12xx 字符集
Note 555823.1 Changing from US7ASCII or WE8ISO8859P1 to WE8MSWIN1252 in 8i, 9i, 10g and 11g
Note 1213683.1 Changing from US7ASCII or WE8ISO8859P1 or IW8ISO8859P8 to IW8MSWIN1255 in 8i, 9i, 10g and 11g
Note 260022.1 Changing From US7ASCII or WE8ISO8859P1 or AR8ISO8859P6 to AR8MSWIN1256 in 8i, 9i, 10g and 11g
Note 261871.1 Changing EL8ISO8859P7 to EL8MSWIN1253 in 8i, 9i, 10g and 11g
Note 263119.1 Changing EE8ISO8859P2 to EE8MSWIN1250 in 8i, 9i, 10g and 11g
Note 266309.1 Changing WE8ISO8859P9 to WE8ISO8859P1/WE8MSWIN1252 in 8i, 9i, 10g and 11g
Note 246008.1 Changing WE8ISO8859P15 to WE8MSWIN1252 in 8i, 9i, 10g and 11g

其他组合:

Note 1104893.1 Changing US7ASCII TO WE8ISO8859P1 in 8i, 9i, 10g and 11g
Note 1963942.1 Changing WE8DEC to WE8ISO8859P1, WE8ISO8859P15 or WE8MSWIN1252 in 8i, 9i, 10g and 11g
Note 257722.1 Changing WE8ISO8859P1 to WE8ISO8859P15 in 8i, 9i, 10g and 11g
Note 261639.1 Changing WE8MSWIN1252 to WE8ISO8859P15 in 8i, 9i, 10g and 11g
Note 273281.1 Changing WE8ISO8859P15 TO WE8ISO8859P1 in 8i, 9i, 10g and 11g

如果要转换成  ZHS16GBK, ZHT16MSWIN950, ZHT16HKSCS, ZHT16HKSCS31,KO16MSWIN949, JA16SJIS 这样的字符集,步骤同文档 Note:260192.1 Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) 是一样的。

我们强烈推荐使用 AL32UTF8 做数据库的 NLS_CHARACTERSET。使用上边的字符集没有什么额外的价值。

基本上 AL32UTF8 是大势所趋,AL32UTF8 支持所有其它字符集定义的字符。

 

C4) 在 8i、9i、10g 和 11g 中将字符集转换为 Unicode (UTF8/AL32UTF8) 的分步指南(包括导出/导入操作)

人们经常会有一个错误的认识,认为简单的使用NCHAR, NVARCHAR2 和 NCLOB就可以让应用程序变得Unicode化,并且比改变NLS_CHARACTERSET花费的工作更少.
However N-types are rather poorly supported in (other vendor) programming languages and on application level in general.
但是一般的N-类型在编程语言以及应用的角度上的支持是很差的.为了使用N-类型,应用程序需要显式的支持.
所以Oracle一般建议使用NLS_CHARACTERSET, CHAR, VARCHAR2 , LONG 和 CLOB 这样的数据类型,而不是N-类型的数据类型.

转换到 Unicode ( AL32UTF8 or UTF8 NLS_CHARACTERSET) 可以:

根据文档 Note 260192.1 Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode), 里边也包括了如何使用 csscan 的步骤。

  • 或者使用部分 export/import 加 csscan / csalter 将现有的数据库转换掉。
  • 或者使用全库 export/import 迁移到一个新的 AL32UTF8 数据库。

或者使用 DMU 工具将现有数据库转换成 AL32UTF8 ,参见 Note 1272374.1 The Database Migration Assistant for Unicode (DMU) Tool
DMU 支持11.2.0.3 及之后版本的数据库以及某些选定的旧版本/平台的组合。
建议在使用 DMU 转换前阅读文档 Note 1272374.1 以及 note 1522722.1 Known Issues With The Database Migration Assistant for Unicode (DMU) Tool version 1.2 (current version)

究竟使用 csscan 加 csalter及部分 export/import,还是使用 DMU 工具,或者使用全库 export/import 我们没有特别的推荐。

一般来说 DMU 工具

  • 对用户更友好
  • 在转换一个已存在的数据库时,转换过程不需要 export/import
  • 如果有很多数据需要修正那么它更简单(通常发生在 US7ASCII 或 WE8ISO8895P1 的数据库上)
  • 如果需要操作的数据量比较少那么它比csscan/csalter/部分 export/import 快。

一般来说 csscan 加 csalter 以及部分 export/import ( = 按Note 260192.1的所有步骤操作)

  • 喜欢用脚本的人更倾向于使用
  • 过去就知道或者使用过
  • 如果操作的数据量比较打那么它比 DMU 工具快。

一般来说如果迁移到新的机器那么通常先使用csscan转换,之后使用全库 export/import。 (检查文档 Note 260192.1 的前六步和第12步)

  • 导入一个新的AL32UTF8数据库 (如果是迁移到新的机器上)
  • 导入到同一台机器的另一个新建的AL32UTF8数据库中 (这样的步骤最少,如果可以容忍停机时间的话)

这三种方式最终的成果是一样的,都是转换成 AL32UTF8。
我们也无法知道究竟哪种方法更快,只能通过测试才能知道。

最好先阅读 Note 788156.1 AL32UTF8 / UTF8 (Unicode) Database Character Set Implications,特别是 “c) the Client side”, 关于 NLS_LANG 通常有很多误解。

将 NLS_CHARACTERSET 从 UTF8 改为 AL32UTF8 (或者从 AL32UTF8 到 UTF8) 可以通过 Note 260192.1 Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) in 8i, 9i, 10g and 11g. 来实现。

 

C5) Physical / Logical Standby 数据库如何操作?

如果配置中涉及到 Logical Standby 数据库,那么在修改了主库字符集后 Logcial Standby 数据库必须重建。其它修改 logical standby 数据库的字符集的方式我们都不支持。

Logical standby 数据库需要同主库有相同的 NLS_CHARACTERSET,而且如果说先修改 Logical Standby 的字符集,之后的 SQL apply 也不会成功。

对于版本低于11.1.0.7的 Physical Standy 数据库,备库也需要重建。

对于11.1.0.7 之后的 Physical Standbys 不需要重建, 详见 Note 1124165.1 Changing Primary Database Character Set without Recreating Data Guard Physical Standbys

 

C6) 如何将数据库从 AL32UTF8/UTF8 改回另外的字符集?

如果您已经有了一个 AL32UTF8 或者 UTF8 但是后来发现应用程序不支持 AL32UTF8 或者 UTF8,那么您可以通过  note 1283764.1 Changing the NLS_CHARACTERSET From AL32UTF8 / UTF8 (Unicode) to another NLS_CHARACTERSET in 8i, 9i, 10g and 11g 将 NLS_CHARACTERSET 改为另外一个。
注意在很多情况下这会造成数据丢失。

 

D) 在 Oracle 12c 中将数据库字符集修改为 Unicode(UTF8/AL32UTF8)

对于将已经存在的数据库字符集迁移至AL32UTF8 (以及已经废弃的 UTF8),在 12c 中我们提供了工具 Database Migration Assistant for Unicode (DMU)。
DMU 工具是唯一的下一代的用来将字符集迁移至 Unicode 的工具。
DMU 提供的交互界面能极大的简化迁移的步骤并且不需要 DBA 有太多的字符集移植经验,同时它还自动完成了很多移植过程需要的操作。
详见文档 Note 1272374.1 The Database Migration Assistant for Unicode (DMU) Tool.
从 Oracle database 12c开始,迁移 NLS_CHARACTERSET 只能使用工具DMU:Note 1418321.1 CSSCAN and CSALTER To Be Desupported after DB 11.2.

 

E) 12c Multitenant Container Databases (CDB) 和 Pluggable Databases (PDB) 中字符集的限制:

如何把一个字符集不同的pdb插入到CDB中,请参照请参照
note 1968706.1 ORA-65116/65119: incompatible database/national character set ( Character set mismatch: PDB character set CDB character set )
或者

参见如下文档 Oracle® Database Globalization Support Guide 12c Release 1 (12.1) , 2 Choosing a Character Set , Choosing a Database Character Set for a Multitenant Container Database
http://docs.oracle.com/cd/E16655_01/server.121/e17750/ch2charset.htm#NLSPG1035

DMU工具是唯一一个可以用来把pdb从非Unicode转换成Unicode的工具,参照文档note 1272374.1 The Database Migration Assistant for Unicode (DMU) Tool / 13) How to convert non-Unicode PDB’s to Unicode PDB’s?

 

F) 其他阅读材料

更改 Oracle Application 数据库的字符集时,还有一些其他注意事项,有关这些事项的完整概述,请参阅以下文章:Note 124721.1 Migrating an Applications Installation to a New Character Set

客户端配置:

Note 788156.1 AL32UTF8 / UTF8 (Unicode) Database Character Set Implications / point “c) the Client side”,
Note 158577.1 NLS_LANG Explained (How does Client-Server Character Conversion Work?)
Note 179133.1 The correct NLS_LANG in a Windows Environment
Note 264157.1 The correct NLS_LANG on Unix Environments
Note 229786.1 NLS_LANG and webservers explained.

有关调试指南的详细信息,请参阅 Note 788931.1 Troubleshooting RDBMS (client and server) NLS Problems (Charactersets, sorts, dates, ..)

Note that NLS_LANGUAGE and NLS_TERRITORY have nothing to do with the ability to *store* characters in a database.
A database using WE8MSWIN1252 NLS_CHARACTERSET and JAPANESE JAPAN as NLS_LANGUAGE and NLS_TERRITORY will *not* allow you to store Japanese as WE8MSWIN1252 doesn’t define Japanese characters.
A database using AL32UTF8 NLS_CHARACTERSET and AMERICAN AMERICA as NLS_LANGUAGE and NLS_TERRITORY *will* allow you to store Japanese (or any other language in the world for that matter).

沪ICP备14014813号

沪公网安备 31010802001379号