User Tools

Site Tools


exadata

This is an old revision of the document!


cellcli

Show alerthistory for cell
dcli -g cell_group -l root cellcli -e list alerthistory
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
exadata.1609592338.txt.gz · Last modified: 2021/01/02 12:58 by ss_wiki_admin