Sunday, September 18, 2016

EXADATA - Importance of Cellinit.ora and Cellip.ora files

Cellinit.ora and Cellip.ora

After Oracle Exadata Storage Server is configured, the database server host must be configured with the cellinit.ora and the cellip.ora files to use the cell. 

The files are located in the /etc/oracle/cell/network-config directory of the database server host.These configuration files contain IP addresses, not host names.

cellinit.ora - This file contains the database IP addresses.
cellip.ora -    This file contains the storage cell IP addresses.

Example:

Quarter RAC Exadata machine contains 2 compute(DB) nodes  and 3 Cell(Storage) servers.Below picture shows the ip configurations. 

192.168.50.23 and 192.168.50.24 belongs to Compute Nodes.
192.168.51.27, 192.168.51.28 and 192.168.51.29 belongs to Cell Servers.

4 comments:

  1. It's not like that:
    192.168.50.23 and 192.168.50.24 belongs to Compute Nodes.

    It's 192.168.50.23 with subnet mask of 24

    ReplyDelete
  2. Thats wrong info brother

    both are subnet and ip address of the UB switch of cell

    /etc./oracle/cell/network-config/
    cellinit.ora---->Contains IB IP subnet for storage cells



    /etc./oracle/cell/network-config/cellip.
    ora --->Contains IB IP addresses for each storage cell

    ReplyDelete
  3. When in query in my environment, v$cell.
    It showing 24 ip's
    Such as
    192.168.16.23;192.168.16.24
    192.168.16.25;192.168.16.26
    ..............
    ..............
    192.168.16.45;192.168.16.46

    It means 12 * 2 sets ... Why this much .... Then what will be the storage cell count??

    ReplyDelete
  4. cellinit.ora is the initialization parameter file used by cell whereas, cellip.ora tells which cells are part of the cluster storage.

    ReplyDelete