{"id":8189,"date":"2016-06-10T11:42:04","date_gmt":"2016-06-10T09:42:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/"},"modified":"2016-06-10T11:42:04","modified_gmt":"2016-06-10T09:42:04","slug":"em13c-and-postgres-plugin","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/","title":{"rendered":"EM13c and postgres plugin"},"content":{"rendered":"

As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of database.<\/p>\n

Once you have downloaded the Blue Medora plugin for EM13c, you have to unzip it:<\/p>\n

oracle@vmtestoraCC13c:\/home\/oracle\/psi\/ [rdbms12102] unzip bm.em.xpgs_12.1.0.2.0_2.0.3.zip\nArchive:\u00a0 bm.em.xpgs_12.1.0.2.0_2.0.3.zip\n\u00a0 inflating: bm.em.xpgs_12.1.0.2.0_2.0.3.opar\n......\n\n<\/pre>\n
Then like other plugins, you have to import it in the OMS (Oracle Management Server):<\/p>\n
oracle@vmtestoraCC13c:\/home\/oracle\/psi\/ [oms13c] emcli import_update\n -file=\/home\/oracle\/psi\/bm.em.xpgs_12.1.0.2.0_2.0.3.opar -omslocal\nProcessing update: Plug-in - PostgreSQL Monitoring\nSuccessfully uploaded the update to Enterprise Manager. \nUse the Self Update Console to manage this update.<\/pre>\n
Once imported, from the Extensibility plugin page, we can display the PostgreSQL plugin:<\/p>\n
\"pp1\"<\/a><\/p>\n
We have to deploy the plugin to the OMS:<\/p>\n
\"pp2\"<\/a><\/p>\n
The next step consists now to deploy the plugin on an agent where there is an existing postgres environment, we select the adequate agent and we select Continue:<\/p>\n
\"pp3\"<\/a><\/p>\n
The postgresql plugin is successfully deployed to the agent:<\/p>\n
\"pp4\"<\/a><\/p>\n
Once the plugin is deployed, we need to add a postgres database target. I used the Add Target Declaratively and choosed Postgresql Database as Target Type:<\/p>\n
\"pp5\"<\/a><\/p>\n
In the next screen you enter the target name and useful informations such as hostname, login, password and port number:<\/p>\n
\"pp6\"<\/a><\/p>\n
Finally the postgresql database target has been added successfully:<\/p>\n
\"pp7\"<\/a><\/p>\n
Once the configuration phase finished, let\u2019s have a look over how EM13c works with postgresql !<\/p>\n
The newly postgresql database target exist in EM13c:<\/p>\n
\"pp8\"<\/a><\/p>\n
We have the same menus as we are used for Oracle database targets:<\/p>\n
\"pp18\"<\/a><\/p>\n
Now let’s try to create a monitoring template for postgresql database. From the EM13c Monitoring template menu, choose create:<\/p>\n
\"pp9\"<\/a><\/p>\n
Choose Target Type and select PosgreSQL database:<\/p>\n
\"pp10\"<\/a><\/p>\n
Enter the monitoring template name and a description:<\/p>\n
\"pp11\"<\/a><\/p>\n
You have the possibility to define thresholds for metrics:<\/p>\n
\"pp12\"<\/a><\/p>\n
Select Ok and the DBI_DB_POSTGRES is created.<\/p>\n
Finally we apply the template to our postgres database as follows, we select the postgressql database and we select Apply:<\/p>\n
\"pp13\"<\/a><\/p>\n
The Home postgres EM13c page displays more informations:<\/p>\n
\"pp14\"<\/a><\/p>\n
The postgresql monitoring offers a lot of monitoring solutions:<\/p>\n
\"pp161\"<\/a><\/p>\n
 <\/p>\n
We have the possibility to diplay the table or indices details:<\/p>\n
\"pp15\"<\/a><\/p>\n
Another good point is the possibility to use the reports. For example the target availability:<\/p>\n
\"pp17\"<\/a><\/p>\n
You can also create incident rules in the same way you did it for Oracle databases. Creating incident rules about Availability, Metric Alert or Metric Errors allows you the possibility to have incidents created and to receive alerts when something goes wrong in your posgresql database.<\/p>\n
\"pp16\"<\/a><\/p>\n
Once you have correctly configured your incident rules and their events, when you stop your postgres database, an incident is created and you receive a mail :=)<\/p>\n
\"pp19\"<\/a><\/p>\n
Deploying the Blue Medora’s plugin in order to administer your postgresql databases withe Enterprise Manager 13c will help you to administer heteregeneous databases environment. Furthermore you can use monitoring templates and incident rules.<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of […]<\/p>\n","protected":false},"author":27,"featured_media":8210,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[96,215,77],"type_dbi":[],"class_list":["post-8189","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-oracle","tag-oracle-enterprise-manager","tag-postgresql"],"acf":[],"yoast_head":"\nEM13c and postgres plugin - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EM13c and postgres plugin\" \/>\n<meta property=\"og:description\" content=\"As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-10T09:42:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"383\" \/>\n\t<meta property=\"og:image:height\" content=\"157\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"EM13c and postgres plugin\",\"datePublished\":\"2016-06-10T09:42:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\"},\"wordCount\":483,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png\",\"keywords\":[\"Oracle\",\"Oracle Enterprise Manager\",\"PostgreSQL\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\",\"name\":\"EM13c and postgres plugin - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png\",\"datePublished\":\"2016-06-10T09:42:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png\",\"width\":383,\"height\":157},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EM13c and postgres plugin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"EM13c and postgres plugin - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/","og_locale":"en_US","og_type":"article","og_title":"EM13c and postgres plugin","og_description":"As an Oracle DBA I use Enterprise Manager to monitor Oracle databases at my client’s sites. I also administer more and more Postgres databases. I decided to download the Blue Medora plugin in order to monitor the postgresql databases with Enterprise Manager 13c, and to avoid to have different monitoring tools for each kinf of […]","og_url":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/","og_site_name":"dbi Blog","article_published_time":"2016-06-10T09:42:04+00:00","og_image":[{"width":383,"height":157,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"EM13c and postgres plugin","datePublished":"2016-06-10T09:42:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/"},"wordCount":483,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png","keywords":["Oracle","Oracle Enterprise Manager","PostgreSQL"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/","url":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/","name":"EM13c and postgres plugin - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png","datePublished":"2016-06-10T09:42:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pp1-1.png","width":383,"height":157},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/em13c-and-postgres-plugin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"EM13c and postgres plugin"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=8189"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8189\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8210"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8189"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}