How to Shutdown and Startup Exadata and Oracle Databases

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.

 

 

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/ 

 62 views today,  1 views in last 3 hour

Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

2 thoughts on “How to Shutdown and Startup Exadata and Oracle Databases

  • March 21, 2020 at 7:46 am
    Permalink

    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.

    Reply
    • March 21, 2020 at 1:10 pm
      Permalink

      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.

      Reply

Leave a Reply