Adding asm disk 19c database
Hi Experts,
We have recently upgraded 2 node RAC non-cdb to CDB with single pdb.
We have created asm disk UAT19C-OCR1p1 and trying to add to diskgroup.
[root@erpuatdb1 mapper]# grep -i UAT19C-OCR a.txt
/dev/mapper/UAT19C-OCR1p1: LABEL="OCR19C1" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="5d18a5df-f66e-48e0-8700-45d016f30ab2"
[griduat@erpuatdb1 ~]$ sqlplus "/as sysasm" SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 1 09:56:12 2023 Version 19.17.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.17.0.0.0 SQL> desc v$asm_diskgroups ERROR: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 UATDB READ WRITE NO------------------->PDB SQL> SQL>