This is second part of 26ai migration blog. We will upgrade here one node Clusterware with ASM in 19c. We will use newest 23.26.1 GoldImages from oracle support. This tutorial showing main steps how to perform upgrade, its not procedure to upgrade your production environment, please checkout official documentation from oracle do proper planning and prechecks before you do it.…
By Mouhamadou Diaw In this previous blog , we deal with Oracle Restart and ACFS. We saw that using ACFS with Oracle Restart will require some manual tasks. The solution is to install a Grid Infrastructure for a cluster, even if we are only using one node. I am using the same configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel…
By Mouhamadou Diaw In this blog we are going to install an Oracle Restart 19c with ASM Filter Driver (AFD). I am using following configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel 4.14.35-1902.2.0.el7uek.x86_64 Once the Oracle Restart installed, I will create an ACFS filesystem We will have to configure following disks for AFD -/dev/sdc -/dev/sdd The Oracle downloaded software was…
Mouhamadou Diaw Last day I was configuring grid infrastructure 11.2.0.3 for a standlone server. After the installation, I decided to apply the Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) – 16742216 In the documentation it is marked You must use the OPatch utility version 11.2.0.3.4 or later to apply this patch. Verifying my opatch version, I see that I…
By Mouhamadou Diaw In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of my operating system root@dbserver /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) root@dbserver ~ $ uname…
This week I needed to install Oracle Grid Infrastructure 12c release 1 in a SLES 12 SP1 environment. Everything worked fine until I ran the root.sh at the end of the installation. Here’s a quick description of the problem and the workaround. The root.sh script ran into error and the installation was completely unsuccessfull: oracle:/u00/app/grid/12.1.0.2 # /u00/app/grid/12.1.0.2/root.sh Performing root user…
By Franck Pachot . As in the previous posts, here are a few commands I used to check that I know how to restore the cluster mandatory files in 12c. It’s what I’m doing while preparing the OCM 12c exam, but without any clue about what will be at the exam. For more details, it’s in the MOS note 1062983.1…
A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to do so. Currently my cluster is running Grid Infrastructure 12.1.0.1 without any PSU applied. The node names are racp1vm1 and…
I promised to upload the scripts of my session to our blog. So, here they are: create_12102_gi_rac_project.sh: This one creates the 12.1.0.2 GI/RAC project on the cobbler server finish_ora_12102_gi_rac_project.sh: This one does the configuration of the GI/RAC on the last node ora12102_gi_rac.ks: The 12.1.0.2 GI/RAC kickstart file pg940.ks: Template kickstart file for PostgreSQL 9.4 create_940_postgres_project.sh: Template project file for PostgreSQL…
As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs. The question is what could we do with it and which performances could we expect… The answer to the first question is indeed pretty simple….almost everything. If you have and ODA…
Making errors is human and when you configure a new Oracle Grid Infrastructure environment (especially one with a large number of nodes), mistakes can happen when configuring ASMLIB on all nodes. If you get an error looking like”PRVG-10122 : ASMLib configuration…does not match with cluster nodes”, there is a simple solution to fix it. When you are installing Grid Infrastructure,…
In this post, I will continue my experiments with Oracle policy managed databases with Grid Infrastructure, and present one of the new features introduced with Grid Infrastructure 12c last June: the cluster configuration policies and policy sets. It allows the administrator to dynamically reconfigure all server pools at a time, with a single command, according to the business workload. To…
