Re: Oracle Multitenant and OMF - GUID Name vs PDB SID Name

Following this thread. I discovered this as well when I started testing pluggable databases but that project stopped. Going to be picking that back up here soon so I would love to know if you find a solution to this.

Jeff

On Wed, Apr 21, 2021 at 2:33 PM Alfredo Abate <alfredo.abate_at_gmail.com> wrote:

> 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).
>
> Thanks,
>
> Alfredo
>

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