Oracle And Cloud

Apr 28
11 min

Downgrade 19c Grid to 12.2 in an Oracle RAC environment.

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

194 views0 comments

Sudipta Bhaskar

Apr 26
12 min

Softwarepatch level different in RAC nodes after GI PSU apply

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

57 views0 comments

Sudipta Bhaskar

Apr 25
23 min

Apr 21 PSU fails "oracle.opatch.opatchsdk.OPatchException: Re-link fails on target "install_srvm"

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,

62 views0 comments

Apr 21 12.2 GI PSU fails with "OPATCHAUTO-72141: Grid is installed only on a single node"

Sudipta Bhaskar

Apr 22
1 min

Apr 21 12.2 GI PSU fails with "OPATCHAUTO-72141: Grid is installed only on a single node"

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

10 views0 comments

Create Amazon RDS PostgreSQL and Connect using psql and pgadmin

Sudipta Bhaskar

Apr 13
1 min

Create Amazon RDS PostgreSQL and Connect using psql and pgadmin

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

26 views0 comments

Install PostgreSQL 13 using yum/dnf in redhat linux 8

Sudipta Bhaskar

Apr 4
3 min

Install PostgreSQL 13 using yum/dnf in redhat linux 8

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

18 views0 comments

sudipta.bhaskar@gmail.com

CONTACT

+919811970620