I want to know the exact total no cell nodes configured as part of the rack by login into the first db node of Exadata machine and run some commands or check some files.
We are not able to believe the output of /opt/oracle.Support.Tools/onecommand/cell_group file or the cellip.ora files or ibnetdiscover cmd ,since in some customer environment those files outputs are not giving the exact no of cell node details.
So is there any other command or file to fetch the exact no of cell nodes as part of the rack on the first db node ,even in the case like customer added additional storage nodes as part of that rack?
Best Answer
Got the answer.Connect the asm instance or any db which running on the exadata box and run the below query
So totally 7 cell nodes are there in this box.