Exadata Quick Reference 4: Top 33 Oracle Exadata Parameters

Here listed down Top 33 Oracle Exadata Parameters, Exadata performance more over dependent on these parameters. It includes traditional database parameters also but those parameters also applied for Exadata environment and playing important role in terms of configuration and performance.

cell_offload_decryption
cell_offload_plan_display
cell_offload_processing 
_cell_index_scan_enabled
_small_table_threshold 
_serial_direct_read 
_serial_direct_read 
_kcfis_storageidx_disabled 
_kcfis_storageidx_diag_mode 
_cell_storidx_mode 
_cell_storidx_minmax_enabled 


parallel_adaptive_multi_user    
parallel_automatic_tuning       
parallel_degree_limit           
parallel_degree_policy          
parallel_execution_message_size 
parallel_force_local            
parallel_instance_group         
parallel_io_cap_enabled         
parallel_max_servers            
parallel_min_percent            
parallel_min_servers            
parallel_min_time_threshold     
parallel_server                 
parallel_server_instances       
parallel_servers_target         
parallel_threads_per_cpu   
_parallel_statement_queuing      
cluster_database 
cluster_database_instances 
cluster_interconnects 
local_listener 
remote_listener

Exadata Quick Reference 3: Oracle Exadata Patching Commands

Compute Node Patching: 

Patching on Database server can be performed serially or in parallel using DCLI utility.

dbnodeupdate.sh utility is used to perform the database server patching

What dbnodeupdate.sh utility does?
  • Stop/unlock/disable CRS for host restart
  • Perform LVM snapshot backup of / filesystem
  • Mount yum ISO image and configure yum
  • Apply OS updates via yum
  • Relink all Oracle homes for RDS protocol
  • Lock GI home and enable CRS upon host restart

#./dbnodeupdate.sh -u -l /u01/app/oracle/software/ESS_121220/p21825906_121220_Linux-x86-64.zip -v 

#./dbnodeupdate.sh -u -l /u01/app/oracle/software/ESS_121220/p21825906_121220_Linux-x86-64.zip -b 

#./dbnodeupdate.sh -u -l /u01/app/oracle/software/ESS_121220/p21825906_121220_Linux-x86-64.zip 

#./dbnodeupdate.sh -c 

-or- 

#./patchmgr -dbnode dbs_group -dbnode_upgrade -dbnode_loc /u01/app/oracle/software/ESS_121220/p21825906_121220_Linux-x86-64.zip dbnode_version 12.1.2.2.0.150917 


Storage Cell Patching: 

Cell storage patching can be done by patchmgr utility which is used to do a patching in rolling as well in non-rolling fashion.


Syntax: ./patchmgr -cells cell_group -patch [-rolling] [-ignore_alerts] [- smtp_from "addr" -smtp_to "addr1 addr2 addr3 ..."]


Here addr is the sending mail id which is used to send status of patching and addr1,addr2,addr3 are receiving mail id to receive the status of patching.

#./patchmgr -cells cell_group -reset_force 
#./patchmgr -cells cell_group -cleanup 
#./patchmgr -cells cell_group -patch_check_prereq 
#./patchmgr -cells ~/cell_group –patch ./patchmgr -cells cell_group –cleanup 

Infiniband Switch Patching:

Patchmgr utility used to patch Infiniband switches.

#./patchmgr -ibswitches ibswitches.lst -upgrade -ibswitch_precheck -force 
#./patchmgr -ibswitches ibswitches.lst -upgrade -force 


You would also like 

Exadata Quick Reference 2: Oracle Exadata Diag Utilities

exawatcher
Location: /opt/oracle.ExaWatcher/GetExaWatcherResults.sh 

What it does?
Useful to monitor Diskinfo, IBCardInfo, IBprocs, Iostat, LGWR, Lsof, MegaRaidFW, Meminfo, Mpstat, Netstat, Ps, RDSinfo, Slabinfo, Top, Vmstat. It saves historical data in /opt/oracle.ExaWatcher/archive in each server.



make_cellboot_usb
Location: /opt/oracle.SupportTools/make_cellboot_usb

What it does?
The make_cellboot_usb utility allows you to rebuild a damaged CELLBOOT USB flash drive. 

sosreport
Location: /usr/sbin/sosreport 

What it does?
The sosreport command is a tool that collects configuration details, system information and diagnostic information from Linux system.

ipconfig 
Location: /opt/oracle.cellos/ipconf 

What it does?
The ipconf utility makes a back up copy of the files it modifies. When the utility is rerun, it overwrites the existing backup file. The log file maintains the complete history of every ipconf operation performed.

CheckHWnFWProfile 
Location: /opt/oracle.SupportTools/CheckHWnFWProfile 

What it does?
The CheckHWnFWProfile utility checks that the system meets the required hardware and firmware specifications, and reports any mismatches.

ibdiagnet 
Location: /usr/bin/ibdiagnet 

What it does?
Useful for scanning the fabric.

checkbadlinks.pl
Location: /opt/oracle.SupportTools/ibdiagtools/checkbadlinks.pl

What it does?
The checkbadlinks.pl utility reports the links that are operating at 5 Gbps. This is usually an indication that the cables are loose, and need to be reseated.

verify-topology 
Location: /opt/oracle.SupportTools/ibdiagtools/verify-topology 

What it does?
It is self expalararty. It is useful to verify fabric topology. The verify-topology utility checks the correctness and health of InfiniBand connections.

sundiag.sh 
Location: /opt/oracle.SupportTools/sundiag.sh 

What it does?
The tool collects a lot of diagnostics information that assist the support analyst in diagnosing your problem, such as failed hardware like a failed disk, etc.

infinicheck
Location:  /opt/oracle.SupportTools/ibdiagtools/infinicheck 

What it does?
The infinicheck utility reports the base InfiniBand performance between servers in Oracle Exadata Database Machine, such as expected minimum throughput between the database server and cell, cell and cell, and database server and another database server. 

This utility can help identify potential issues in the InfiniBand fabric.

diagnostics.iso

What it does?
The diagnostics.iso utility may be used to boot the server to diagnose serious problems when no other way exists to analyze the system due to damage to the system, and its CELLBOOT USB flash drive. 

Use this utility only with Oracle Support Services guidance. The root password should be available to Oracle Support Services, as needed.

CheckSWProfile.sh
Location: /opt/oracle.SupportTools/CheckSWProfile.sh 

What it does?
CheckSWProfile.sh processes the list of InfiniBand switch names and passwords provided,logs in to each switch and runs a series of InfiniBand commands such as  version show, module-firmware and also copies the contents of  /etc./opensm/opensm.conf to temporary files in /tmp.

Exadata Quick Reference 1: Oracle Exadata Utilities

We have started the sequence of posts for Oracle Exadata Quick Reference which will include Exadata Commands, Utilities, Patching commands, quick overview of exadata features, Exadata parameters, wait events etc...

Agenda for this sequence is to review the exadata quickly in shorter time which also can help for interview preparation. Also it can help for exadata administrator to get the data quickly.

Following are the Oracle Exadata Utilities which are available as of now.


dbmcli 
Command-line administration tool for configuring database servers, and managing objects in the server environment.  

cellcli
Command-line administration tool for Oracle Exadata Storage Server Software 

dcli
Runs commands on multiple compute nodes and cells in parallel threads 

exacli
Command-line administration tool for Oracle Exadata Storage Server Software. It runs on compute nodes and enables you to manage cells remotely. 

exadcli
The exadcli utility runs commands on multiple cells in parallel threads. You can issue an ExaCLI command to be run on multiple cells. 

OEDA
The Exadata Deployment Assistant tool used to gather the information needed to deploy the Exadata Database Machine. The information entered in the tool is used to create the configuration files used to deploy the machine. 

checkip.sh
Run the Network Check script on the network where the machine will be deployed to validate the specified names and IP addresses have been added correctly to the name server, and they do not conflict with the existing network configuration.   

exachk
Exachk utility used to conduct a comprehensive Exadata Health Check on Exadata Database Machine to validate hardware, firmware and configuration. 

Cloud Edition: Oracle Exadata Interview Questions and Answers

What kind of subscription options exists for Oracle Database Exadata Cloud Service?
  • Non-metered Subscription 
  • Metered Subscription 

What mean by Non-metered Subscription?
A non-metered subscription is an agreement to purchase a specific number of service units over a specific term. Consequently, the charge for a non-metered subscription is not related to actual service usage. Non-metered subscriptions are also referred to as standard subscriptions.

What mean by Metered Subscription?
Metered Subscription — With a metered subscription, you are charged based on your service usage. 

Two varieties exist:  
  • Pre-Paid — With a pre-paid subscription you pay an up-front amount to establish an account that is consumed as you use a service. 
  • Pay As You Go — With a pay as you go subscription you do not pay an upfront amount and are billed periodically for your actual service usage. 

What type of exadata configurations offered for oracle exadata cloud service in Oracle premises?