Resource Control in Exadata

We can check enabled resources (CPUs, RAM) with below command on exadata.

Sample output from one storage cell of Exadata 1/8th Rack

[root@cell01 ~]# /opt/oracle.SupportTools/resourcecontrol -show

[INFO] Validated hardware and OS. Proceed.

[SHOW] Number of cores active per socket: 3

[SHOW] Number of harddisks active - 6.

[SHOW] Number of flashdisks active - 8.

1/8th Exadata Rack comes with same hardware as quarter rack, but only half of the resources would be enabled on each 1/8th storage cell So, if in future if we need to upgrade 1/8th rack to quarter rack then we can use this utility to enable rest all the resources.

Above example shows all the enabled resources on one storage cell.

Useful Oracle Exadata Metalink Notes

Thought to list down some Exadata Document metalink which you can keep as a reference for lifetime.

Doc ID	Document Description
888828.1	Exadata Database Machine and Exadata Storage Server Supported Versions
1270094.1	Exadata Critical Issues
1353073.1	Exadata Diagnostics Collection Guide
1187674.1	Master Note for Oracle Exadata Database Machine and Oracle Exadata Stororage Server
1483344.1	Exadata Platinum Customer Outage Classifications and Restoration Action Plans
1571965.1	Maximizing Availability with Engineered Systems - Exadata
1262380.1	Exadata Testing Practices and Patching Explained
1306814.1	Oracle Software Patching with OPLAN
1110675.1	Oracle Exadata Database Machine Monitoring
1070954.1	Database Machine Healthcheck (Exachk)
1094934.1	Best Practices for Data Warehousing on the Database Machine
1269706.1	Best Practices for OLTP Applications on the Database Machine
1071221.1	Oracle Sun Database Machine Backup and Recovery Best Practices
1054431.1	Configuring DBFS on Oracle Exadata Database Machine
1084360.1	Bare Metal Restore Procedure for Compute Nodes on an Exadata Environment (Linux)
1339769.1	Master Note for Oracle Database Resource Manager
960510.1	Data Guard Transport Considerations on Oracle Database Machine
1551288.1	Understanding ASM Capacity and Reservation of Free Space in Exadata
401749.1	Shell Script to Calculate Values Recommended Linux HugePages / HugeTLB Configuration
1009715.1	Integrated Lights Out Manager (ILOM) CLI Quick Reference
1070954.1	Oracle Exadata Database Machine exachk or HealthCheck
1317159.1	Changing IP addresses on Exadata Database Machine
1244344.1	Exadata Starter Kit
1537407.1	Requirements and restrictions when using Oracle Database 12c on Exadata Database Machine
1551288.1	Understanding ASM Capacity and Reservation of Free Space in Exadata
1459611.1	How to Calculate Usable_FILE_MB / REQUIRED_MIRROR_FREE_MB
361468.1	HugePages on Oracle Linux 64-bit
761868.1	Oracle Exadata Diagnostic Information required for Disk Failures and some other Hardware issues
10386736	Documentation for Exadata 11.2 & 12.1

You can follow  our   Exadata Certification Question   to   achieve   maximum success in your Exadata exam.

Exadata Monitoring Command

Additional monitoring commands which are required with usual DBA skill set on DB and CELL server.

Database Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Exadata: dcli

    ASM: asmcmd, asmca

    Clusterware: crsctl, srvctl

Cell Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Cell management: cellcli, cellsrvstat


                                    Exadata Monitoring Tools

Steps to Generate Exadata One Command Configuration sheet

First download  Oracle Exadata Deployment Assistance from below link as per your respective Operating System.

Oracle Exadata Deployment Assistance (OEDA)

Install it on your machine and click on config to open deployment assistance.

Below are the detailed steps to fill the configuration details.

Click to enlarge.....

Provide organization name, application details, timezone with NTP and DNS Server details.

Select appropriate Exadata Configuration Rack, in our case it's Half Rack High Performance.

Provide network details for Administration and Client connectivity. You should have separate network for admin and client as per best practice.

Download Free Oracle Exadata Certification Exam Dumps

Exadata Installation Activities

Implementation of Exadata done by Oracle ACS team so many time we are curious to know that what exactly they are doing so here we have listed down the list of activities which can be done by Oracle in various phases.

1.  Configuration worksheet

2.  Pre-delivery Survey

(ACS Team Activity)

3.  Generic Config Files based on Configuration Worksheet

4.  Run checkip.sh

(Oracle H/W Team Activity)

5.  Power on and validate all the components

6.  Configure KVM

7.  Configure Infiniband Swithces

8.  Configure Cisco Switch

9.  Configure IP to PDUs

10. Storage Cell validation

11. Compute Node validation

(ACS Team Activity)

12. Transfer configuration files from USB to DB node

13. Execute firstboot and applyconfig.sh

14. Stage Oracle Software on Node 1

15. Run OneCommand

                                           ASR Installation

ASR Installation and Registration procedure with Oracle

Plateforms:

RHEL 3 or latter x86
SUSE Linux 9 or latter x86
OEL 4 or latter x86

Software Requirement (08/10/2013) :

1. Oracle Automated Service Manager (OSAM) Package (Patch Number p17270592_150_Linux-x86-64.zip)
2. Oracle Automated Service Request (ASR) Package (Patch Number p17199302_45_Linux-x86-64.zip)
3. Service Tools Bundle (STB) (Patch Number p12757884_10000_Generic.zip)

Here we have taken rpm and patch for testing purpose, it's always best practice to use latest RPMs and patch.

All the installation must be done by super User

1. Install STB on ASR Manager Server

          #rpm -i sun-hardware-reg-1.0.0-1.i386.rpm
          #rpm -i sun-servicetag-1.1.5-1.i386.rpm

   2. Verify created service tag execute below command

         #/opt/sun/servicetag/bin/stclient -x

  3. Install OSAM on ASR Manager Server

        #rpm -i SUNWsasm-1.5.0-112.rpm

  4. Install ASR Package on ASR Manager Server

       #rpm -ivh SUNWswasr-4.5-20130703104534.rpm

  5. Add asr path in .bash_profile file:

      PATH=$PATH:/opt/SUNWswasr/bin/asr
      export PATH

Register ASR Manager :

What is Exadata ?

• Exadata is pre-configured combination of hardware and software which provides a platform to run the Oracle Database. 

• It includes server, storage, network switch, PDU, KVM, storage software, Oracle software and Infiniband switches to connect the storage with server in single box. 

• In short it contains everything in single box, only we have to provide power and network from outside. 
• KVM is not exists from X3-2 version.