DBCA 12.2 does not update /etc/oratab in GI / RAC

Interesting things happen. And I learned (credits to Arun Gupta and others) that there is a change in Oracle Database 12.2 environments I wasn’t aware: The DBCA 12.2 does not update /etc/oratab in GI / RAC environments. Let me give you some extra information and hints on this topic as it may cause some strange situations. DBCA 12.2 does not update /etc/oratab in GI / RAC Arun Gupta commented on the blog: Another case in point. DBCA fails to update the /etc/oratab file in 12.2 when a database is created. There is no documentation of this behavior. So, I opened…

Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes

This blog post title sounds a bit weird, doesn’t it? Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes. Why the heck should you patch your 12.1.0.2 database homes upfront? Oracle 12.2.0.1 RESTART: Make sure you’ve patched your Oracle 12.1.0.2 homes Well, there’s an interesting issue happening. When you work with Oracle Grid Infrastructure, no matter if you operate a cluster or “just” use Oracle Restart, you’ll have to upgrade GI to Oracle 12.2 first before you can manage 12.2 databases with it. That’s not new. It’s a well understood rule. Now guess you operate Oracle RESTART (SIHA…

Keep your patch versions between Grid Infrastructure and Databases Homes in synch

I’ve had some interesting discussions with Anil Nair, our RAC Product Manager and a customer in the past days. The customer was looking for a definite statement that they can have a higher version of Patch Set Updates (PSUs) or Proactive Bundle Patches (BPs) in the Database homes than in the Grid Infrastructure home managing the resources. Can you have different PSU/BP versions between Database and GI homes? Yes, you can have a higher version PSU or BP in the Database home than in the Grid Infrastructure home managing the resources. This is implicitly documented in MOS Noteย 337737.1 – Oracle…

Grid Infrastructure PSU Jan 2015 – Am I too intolerant?

Germans are not only known for being precise and timely – but sometimes also for being too direct. Well, Roy could tell you stories … and I always honor his politeness ๐Ÿ™‚ Enough about stereotypes. I work with a customer at the moment on their 12c upgrades. And I did recommend the most recent PSU (Patch Set Updates) for their Grid Infrastructure environments running Oracle Restart. Same of course for the database homes but this blog post will just name some findings I’ve had the other night when trying to apply the January 2015 GI PSU to my Oracle Restart…

PSU1 and PSU2: Datapatch Issues coverd in MOS Note

You may have read a posting dis-recommending PSU1 and PSU2 for Oracle Multitenant 12.1.0.1 especially in RAC/GI environments earlier this week. Actually following a lot of internal discussions I will post some advice and clarification later this week. Now I have an useful update: Datapatch Issues are covered within a separate MOS Note making it easier to keep track and find workarounds for known issues. Please see MOS Note:1609718.1 Datapatch Known Issues -Mike

Upgrade to Grid Infrastructure – but OCR and VOTING on RAW?

Just received this question from a colleague these days: “The current customer environment is 10.2.0.5 on Linux with a 2 node RAC cluster having OCR and Voting Disks on RAW devices. Customer is concerned about the possibility of upgrading to 11gR2 Grid infrastructure first before they could upgrade to 12c Grid infrastructure.” Now the answer is written down in MOS Note 1572925.1: How to Upgrade to 12c Grid Infrastructure if OCR or Voting File is on Raw/Block Devices Basically the MOS Note says: You will have to relocate your OCR/Voting to a supported device BEFORE you can upgrade to Oracle…

Recap on Deinstall Routines

A few weeks ago I’Ve posted something about the deinstall utility as OUI doesn’t offer a “deinstall software” option anymore: How to deinstall “old” SW after 11.2.0.2 has been applied? And I’ve got some feedback (which is a good sign as it means that some of the content might be useful and will be read – and from the follow-up you see that we’ll read your comments and emails as well ๐Ÿ™‚ ). Anyway, the feedback was either CRS deinstall does not work the right way or deinstall cleans up too many things. So Roy did follow up with our…