Thanks for your reply. I resolved myself. Using CON_DBID. This is also a
column on V$DATABASE. I was not aware of this till few minutes ago... :-D
On CDB:
*U71013576@P11CDB6.ecc03cas06vm01 [18c RAC] r 1 select 2 sys_context
('userenv','CON_DBID') CON_DBID, 3 sys_context
('userenv','DB_NAME') DB_NAME, 4 sys_context ('userenv','DBID')
DBID, 5 sys_context ('userenv','DB_UNIQUE_NAME') DB_UNIQUE_NAME
6* from dualCON_DBID DB_NAME DBID
DB_UNIQUE_NAME-------------------- --------------------
-------------------- --------------------2416754358 P11CDB
2416754358 P11CDB*
On PDB:
*U71013576@P00NGP/P11CDB6.ecc03cas06vm01 [18c RAC] r 1 select 2
sys_context ('userenv','CON_DBID') CON_DBID, 3 sys_context
('userenv','DB_NAME') DB_NAME, 4 sys_context ('userenv','DBID')
DBID, 5 sys_context ('userenv','DB_UNIQUE_NAME') DB_UNIQUE_NAME
6* from dualCON_DBID DB_NAME DBID
DB_UNIQUE_NAME-------------------- --------------------
-------------------- --------------------630270457 P00NGP
2416754358 P11CDB*
Em seg, 30 de set de 2019 às 15:52, Mladen Gogala <gogala.mladen@xxxxxxxxx>
escreveu:
I would not use DBID column for PDB databases. I would use GUID column
which is guaranteed to be unique.
On 9/30/19 1:13 PM, Luis Claudio Dias dos Santos wrote:
Hi
I have a CDB with two PDBS.
U71013576@P11CDB6.ecc03cas06vm01 [18c RAC] select sys_context
('userenv','CON_NAME') from dual;
SYS_CONTEXT('USERENV','CON_NAME')
---------------------------------------------------------------------------------------------------
CDB$ROOT
In other words: ('userenv','DBID') is not following
('userenv','DB_NAME'), but ('userenv','DB_UNIQUE_NAME').
You can adopt unique names. I have an inexhaustible reservoir of DB names:
"NANCY", "MITCH", "ADAM", "AOC","LINDSAY","ILHAN", "RAND". You can combine
them as you like. The funny thing is that when I get sick of these names, I
will get another batch. Every 2 years the set gets renewed.