Showing posts with label OEM. Show all posts
Showing posts with label OEM. Show all posts
Saturday, January 6, 2018
Steps
to add NFS/ZFS mount point to OEM monitoring
1.
Login to the server and check the nfs mount point using “df –h “:--
[]-->df
-h
Filesystem
Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00 --
Local
/dev/sda1
-- Local
amxnfs02:/nfs --NFS
amxnfs02:/nfs
amxp1zfs-data:/export --ZFS
2.
Login to OEM console and search with the hostname by putting the hostname in “search
target name”
3.
Click on the target name mentioned as host in OEM
4.
Click on host >>> monitoring >>> metric and collection
setting.
5.
Click on edit button of file system ;---
6.
Click on add button of the right end corner
7.
Then click on the search button and check the file system under current
monitoring
Steps to add the NFS mount point in OEM
:---
a. Login to the server and check if the agent is running by “ ps
–ef|grep emag”
b. Check the status of the emagent and make sure that the target is
GREEN in OEM
:---
c. Step the agent in OEM by using emctl stop agent :--
[]-->./emctl
stop agent
Oracle Enterprise Manager Cloud Control 12c
Release 5
Copyright (c) 1996, 2015 Oracle
Corporation. All rights reserved.
Stopping agent ..... stopped.
[applmgr@amx:/u01/app/oracle/agent12c_new/core/12.1.0.5.0/bin]
[]-->
d. Take the backup of the emd.properties file .
[applmgr@amx:/u01/app/oracle/agent12c_new/agent_inst/sysman/config]
[]-->cp emd.properties emd.properties_bkp_01052018
[applmgr@amx:/u01/app/oracle/agent12c_new/agent_inst/sysman/config]
[]-->
e. Modify the emd.properties and add the parameter EM_MONITOR_ALL_DISKS=true
and start
the emagent.
[applmgr@amx:/u01/app/oracle/agent12c_new/agent_inst/sysman/config]
[]-->cat emd.properties|grep
EM_MONITOR_ALL_DISKS
EM_MONITOR_ALL_DISKS=true
[applmgr@amx:/u01/app/oracle/agent12c_new/agent_inst/sysman/config]
[]-->
[applmgr@amx:/u01/app/oracle/agent12c_new/core/12.1.0.5.0/bin]
[]-->./emctl start agent
Oracle Enterprise Manager Cloud Control 12c
Release 5
Copyright (c) 1996, 2015 Oracle
Corporation. All rights reserved.
Starting agent ....................
started.
[applmgr@amx:/u01/app/oracle/agent12c_new/core/12.1.0.5.0/bin]
[]-->
f. Uploaad the agent once after starting the agent
[]-->emctl upload agent
Oracle Enterprise Manager Cloud Control 12c
Release 5
Copyright (c) 1996, 2015 Oracle
Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
[applmgr@amx:/u01/app/oracle/agent12c_new/core/12.1.0.5.0/bin]
[]-->
g. Click on enterprise (at left corner) >>>>
configuration >>>> Refresh host
configuration .
h. Re login to OEM console and validate the changes same as
Step 2 to Step 7 and it make take time to update the changes .
i. Once the changes are affected need to add the NFS mount point to
OEM with warning threshold as 20 and critical threshold as 5 and click on
continue.
j. Once clicked on continue , then clink on OK to save the
changes and then click on OK to confirm the changes .
Monday, November 13, 2017
OMS Database Important queries
----------------------------------------
Below table to pull all the
alerts in individual OEM host DB.
select *
from MGMT$ALERT_CURRENT
--where target_name like
'%OBI%'
--order by
collection_timestamp desc
-------------------------------------------
Please find the below
query which will help you in identifying the OEM incident state
select
a.INCIDENT_NUM,b.CATEGORY_NAME,a.SUMMARY_MSG,a.RESOLUTION_STATE,a.OWNER,a.IS_ACKNOWLEDGED,a.CLOSED_DATE,a.CREATION_DATE
from MGMT$INCIDENTS a,MGMT$INCIDENT_CATEGORY b
where
a.RESOLUTION_STATE not in
('Closed','Resolved')
--and
b.CATEGORY_NAME not in ('Diagnostics','Fault')
and
a.incident_id=b.incident_id order by CREATION_DATE desc;
--------------------------------------
Most
frequent alert current metric value and status
select
to_char(min(begin_time),'hh24:mi:ss')||'
/'||round(avg(intsize_csec/100),0)||'s' "Time+Delta",
metric_name||' - '||metric_unit
"Metric",
sum(value_inst1) inst1, sum(value_inst2)
inst2, sum(value_inst3) inst3, sum(value_inst4) inst4,
sum(value_inst5) inst5, sum(value_inst6)
inst6
from
( select
begin_time,intsize_csec,metric_name,metric_unit,metric_id,group_id,
case inst_id when 1 then round(value,1)
end value_inst1,
case inst_id when 2 then round(value,1)
end value_inst2,
case inst_id when 3 then round(value,1)
end value_inst3,
case inst_id when 4 then round(value,1)
end value_inst4,
case inst_id when 5 then round(value,1)
end value_inst5,
case inst_id when 6 then round(value,1)
end value_inst6
from gv$sysmetric
where metric_name in ('Host CPU Utilization
(%)','Current OS Load', 'Physical Write Total IO Requests Per Sec',
'Physical Write Total Bytes Per Sec',
'Global Cache Average Current Get Time', 'Global Cache Average CR Get Time',
'Physical Read Total Bytes Per Sec',
'Physical Read Total IO Requests Per Sec',
'CPU Usage Per Sec','Network Traffic
Volume Per Sec','Logons Per Sec','Redo Generated Per Sec',
'User Transaction Per Sec','Database CPU
Time Ratio','Database Wait Time Ratio','Database Time Per Sec')
)
group
by metric_id,group_id,metric_name,metric_unit
order
by metric_name;
Saturday, March 18, 2017
OEM Agent
---Agent bin
location
/app/oracle/agent11g/bin
--11g grid control
/u01/app/oracle/agent12c/core/12.1.0.5.0/perl/bin
-- 12c cloud
$AGENT_HOME/bin
---Agent log
location
$AGENT_HOME/sysman/log
----
Checking agent status
ps -ef
| grep em
ps -ef
| grep agent
ps -ef
| grep emctl
bin>emctl pingOMS
bin>emctl status agent
bin>emctl stop agent
bin>emctl start agent
bin>emctl upload agent
-- Creating Blackout
emctl start blackout CHG# -nodeLevel -d 08:00
The
The
-nodeLevel option is used to specify a
blackout for all the targets on the host; in other words, all the
targets that the Management Agent is monitoring, including the
Management Agent host itself. The -nodeLevel option must follow the blackout name. If you specify any targets after the -nodeLevel option, the list is ignoredemctl start blackout CHG# -nodeLevel -d 08:00
emctl status blackout CHG#
emctl stop blackout CHG#
OMS
OMS log
location
/u01/oracle/product/oms11g/em/EMGC_OMS1/sysman/log
Subscribe to:
Posts (Atom)