This is the right blog post for a Friday 13th. And please forgive me – I wanted to put this on the blog earlier as two of my customers hit this weeks ago already. But it must have fallen through the cracks. Still, now it is hopefully not too late to tell you what you should do if you hit ORA-29702 – and your instance does not startup in the cluster anymore. Especially when you tested a database upgrade – and after a restore, the database doesn’t want to start, no matter what you try.… Continue reading...
This was the question I received the most often during the Virtual Classroom web seminars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.
Recap – EBS and Oracle 19c
In September 2019, right before Oracle Open World, we announced the certification of EBS …Continue reading...
To be very honest, when I posted a few days ago, Oracle Database 19c is certified on OL8/RHEL8 I didn’t check for the Oracle Clusterware (OCW) certification. I blindly assumed that this is the case. But from comments and discussions on twitter, I realized it may be necessary to point this out explicitly to avoid confusion. Even though my fellow mate, RAC Product Manager Anil Nair has pointed it out already many times: Of course, Oracle Clusterware is certified on OL8/RHEL8 as well.
Find it on MOS
Your source for certification information …Continue reading...
Thanks to all our customers who participated in our evaluation test for RAC upgrade support with the AutoUpgrade Tool. And my colleagues worked hard to deliver the new version as quickly as possible. Just to make sure: This is not an April’s fools blog post. Since 2 days, you can download AutoUpgrade – New Version with RAC Database Upgrade Support.
Where to download it?
As usual, you can download the newest version – in this case 19.8 aka 20200327 from MOS Note: 2485457.1:
You simply copy the new version into your 19c (or …Continue reading...
Internally we can use a Gold Image service at Oracle. I can download a zip with 19.6.0 included. But externally for you as customers, the download of 19.6.0 required that you download 19.3.0 at first, then apply 19.6.0 on top of it. But a day ago, a tweet by my Belgium friend Philippe Fierens caught my attention. Do we offer patched Gold Images already?
What is a Gold Image?
Since Oracle 18c, the installation routine has changed to the better. You download zip file containing the Gold Image, you create a directory and …Continue reading...
I need to bring this blog post forward about AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB. Initially I planned to write this a bit later. But some of you had questions or were wondering why AutoUpgrade hasn’t done certain tasks. Hence, I’d like to clarify what AutoUpgrade can do, what it can’t and what you’ll have to do at the moment.
I refer to the AutoUpgrade tool as of July 2019. In later versions, one or the other restriction may be lifted. I will blog about it then as well.
AutoUpgrade – Step-by-stepContinue reading...
This blog lives a lot from customer’s feedback and updates. And these days, Nicolas Jardot from dbi-services in Switzerland sent me an email asking: Where does the database link SYS_HUB come from? And if he can delete it or if it has any deeper purpose. Neither Google nor MOS reveal a lot of useful information
Where does the database link SYS_HUB come from?
I took my vanilla 18.3.0 database in our hands-on lab and check:
column owner format a5 column db_link format a12 column username format a12 column host format a12 select con_id, owner, db_link, username, host from cdb_db_links; CON_ID… Continue reading...
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:
… Continue reading...
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
Very good news for all customers using Oracle RESTART:
The Oracle RESTART deprecation announcement got withdrawn.
I have blogged in the past several times about Oracle RESTART of course either regarding upgrade, downgrade and patching:
And one of the customers I work with for quite a while, Swiss Mobiliar Insurance uses Oracle RESTART for all their Oracle Database environments:
The question all customers I deal with who use Oracle RESTART: How long will Oracle support it? And will there be a successor …Continue reading...
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.
For Oracle Database 18c, 19c and onward, please read instead:
Can you have different PSU/BP versions between Database and GI homes?
Yes, you can have a higher version PSU …Continue reading...
++++++ 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.
… Continue reading...
In der praxisorientierten “Noon2Noon”-Veranstaltung wollen wir uns mit den Herausforderungen beim Upgrade nach Oracle 12c bzw. Oracle 12c Release 2 (falls diese zu diesem Zeitpunkt für On Premises Datenbanken freigegeben ist) auseinandersetzen. Das ungewöhnliche Format zielt auf Lösungsorientiertheit. Bei
Last week at the upgrade workshop in Budapest a customer had a interesting and – I believe – not uncommon question.
“How can I upgrade my Linux Operating System in my RAC environment without taking the entire cluster down?”
In this specific case the customer wanted to upgrade from RHEL 5.10 to RHEL6 or RHEL7.
Let’s assume it’s the typical 2-node-RAC where one wants to upgrade in a rolling fashion. And the data is stored within ASM.
- Drain Node 1 (i.e. take the workload off) – this will be the node getting upgraded first
- Remove Node 1 from the cluster
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 …Continue reading...
During the installation of Oracle Grid Infrastructure 22.214.171.124 you’ve had the an option to choose YES/NO to install the Grid Infrastructure Management Repository (GIMR) database MGMTDB – but as of Oracle 126.96.36.199 Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 188.8.131.52:
GIMR database now mandatory in Oracle GI 184.108.40.206
With Oracle Grid Infrastructure 220.127.116.11 this choice has become obsolete and the above screen does not appear anymore. The GIMR database has become mandatory.
What do we stored in the GIMR?
- You’ll find it in the Oracle 18.104.22.168 documentation via this link.
In addition please see the …Continue reading...
You may have read a posting dis-recommending PSU1 and PSU2 for Oracle Multitenant 22.214.171.124 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
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
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 …