![]() | Oracle System Handbook - ISO 7.0 May 2018 Internal/Partner Edition | ||
|
|
![]() |
||||||||||||||||||||||||||||||||||||||||||||||||
Solution Type Predictive Self-Healing Sure Solution 1903388.1 : SuperCluster - ssctuner reference document
SuperCluster tuning assistant In this Document
Applies to:Oracle SuperCluster M6-32 Hardware - Version All Versions to All Versions [Release All Releases]Oracle SuperCluster T5-8 Half Rack - Version All Versions to All Versions [Release All Releases] SPARC SuperCluster T4-4 Half Rack - Version All Versions to All Versions [Release All Releases] Oracle Exadata Storage Server Software - Version 11.2.3.2.1 to 11.2.3.2.1 [Release 11.2] SPARC SuperCluster T4-4 Full Rack - Version All Versions to All Versions [Release All Releases] Oracle Solaris on SPARC (64-bit) Linux x86-64 PurposeDescribe the purpose and functionality of the mandatory ssctuner service on Oracle SuperCluster systems Scope Will cover the version of ssctuner starting with the JAN 2014 Quarterly Full Stack Download Patch (QFSDP) DetailsDefinition
ssctuner is a small set of Perl/Korn shell scripts and config files ssctuner checks to make sure the package (IPS or SvR4) is not
Solaris 11 must be at SRU 11.4 or later for this tool or ssd.conf/sd.conf settings could cause panics. Also, if you currently
set ndd parameters via another SMF service or init script, that must be removed. ssctuner should manage the ndd parameters. How to install itssctuner should be automatically installed as part of SuperCluster How to run it "live" making recommended tuning changesIt is enabled as part of install, if it is ever disabled, enable again by: #svcadm enable ssctuner
Note that /etc/system, /kernel/drv/sd.conf and /kernel/drv/ssd.conf parameters will not take effect until a reboot occurs after enabling
the service... So check that current date minus uptime is earlier than timestamp in /etc/system comment to know that they are in effect (or just reboot if convenient to be sure). How to change or disable components of what ssctuner does/checksWith 1.1.4 changes, ssctuner now uses SMF property variables to NOTE : EVEN THOUGH WE SHOW YOU EXAMPLES PLEASE CHANGE THESE ONLY IN CONSULTATION WITH ORACLE SUPPORT!
# svccfg -s ssctuner listprop 'ssctuner_vars/*'
ssctuner_vars/CRIT_THREADS_FIX boolean true ssctuner_vars/CRIT_THREADS_NONEXA boolean false ssctuner_vars/DISK_SPACE_CHECK boolean true ssctuner_vars/DISK_USAGE_CRIT integer 90 ssctuner_vars/DISK_USAGE_WARN integer 85 ssctuner_vars/DISM_CHECK boolean true ssctuner_vars/EMAIL_ADDRESS astring root@localhost ssctuner_vars/EMAIL_MESSAGES boolean true ssctuner_vars/FORCELOAD_VDC boolean false ssctuner_vars/INTRD_DISABLE boolean true ssctuner_vars/ISCSI_TUNE boolean true ssctuner_vars/MAJOR_INTERVAL integer 120 ssctuner_vars/MEM_USAGE_CRIT integer 97 ssctuner_vars/MEM_USAGE_WARN integer 94 ssctuner_vars/MINOR_INTERVAL integer 2 ssctuner_vars/NDD_TUNE boolean true ssctuner_vars/NFS_CHECK boolean true ssctuner_vars/NFS_EXCLUDE astring ssctuner_vars/NFS_INCLUDE astring ssctuner_vars/NTPCONF_TUNE boolean true ssctuner_vars/POWERADM_DISABLE boolean true ssctuner_vars/SDCONF_TUNE boolean true ssctuner_vars/SERD_THRESHOLD_TUNE boolean true ssctuner_vars/SSDCONF_TUNE boolean true ssctuner_vars/SYSLOG_DUP_SUPPRESS_HOURS integer 8 ssctuner_vars/SYSTEM_TUNE boolean true ssctuner_vars/ZPOOL_FIX boolean true ssctuner_vars/ZPOOL_NAME_CUST astring To make critical messages go to your email address, for example
# svccfg -s ssctuner setprop ssctuner_vars/EMAIL_ADDRESS="my_name@mycorp.com"
To change disk usage ( / and zone roots ) warning level to 80%
# svccfg -s ssctuner setprop ssctuner_vars/DISK_USAGE_WARN=80 To enable thread priority changing for non-exa Oracle DB domains# svccfg -s ssctuner setprop ssctuner_vars/CRIT_THREADS_NONEXA=true
To enable zpool check/repair of vdisk zpools not generated by the SuperCluster installer# svccfg -s ssctuner setprop ssctuner_vars/ZPOOL_NAME_CUST=my_vdisk_pool To exclude NFS mounts from warning mechanism# svccfg -s ssctuner setprop ssctuner_vars/NFS_EXCLUDE='mount_name_or_device'
To include NFS mounts in warning mechanism (overrides exclude )
# svccfg -s ssctuner setprop ssctuner_vars/NFS_INCLUDE='mount_name_or_device'
NOTE : NFS_EXCLUDE, NFS_INCLUDE and ZPOOL_NAME_CUST should be kept simple strings but can be simple regular expressions. If you need the flexibility of
regular expressions, be extremely careful to double quote and verify ssctuner service comes back after restarting with no errors in SMF log file or you may end up preventing the ssctuner service from functioning. One example of what is not legal : svccfg -s ssctuner setprop ssctuner_vars/NFS_EXCLUDE=zurich\|jurassic
svccfg -s ssctuner setprop ssctuner_vars/NFS_EXCLUDE='zurich|jurassic' And what is legal: svccfg -s ssctuner setprop ssctuner_vars/NFS_EXCLUDE='zurich\|jurassic'
To change the amount of time ssctuner will suppress repeat warnings for
# svccfg -s ssctuner setprop ssctuner_vars/SYSLOG_DUP_SUPPRESS_HOURS=24 If you use the wrong syntax svcs ssctuner will show the service not come back
and the following line will show the offending property you must fix : #grep -i parameter /var/svc/log/site-application-sysadmin-ssctuner:default.log
After any changes are made, the service must be refreshed and restarted to take effect : # svcadm refresh ssctuner
# svcadm restart ssctuner EXCEPT UNDER INSTRUCTION FROM ORACLE SUPPORT. The ssctuner service should never be disabled or uninstalled.
If ever directed to the way to disable ssctuner is #svcadm disable ssctuner
This will stop the repeated checks but leave most tuning changes in tact (a reboot after this will lose ndd tunings)
Updatingssctuner is updated along with the exafamily updates with each QFSDP. It is permitted to update ssctuner to a version newer than the existing QFSDP if directed to by support. However you should not run and older version compared to your QFSDP level. When ssctuner package is updated on Solaris 11, new features may be added Those will always be visible in the SMF properties, and changes to SMF property Legacy InformationThe legacy /opt/oracle.supercluster/ssctuner/etc/ssctuner.conf will be CRIT_THREADS_FIX=TRUE
How to turn off and remove the service undoing all tuning changes This script needs to be run before the package removal and will rollback any changes to the status prior to the current ssctuner install (including system changes not related to ssctuner). The script runs in interactive mode allowing the user to select which changes to rollback. Note that /etc/system parameters will persist in effect until a reboot occurs after uninstalling.
Generic feedback
For general feedback about the Oracle SuperCluster ssctuner service please fell free to discuss in the MOS communities Oracle SuperCluster General Tuning Discussion. References<NOTE:1567979.1> - Oracle SuperCluster Supported Software Versions - All Hardware Types<NOTE:2008049.1> - Oracle SuperCluster SSCtuner Best Practices Attachments This solution has no attachment |
||||||||||||||||||||||||||||||||||||||||||||||||
|