Shaun's Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=== cellcli ===
== Show alerthistory for cell ==
<code bash>
dcli -g cell_group -l root cellcli -e list alerthistory
</code>

== Show disk caching for griddisk disks ==
<code bash>
dcli -g cell_group -l root cellcli -e list griddisk attributes name,cachingpolicy,cachedBy
</code>

== Disable caching of griddisk ==
<code bash>
alter griddisk RECOC1_CD_08_heiwcel08_man cachingpolicy='none'
</code>

== Upgrade Infiniband Switch ==
<code bash>
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
</code>

== Online change WriteThrough to WriteBack Flash Cache ==
<code>
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
</code>

== Pinning tables in Flashcache ==
<code sql>
alter table "SCHEMA_NAME"."TABLE_NAME" storage (cell_flash_cache keep);
</code>

== Setting number of active cores on DB server ==
<code bash>
DBMCLI> list dbserver attributes corecount
         16/44

/opt/oracle.SupportTools/resourcecontrol -show
/opt/oracle.SupportTools/resourcecontrol -core 16 -force
</code>

== Increase Database Server Core Count ==
<code bash>
# /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
</code>

== Create Cell Server RAM cache ==
<code>
LIST CELL ATTRIBUTES ramCacheMaxSize,ramCacheMode, ramCacheSize
ALTER CELL ramCacheMaxSize=16G
ALTER CELL ramCacheMode=On
or
ALTER CELL ramCacheMode=auto
</code>

== Retrieve ExaWatcher Detail (DB Node)==
<code bash>
/opt/oracle.ExaWatcher/GetExaWatcherResults.sh --from 11/30/2020_08:00:00 --to 12/01/2020_11:00:00 --resultdir /tmp/exawatcher_30112020
</code>
Shaun's Wiki

User Tools

Site Tools

Page Tools
