Clear inactive sessions and stop n start pluggable database

Clear inactive sessions and stop n start pluggable database Script To Clear inactive sessions, To restart pluggable database [oracle@EXADB_SRVR tmp]$ cat /home/oracle/clear_inactive_sessions.sh#!/bin/sh export ORACLE_SID=ORCL1export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1export PATH=$ORACLE_HOME:$ORACLE_HOME/bin:$PATH:.export TWO_TASK=ORAPDB1 sqlplus pdb_admin/******** <<

GI rolling upgrade from 19.12 to 19.15 on RAC

Step by step procedure to upgrade Grid infrastructure from 19.12 to 19.15 on RAC. Oracle Grid infrastructure from 19.12 to 19.15 on RAC in a rolling method. download Patch: 33803476

Script for DB Services and ASM Disk info

Automation Solution for DB Services and ASM Disk info. Capturing Database Services details and Automatic storage Management (ASM) Disk info  has been automated to minimize startup and  post maintenance issues.100%

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

Step by Step procedure for dry-run upgrade on RAC

Step by Step procedure for Oracle Grid Infrastructure dry-run upgrade on RAC Linux. Oracle Grid Infrastructure dry-run upgrade mode enables you to check system readiness for upgrade. Purpose of the

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

One-off patch on Oracle 19.15 RAC nodes on Linux 7.9

One-off patch on Oracle 19.15 RAC nodes on Linux 7.9 to fix internal error ======================================================================== Apply one off patch on RAC in a rolling fashion===================================================== OS: Linux 7.9 RedhatDB :