X

Archived Database Upgrade Blog

Flaws and Pitfalls

Flaws and Pitfalls

Speed up Upgrade Phase 65 with a new catuposb.sql

Credits to Chris Smids from Proximus in Belgium :-) Thanks, Chris!!! Upgrade to Oracle 12.1.0.2 is slow in phase: #65 ? You are wondering why phase: #65 of the...

Credits to Chris Smids from Proximus in Belgium :-) Thanks, Chris!!! Upgrade to Oracle 12.1.0.2 is slow in phase: #65 ? You are wondering why phase: #65 of the database upgrade to Oracle Database 12.1.0.2 takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a while:  dbms_output.put_line('catuposb, update 4 - rows updated ' || rows_updated);END; -- end of update for system internally generated objs/ The cause for this issue is buried...

Flaws and Pitfalls

Incremental Statistics Collection in Oracle 12.1.0.2 - A True Story

Recently I came across a really interesting customer case in the UK dealing with Incremental Statistics Collection issues in regards to an upgrade to Oracle...

Recently I came across a really interesting customer case in the UK dealing with Incremental Statistics Collection issues in regards to an upgrade to Oracle Database 12.1.0.2. This is the follow-up blog post to:  Incremental Statistics Collection in Oracle 12.1.0.2 - Upgrade Pitfalls (Apr 27. 2016) https://blogs.oracle.com/UPGRADE/entry/incremental_statistics_collection_in_oracle2 A while back I blogged already about Incremental Statistics collection in Oracle Database...

Flaws and Pitfalls

Incremental Statistics Collection in Oracle 12.1.0.2 - Upgrade Pitfalls

A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:  Incremental Statistics Collection Improved in Oracle...

A while back I blogged already about Incremental Statistics collection in Oracle Database 12.1.0.2:  Incremental Statistics Collection Improved in Oracle Database 12c - Nov 13, 2014https://blogs.oracle.com/UPGRADE/entry/incremental_statistics_collection_improved_in. And you'll find more information in our documentation and in posts by our optimizer folks:   Database SQL Tuning Guide 12c:Gathering Incremental Statistics on Partitioned Objects Incremental Statistics Maintenance...

Flaws and Pitfalls

RMAN Catalog Upgrade fails - ORA-02296 - error creating modify_ts_pdbinc_key_not_null

This issue got raised to my via a customer I know for quite a while - all credits go to Andy Kielhorn for digging down into that issue and solving it. , Failed...

This issue got raised to my via a customer I know for quite a while - all credits go to Andy Kielhorn for digging down into that issue and solving it. , Failed RMAN Catalog Upgrade from 11.2.0.4 to 12.1.0.2 The RMAN catalog upgrade: SQL> @?/rdbms/admin/dbmsrmansys.sql $ rman CATALOG rman/xxx@rman01 RMAN> UPGRADE CATALOG;  RMAN> UPGRADE CATALOG; failed with the following sequence of error messages:  error...

Flaws and Pitfalls

Disable Transparent Hugepages on SLES11, RHEL6, RHEL7, OL6, OL7 and UEK2 Kernels

This blog post is not related to database upgrades and migrations. But still I think it is very useful for many customers operating on modern Linux systems....

This blog post is not related to database upgrades and migrations. But still I think it is very useful for many customers operating on modern Linux systems. Recommendation  Support just published an ALERT strongly recommending to disable Transparent Hugepages on Linux systems. And the below information does not apply to RAC systems only but also to single instance environments.. Which Linux Distrubutions/Kernels are affected?  SLES11 RHEL6 and RHEL7 OL6 and OL7 UEK2 Kernels....

Flaws and Pitfalls

GC Freelist Session Waits causing slowness and hangs

One of the best things in my job:I learn from you folks out there. Everyday.  Credits here go to Maciej Tokar who did explain the below topic to me via LinkedIn...

One of the best things in my job:I learn from you folks out there. Everyday.  Credits here go to Maciej Tokar who did explain the below topic to me via LinkedIn - thanks a lot, Maciej! . Locks are not being closed fast enough, resulting in gc freelist waits You can find a reference for Global Cache Freelist in the Oracle Documentation. This issue here can or will lead to database being slow, up to complete hangs. Based on my research it looks as the issue is not related to...

Flaws and Pitfalls

VBox 5.0.10/12 issues with PERL and Seg Faults - UPDATE

A bit more than two months ago I did hear from several people having issues with our Hands-On Lab environment. And it became clear that only those who use...

A bit more than two months ago I did hear from several people having issues with our Hands-On Lab environment. And it became clear that only those who use Oracle Virtual Box 5 see such errors.  VBox 5.0.10 crash issues with our Hands-On-Lab (Nov 30, 2015)https://blogs.oracle.com/UPGRADE/entry/vbox_5_0_10_crash . Oracle VirtualBox 5.0.x - Segmentation Fault in PERL (Nov 12, 2015)https://blogs.oracle.com/UPGRADE/entry/oracle_virtualbox_5_0_x . Then I read Danny Bryant's blog...

Flaws and Pitfalls

Network ACLs and Database Upgrade to Oracle 12c

What has been changed in Oracle Database 12c with Network ACLs? Starting from 12c, network access control in the Oracle database is implemented using Real...

What has been changed in Oracle Database 12c with Network ACLs? Starting from 12c, network access control in the Oracle database is implemented using Real Application Security access control lists (ACLs). Existing 11g network ACLs in XDB will be migrated. Existing procedures and functions of the DBMS_NETWORK_ACL_ADMIN PL/SQL package and catalog views have been deprecated and replaced with new equivalents In 12c, a network privilege can be granted by appending an access...

Flaws and Pitfalls

UPDATE: _rowsets_enabled in Oracle Database 12c

Please find a recent update here: https://blogs.oracle.com/UPGRADE/entry/rowsets_enabled_apply_patch_and(Oct 7, 2016) Last week I did post this entry with a...

Please find a recent update here: https://blogs.oracle.com/UPGRADE/entry/rowsets_enabled_apply_patch_and(Oct 7, 2016) Last week I did post this entry with a strong recommendation to disable _rowsets_enabled in Oracle Database 12.1.0.2: Nov 10, 2015:Switch off _rowsets_enabled in Oracle Database 12chttps://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in  Today I can give you an update, more insight information and better workarounds. Credits go to our DWH and...

Oracle

Integrated Cloud Applications & Platform Services