exadata

cellcli

Show alerthistory for cell

dcli -g cell_group -l root cellcli -e list alerthistory

Show disk caching for griddisk disks

dcli -g cell_group -l root cellcli -e list griddisk attributes name,cachingpolicy,cachedBy

Disable caching of griddisk

alter griddisk RECOC1_CD_08_heiwcel08_man cachingpolicy='none'

Upgrade Infiniband Switch

export EXADATA_IMAGE_IBSWITCH_UPGRADE_VERSION=2.2.7_2
cd patch_18.1.8.0.0.180906.1
./patchmgr -ibswitches ../infini_group -upgrade -ibswitch_precheck

Online change WriteThrough to WriteBack Flash Cache

CellCLI>
 list griddisk attributes name, status, asmdeactivationoutcome
 alter griddisk all inactive
 drop flashcache
 alter cell shutdown services cellsrv
 alter cell flashCacheMode=WriteBack
 alter cell startup services cellsrv
 alter griddisk all active
 create flashcache all
 list cell attributes flashCacheMode
 list griddisk attributes name, status, asmmodestatus

Pinning tables in Flashcache

ALTER TABLE "SCHEMA_NAME"."TABLE_NAME" storage (cell_flash_cache keep);

Setting number of active cores on DB server

DBMCLI> list dbserver attributes corecount
         16/44
 
/opt/oracle.SupportTools/resourcecontrol -show
/opt/oracle.SupportTools/resourcecontrol -core 16 -force

Increase Database Server Core Count

# /opt/oracle.SupportTools/resourcecontrol -core 24
[INFO] Validated hardware and OS. Proceed.
[SHOW] Number of cores active per socket: 8
[SHOW] Total number of cores active: 16
[INFO] Enabling 12 cores on each socket.
[INFO] Import all bios settings
Preparing to restore XML file to BIOS...
Done preparing to restore settings in /var/log/oracleexa/resctl/bios_settings_new.xml to BIOS.
Restoring BIOS configuration (allow several minutes).......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Done.
[INFO] All bios settings have been imported with success
[ACTION] Reboot server for settings to take effect

Create Cell Server RAM cache

LIST CELL ATTRIBUTES ramCacheMaxSize,ramCacheMode, ramCacheSize
ALTER CELL ramCacheMaxSize=16G
ALTER CELL ramCacheMode=On
or
ALTER CELL ramCacheMode=auto

Retrieve ExaWatcher Detail (DB Node)

/opt/oracle.ExaWatcher/GetExaWatcherResults.sh --from 11/30/2020_08:00:00 --to 12/01/2020_11:00:00 --resultdir /tmp/exawatcher_30112020