Oracle Multitenant and OMF - GUID Name vs PDB SID Name

From: Alfredo Abate <alfredo.abate_at_gmail.com>
Date: Wed, 21 Apr 2021 16:33:44 -0500
Message-ID: <CALrB5pqbF+RdWYyMYDQd+ykaNTkGuMAs_2j4J9CM-XsUSKp+xA_at_mail.gmail.com>

Hi,

I'm a little late to the game, but finally getting knee deep with pluggable databases for some of our systems. This particular installation is Oracle Linux 7 and 19c database. I'm using Oracle Managed Files (OMF) and what I've found is that the PDB SID is not used but the GUID is for the directory name for the datafiles.

Expected: /u03/app/oracle/oradata/CDBDEV/pdbdev/datafiles

Created:
/u03/app/oracle/oradata/CDBDEV/BFE6E37933E00DF1E053AF15DC0A2DF9/datafiles

Is there any way to change this behavior with OMF and PDBs or is this just the nature of how it works? It would be easier to have the PDB SID name than trying to remember which GUID belongs to which PDB (without looking it up).

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 21 2021 - 23:33:44 CEST

This message: [ Message body ]
Next message: Mladen Gogala: "Re: [External] : Re: Where is 19.11?"
Previous message: Jack Applewhite: "Re: Recommendation for Oracle Monitoring tool"
Next in thread: Jeff Chirco: "Re: Oracle Multitenant and OMF - GUID Name vs PDB SID Name"
Reply: Jack van Zanen: "Re: Oracle Multitenant and OMF - GUID Name vs PDB SID Name"
Reply: Jeff Chirco: "Re: Oracle Multitenant and OMF - GUID Name vs PDB SID Name"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message