While upgrading Grid Infrastructure (GI) from 12.1.0.2 to 12.2.0.1, gridSetup.sh reports missing pre-requisite patch 21255373 even though patch is already available
$ /u01/app/12.1.0/grid/OPatch/opatch lsinventory|grep 21255373
22393909, 21255373, 25164540, 18868829, 20408163, 20579351, 20350915
It is a bug. the workaround is to use ‘gridSetup.sh -skipPrereqs’ after verifying all other pre-requisites successfully.
$ /u01/app/12.2.0.1/grid/gridSetup.sh -skipPrereqs
One of the RAC instance is up, but the rest RAC instances failed to start up.
$sqlplus / as sysdba SQL> startup; ERROR at line 1: ORA-01102: cannot mount database in EXCLUSIVE mode
Read more of this content when you subscribe today.
When startup a RAC database or its instances, and get “ORA-00449: background process ‘RBAL’ unexpectedly terminated with error 448”.
Checked all cluster resources are ONLINE.
SQL> startup ORA-00449: background process 'RBAL' unexpectedly terminated with error 448 SQL>
Read more of this content when you subscribe today.
[oracle@racnode1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Jan 13 16:31:25 2020 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12547: TNS:lost contact Enter user-name: ERROR: ORA-12547: TNS:lost contact
Read more of this content when you subscribe today.
Here is an example of how to drop an ASM disk group.
On racnode1:
SQL> connect / as sysasm Connected. SQL> drop diskgroup ocr; drop diskgroup ocr * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup OCR is mounted by another ASM instance
On racnode2 ASM instance.
SQL> alter diskgroup ocr dismount; Diskgroup altered. SQL>
Back to racnode1 ASM instance, and drop the diskgroup ocr, which is not longer used and required. There are options:
INCLUDING CONTENTS:You must specify this clause if the disk group contains any files.
EXCLUDING CONTENTS: To ensure that Oracle ASM drops the disk group only when the disk group is empty. This is the default. If the disk group is not empty, then an error will be returned.
FORCE: Clears the headers on the disk belonging to a disk group that cannot be mounted by the Oracle ASM instance. The disk group cannot be mounted by any instance of the database.
SQL> drop diskgroup ocr; Diskgroup dropped. SQL>
Find the ASM disk label:
[root@racnode2 ~]# /sbin/blkid ... .. . /dev/sdi1: LABEL="ASM_OCR_VOTE" TYPE="oracleasm" ... .. .
Delete the asm disk “ASM_OCR_VOTE” on one node only:
[root@racnode1 ~]# oracleasm deletedisk ASM_OCR_VOTE Clearing disk header: done Dropping disk: done [root@racnode1 ~]# [root@racnode1 bin]# oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks... Cleaning disk "ASM_OCR_VOTE" Scanning system for ASM disks...
Remove vdi file from VirtualBox.
Make DBA Life Easy 