X

Archived Database Upgrade Blog

Oracle Database Upgrade Blog is moving

Dear Readers, the "Upgrade Your Database - NOW!" blog exists now for almost 8 years and has become one of the most read blogs on Oracle's own blogging platform. The platform will be migrated from Apache Roller to Oracle Compendium within the upcoming weeks. As part of this migration we decided that we'll move our Database Upgrade blog to another site offering more possibilities to present our mostly technical content in a convenient way and giving you easy access to slides,...

Monday, April 17, 2017 | Read More

Oracle Database Upgrade Blog has moved

Dear Readers, the "Upgrade Your Database - NOW!" blog exists now for almost 8 years and has become one of the most read blogs on Oracle's own blogging platform. The platform will be migrated from Apache Roller to Oracle Compendium aka Content Marketing within the upcoming weeks. As part of this migration we decided that we'll move our Database Upgrade blog to another site offering more possibilities to present our mostly technical content in a convenient way and giving you easy...

Monday, April 17, 2017 | Read More

Upgrade Workshops in California Next Week!

With a major winter storm hitting the east coast today, there is no better time to think about flying to California!   I will be delivering workshops in Redwood Shores (Tuesday, March 21) and El Segundo (Thursday, March 23). Remember that these are free workshops, but please do register if you plan on attending. That way we be sure to have enough space (not to mention enough food!) for everybody.   As a reminder, here is the general workshop agenda.  Introduction, Preparation...

Tuesday, March 14, 2017 | Workshop | Read More

Non-CDB still exists in Oracle Database 12.2.

  I received a question from 3 different colleagues in the past week: "Does Oracle Database 12.2 still allow us to create non-CDB databases?" And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant - I think it is important to clarify it. . Is the non-CDB architecture still available and supported in Oracle Database 12.2? I did blog about it a while ago - but Google is not always your friend to direct you...

Tuesday, March 14, 2017 | Oracle Database 12.2 | Read More

In case you miss the downloads of Oracle Database 12.1.0.2 on OTN

Somebody asked me the other day why the download options for Oracle Database 12.1.0.2 for Linux and Solaris  disappeared from OTN? The same will happen with the other platforms as soon as Oracle Database 12.2.0.1 is available on-premises for them as well. You can always download Oracle Database 12.1.0.2 and previous releases from: Oracle Software Cloud (eDelivery) . --Mike

Thursday, March 9, 2017 | Oracle Database 12c | Read More

Converting an 12.1 non-CDB and plug it into an 12.2 CDB

2 customers requested a bit more explanation on how to:Convert and Plugin an Oracle 12.1 non-CDB database into an Oracle 12.2 container database Cool, I like that :-) I will do this right away and use the approach to Upgrade first, then Plugin afterwards. . Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1 First the preupgrade.jar must be executed - please download always the most recent version from MOS Note:884522.1 as the version we publish is usually newer including...

Wednesday, March 8, 2017 | Single-/Multitenant | Read More

Oracle Database 12.2 - Lifetime Support Policy updated

The Oracle Lifetime Support Policy brochure for tech products has been updated now as well in order to reflect the addition and availability of Oracle Database 12.2 on-premises: Lifetime Support Policy - Oracle technology products Please note that this table and the brochure never makes a distinction between patch sets and base releases. For instance, the line talking about Oracle 11.2 does not say that Oracle Database 11.2.0.3 is out of any bug fixing support since Aug 27,...

Tuesday, March 7, 2017 | Oracle Database 12.2 | Read More

Install components in Multitenant ALWAYS with catcon.pl

I did blog several times about how to remove an unwanted component from a database. But yesterday I came across this interesting scenario worth a blog post. . How to install a component afterwards in Single-/Multitenant? I haven't checked all the MOS Notes but I recognized that some MOS Notes explaining how to (re-)create a component such as JVM are not updated to deal with a Single and/or Multitenant environment as they simply call the scripts from SQL*Plus. But the key to...

Thursday, March 2, 2017 | Single-/Multitenant | Read More

Oracle Database 12.2.0.1 on-premises is now available, too

Yep - it's available ... Oracle Database 12.2.0.1 on-premises is available for download now not only on Exadata and SuperCluster but on Linux x86-64, SPARC and Intel Solaris. For other platform plans please see MOS Note:742060.1. Oracle Software Delivery Cloud OTN Oracle Database 12c Release 2 (12.2.0.1.0) - Standard Edition 2 and Enterprise Edition Linux x86-64 File 1  (3.2 GB)  See All Oracle Solaris (SPARC systems, 64-bit) File 1  (3.1 GB)  See All Oracle Solaris (x86 systems,...

Wednesday, March 1, 2017 | Oracle Database 12.2 | Read More

Thanks for the Workshops in Vancouver and Calgary

Thanks to all of you visiting our "Upgrade / Migrate / Consolidate to Oracle Database 12.2 and the Oracle Cloud" workshops in Vancouver and Calgary last week. It was awesome. I had a lot of fun and I'm so glad I've got such great audiences. I did like the interaction a lot. Thanks as well for sending in some feedback emails to my colleagues - I'll be happy to come back soon again. Vancouver really impressed me. And I've had not much time or chance to see anything of Calgary. Ple...

Tuesday, February 28, 2017 | Workshop | Read More

Remove components from the Oracle kernel with chopt

I've had an interesting discussion today. Somebody removed OLAP with chopt - and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you'll have to make sure to remove the dictionary components as well.  A while back a blogged about chopt already: Removing Options from the Oracle Database kernel in 12c And there's a helpful Support Note out there: MOS Note: 948061.1How to...

Thursday, February 23, 2017 | Best Practice | Read More

Reminder: Upgrade Workshops in March!

Hi Folks! While Mike is out in Vancouver and Calgary this week, I will be delivering upgrade workshops for our public sector customers in Harrisburg and Trenton. But this seemed like a good time to remind everyone about the "Upcoming Events" list in the right sidebar of the blog. You might need to scroll down a bit to see it, but next month we will be running events in 21-MAR: Redwood Shores, CA (Register here!) 23-MAR: El Segundo, CA (Register here!) 29/30-MAR: Milano, Italy (Re...

Tuesday, February 21, 2017 | Workshop | Read More

Workshop in Vancouver - Venue has changed

I arrived well in Canada seeing the longest immigration line ever - but luckily as the immigration process by itself is very efficient it didn't take over an hour.  Vancouver sees to be a very nice city - only the weather could be a bit better ;-) I'm looking forward to the "Upgrade / Migrate / Consolidate to Oracle Database 12.2 and the Cloud" workshop tomorrow and just in case you haven't been alerted yet, there was a venue change over a week ago in order to accommodate all...

Monday, February 20, 2017 | Workshop | Read More

Client Certification for Oracle Database 12.1.0.2/12.2.0.1

I've received a question about client certification for Oracle Database 12.2.0.1 the other day. And this reminded me on this very helpful MOS Note: MOS Note: 207303.1 Client / Server Interoperability Support Matrix for Different Oracle Versions  It spans the client interoperability back to the Oracle 9.2 days and is a very helpful resource. And don't forget that sometimes client software may need a patch as well. A customer I exchange emails with on a regular basis just upgraded...

Friday, February 17, 2017 | Oracle Database 12.2 | Read More

Oracle Database 12.2 for Exadata/SuperCluster available

Oracle Database 12.2.0.1 on-premises for Exadata and SuperCluster is now available for download from Oracle eDelivery/SoftwareCloud. Connect to eDelivery and login: Search for: "Oracle Database" and mark "Oracle Database Enterprise Edition ..." . Click on "Select Platforms" and select "Linux x86-64", then hit "Continue": . Once you accepted the license agreement you'll be able to download the software: . Please be aware that the software can be installed on Oracle Exadata and...

Monday, February 13, 2017 | Oracle Database 12.2 | Read More

The OJVM Patching Saga - and how to solve it - Part IV

Related Posts on "The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed Part V - MOS Note explaining "Conditional Rolling Install"  What is missing with the "Mitigation Patch? Michael, the team lead from a large Oracle customer mailed me the other day. He wanted to disable Java on all their +600 databases by using the Mitigation Patch for OJVM. But he...

Thursday, February 9, 2017 | Patch Recommendation | Read More

DBMS_QOPATCH does not work in PDBs (right now)

Thanks to Murthy who commented on this blog post and Jeannette Holland (SimCorp) who opened an SR resulting in an ER. . DBMS_QOPATCH in Multitenant DBMS_QOPATCH will deliver useful information about installed patches only when executed within the CDB$ROOT. It has been designed this way for security reasons in Oracle Database 12.1 but I can easily see a need to check for installed patches within a PDB as well. . Testcase I "borrowed" this test case from Jeannette's SR: SQL> COLUMN...

Wednesday, February 8, 2017 | Single-/Multitenant | Read More

February 2017 version of PREUPGRD.SQL is available

The new version of the preupgrd.sql (including the utluppkg.sql package) in its February 2017 version is available for download from MOS Note:884522.1. If you are going to upgrade to Oracle Database 12.1.0.2 please exchange your current preupgrd.sql/utluppkg.sql either in ?/rdbms/admin or in the location of the source system you've copied it to with the new version. . --Mike .

Friday, February 3, 2017 | Oracle Database 12c | Read More

New SPFILE parameters in Oracle Database 12.1.0.2 with July 2016 (and newer) PSU/BP

New Parameters in Oracle Database 12.1.0.2 with July 2016 PSU/BP By following an internal discussion and checking parameter changes between Patch Set Updates (PSU) and Proactive Bundle Patches (BP) I learned that we introduced two new SPFILE parameters in Oracle Database 12.1.0.2 with the July PSU and BP. One is documented in the patch readme, the other one can be found right now only in the Oracle Database 12.2.0.1 manual: ALLOW_GROUP_ACCESS_TO_SGA ENCRYPT_NEW_TABLESPACES .The...

Wednesday, February 1, 2017 | Oracle Database 12c | Read More

Where is the Jan 2017 PSU for Oracle Database 11.2.0.4?

Where is it? This question reached me a week ago: "Where is the January 2017 PSU for Oracle Database 11.2.0.4?" "What's the deal?" was my first thought - just go and download it from MOS. Well, not really ... . Where to download Proactive Bundle Patches, Patch Set Updates and Patch Sets? My favorite note is: MOS Note:1454618.1 Quick Reference to Patch Numbers for PSU, SPU(CPU), BPs and Patchsets It gives me access to all the download links for the patch bundles I'm looking for. But...

Monday, January 30, 2017 | Patch Recommendation | Read More

Release Dates Oracle Database 12.2.0.1 on-prem - Extended Support Waiving for Oracle 11.2.0.4 / 12.1.0.2

Yesterday night the most important MOS Note:742060.1 got updated with the planned release date for Oracle Database 12.2.0.1 on-premises.  In addition the dates for Waived Extended Support for Oracle Database 11.2.0.4 and 12.1.0.2 got extended as well. Please see: MOS Note: 742060.1: Release Schedule of Current Database Releases In summary: Oracle Database 12.2.0.1 for Exadata and SuperCluster is supposed to be released soon. Oracle Database 12.2.0.1 for Intel Linux x86 and Solaris pl...

Friday, January 27, 2017 | Oracle Database 12.2 | Read More

Gather SQL Statements from AWR and Cursor Cache without need for Diag and Tuning Packs

When we talk about database upgrades and migrations the most important (and unfortunately time-/resource consuming) activity is testing. But often testing resources are limited or, even worse, don't exist. I've worked with customers where we migrated a core EBS system off AIX to Linux - but only got a 6 year old Tru64 box for testing purposes (where the recompilation took 20x as long as later on the production environment). Or the classic one: Database is too big thus we test...

Thursday, January 26, 2017 | Cloud | Read More

Restarting a failed Database Upgrade with DBUA 12.2

In my previous blog post I did showcase how to restart a failed database upgrade on the command line before Oracle Database 12c, with Oracle Database 12.1.0.x and with the new Oracle Database 12.2.0.x: Restarting a failed Database Upgrade with catctl.pl(Upgrade Blog - Jan 24, 2017) Here I'd like to show the new capability of the Database Upgrade Assistant (DBUA) to restart an upgrade, a functionality the DBUA was missing until now. Please note that you can always go back to the...

Wednesday, January 25, 2017 | Oracle Database 12.2 | Read More

Restarting a failed Database Upgrade with catctl.pl

What if ... What if a database upgrade fails in between? First of all you should have enabled one of the common protections for issues happening during an upgrade: Guaranteed Restore Point to Flashback Database Restore an RMAN Online Backup Restore a partial Offline Backup See our slide's Fallback section for further details. But actually there are ways to restart the upgrade without the need to fallback in case of a non-destructive incident such as running out of archivelog space.....

Tuesday, January 24, 2017 | Oracle Database 12.2 | Read More

Default Changes SPFILE Parameters - Oracle 12.2

Parameters in Oracle Database 12.2.0.1 - part 4 of the series: New SPFILE Parameters in Oracle Database 12.2.0.1 Obsolete SPFILE Parameters in Oracle Database 12.2.0.1 Deprecated SPFILE Parameters in Oracle Database 12.2.0.1 Default SPFILE Parameter changes between Oracle Database 11.2.0.4, 12.1.0.2 and 12.2.0.1 Roy and I did a comparison between default parameter settings in Oracle Database 11.2.0.4 vs Oracle Database 12.1.0.2 vs Oracle Database 12.2.0.1. And some changes are...

Wednesday, January 18, 2017 | Oracle Database 12.2 | Read More

Having fun with PDB LOCKDOWN PROFILES

In Oracle Database 12.2 (available in the Oracle DBaaS Cloud) there's a new functionality called "PDB LOCKDOWN PROFILES". Actually the parameter came already in undocumented and not functional in Oracle Database 12.1.0.2 (see here). PDB Lockdown Profiles PDB Lockdown Profiles are meant as a granular way to restrict or enable access - mostly under the aspect of using the database in a highly shared environment but requiring security. The idea is to embed restrictions on-top of a...

Tuesday, January 17, 2017 | Single-/Multitenant | Read More

Upgrade Workshops in North America - Jan 2017

There are still a few seats left for the "Upgrade / Migrate / Consolidate to Oracle Database 12.2 on-premises and in the Cloud" workshops Roy will give in January and early February 2017. And again, ONLY real tech stuff will happen in these workshops. ONLY customer cases we worked with will showcased. And Roy will do a LIVE and UNCENSORED upgrade from Oracle Database 11.2.0.4 to 12.2.0.1. Hurry to get your seat! Jan 18, 2017 Reston, VA - Full-day Upgrade Seminar: Register Here Jan...

Tuesday, January 10, 2017 | Workshop | Read More

DOAG Noon2Noon - Upgrade/Multitenant - 2.-3.2.2017

++++++ Sorry - this is a German event only thus I will write in German ++++++ . Ich bin schon sehr gespannt. Am 2. Februar 2017 wird im Intercity Hotel in Mainz das DOAG Noon2Noon zum Thema "Upgrade, Migration und Multitenant" stattfinden. Von 12:00h mittags bis 12:00h mittags am Folgetag. Der Praxisbezug steht im Vordergrund. Garniert mit kurzen Vorträgen. In der praxisorientierten "Noon2Noon"-Veranstaltung wollen wir uns mit den Herausforderungen beim Upgrade nach Oracle 12c...

Monday, January 9, 2017 | Workshop | Read More

Happy New Year!

A Happy New Year 2017 to all of you! Thanks for visiting our blog quite often - we promise to keep that level of technical information in the new year as well. But let me review some things and give you an outlook for 2017. Flashback 2016 was an exciting year in terms of technology. Oracle moves strongly towards more and more cloud offerings - and Oracle Database 12.2 got released in the Oracle DBaaS Cloud as well. Roy and I did a good number of workshops internally with our...

Monday, January 9, 2017 | Off Topic | Read More

Upgrade Workshops Early 2017 in North America

I will be starting a slate of Oracle Database 12c Release 2 upgrade workshops and presentations after the holidays. Here's a list of events coming in January & March along with links to the registration and sign-up pages for the various events or their sponsoring organizations. If you live or work nearby one of these events, or if you will be participating in the RMOUG Training Days or the TCOUG winter meeting, I'd love to see you there!  Date  Location  Event  18-Jan  Reston, VA  ...

Wednesday, December 14, 2016 | Workshop | Read More

Create a database with NON-DEFAULT Time Zone

One requirement of Transportable Tablespaces (and of course Full Transportable Export/Import as well) is to have identical database character sets AND identical time zone settings. Problem Source database has a lower time zone setting than the default target database in the destination home. Lets assume you'd like to migrate an Oracle 11.2.0.4 off IBM AIX and migrate it into Oracle 12.1.0.2 on an Exadata meaning Oracle Linux 6. The source time zone version if it has never been...

Thursday, December 8, 2016 | Tech | Read More

Upgrade to Oracle Database 12.2 - Slides are available

The workshops in Brussels and Utrecht were awesome with great audience - I enjoyed both events a lot. And thanks for your patience with my voice and the microphone issues we've had in Brussels before lunch. I promised the workshop slides - and here they are, ready for download: Upgrade, Migrate and Consolidate to Oracle Database 12.2 and the Cloud Please be aware: It's the first drop of the slides, not everything has been updated yet for Oracle Database 12.2, and of course there...

Tuesday, December 6, 2016 | Slides | Read More

Transportable Tablespaces and READ ONLY in Oracle Database 12c

We recently worked with a customer who noticed that they were not able to use transportable tablespaces to connect the same tablespace data files to two databases at the same time, even after setting the tablespaces READ ONLY in SQL*Plus. This is new behavior in 12c, and many customers are not yet aware of this change. Here are the details of what changed, why, and how you might want to deal with it if the changes affect your environment. What Changed?Starting in 12.1, data...

Friday, December 2, 2016 | Data Pump | Read More

UKOUG TECH 16 is coming - and I'm speaking

Uhhh ... time flies. I look into my calendar - and UKOUG TECH 16 Conference is almost there. Just a few days to go (and hopefully no Lufthansa strike on the upcoming weekend - but I looked already for alternatives). Anyhow, I'm excited and look forward to my 2nd TECH conference. Last year was the first time for me and I enjoyed it a lot. Very good audience, good location - even though I can't say much about the city of Birmingham as I haven't seen anything except for the...

Thursday, December 1, 2016 | Workshop | Read More

DBA_REGISTRY_HISTORY vs DBA_REGISTRY_SQLPATCH

At the DOAG Conference in November in Nürnberg in November 2016 a customer asked me right after my talk about "Upgrade to Oracle Database 12.2. - Live and Uncensored" why the DBA_REGISTRY_HISTORY does not get updated when he applies a Bundle Patch and follows all instructions including the "./datapatch -verbose" call. I was wondering as well and asked him to open an SR. Which he did. And he received the message from Support that it is not supposed to appear in Oracle 12c...

Wednesday, November 30, 2016 | Patch Recommendation | Read More

Lufthansa - 14th pilot strike in 2 years - lovely :-(

I don't blame anybody. Really, I don't.  But nevertheless this is awkward.  Source: Facebook - https://scontent.fmuc2-1.fna.fbcdn.net/v/t1.0-9/15193604_10210663792047910_5774221704440071551_n.jpg?oh=99f7242c9283bf664db779354d594b3b&oe=58B51EA1 I've got affected by the most recent - the 14th (!!!) in two years - strike of the Lufthansa pilots. And not for the first time. I've had my share of strike experience already quite often in the past years with my main airline carrier. Last...

Tuesday, November 29, 2016 | Off Topic | Read More

New PREUPGRADE.JAR is available - MOS 884522.1

As promised - and thanks to everybody from the Database Upgrade Development Team - the new preupgrade.jar for Oracle Database 12.2 is available: MOS Note:884522.1 - Download and Run Oracle's Database Pre-Upgrade Utility And of course the previous preupgrd.sql with the package utlupkkg.sql and the old utlu112i.sql for upgrade to Oracle 11.2.0.4 (which I wouldn't do anymore) are available as well. Please ALWAYS use the version downloaded from this MOS note as this version is much...

Thursday, November 24, 2016 | Oracle Database 12.2 | Read More

Enabling ADAPTIVE Features of Oracle 12.2 in 12.1

Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. For more information please see: https://blogs.oracle.com/UPGRADE/entry/optimizer_adaptive_features_obsolete_in https://blogs.oracle.com/optimizer/entry/optimizer_adaptive_features_in_the But Oracle Database 12.2 on-premises is not out yet - so what should you do when upgrading to Oracle Database 12.1 - or struggling with some of the "adaptive"...

Wednesday, November 23, 2016 | Oracle Database 12c | Read More

OPTIMIZER_ADAPTIVE_FEATURES obsolete in Oracle 12.2

The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2. It gets replaced with two parameters of whom one is enabled, the other one is disabled by default: OPTIMIZER_ADAPTIVE_PLANS=TRUE by default OPTIMIZER_ADAPTIVE_STATISTICS=FALSE by default Nigel Bayliss, our "Optimizer" Product Manager has blogged about it already with way more detailed insights. https://blogs.oracle.com/...

Tuesday, November 22, 2016 | Oracle Database 12.2 | Read More

SANGAM and DOAG Conferences 2016 - Recap + Slides

The past weeks were very intense. I've been to Japan for customer meetings and a Dev Day and an internal workshop, then on to China for an internal training, then to India for SANGAM conference and afterwards to Nürnberg for DOAG, the German Oracle User's Group conference. And UKOUG is just in two weeks ... You'll find the slides of my talks here: Upgrade to Oracle Database 12c - Live and Uncensored How to Ensure Performance Stability when Upgrading Oracle Databases and in the Sli...

Friday, November 18, 2016 | Workshop | Read More

SPFILE Parameter: max_pdbs - a must for Single Tenant

Sometimes my job has a aspect making me smile at the end of the day ;-) I sat together with Johannes Ahrends during a talk at the OUGN Conference on the boat from Oslo towards Kiel. And we were discussing afterwards why there's no official way to limit the number of PDBs which will be essential for customers wanting to go the Single Tenant track. I had my Hands-On environment up and we played a bit in the break recognizing that a constraint on CONTAINER$ won't be the correct...

Monday, November 14, 2016 | Single-/Multitenant | Read More

Deprecated Parameters in Oracle Database 12.2.0.1

Parameters in Oracle Database 12.2.0.1 - part 3 of the series: New SPFILE Parameters in Oracle Database 12.2.0.1 Obsolete SPFILE Parameters in Oracle Database 12.2.0.1 Deprecated SPFILE Parameters in Oracle Database 12.2.0.1 Finally, here's the list of DEPRECATED parameters in Oracle Database 12.2.0.1: O7_DICTIONARY_ACCESSIBILITY active_instance_countasm_preferred_read_failure_groups background_dump_dest buffer_pool_keep buffer_pool_recycle commit_write cursor_space_for_timedb_bloc...

Friday, November 11, 2016 | Oracle Database 12.2 | Read More

Obsolete SPFILE Parameters in Oracle Database 12.2.0.1

This is the 2nd posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.  New SPFILE Parameters in Oracle Database 12.2.0.1 Obsolete SPFILE Parameters in Oracle Database 12.2.0.1 Deprecated SPFILE Parameters in Oracle Database 12.2.0.1 Find the list of the 159 obsoleted parameters here (and of course in V$OBSOLETE_PARAMETERS): _app_ctx_vers _average_dirties_half_life _aw_row_source_enabled _compatible_no_recovery _data_transfer_cache_size_db_no_mount_lock...

Thursday, November 10, 2016 | Oracle Database 12.2 | Read More

New SPFILE parameters in Oracle Database 12.2.0.1

Oracle Database 12.2.0.1 is available now in the Oracle Cloud. And this is the list of 46 new init.ora/spfile parameters compared to Oracle Database 12.1.0.2 - including the links (where possible) to the Oracle Database 12.2 Reference documentation. Parameter Description allow_global_dblinks LDAP lookup for DBLINKS allow_group_access_to_sga Allow read access for SGA to users of Oracle owner group approx_for_aggregation Replace exact aggregation with approximate aggregation approx_for_co...

Wednesday, November 9, 2016 | Oracle Database 12.2 | Read More

Upgrades to Oracle Database 12.2.0.1 (and Downgrades)

Oracle Database 12c Release 2 (12.2) is available now in the Oracle Cloud in DBCS and ECS in both NAS and EMEA zones, as well as being available on Exadata Express Cloud Service. The Oracle Database 12.2 documentation should be published later today. Just to note down, the versions supporting direct upgrade either with catctl.pl on the command line or with DBUA are: Oracle Database 11.2.0.3 Oracle Database 11.2.0.4 Oracle Database 12.1.0.1 Oracle Database 12.1.0.2 No direct...

Tuesday, November 8, 2016 | Oracle Database 12.2 | Read More

SANGAM and DOAG Conferences 2016

The upcoming weeks will involve a lot of travel ;-) I'm looking forward to present at SANGAM Conference in Bangalore, India on Nov 11 and 12 for the first time.  I will have two sessions at SANGAM: There are so many interesting talks in the agenda (please click here) - the organizers have done a fantastic job. . Then I'm heading straight back to present at the German Oracle User Group Conference (DOAG) for the ... let me think ... 14th (?) time. So no time for jet lag. And glad...

Monday, November 7, 2016 | Workshop | Read More

Full Transportable Export/Import - PAR File Examples

Roy and I blogged about Full Transportable Export/Import in the past: Full Transportable Export/Import White Paper Full Transportable Export/Import - Things to Know Full Transportable Export/Import - Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud Exclude Stats differently for TTS and FTEX If you haven't heard of this database feature, it allows you to migrate a full database by using Transportable Tablespaces as a base technology but letting Data Pump...

Thursday, November 3, 2016 | Data Pump | Read More

Database Upgrade Workshops in Brussels and Utrecht

On November 24 and 25 I'll give two full-day Upgrade / Migrate / Consolidate to Oracle Database 12.2 and the Oracle Cloud workshops in Brussels and Utrecht. If you want to grab a seat please hurry as I've got informed that only a few seats are left. Please use the registration links: November 24, 2016 - Brussels/Belgium November 25, 2016 - Utrecht/Netherlands Both workshops will happen in the Oracle offices. You'll get the address from the above links as well. Looking forward to...

Wednesday, November 2, 2016 | Workshop | Read More

October 2016 Proactive BP got replaced

Just received a message from Oracle Support this early morning as I did install the Proactive Bundle Patch from October 2016 into my Oracle Database 12.1.0.2 environment saying: Dear Oracle Customer, You are receiving this email because our recordsindicate you downloaded the following patch: Patch number: 24448103 Release: DB Proactive Bundle 12.1.0.2.161018 Platform: Linux x86-64 This patch has been replaced and is now available for download. Please review section 1.1 of thefo...

Tuesday, November 1, 2016 | Patch Recommendation | Read More

New preupgrd.sql is available - MOS 884522.1

A new preupgrd.sql got released this week via MOS Note:884522.1. Plus use this one for upgrades to Oracle Database 12.1.0.2 instead of the deployed (or any other earlier version). Changes since initial release of 12.1.0.2 Do not recommend pga_aggregate_limit for 12.1 databases fix miscalculation of upgrade parallel pdb count Updates to the memory sizing uploaded in build #12 Removed the 32-bit and 64-bit values in the manual display. Added a pga_aggregate_limit. Shared_pool_size has...

Wednesday, October 26, 2016 | Patch Recommendation | Read More

Gather Fixed Objects Stats in PDBs as well?

Yesterday I received an interesting customer question: "Do we have to gather fixed objects stats inside a PDB as well or only in the CDB$ROOT?" The customer told me he couldn't find anything in the documentation. Neither could I. And I did check also the usual suspects this morning "Best Practices for Gathering Statistics" - but it does not say anything about PDBs and CDBs. Therefore I did a short test: Create a PDB in my Oracle 12.1.0.2 CDB:SQL> create pluggable database PDB3...

Friday, October 21, 2016 | Single-/Multitenant | Read More

October 2016 PSU and BP - Database Patching?

What will you get when you download the most recent Oracle Database PSU or BP from October 2016? MOS Note: 1683799.1 - 12.1.0.2 Patch Set - Availability and Known Issues is not entirely clear. Therefore lets shed some light ... The Matrix This matrix in MOS Note: 1683799.1 tells you about the availability of PSUs and BPs for a regular database installation (non-RAC, non-Exadata). But it doesn't clearly tell you what's included - and the names being used aren't very...

Thursday, October 20, 2016 | Patch Recommendation | Read More

October 2016 PSU and Proactive BP are available

When the leafs are falling down ... ... then it's time for the October 2016 Patch Set Update (PSU) and Proactive Bundle Patches (BP).  Things you need to know: General information: Critical Patch Update - October 2016 Risk Matrix for: Oracle Database Server, version(s) 11.2.0.4, 12.1.0.2 Patch Availability: MOS Note: 2171485.1 Download the Database PSU or BP:MOS Note: 1683799.1 - 12.1.0.2 Patch Set - Availability and Known Issues Interesting information: Newly scheduled final...

Wednesday, October 19, 2016 | Patch Recommendation | Read More

_rowsets_enabled - Apply patch and use the default

I while back I blogged about issues with "rowsets", a new Oracle 12c feature which unfortunately had two known wrong result (WQR) bugs: Switch off "_rowsets_enabled" in Oracle Database 12c  Nov 10, 2015 UPDATE: _rowsets_enabled in Oracle Database 12c Nov 16, 2015 extended with updates on Dec 2, 2015 and Sep 14, 2016 What does "rowsets" actually mean? I'd like to thank Sankar, our Development manager for providing this explanation which sheds some light on how important this feature...

Tuesday, October 11, 2016 | Patch Recommendation | Read More

UKOUG: SIG (RAC, Cloud, Database, ...) - 12 Oct 2016

Wow ... time flies ... I think it was February or March this year when I'd got invited to the UKOUG SIG for RAC, Database, Cloud, Infrastructure in London on Oct 12, 2016. Just a week ago I looked into my calendar and realized: Book a flight. Now! We have to arrange travel at least 7 days before departure as otherwise extra approvals may be required. Time flies ... The room number in the picture above was the one of my hotel room in Baku earlier this year in May ;-) And of...

Monday, October 10, 2016 | Workshop | Read More

RMAN Recovery Catalog with July PSU: How to resolve RASCHEMAVER and BASCHEMAVER schema mismatch

Related blog posts: RMAN Catalog Upgrade fails - ORA-02296 - error creating modify_ts_pdbinc_key_not_null(April 19, 2016) RMAN Catalog requires Enterprise Edition (EE) since Oracle Database 12.1.0.2 (April 22, 2016) RMAN Catalog Upgrade to Oracle 12.1.0.2 (August 1, 2014) Thanks to Ah Huat Tan from Amway IT Services for keeping me updated! Actually as I see that more people who got hit by this issue so I'd consider it to be worth to write about it. Problem and Analysis You'd apply the...

Friday, October 7, 2016 | Patch Recommendation | Read More

OOW 2016: Slides and HOL Download

Sorry for any delay but Roy and I promised to make our OOW 2016 slides available right after the talks. And some people were asking already where they are. For internal people you'll find them via the usual sources on database.us. But customers will have to wait until Oracle Database 12.2 is available in the Cloud as it got announced at OOW during the keynotes. . What you can get right now: How to Ensure Performance Stability when Upgrading to Oracle Database 12c,our Thursday...

Wednesday, October 5, 2016 | OOW | Read More

Can I apply a BP on top of a PSU? Or vice versa? PART 2

I thought I won't blog about this again: Can I apply a BP on top of a PSU? Or vice versa?(May 6, 2016) But then a colleague of mine raised this simple question: "I have a customer that would like to change from patching using PSU to patching using Bundle Patch. I am wondering what happens if my home has had several PSUs installed. Before applying a BP, would I need to rollback one by one all the PSUs that have been installed in reverse order (tedious) OR only the latest PSU (good...

Tuesday, October 4, 2016 | Patch Recommendation | Read More

Data Pump's amazingly useful METRICS=Y and LOGTIME=ALL parameters

Now that I am back from OpenWorld, I will hijack the Upgrade blog while Mike is traveling. :-) Thank you to everybody who came to our presentations or stopped at the demo booth to chat last week. We had a great many conversations, and we always learn from talking to customers! One of the common questions about Data Pump came in the form, "I have a data pump job that used to run in X minutes, but now takes <multiple of X> minutes. Can you tell me what might be happening?" Of...

Tuesday, September 27, 2016 | Data Pump | Read More

OOW 2016: Where are the slides? And the lab?

OOW16 is not over yet. Still one day to go. Or walk. My average walking distance per day so far is almost 11km per day or 13500 steps according to my cell phone.  We've had one talk so far, our "Upgrade and Migrate to Oracle Database 12.2 - Live and Uncensored" on Monday, 3 of 4 Hands-On-Labs, all fully sold out - and tomorrow we'll have the final lab and the 2nd presentation "Ensure Performance Stability When Upgrading to Oracle Database 12c" in Moscone South 302 at 9:30am.  To...

Thursday, September 22, 2016 | OOW | Read More

OOW16 - Focus on Upgrade / Migrate / Consolidate

Almost ready to fly out - just have to pack my suitcase. And looking forward to an exiting Oracle Open World 2016 Conference in San Francisco.  If you are interested in a selection of really useful presentations, labs and meetups around Upgrade / Migration (incl DMU) / Consolidation and the Optimizer in Oracle Database 12c please see this Focus On document with links to the presentations of people we know, customers we have worked with - and of course our talks as well. Click...

Thursday, September 15, 2016 | OOW | Read More

The OJVM Patching Saga - and how to solve it - Part III

Related Posts on "The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed Part V - MOS Note explaining "Conditional Rolling Install"  . What is the "Mitigation Patch? In MOS Note:1929745.1 - Oracle JavaVM Component Database Patches there's a section called What is the Mitigation Patch. It says: "For situations where the latest OJVM PSU cannot be...

Wednesday, September 14, 2016 | Patch Recommendation | Read More

The OJVM Patching Saga - and how to solve it - Part I

Related Posts on "The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed Part V - MOS Note explaining "Conditional Rolling Install"  . Who's the Product Manager for Patching? First of all, I'm neither a patching expert nor am I the Product Manager for Patching. There's no such role as far as I know but there are people inside Oracle who have way more clue...

Monday, September 5, 2016 | Patch Recommendation | Read More

Oracle Open World 2016 - Recommended Customer Talks

At OOW 2016 there are some customer talks from customers we worked with or at least were involved in their project plans. We highly recommend the talks below. British Telecom has such an ambitious upgrade and migration project for really MANY databases. I'm looking forward to David's talk. We met at UKOUG TECH15 and I promise it will be a very interesting insight presentation.  Migrating Oracle Real Application Clusters Databases to Oracle Multitenant [CON2718] David Hickson,...

Thursday, August 18, 2016 | OOW | Read More

Oracle Open World 2016 - Upgrade Talks / HOL

Just a few weeks until Oracle Open World 2016 Conference will kick off. September 18-22, 2016 in San Francisco. For us it is usually the most busiest week of the year. But also a great experience every year with so many good discussions and meetings. It's very intense. Since a few hours the OOW16 Session Catalog is online with the schedule (but it still misses the rooms).  This is the list of our talks and HOL sessions:  Upgrade and Migrate to Oracle Database 12c: Live and...

Tuesday, August 16, 2016 | OOW | Read More

OJVM patch: Standby-First patching, yes or no?

I have blogged in the past more than once about the "wonderful" topic of OJVM patching. And please don't beat me and you can be sure that even our execs are aware of this topic. Anyhow,  I'd like to summarize a few typical questions sent to me in the past months regarding OJVM patching. . Do I need to apply the OJVM patch every time I apply a PSU or BP? Unfortunately this is not a one-time-and-then-you-are-set operation. You'll have to do it every time. . How do I find out if...

Monday, August 8, 2016 | Patch Recommendation | Read More

PDB unplug/plug/patch with PSUs or BPs

This question was posted on the blog a few days ago referring to my previous blog posts describing the two techniques to upgrade in an Oracle Multitenant environment: Everything at Once One at a Time --- via unplug/plug Question:  We are planning to upgrade from 12.1.0.2.1 to 12.1.0.2.5.The plan is to create new 12.1.0.2.5 oracle home andgradually moving PDB from 12.1.0.2.1 to 12.1.0.2.5.Should I follow the same steps?Is there any document for what we want to do? And luckily...

Monday, August 1, 2016 | Patch Recommendation | Read More

Proactive Bundle Patches - Change reflected now in MOS as well

Now the Known Isuses and Alerts and Recommended Patches Notes in MOS reflect the naming and classification change of the different types of patches as well. See in: MOS Note:1683799.1 - 12.1.0.2 Patch Set - Availability and Known Issues We don't speak about Bundle Patches for Exadata and DBIM anymore making it easier to find the correct patch for your platform. Just wanted to share this as I'm refreshing our upgrade slide deck at the moment :-) --Mike . 

Thursday, July 28, 2016 | Patch Recommendation | Read More

OTN Tour LAD - Panama, Costa Rica, Mexico, Guatemala

OTN Tour Latin America 2016 is ready to take off And for me it's the first time in 4 years that I won't be able to participate. Which is very sad as it is such a great thing to meet all these wonderful people, not only from the User Groups doing all the orga stuff but also discussing with customers, learning from skilled and knowledgeable co-presenters, the entire travel, the wonderful cities ... I miss this already. Maybe next year ... Nevertheless, the Database Upgrade team...

Thursday, July 21, 2016 | Workshop | Read More

July 2016 - Proactive BPs and PSUs are available

Last night the July 2016 patches got released Not all of them actually. In case you miss AIX, Intel Solaris and zLinux versions those should be available by Friday, July 22, 2016.   See the Oracle Critical Patch Update Advisory July 2016 for further details, and especially the Database announcement on MOS. What's new, what's important? First of all the renaming of DBIM and Exadata Bundle Patches into PROACTIVE BUNDLE PATCHES is now settled in more MOS notes. 2.1 Database patch for...

Wednesday, July 20, 2016 | Patch Recommendation | Read More

Global Temporary Tables - Change in Oracle 12c

A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.  Something you need to be aware of when using GTTs in Oracle Database 12.1.0.2: Prior to this release GTTs shared statistics between sessions. Statistics were SHARED between different sessions. Now since Oracle Database 12c this is different by default - statistics on GTTs are visible to the SESSION only. This can be changed and altered of...

Thursday, July 7, 2016 | Optimizer | Read More

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 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 in...

Tuesday, July 5, 2016 | Flaws and Pitfalls | Read More

Full Transportable Export/Import - Things to Know

This blog post is an addition to: Full Transportable Export/Import - Migration an 11.2.0.4 database to Oracle Database 12c - into the Oracle Cloud Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you'll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all.  So let me point out a few things to take into consideration - and some of them are...

Monday, July 4, 2016 | Best Practice | Read More

Full Transportable Export/Import - Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Full Transportable Export/Import - one of the coolest features in Oracle Database 12c  We blogged about Full Transportable Export/Import a while back. It is - no doubt - one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab - Upgrade, Migrate, Consolidate to Oracle Database 12c) as well. It utilizes the technique of Transportable Tablesspaces - cross-platform, cross- Endianness, cross-version - but lets Oracle Data Pump do...

Monday, June 27, 2016 | Data Pump | Read More

Minor Upgrade? Going from 11.2.0.1 to 11.2.0.4?

My Belgium friend Phillipe Fierens raised a great question on Twitter last week and dropped me an email again after having a discussion with his client: For Phillipe and myself the answer is pretty clear and straight forward: There is no minor upgrade anymore since every (patch set) release is a full release and since new parameters, parameter values, features and whatever appears even in patch sets.  But the following discussion on Twitter with comments from all sides made me...

Monday, June 20, 2016 | Best Practice | Read More

EM 13c - How to Upgrade from EM Cloud Control 12c

I'm not a Cloud Control expert but I use the tool from time to time - and most of my customers are heavy users of it, especially in larger deployments. If you use Oracle Enterprise Manager Cloud Control 12c (12.1.0.3, 12.1.0.4 or 12.1.0.5) and would like to evaluate your options to upgrade to Oracle Enterprise Manager Cloud Control 13c then please consult the following very useful documentation: MOS Note:2095192.1EM 13c: Checklist for Upgrading Enterprise Manager Cloud...

Thursday, June 16, 2016 | Best Practice | Read More

Silence for some weeks?

You may wonder why I haven't posted many things in the past weeks. Or why I haven't replied to your comments yet. The few posts were pre-written - and I took off for a few weeks and traveled on the West Coast of the US from San Francisco towards the north. So while I'm writing new content and answering your comments and building up a new hands-on lab for our upcoming workshops let me share some pictures with you - fully off-topic of course :-)  Plenty of clouds in Northern...

Wednesday, June 15, 2016 | Off Topic | Read More

DMU - Tips and Tricks - Migration Assistant for Unicode

Please find previous posts about the Data Migration Assistant for Unicode (DMU) here: We included the DMU into our slide deck a while ago: Upgrade, Migrate & Consolidate to Oracle Database 12c. DMU 2.1 is available (June 2, 2015) https://blogs.oracle.com/UPGRADE/entry/migrating_to_unicode_get_dmu . Since Roy and I subscribed to the Hot Topics support email we'll find a very helpful note none of us was aware of almost every second day. One of these recent finds is: MOS...

Monday, May 30, 2016 | Best Practice | Read More

Transportable Tablespaces - Characters Sets - Same same but different?

All credits go to Don Wolf, an Oracle Advanced Customer Support engineer from Ohio as he dug out this information :-) Thanks Don! Do database character sets have to match EXACTLY for Transportable Tablespaces? That sounds like a simple question. When you look into our big slide deck the answer will be a straight "Yes". No doubts. Regardless if you would like to do Transportable Tablespaces or Full Transportable Export/Import your sources and your target's database character...

Wednesday, May 25, 2016 | Tech | Read More

MOS Note:136697.1 - New HCHECK.SQL for Oracle Database 12c

A while back we added this slide to our big slide deck: The story behind this slide A large and important customer in the US tested a patch set upgrade - but when they approached the production upgrade from 11.2.0.2 to 11.2.0.3 on a large RAC cluster they've had to cancel the attempt and revert to the previous state. Reason They've hit a dictionary corruption somewhere silently sleeping in the database causing no trouble at all so far - until the upgrade touched the broken...

Thursday, May 19, 2016 | Best Practice | Read More

Recap - OTN Tour EMEA - Baku, Azerbaijan - 2016

Working on a Saturday is not common for me but happens from time to time mostly when I travel abroad or when a customer has a critical upgrade or migration on a weekend. Having 120 skilled and enthusiastic people in a conference day on a Saturday is VERY UNCOMMON. And having them stay from 9am to 6pm is a sign that the selection of topics fit the interest of the audience - and the presenters got their attention the entire day. Please find the slides and the Hands-On-Lab here: Ens...

Tuesday, May 17, 2016 | Workshop | Read More

Recap - OTN Tour EMEA - Milano, Italy - 2016

Thanks for this excellent day yesterday in Milano for the OTN EMEA Tour 2016. What a great audience, excellent speakers covering a broad spectrum - and also a perfect organization. In case you need the slides please find them here (or many more including the Hands-On-Lab) in the Slides Download Center to your right (scroll down a bit): Ensure Performance Stability When Upgrading Oracle Databases How Oracle Single-Tenant will change a DBA's life (currently minus the 12.2 slides) I'...

Friday, May 13, 2016 | Workshop | Read More

OTN Tour EMEA 2016 - Milan and Baku

Time to travel a bit. OTN Tour EMEA 2016 has started yesterday in Düsseldorf, and tomorrow, May 12, Milan will be on the route. . Then on to Baku, Azerbaijan for the event on Saturday, May 14. First time for me. And I'm so looking forward to it. For Baku you will need to hurry as only 20 tickets are left. .  Thanks to all the people like Ludovico Caldara and Kamran Agayev and all the others for their hard work setting ip those events. And I look forward to see you and learn a...

Wednesday, May 11, 2016 | Workshop | Read More

Upgrade NOW! - OTN Interview at Collaborate16

Thanks again to Laura for this interview at Collaborate 2016 :-) Why you need to Upgrade to Oracle Database 12c - NOW! --Mike . 

Friday, May 6, 2016 | Best Practice | Read More

Are BPs. PSUs and Proactive BPs cumulative?

Are Bundle Patches (BPs) and Patch Set Updates (PSUs) cumulative? That is a question sounding trivial to many people but actually it does get asked quite often. And sometimes I forget to mention this during the workshops - and luckily usually somebody asks the question reminding me to explain it. Yes, Bundle Patches and Patch Set Updates (and of course Proactive Bundle Patches and Critical/Security Patch Updates (CPUs/SPUs) are all cumulative. You'll find this mentioned in the...

Wednesday, May 4, 2016 | Patch Recommendation | Read More

Can I apply a BP on top of a PSU? Or vice versa?

This question was in my inbox this morning raised by a customer via a colleague.  Our feeling said: Yes, but you'll have to deinstall the PSU first before applying the BP. Having a feeling is one thing, knowing the truth is better. And as I have so much fun by applying PSUs and BPs back and forth since two weeks I thought "let's give it a try". So here we go ... . Apply a BP on top of a PSU This is my starting point - Oracle Database 12.1.0.2 with PSU October 2015, the last state...

Tuesday, May 3, 2016 | Patch Recommendation | Read More

Upgrade to Oracle Database 12c: We don't insist :-)

It's so funny - for years I discuss with customers minimal downtime upgrade strategies back and forth, up and down. I saw DBAs really hunting to save a few seconds potential downtime - and I always take this serious as there is usually a real reason behind that. Just to learn a few days later by repeating experience that my work Windows7 laptop goes down to apply upgrades ... and this takes looooooooong .... sometimes it takes a lengthy +30 minutes of quiet time. Whereas my...

Friday, April 29, 2016 | Oracle Database 12c | Read More

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 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 12.1.0.2: ...

Thursday, April 28, 2016 | Flaws and Pitfalls | Read More

MOS Note 1454618.1: Quick Reference to Database PSUs, CPUs, BPs and Patchsets

Sometimes my mouse arm gets tired by clicking myself through MOS notes just to download a specific PSU or BP - and as I experiment a lot with PSUs and BPs right now I clicked a lot in the past days and nights.  Usually I'd start with either MOS Note:161818.1 - then click on the release link (e.g. 12.1.0.x) in the left-most column, then into the Availability and Known Issues not (e.g. MOS Note:1683799.1 for Oracle Database 12.1.0.2.0) and then select the most recent patch from...

Tuesday, April 26, 2016 | Patch Recommendation | Read More

New PREUPGRD.SQL is available - Upgrade 12c - Apr16

It's time for a new and improved version of our team's preupgrd.sql (comes with the preupgrade package utluppkg.sql).  The April 2016 preupgrd.sql  Please always download and use the most recent version from: MOS Note:884522.1 How to Download and Run Oracle's Database Pre-Upgrade Utility as this version is 3 years newer than the one you'll get with a fresh install of Oracle Database 12.1.0.2 . Included in the April 2016 PSU and BP as well Great news - and very important. Once you...

Friday, April 22, 2016 | Best Practice | Read More

Oracle Database BP April16 applied successfully

Usually I don't post twice a day but as my post scriptum for the previous blog post got longer and longer I decided to write an entry about it - maybe simply because I feel soooo happy that my patch application succeeded flawless. For many of you the following steps may look very boring as you have done this many times. But I use the blog also to brain-dump information for myself ;-) And for those who'd like to play with it, I summarized the steps fitting exactly into our...

Thursday, April 21, 2016 | Patch Recommendation | Read More

Oracle April 2016 PSU and Proactive BPs are there

Hurray, it's Patching Day! Sounds a bit like D-Day ;-) But April 19, 2016 the most recent April PSUs (Patch Set Updates) and BPs (Bundle Patches) got released. Find all the necessary information with the below links:  Critical Patch Update - April 2016 Patch Availablity - Oracle Database - April 2016 The important change in the April PSU/BP release: The database patch for "Engineered Systems and Database In-Memory 12.1.0.2" luckily got renamed into "Proactive Bundle...

Thursday, April 21, 2016 | Patch Recommendation | Read More

Data Pump - Exclude Stats differently for TTS and FTEX

Nice little best practice for statistics and Data Pump when doing either Transportable Tablespaces or Full Transportable Export-Import (credits to Roy and Dean Gagne). . Transport Statistics via a Staging Table First of all we always recommend to exclude statistics when doing a Data Pump export as the import of such stats takes way longer than transporting them via a stats table. If you are unfamiliar with transporting stats between databases please see the Oracle Performance...

Wednesday, April 20, 2016 | Data Pump | Read More

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 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 creating modify_ts_pdbinc_key_not_nullRMAN-00571: ==============================...

Tuesday, April 19, 2016 | Flaws and Pitfalls | Read More