Management Server(MS) running on database nodes.

From exadata database machine administration guide:
“Starting with Oracle Exadata Database Machine 12.1.2.1.0
The database nodes now run the Management Server (MS). Previously MS ran only on the storage nodes.
The database nodes now run a new service called Database Machine Service (dbmsrv).
This new service is based on the MS that runs on the storage servers and provides enhanced management capabilities to the database nodes.”

[root@###exa03db01 ~]# dbmcli
DBMCLI: Release – Production on Mon Dec 14 13:25:01 CST 2015

Copyright (c) 2007, 2014, Oracle. All rights reserved.

DBMCLI> list dbserver detail
name: ###exa03db01
bbuStatus: normal
coreCount: 18/36
cpuCount: 36/36
diagHistoryDays: 7
fanCount: 16/16
fanStatus: normal
id: #########
interconnectCount: 2
interconnect1: ib0
interconnect2: ib1
ipaddress1: 192.168.10.1/22
ipaddress2: 192.168.10.2/22
kernelVersion: 2.6.39-400.250.4.el6uek.x86_64
locatorLEDStatus: off
makeModel: Oracle Corporation ORACLE SERVER X5-2
metricHistoryDays: 7
msVersion: OSS_12.1.2.1.2_LINUX.X64_150617.1
notificationMethod: snmp
notificationPolicy: critical,warning,clear
powerCount: 2/2
powerStatus: normal
releaseImageStatus: success
releaseVersion: 12.1.2.1.2.150617.1
releaseTrackingBug: 20748218
snmpSubscriber: host=10.240.6.21,port=162,community=public,type=ASR
status: online
temperatureReading: 22.0
temperatureStatus: normal
upTime: 32 days, 19:15
msStatus: running
rsStatus: running

DBMCLI>
DBMCLI> help

HELP [topic]
Available Topics:
ALTER
ALTER ALERTHISTORY
ALTER DBSERVER
ALTER IBPORT
ALTER THRESHOLD
CREATE
CREATE DBSERVER
CREATE THRESHOLD
DESCRIBE
DROP
DROP ALERTHISTORY
DROP DBSERVER
DROP THRESHOLD
LIST
LIST ALERTDEFINITION
LIST ALERTHISTORY
LIST DBSERVER
LIST IBPORT
LIST LUN
LIST METRICCURRENT
LIST METRICDEFINITION
LIST METRICHISTORY
LIST PHYSICALDISK
LIST THRESHOLD
SET
SPOOL
START

DBMCLI> list alerthistory
2_1 2015-09-09T07:04:25-05:00 critical “File system “/u01” is 89% full, which is above the 80% threshold. This alert will be cleared when file system “/u01″ becomes less than 75% full. Top three directories ordered by total space usage are as follows: /u01/app : 56.64G /u01/Software : 13.62G /u01/onecommand : 12.43G”

Like Exadata storage serves you can create file system threshold limit instead of crontab scripts.

DBMCLI> list metriccurrent
DS_BBU_TEMP ##exa03db01 26.0 C
DS_CPUT ##exa03db01 3.2 %
DS_CPUT_MS ##exa03db01 0.0 %
DS_FANS ##exa03db01 16
DS_FSUT / 42 %
DS_FSUT /boot 9 %
DS_FSUT /u01 34 %
DS_FSUT /u02 45 %
DS_FSUT /usr/openv 34 %
DS_MEMUT ##exa03db01 58 %
DS_MEMUT_MS ##exa03db01 0.1 %
DS_RUNQ ##exa03db01 1.4
DS_SWAP_IN_BY_SEC ##exa03db01 0.0 KB/sec
DS_SWAP_OUT_BY_SEC ##exa03db01 0.0 KB/sec
DS_SWAP_USAGE ##exa03db01 0 %
DS_TEMP ##exa03db01 22.0 C
DS_VIRTMEM_MS ##exa03db01 4,260 MB
N_HCA_MB_RCV_SEC ##exa03db01 0.351 MB/sec
N_HCA_MB_TRANS_SEC ##exa03db01 0.336 MB/sec
N_IB_MB_RCV_SEC HCA-1:1 0.158 MB/sec
N_IB_MB_RCV_SEC HCA-1:2 0.193 MB/sec
N_IB_MB_TRANS_SEC HCA-1:1 0.159 MB/sec
N_IB_MB_TRANS_SEC HCA-1:2 0.177 MB/sec
N_IB_UTIL_RCV HCA-1:1 0.0 %
N_IB_UTIL_RCV HCA-1:2 0.0 %
N_IB_UTIL_TRANS HCA-1:1 0.0 %
N_IB_UTIL_TRANS HCA-1:2 0.0 %
N_NIC_KB_RCV_SEC ##exa03db01 84.8 KB/sec
N_NIC_KB_TRANS_SEC ##exa03db01 3.5 KB/sec

DBMCLI> CREATE THRESHOLD DS_FSUT comparison=’>’,warning=75,critical=90
Threshold DS_FSUT successfully created

DBMCLI> alter THRESHOLD DS_FSUT comparison=”>”, warning=70
Threshold DS_FSUT successfully altered

DBMCLI> list threshold detail
name: DS_FSUT
comparison: >
critical: 90.0
warning: 70.0

DBMCLI> drop threshold DS_FSUT;
Threshold DS_FSUT successfully dropped

DBMCLI> list threshold detail

Advertisements

About Ugurcan

Exadata Engineer
This entry was posted in Oracle Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s