Downgrade GI from 19c to 12.1 in an Oracle RAC

Downgrade Grid Infrastructure from 19c Grid to 12.1 on Oracle RAC environment. 1) run below 2 commands on both the nodes using grid user — crsctl query crs activeversion— crsctl

Oracle Clusterware cannot be started

Error Received: Oracle Clusterware cannot be started : CRS-6706: Oracle Clusterware Release patch level (‘3909003374’) does not match Software patch level (‘3998055650’).CRS-4000: Command Start failed, or completed with errors. Error

How to deinstall 12201 GRID HOME

Step by step procedure to deinstall 12201 GRID HOME. It is mandatory activity for Oracle DBA to uninstall the old version if it is not in use . Otherwise there

How to find the Exact Pluggable Database Name ?

To find the Exact Pluggable Database Name : [oracle@EXADB_SRVR bin]$ ./srvctl config service -d ORCL1 -s ORCL.xyz.comService name: ORCL.xyz.comServer pool:Cardinality: 2Disconnect: falseService role: PRIMARYManagement policy: AUTOMATICDTP transaction: falseAQ HA notifications:

How to disable OLAP option in Oracle

To Disable Online Analytical Process (OLAP) option in Oracle. Step 1)Database version 11g Release 2 and newer col parameter format a15 col value format a15 select * from v$option where

Issues & Fixes while upgrading GI from 12c to 19c

Issues & Fixes while upgrading GI from 12c to 19c. Issues & Fixes while upgrading GI from 12.1.0.2.0 to 19.14.0.0.0 RAC environment.Source GI version: 12.1.0.2.0Target GI Version: 19.14.0.0.0 Our Plan

How to drop Oracle database?

To drop Oracle database… oracle@ORASRVR:/u00/app/oracle/ [ORCL] sqlplus “/as sysdba” SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 12 17:38:21 2022 Connected to an idle instance.   SQL> startup mount restrictORACLE instance

How to modify Instance name in CDB?

To modify Instance name in Container Data Base Environment: CDBUnique DB= UORCLOLD Instance name: OINSTNew Instance name: NINST Syntax: $srvctl modify database -db -instance Command: $srvctl modify database -db UORCL