IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi
I will explain How to Shutdown and Startup Exadata and Oracle Databases in this post.
If you want to learn more details about Exadata database machine, read the following articles.
https://ittutorial.org/exadata-tutorial-x8-oracle-database-machine-3/
Step-1: Firstly check all Database and Cluster resources, which resources are online which was offline.
[oracle@msddbadm01 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATAC1.dg
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
ora.DBFS_DG.dg
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
ora.RECOC1.dg
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
ora.asm
ONLINE ONLINE msddbadm01 Started,STABLE
ONLINE ONLINE msddbadm02 Started,STABLE
ora.net1.network
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
ora.ons
ONLINE ONLINE msddbadm01 STABLE
ONLINE ONLINE msddbadm02 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE msddbadm01 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE msddbadm02 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE msddbadm01 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE msddbadm02 169.254.95.5 192.168
.23.12 192.168.23.13
,STABLE
ora.cvu
1 ONLINE ONLINE msddbadm02 STABLE
ora.dbm01.db
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE STABLE
ora.ebys.db
1 ONLINE ONLINE msddbadm01 Open,STABLE
2 ONLINE ONLINE msddbadm02 Open,STABLE
ora.ebymsdol.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE msddbadm02 Open,STABLE
ora.oc4j
1 ONLINE ONLINE msddbadm02 STABLE
ora.repdb.db
1 ONLINE ONLINE msddbadm01 Open,STABLE
2 ONLINE ONLINE msddbadm02 Open,STABLE
ora.scan1.vip
1 ONLINE ONLINE msddbadm01 STABLE
ora.scan2.vip
1 ONLINE ONLINE msddbadm02 STABLE
ora.scan3.vip
1 ONLINE ONLINE msddbadm01 STABLE
ora.msdol.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.test.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE STABLE
ora.msd.db
1 ONLINE ONLINE msddbadm01 Open,STABLE
2 ONLINE ONLINE msddbadm02 Open,STABLE
ora.msddbadm01.vip
1 ONLINE ONLINE msddbadm01 STABLE
ora.msddbadm02.vip
1 ONLINE ONLINE msddbadm02 STABLE
--------------------------------------------------------------------------------
[oracle@msddbadm01 ~]$
[oracle@msddbadm01 ~]$
[oracle@msddbadm01 ~]$ ps -ef | grep smon
oracle 96063 94711 0 09:45 pts/1 00:00:00 grep smon
oracle 140550 1 0 2019 ? 00:02:04 asm_smon_+ASM1
root 147726 1 1 2019 ? 1-07:46:09 /u01/app/12.1.0.2/grid/bin/osysmond.bin
oracle 156168 1 0 2019 ? 00:05:20 ora_smon_REPDB1
oracle 156172 1 0 2019 ? 00:05:18 ora_smon_EBYS1
oracle 156342 1 0 2019 ? 00:15:49 ora_smon_msd1
[oracle@msddbadm01 ~]$
[oracle@msddbadm01 ~]$
Step-2: Shutdown database(s) safely as follows.
[oracle@msddbadm01 ~]$ srvctl stop database -d DB_NAME [oracle@msddbadm01 ~]$ srvctl stop database -d MSDB [oracle@msddbadm01 ~]$ srvctl stop database -d EBYS [oracle@msddbadm01 ~]$ srvctl stop database -d REPDB
Step-3: If all databases and their instances shutdown, then stop Cluster Resources as follows.
Firstly Set Grid Infrastructure Profile, then stop all resources.
crsctl stop cluster -all
[root@msddbadm01 ~]$ . oraenv
ORACLE_SID = [msd1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[root@msddbadm01 ~]$ crsctl stop cluster -all
or You can stop CRS on each database server node as follows.
[oracle@msddbadm01 ~]$ crsctl stop crs
Step-4: Shutdown all Cell Servers.
You can shutdown all Cell Servers on Database server as follows.
[root@msddbadm01 ~]$ dcli -g cell_group -l root "su - celladmin -c \"cellcli -e alter cell shutdown services all \""
Or you can shutdown each cell server one by one as follows. Before shutdown it, check its services as follows.
[root@msdceladm01 ~]# service celld status rsStatus: running msStatus: running cellsrvStatus: running [root@msdceladm01 ~]#
[root@msdceladm01 ~]# service celld stop
or
[root@msdceladm01 ~]# cellcli -e alter cell shutdown services all
Do this step for all Cell servers one by one.
Step-5: Shutdown Cell Servers.
You can shutdown them with one command from database server as follows.
[root@msddbadm01 ~]$ dcli -g cell_group -l root poweroff
or you can shutdown them one by one on related cell server.
[root@msdceladm01 ~]# shutdown -h -y now
Step-6: Shutdown all Database Servers as follows.
[ root@msddbadm01 ~]$ shutdown -h -y now
or
[root@msddbadm01 ~]$ poweroff
If all ssh connections are down, then check the Exadata lights if they are on or off.
Step-6: Once exadata has been offline, you can startup it by clicking the power button on the front panel of the Exadata Storage Servers and Database servers.
When the Storage servers and database servers’ light are on, then it will startup in a 10 minutes.
You can startup cell servers from Database server using the following command.
for host in `cat cell_group`; do
echo ${host}: `ipmitool -H ${host}-ilom -U root -P welcome1 chassis power on`
done
You can also startup exadata by using ILOM.
Step-7: Check all Cell Servers if they are online or not.
[root@msddbadm01 ~]$ dcli -g cell_group -l root 'hostname; uptime' [root@msddbadm01 ~]$ dcli -g cell_group -l root "su - celladmin -c \"cellcli -e list cell detail \""
Step-8: If Cell servers are online, then check the Database Servers.
Normall all CRS services should be startup automatically.
But check it as follows on each database server.
[root@msddbadm01 ~]$ crsctl status resource -t [root@msddbadm01 ~]$ ps -ef | grep smon
Step-9: If Cluster and database services are not startup automatically, then startup them as follows.
[root@msddbadm01 ~]$ . oraenv ORACLE_SID = [msd1] ? +ASM1 The Oracle base remains unchanged with value /u01/app/oracle [root@msddbadm01 ~]$ crsctl start cluster -all
Step-10: If Databases are not up, then Startup database(s) as follows.
[oracle@msddbadm01 ~]$ srvctl start database -d DB_NAME [oracle@msddbadm01 ~]$ srvctl start database -d MSDB [oracle@msddbadm01 ~]$ srvctl start database -d EBYS [oracle@msddbadm01 ~]$ srvctl start database -d REPDB
Now All exadata and database services are up, you can use them safely.
Do you want to learn Exadata detailed, then read the following articles.
https://ittutorial.org/exadata-tutorials-oracle-magic-database-machine-exadata-lessons/
Hello,
do You think it matters when we first :
Step-4: Shutdown all Cell Servers.
and then Step-6: Shutdown all Database Servers as follows.
Seems to be the opposite .
Thank You.
Hi,
You have already shutdown database and cluster services at the Step2-3, so You can shutdown Cell Servers if the database and cluster services are off.
You can also shutdown cell servers before database servers, if the databases and CRS are shutdown.