How To Get Current Release Version of Exadata Components?

Whenever we plan for patching, upgrade or migrate, knowing the current release version of exadata component is first and mandatory thing to proceed ahead. These information  also helps you while doing any configuration level changes on exadata machine.

Following commands will help you to get the current realease version of the exadata machine component.

Database Server

OS Image Version: #imageinfo

Database: $opatch lsinventory

Grid:  $opatch lsinventory

Cell Server

Software/OS Image Version: #imageinfo

Infiniband Switch

#version

Ethernet Switch

#show version

PDU

Open web console using PDU management IP. Click on module info to get the PDU firmware version

You can also refer Exadata Interview Questions and Answers eBook to get maximum success in interview.

Oracle Exadata default passwords

When Exadata get deployed,  by default it configured with Oracle standard username and password. As per good practice you should always change default password once Exadata handed over to you from Oracle. Below is the list of default Users and Passwords for Exadata.

Database Server

root/welcome1

oracle/welcome1

grid/welcome1

grub/sos1Exadata

Database server ILOMs

root/welcome1

Exadata Storage Cell Server

root/welcome1

celladmin/welcome1

cellmonitor/welcome1

Download Free Oracle Exadata Certification Exam Dumps

Exadata Storage Cell Server ILOMs

Exadata Storage Index Part-1

• It is not like traditional index which is in database. This is the feature of storage software and useful to eliminate IOs.
• Storage Index filter out data from the consideration. 

• It works by storing minimum and maximum column values for disk storage units, which are 1 Megabyte (MB) by default.
• Because SQL predicates are passed to the storage servers when Smart Scans are performed, the storage software can check the predicates against the Storage Index metadata (maximum and minimum values) before doing the requested I/O.

• Any storage region that cannot possibly have a matching row is skipped.

• There are no tuning technique or documents for storage index as it maintain by storage software only.

Storage Indexes consist of a minimum and a maximum value for up to eight columns. This structure is maintained for 1MB chunks of storage (storage regions). Storage Indexes are stored in memory only and are never written to disk.

Storage index is not static, whenever we shutdown or reboot storage server it will be removed and once server comes up storage server automatically create index.

Now we will see that how storage index actually work while executing the query on the DB server.

Click on image to enlarge.

Now we are executing below query on this table.

SQL> select * from TABLE where c>7;

In this case first query will go to the storage index and it will check min and max number for rows of first set but 7 is not fitting in Min and Max for rows of first set so, it will eliminate to check the data of that rows and it will move to second set of rows. 

Cellcli - Alter

CellCLI> alter cell shutdown services rs --> To shutdown the Restart Server service 
CellCLI> alter cell shutdown services MS --> To shutdown the Management Server service 
CellCLI> alter cell shutdown services CELLSRV --> To shutdown the Cell Services 
CellCLI> alter cell shutdown services all -->To shutdown the RS, CELLSRV and MS services 
CellCLI> alter cell restart services rs 
CellCLI> alter cell restart services all 
CellCLI> alter cell led on
CellCLI> alter cell led off 
CellCLI> alter cell validate mail
CellCLI> alter cell validate configuration 
CellCLI> alter cell smtpfromaddr='cell07@orac.com' 
CellCLI> alter cell smtpfrom='Exadata Cell 07' 
CellCLI> alter cell smtptoaddr='satya@orac.com' 
CellCLI> alter cell emailFormat='text' 
CellCLI> alter cell emailFormat='html' 
CellCLI> alter cell validate snmp type=ASR - Automatic Service Requests (ASRs) 
CellCLI> alter cell snmpsubscriber=((host='snmp01.orac.com,type=ASR')) 
CellCLI> alter cell restart bmc - BMC, Baseboard Management Controller, controls the compoments of the cell. 
CellCLI> alter cell configure bmc 
CellCLI> alter physicaldisk 34:2,34:3 serviceled on
CellCLI> alter physicaldisk 34:6,34:9 serviceled off 
CellCLI> alter physicaldisk harddisk serviceled on 
CellCLI> alter physicaldisk all serviceled on 
CellCLI> alter lun 0_10 reenable 
CellCLI> alter lun 0_04 reenable force 
CellCLI> alter celldisk FD_01_cell07 comment='Flash Disk' 
CellCLI> alter celldisk all harddisk comment='Hard Disk' 
CellCLI> alter celldisk all flashdisk comment='Flash Disk' 
CellCLI> alter griddisk RECO_CD_10_cell06 comment='Used for Reco'
CellCLI> alter griddisk all inactive 
CellCLI> alter griddisk RECO_CD_11_cell12 inactive 
CellCLI> alter griddisk RECO_CD_08_cell01 inactive force 
CellCLI> alter griddisk RECO_CD_11_cell01 inactive nowait 
CellCLI> alter griddisk DATA_CD_00_CELL01,DATA_CD_02_CELL01,...DATA_CD_11_CELL01 inactive 
CellCLI> alter griddisk all active 
CellCLI> alter griddisk RECO_CD_11_cell01 active 
CellCLI> alter griddisk all harddisk comment='Hard Disk' 
CellCLI> alter ibport ibp2 reset counters
CellCLI> alter iormplan active 
CellCLI> alter quarantine 
CellCLI> alter threshold DB_IO_RQ_SM_SEC.PRODB comparison=">", critical=100 
CellCLI> alter alerthistory

X2-2 Exadata Storage Overview

Exadata Storage

-High Performance storage
-Up to 1.8 GB/Sec raw data Bandwidth
-Up to 75.000 IOPS using flash
-64 Bit Intel-based sun fire server
-Pre-Installed Software - Storage Software , Oracle Linux x86_64 , Drivers and Utilities

Exadata Storage Configuration

-12 x 3.5 inch High Performance or High Capacity SAS disks
-384 GB of Exadata Smart Flash Cache
-12 CPU cores dedicated to SQL processing in storage
-24 GB memory
-Dual InfiniBand ports
-Redundant power supplies
-Oracle Exadata Storage
-Server software
-Oracle Linux or Solaris based Database Machines

Hardware Stack 



Storage Grid