Get the App
SLTechnology News&Howtos  ›  Database  › 

Oracle Exadata all-in-one shutdown process (virtual machine environment)

Shulou Source: shulou.com Published: 2022-06-01 15:52:50 10月03日 Update

Edit the cell,db node information file all_group,dbs_group,cell_group

[root@idc-dns1 exatest] # pwd

/ root/exatest

[root@idc-dns1 exatest] # cat all_group

Exadb1

Exadb2

Cell1

Cell2

Cell3

[root@idc-dns1 exatest] # cat dbs_group

Exadb1

Exadb2

[root@idc-dns1 exatest] # cat cell_group

Cell1

Cell2

Cell3

[root@idc-dns1 exatest] #

Add ssh trust to all servers to enable remote login without entering passwords

[root@idc-dns1 exatest] # dcli-k-g all_group-l root

The authenticity of host 'cell1 (172.16.218.61)' can't be established.

RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.

Are you sure you want to continue connecting (yes/no)? Yes

Root@cell1's password:

The authenticity of host 'exadb1 (172.16.218.171)' can't be established.

RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.

Are you sure you want to continue connecting (yes/no)? Yes

Root@exadb1's password:

The authenticity of host 'cell2 (172.16.218.62)' can't be established.

RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.

Are you sure you want to continue connecting (yes/no)? Yes

Root@cell2's password:

The authenticity of host 'exadb2 (172.16.218.172)' can't be established.

RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.

Are you sure you want to continue connecting (yes/no)? Yes

Root@exadb2's password:

The authenticity of host 'cell3 (172.16.218.63)' can't be established.

RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.

Are you sure you want to continue connecting (yes/no)? Yes

Root@cell3's password:

Exadb1: ssh key added

Exadb2: ssh key added

Cell1: ssh key added

Cell2: ssh key added

Cell3: ssh key added

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

Test dcli to get the hostname of all hosts

[root@idc-dns1 exatest] # dcli-g all_group-l root hostname

Exadb1: exadb1

Exadb2: exadb2

Cell1: cell1

Cell2: cell2

Cell3: cell3

Check whether the cluster configuration of the db host is powered on

[root@idc-dns1 exatest] # dcli-g dbs_group-l root / u01/app/11.2.0/grid/bin/crsctl config crs

Exadb1: CRS-4622: Oracle High Availability Services autostart is enabled.

Exadb2: CRS-4622: Oracle High Availability Services autostart is enabled.

Disable boot boot

[root@idc-dns1 exatest] # dcli-g dbs_group-l root / u01/app/11.2.0/grid/bin/crsctl disable crs

Exadb1: CRS-4621: Oracle High Availability Services autostart is disabled.

Exadb2: CRS-4621: Oracle High Availability Services autostart is disabled.

Db node stops Oracle database cluster

[root@idc-dns1 exatest] # dcli-g dbs_group-l root / u01/app/11.2.0/grid/bin/crsctl stop crs

Exadb1: CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.crsd' on' exadb1'

Exadb1: CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.cvu' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.registry.acfs' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.mfy.db' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.oc4j' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.scan1.vip' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.LISTENER.lsnr' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.exadb1.vip' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.cvu' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.mfy.db' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.DATA.dg' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.RECO.dg' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.registry.acfs' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.RECO.dg' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.scan1.vip' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.exadb1.vip' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.oc4j' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.DATA.dg' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.asm' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.asm' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.ons' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.ons' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.net1.network' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.net1.network' on' exadb1' succeeded

Exadb1: CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exadb1' has completed

Exadb1: CRS-2677: Stop of 'ora.crsd' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.drivers.acfs' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.ctssd' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.evmd' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.asm' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.mdnsd' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.evmd' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.mdnsd' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.ctssd' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.drivers.acfs' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.asm' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.cluster_interconnect.haip' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.cssd' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.cssd' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.diskmon' on' exadb1'

Exadb1: CRS-2673: Attempting to stop 'ora.crf' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.crf' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.gipcd' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.diskmon' on' exadb1' succeeded

Exadb1: CRS-2677: Stop of 'ora.gipcd' on' exadb1' succeeded

Exadb1: CRS-2673: Attempting to stop 'ora.gpnpd' on' exadb1'

Exadb1: CRS-2677: Stop of 'ora.gpnpd' on' exadb1' succeeded

Exadb1: CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exadb1' has completed

Exadb1: CRS-4133: Oracle High Availability Services has been stopped.

Exadb2: CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.crsd' on' exadb2'

Exadb2: CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.registry.acfs' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.mfy.db' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.LISTENER.lsnr' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.exadb2.vip' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.registry.acfs' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.exadb2.vip' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.mfy.db' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.DATA.dg' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.RECO.dg' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.RECO.dg' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.DATA.dg' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.asm' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.asm' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.ons' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.ons' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.net1.network' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.net1.network' on' exadb2' succeeded

Exadb2: CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exadb2' has completed

Exadb2: CRS-2677: Stop of 'ora.crsd' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.ctssd' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.evmd' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.asm' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.drivers.acfs' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.mdnsd' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.evmd' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.mdnsd' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.ctssd' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.asm' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.cluster_interconnect.haip' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.cssd' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.drivers.acfs' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.cssd' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.diskmon' on' exadb2'

Exadb2: CRS-2673: Attempting to stop 'ora.crf' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.crf' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.gipcd' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.diskmon' on' exadb2' succeeded

Exadb2: CRS-2677: Stop of 'ora.gipcd' on' exadb2' succeeded

Exadb2: CRS-2673: Attempting to stop 'ora.gpnpd' on' exadb2'

Exadb2: CRS-2677: Stop of 'ora.gpnpd' on' exadb2' succeeded

Exadb2: CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exadb2' has completed

Exadb2: CRS-4133: Oracle High Availability Services has been stopped.

[root@idc-dns1 exatest] #

Check if there are still cluster processes on the db node

[root@idc-dns1 exatest] # dcli-g dbs_group-l root "ps-ef | grep diskmo [n]"

Check cell automatic alarm notification

[root@idc-dns1 exatest] # dcli-g cell_group-l root "su-celladmin-c\" cellcli-e list cell attributes name,notificationMethod\ ""

Cell1: cell1

Cell2: cell2

Cell3: cell3

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

Disable Cell alarm notification

[root@idc-dns1 exatest] # dcli-g cell_group-l root "su-celladmin-c\" cellcli-e alter cell notificationMethod=none\ ""

Cell1: Cell cell1 successfully altered

Cell2: Cell cell2 successfully altered

Cell3: Cell cell3 successfully altered

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

Turn off the Cell service

[root@idc-dns1 exatest] # dcli-g cell_group-l root "su-celladmin-c\" cellcli-e alter cell shutdown services all\ ""

Cell1:

Cell1: Stopping the RS, CELLSRV, and MS services...

Cell1: The SHUTDOWN of services was successful.

Cell2:

Cell2: Stopping the RS, CELLSRV, and MS services...

Cell2: The SHUTDOWN of services was successful.

Cell3:

Cell3: Stopping the RS, CELLSRV, and MS services...

Cell3: The SHUTDOWN of services was successful.

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

Cell shutdown

[root@idc-dns1 exatest] # dcli-g cell_group-l root poweroff

Db shutdown

[root@idc-dns1 exatest] # dcli-g dbs_group-l root poweroff

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

[root@idc-dns1 exatest] #

Reference Oracle Note ID 1093890.1

Steps To Shutdown/Startup The Exadata & RDBMS Services and Cell/Compute Nodes On An Exadata Configuration. (document ID 1093890.1)

Tags: Node cluster check host alarm service information password data database file document server process reference test login input configuration all in one Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei vpn Microsoft Shulou Tech Info Shulou Technology