Database - RAC/Scalability (MOSC)

MOSC Banner

Instance name of pluggable database in RAC

edited Mar 23, 2016 5:02AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center