Re: Oracle Multitenant and OMF - GUID Name vs PDB SID Name
Date: Fri, 23 Apr 2021 10:16:44 +1000
Message-ID: <CAFeFPA9U3_s1X0DWVEGqbxTqGyJw44yOp=WO_0HaemohxbR8sw_at_mail.gmail.com>
I think it is the nature of the beast...
Just thinking about it.. it is fairly simple to rename a PDB and without using the unique ID that could get messy Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Thu, Apr 22, 2021 at 7:34 AM 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-lReceived on Fri Apr 23 2021 - 02:16:44 CEST