Oracle And Cloud

I have upgraded my 2 node RAC to 19.8 from 12.2 using GUI Method. But I want to create a blog post of upgrade using silent method. So, I am downgrading my RAC Grid Home from 19.8 to previous 12.2 version. My environment [oracle@OEL7N1 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [oel7n1] is [19.0.0.0.0] [oracle@OEL7N1 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] [oracle@OEL7N1 ~]$ crsctl query c

crsctl query crs softwarepatch showing different output in different nodes. [oracle@OEL7N1 ~]$ crsctl query crs softwarepatch Oracle Clusterware patch level on node oel7n1 is [1831702305]. [oracle@OEL7N1 ~]$ crsctl query crs activeversion -f Oracle Clusterware active version on the cluster is [12.2.0.1.0]. The cluster upgrade state is [ROLLING PATCH]. The cluster active patch level is [0]. [oracle@OEL7N2 ~]$ crsctl query crs softwarepatch Oracle Clusterware patch level on no

While applying 12.2 Apr 21 PSU (12.2.0.1.210420), it fails with "Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Re-link fails on target "install_srvm" Execution of [OPatchAutoBinaryAction] patch action failed, check log for more details. Failures: Patch Target : oel7n2->/grid/app/oracle/12.2 Type[crs] Details: [ ---------------------------Patching Failed--------------------------------- Command execution failed during patching in home: /grid/app/oracle/12.2,

I have recently faced this issue. While patching my newly built 12.2 RAC in rolling mode using opatchauto, it fails with following error. After quite a bit of research, found it to be a bug. Bug 26367944 - LNX-12201.170718GIRU:OPATCH SHOULD VALIDATE NONROLLING ON ONE HUB NODE CLUSTER Oracle Note Id : Opatchauto fails with OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode on single node cluster (Doc ID 2336186.1) Solution I ran it like the following. [root@OE

Login to Amazon AWS Console and Open Amazon RDS Section Follow the following steps to create a RDS PostgreSQL Database Click on Create Database Note: Version 13 doesn't have Free Tier Option. So, this will be chargeable. Use the smallest configuration. For this post, we are using Public Access as Yes. In real life scenario it should be always No. Click on Create Database, It will create the Database. Make sure to delete the database after doing your learning as this will incu

This post will explain the installation process of PostgreSQL 13 in redhat linux 8 We are following the yum/dnf method of installation here. Create a VM in Local Machine using Virtualbox/Vmware/Hyper V or create a ec2-instance/VM in cloud. Here I am using a local VM using Virtualbox. 2. We need to download the repo first. dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm 3. We can check the repolist by running th