Database - RAC/Scalability (MOSC)

MOSC Banner

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center