Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
When the “ip”, “ntp” or “ilom” information is changed on the Exadata cellnodes, some operations must be performed. You can perform these operations by following the steps below.
In our scenario, we assume that the changes will be made to all cellnodes. Before starting operations, the CRS on the db nodes must be turned off.
First, we create a file named dbs_group. In this file, we write the IPs of the db nodes. Each line must have only a single IP. We then turn off the services on all nodes with the following command.
1 | [root@orcldb01 ~]# dcli -g dbs_group -l root /u01/app/11.2.0.3/grid/bin/crsctl stop crs -f |
Configuration Change
First, back up the existing configuration file to a location other than cellnode.
From any db node, create the configuration file to modify. Create a file named cell_group and type the IPs of all cell nodes into this file. Each line must have only a single IP. You can then perform the following operations.
1 | [root@orcldb01 ~]# dcli -g cell_group -l root cp /opt/oracle.cellos/cell.conf /root/new.cell.conf |
Turn off services on all Cell Nodes.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 | [root@orcldb01 ~]# dcli -g cell_group -l root cellcli -e alter cell shutdown services all orclcel01: orclcel01: Stopping the RS, CELLSRV, and MS services... orclcel01: The SHUTDOWN of services was successful. orclcel02: orclcel02: Stopping the RS, CELLSRV, and MS services... orclcel02: The SHUTDOWN of services was successful. orclcel03: orclcel03: Stopping the RS, CELLSRV, and MS services... orclcel03: The SHUTDOWN of services was successful. orclcel04: orclcel04: Stopping the RS, CELLSRV, and MS services... orclcel04: The SHUTDOWN of services was successful. orclcel05: orclcel05: Stopping the RS, CELLSRV, and MS services... orclcel05: The SHUTDOWN of services was successful. orclcel06: orclcel06: Stopping the RS, CELLSRV, and MS services... orclcel06: The SHUTDOWN of services was successful. orclcel07: orclcel07: Stopping the RS, CELLSRV, and MS services... orclcel07: The SHUTDOWN of services was successful. orclcel08: orclcel08: Stopping the RS, CELLSRV, and MS services... orclcel08: The SHUTDOWN of services was successful. orclcel09: orclcel09: Stopping the RS, CELLSRV, and MS services... orclcel09: The SHUTDOWN of services was successful. orclcel10: orclcel10: Stopping the RS, CELLSRV, and MS services... orclcel10: The SHUTDOWN of services was successful. orclcel11: orclcel11: Stopping the RS, CELLSRV, and MS services... orclcel11: The SHUTDOWN of services was successful. orclcel12: orclcel12: Stopping the RS, CELLSRV, and MS services... orclcel12: The SHUTDOWN of services was successful. orclcel13: orclcel13: Stopping the RS, CELLSRV, and MS services... orclcel13: The SHUTDOWN of services was successful. orclcel14: orclcel14: Stopping the RS, CELLSRV, and MS services... orclcel14: The SHUTDOWN of services was successful. |
After making the necessary changes in the newly created “new.cell.conf” file in all cellnodes, activate the change with the following command(on cell nodes as root). This command will restart the corresponding node.
1 | [root@orclcel01 ~]# /opt/oracle.cellos/ipconf force newconf /root/new.cell.conf reboot |
When the cell node is turned on, new configurations will be active. You can find out if there are any problems with the following command. This command also checks if the changes in the active configuration file “/opt/oracle.cellos/cell.conf” match “/root/new.cell.conf”.
1 | [root@orclcel01 ~]# /opt/oracle.cellos/ipconf verify conf /root/new.cell.conf verbose |
Finally verify cellnode configuration via cellcli.
1 2 | CellCLI> alter cell validate configuration Cell orclcel01 successfully altered |
