Ok so I am trying to get up to speed on 12c and CDB and PDB. I have installed 12.1.0.2 on Oracle Linux 7. I have it up and running. When i connect via the following connection i get these queries and i believe this is my CDB.
| orcl | sys@//10.0.10.102:1521/orcl.localdomain |
when i run select cdb from v$database I get
CDB
YES
When i run SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
CDB$ROOT
PDB$SEED
PDBORCL
and if i run select * from dba_data_files
I get
/u01/app/oracle/oradata/orcl/users01.dbf
/u01/app/oracle/oradata/orcl/undotbs01.dbf
/u01/app/oracle/oradata/orcl/system01.dbf
/u01/app/oracle/oradata/orcl/sysaux01.dbf
Now this makes me think I am connected to my CDB.
Well if i connect to
| pdborcl | sys@//10.0.10.102:1521/pdborcl.localdomain |
when i run select cdb from v$database I get
CDB
YES
and then i run SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
I get
PDBORCL
Then when i run select * from dba_data_files
I get
/u01/app/oracle/oradata/orcl/pdborcl/example01.dbf
/u01/app/oracle/oradata/orcl/pdborcl/SAMPLE_SCHEMA_users01.dbf
/u01/app/oracle/oradata/orcl/pdborcl/sysaux01.dbf
/u01/app/oracle/oradata/orcl/pdborcl/system01.dbf
Ok so I get separate datafiles, separate queires except when i run the chekc to see if it is cdb. What gives? Thanks for your help.