Instance name of pluggable database in RAC
I've a 3 node cluster as you can see below.
SQL> select inst_id,instance_name,host_name from gv$instance;
INST_ID INSTANCE_NAME HOST_NAME
---------- ---------------- ---------------------------------
3 CONTDB3 rac3
2 CONTDB2 rac2
1 CONTDB1 rac1
I ran the query on same node as above
SQL> select inst_id,name,open_mode from gv$pdbs;
INST_ID NAME OPEN_MODE
---------- ------------------------------ ----------
3 PDB$SEED READ ONLY
3 PLUGDB READ WRITE
2 PDB$SEED READ ONLY
2 PLUGDB MOUNTED
1 PDB$SEED READ ONLY
1 PLUGDB READ WRITE
6 rows selected.
Why I don't see PLUGDB1, PLUGDB2, PLUGDB3, and PDB$SEED1,2,3 on 3 node cluster?
Thanks