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.

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.

 

[[email protected]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
--------------------------------------------------------------------------------
[[email protected] ~]$ 
[[email protected] ~]$ 


[[email protected] ~]$ 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
[[email protected] ~]$ 
[[email protected] ~]$

 

Step-2: Shutdown database(s) safely as follows.

[[email protected] ~]$ srvctl stop database -d DB_NAME

[[email protected] ~]$ srvctl stop database -d MSDB

[[email protected] ~]$ srvctl stop database -d EBYS

[[email protected] ~]$ 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

[[email protected] ~]$ . oraenv
ORACLE_SID = [msd1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[[email protected] ~]$ crsctl stop cluster -all

 

or You can stop CRS on each database server node as follows.

[[email protected] ~]$ crsctl stop crs

 

 

Step-4: Shutdown all Cell Servers.

You can shutdown all Cell Servers on Database server as follows.

 

[[email protected] ~]$ 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.

[[email protected] ~]# service celld status
rsStatus: running
msStatus: running
cellsrvStatus: running
[[email protected] ~]#

 

[[email protected] ~]#  service celld stop

or

[[email protected] ~]#  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.

 

[[email protected] ~]$  dcli -g cell_group -l root poweroff

 

or you can shutdown them one by one on related cell server.

[[email protected] ~]# shutdown -h -y now

 

Step-6: Shutdown all Database Servers as follows.

[ [email protected] ~]$  shutdown -h -y now

or

 

[[email protected] ~]$  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.

 

[[email protected] ~]$  dcli -g cell_group -l root 'hostname; uptime'

[[email protected] ~]$ 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.

[[email protected] ~]$ crsctl status resource -t

[[email protected] ~]$ ps -ef | grep smon

 

Step-9:  If Cluster and database services are not startup automatically, then startup them as follows.

[[email protected] ~]$ . oraenv
ORACLE_SID = [msd1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[[email protected] ~]$ crsctl start cluster -all

 

Step-10: If Databases are not up, then Startup database(s) as follows.

[[email protected] ~]$ srvctl start database -d DB_NAME

[[email protected] ~]$ srvctl start database -d MSDB

[[email protected] ~]$ srvctl start database -d EBYS

[[email protected] ~]$ 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/ 

 859 views last month,  1 views today

About 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 [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

2 comments

  1. 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.

Leave a Reply

Do NOT follow this link or you will be banned from the site!