Hey readers, if you remember, last post was about how to create physical standby database in Oracle 19c And there I mentioned that you have to install the binaries on your DR server. And apply same patch as that of production. Earlier when we were on 11g we used to download the Oracle Binaries and…
How to Create Physical Standby Database in Oracle 19c
Hey Reader, today we will be covering how to create physical standby database in oracle 19c. This won’t be a regular request coming into your email unless you work in Project team where you create Primary database for new application and based on business request you will create it’s Physical standby database. I will try…
How to Upgrade Oracle Grid Infrastructure from 12c to 19c ( RAC ) in Rolling Fashion
Today, We will learn upgrade in rolling fashion, which means, you will have one instance of the database available to the end user. I will cover each and every slide and steps I followed in detail. In case you are looking for how to upgrade oracle grid infrastructure (ORACLE RESTART) from 12c to 19c Before…
How to Complete Grid Infrastructure Upgrade when GUI is lost
It is always a trouble maker for us, when we lost the internet connection, server get rebooted, or your own machine/laptop gets rebooted while doing Oracle installation/cluster upgrade.So when you are upgrading your grid infrastructure from 12c to 19c, rootupgrade.sh take 30mins-45mins to complete per node. So till then your GUI session will be unattended….
How to Upgrade GI Single Instance ASM from 12c to 19c
Last year we did Grid Infrastructure upgrade activity for RAC database as well as Single Instance ASM database server. We were upgrading 12c GI to 19c GI. Here we will discuss how to upgrade GI for Single Instance ASM (Oracle Restart) using GUI with complete slides. If you are looking for how to upgrade oracle…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
When you are patching RDBMS home/ Grid home, sometimes you might have encountered Prerequisite check “CheckActiveFilesAndExecutables” failed. error where your opatch failed . Similarly you have came across when you actually fired opatch apply and command came out as an error – In this example – I was patching RDBMS home 19c with April 2021…
How to Upgrade OPatch Utility
Today we will cover where, why and how to download OPatch utility and how to upgrade the current version of the Utility to latest one. It’s a easy task and same procedure is followed from 10g ( I have worked only from 10g hence I am confirming from 10g. If you have done this same…
How to Manually downgrade a database (Non CDB) from 19c to 11g
I have been told that, there are lot of blogs on How to manually upgrade a database from 11g to 19c but there are very few blogs which has action plan about how to downgrade a database from 19c to 11g. I would like create one for you. Along with that I have seen many…
How to Manually Upgrade Database (Non-CDB) from 11g to 19c
PRECHECKS -> 1 Minimum version of the database that can be directly upgraded to Oracle 19c Source Target 11.2.0.4 19c 12.1.0.2 19c 12.2.0.1 19c 18.1 19c 2 Changes in 19c need to be discussed with Application Teams There are lot of changes in 19c like – utl_file_dir, streams, oracle multimedia are de-supported, do check with…
ORA-38701:Flashback database log 1 seq 1 thread 1 and ORA-27037: unable to obtain file status
Hello Readers, I know I was away from blog due to personal issues. Now it is resolved and we are back to posting. Today, we found an issues on UAT server where someone removed the /FRA mount point which was given to us for Flashback logs. Background story 1 DB had 1 restore point2 DB…