Hi,
I would like to know is there any way from which we can find the list of all PDB's for a particular CDB.
Generally without connecting to sqlplus, I can find the list of all ORACLE_SID or instance from '/etc/oratab' on a particular machine.
But for container database, /etc/oratab file just has the SID for root CDB.
Even in cluster 'srvctl' doesn't tell anything about the number of or list of all PDB's for that particular instance.
ex: I know CDB is SID of Container Database. But how will I find how many PDB's or list of PDB names using command or some file.
[grid@rac1 ~]$ srvctl status database -db CDB
Instance CDB1 is running on node rac1
Instance CDB2 is running on node rac2
[grid@rac1 ~]$ srvctl status instance -db CDB -instance CDB1
Instance CDB1 is running on node rac1
I know there is someways using SQLplus queries. Not even a single way without creating a SQL plus session ?