If I may offer some guidance here based on Oracle internal experience and
customer deployment experiences....
differentiate container from content. The container name CDB/SID, should be an
abstraction that should reflect ownership (ex. LOB), or geographic location or
version or some attribute specific to the container such as service level,
etc... The PDB name should reflect content and deployment use (prod, test, dev,
UAT...). The point here really is that you don’t want to bind the PDB name to
the hosting container as that could change.
This is not hard and fast policies but intended as guidance. Keep it simple and
try to preserve these distinctions and where possible, global uniqueness in
naming conventions.
hope this helps,
jpm
I struggled with this as well. I was going to try something like
TVPRODCDB, but the pdbs may not relate as you stated. I ended up keeping the
pdb names the same as the database name from prior versions (e.g. TVPROD),
this way the applications could use the same tns entry. Of course the tns
entries can be called anything you like but I like for them to match the
container name for clarity sake. The cdb name I named similar to the host
server (e.g. PRODSERVDB01). Which of course is generic and confusing but
allows for the cdb name to be unrelated to its pdbs. I spent way too much
time thinking about this, but I like having consistent naming conventions.
I'm still not happy with the cdb name, but it was the best I could come up
with.
Jay
Sent from my iPhone
On Jul 15, 2016, at 2:22 PM, Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
wrote:
Out of curiosity, how do you guys name your CDBs and PDBs in relation to
each other?
For example, prior to 12c I might have TV Shows Databases called TVDEV,
TVTST, TVPROD.
In the CDB/PDB world, I would assume I would name my PDBs TVDEV, TVTST,
TVPROD and I would NOT have them in the same container as they would exist
on dedicated dev, test, prod servers.
So I'm what some of you guys are doing - I realize the CDB is the instance
name so for single PDB tenant databases, I would probably call both the
container and the PDB TVPROD (but I'm betting they have to be different
names?)
In a world of disparate PDBs in one container, I might call my container
MISHMASH since the container may not really relate to the individual PDBs it
contains.
Chris
