OEM ORACLE MONITORING TOOL
-------------------------------------------------
ORACLE ENTERPRISE MANAGER (OEM) ORACLE MONITORING TOOL
--------------------------------------------------------------------------------------------------
Introduction:
Oracle Enterprise Manager is a set of web based tools aims at managing software and hardware produced by oracle corporation as well as by non -oracle entitie OEM is a system management tool which provides an integrated solution for managing your heterogenous environment,it combines a graphical console,agents,common services,and tools to provide an integrated comprehensive systems management platform for managing oracle products.
In traditional one Oracle enterprsise manager in each databases one single enterprise manager in all the database,agent is the mediator for OEM and databases they will constantly monitor The database ,one single web URL which is used to login for entire monitoring environment all your targeted databases,they come with 12c cloud technology,12c OEM has a repository database will hold all the data for agent
1) Monitor other vendor databases also
2)Host monitoring
3)Generate all performance report from OEM itself like AWR at consolidate at one place
4)Schedule jobs
5)Monitoring Templates like any tablespace reach 90% thresh holdvalue set to 90% usage you will get the notify (Templates),you choose what the template you want apply to the target databases
6)Groups-->Target Groups :groups in 12c oem the entire group the entire job will be done in target groups like shutting down the database running queries
7) Monitor the RAC setup
8)Monitor the weblogic
9)Monitor the fusionware
10)Monitor the other vendors
11)we can configure thresh holds critical medium in the oem itself
12)Mount point utilization
13)we can take backup using the own scripts
14)checking blocking session is easy in OEM (performance tuning)
15)all the reports can be generated in OEM like (AWR,ADDM,ASH)
16)Startup and shutdown also be done in OEM
17)OEM also checks the database growth
Let us Start the process
----------------------------
Prerequisites
--------------
Oracle Linux installed in the system
Database should be installed
we will install the Enterprise Manager on a linux platform
we will get the software from oracle website ---->Downloads---->Enterprsie Manager---->click on oracle enterprise manager downloads----> select on linux x86 64 bit
we can get the three zipped files like em12103_linux_disk1.zip,em12103_linux_disk2.zip,em12103_linux_disk2.zip
before starting the install we need to make sure that there no database control configurataion
we need to set up that
we need to listener is to be started
after that emca -config dbcontrol db
started em configuration assistant
it will ask like database sid-->prod
listener port number -->1521
Listener Oracle_Home /u01/app/oracle/product/12.1.0/db
Password for sysuser
Password for DBSNMP user
Password for SYSMAN user
Email address for notifications
Outgoing mail SMTP server for notifications
You have to specified the following settings
After that emca configuration assistant completed it will get the OEM url
login screen Menu screen
Home Menu screen
Performance Menu screen
Availability Menu Screen
Server Menu Screen
Schema Menu Screen
Data movement Screen Menu
Software and Support Menu
Note : info on OEM it may be differ from your environment like production,testing,development
THANK YOU FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME
