{"id":7151,"date":"2016-02-22T10:27:43","date_gmt":"2016-02-22T09:27:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/"},"modified":"2016-02-22T10:27:43","modified_gmt":"2016-02-22T09:27:43","slug":"em-13c-target-is-fully-broken","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/","title":{"rendered":"EM 13c target is fully broken !!"},"content":{"rendered":"

At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the following state\u00a0:<\/p>\n

2016-02-05 15:31:46,863 [2527:A154C6AD] INFO - Target: [oracle_database.TESTDBA] is fully broken: \nDynamic Category property error (code=0x400)<\/pre>\n
The gcagent.log showed me the errors:<\/p>\n
2016-01-28 13:41:11,423 [261843:CE28B2D8] INFO - >>> Reporting exception: \noracle.sysman.emSDK.agent.client.exception.NoSuchTargetException: \nthe oracle_database target \"TESTDBA\" does not exist (request id 1) <<< \noracle.sysman.emSDK.agent.client.exception.NoSuchTargetException: \nthe oracle_database target \"TESTDBA\" does not exist \nat oracle.sysman.gcagent.dispatch.cxl.GetMetricDataAction.satisfyRequest(GetMetricDataAction.java:175) \nat oracle.sysman.gcagent.dispatch.ProcessRequestAction._call(ProcessRequestAction.java:135) \nat oracle.sysman.gcagent.dispatch.ProcessRequestAction.call(ProcessRequestAction.java:96) \nat oracle.sysman.gcagent.dispatch.InlineDispatchCoordinator.dispatchRequest(InlineDispatchCoordinator.java:235) \nat oracle.sysman.gcagent.dispatch.DispatchRequestsAction.call(DispatchRequestsAction.java:111) \nat oracle.sysman.gcagent.dispatch.DispatchRequestsAction.call(DispatchRequestsAction.java:51) \nat oracle.sysman.gcagent.task.DiagWrappedAction.call(DiagWrappedAction.java:52) \nat java.util.concurrent.FutureTask.run(FutureTask.java:262) \nat oracle.sysman.gcagent.task.SingleActionTask.run(SingleActionTask.java:76)<\/pre>\n
Looking at \/https:\/\/agent:3872\/emd\/browser\/main we can display the following error:<\/p>\n
2016-01-22 11:49:34,661 ERROR - \nThe target is fully broken (code=0x404) for the following reason: Invalid Input \n 2016-01-22 11:49:35,184 ERROR - The target is fully broken (code=0x406) for the following reason: \nNo valid queryDescriptor or executionDescriptor found for target [oracle_database.TESTDBA$11] \n 2016-01-22 11:49:35,193 INFO - Dynamic property execution error for [DeduceAlertLogFile], \nerror: Can't resolve a non-optional query descriptor property [background_dump_dest<\/pre>\n
I opened a SR and Oracle gave me an important hint by asking me to run the following query:<\/p>\n
SQL> select v.version \"DBVersion\", p.value \"DBDomain\" from \n(select nvl((select version from (select version || '.'|| id version\nfrom dba_registry_history where NAMESPACE = 'SERVER'\nand BUNDLE_SERIES='PSU'\norder by ACTION_TIME desc) where rownum = 1),\n(select version from v$instance)) version from dual) v, v$parameter p\nwhere p.name='db_domain';\nand BUNDLE_SERIES='PSU'\n\u00a0\u00a0\u00a0\u00a0 *\nERROR at line 3:\nORA-00904: \"BUNDLE_SERIES\": invalid identifier<\/pre>\n
We can notice the BUNDLE_SERIES column does not exist in the view dba_registry_history for my database target in a fully broken state.<\/p>\n
By the way there is a bug number 9656976<\/a>\u00a0:<\/p>\n
Execution of catbundle.sql is not always required for new and upgraded databases. \n The Readme documentation indicates when it is required. \n However, you can execute catbundle.sql when it is not required so that the new or \nupgraded database has an updated dba_registry_history table<\/pre>\n
I tried a first solution by creating a table named dba_registry_history under the dbsnmp monitoring user in my broken database target, and the target was dicovered successfully, and was not anymore in a fully broken state.<\/p>\n
Finally I choosed to run the catbundle.sql script on every database which were in a broken state, and the database target discovery was successfull for every database.<\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[96,215],"type_dbi":[],"class_list":["post-7151","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-oracle","tag-oracle-enterprise-manager"],"acf":[],"yoast_head":"\nEM 13c target is fully broken !! - 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\/em-13c-target-is-fully-broken\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EM 13c target is fully broken !!\" \/>\n<meta property=\"og:description\" content=\"At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-22T09:27:43+00:00\" \/>\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\\\/em-13c-target-is-fully-broken\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"EM 13c target is fully broken !!\",\"datePublished\":\"2016-02-22T09:27:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/\"},\"wordCount\":201,\"commentCount\":0,\"keywords\":[\"Oracle\",\"Oracle Enterprise Manager\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/\",\"name\":\"EM 13c target is fully broken !! - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-02-22T09:27:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/em-13c-target-is-fully-broken\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EM 13c target is fully broken !!\"}]},{\"@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":"EM 13c target is fully broken !! - 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\/em-13c-target-is-fully-broken\/","og_locale":"en_US","og_type":"article","og_title":"EM 13c target is fully broken !!","og_description":"At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at this timeI discovered that half of my database targets in 11.2.0.3 version were in the […]","og_url":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/","og_site_name":"dbi Blog","article_published_time":"2016-02-22T09:27:43+00:00","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\/em-13c-target-is-fully-broken\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"EM 13c target is fully broken !!","datePublished":"2016-02-22T09:27:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/"},"wordCount":201,"commentCount":0,"keywords":["Oracle","Oracle Enterprise Manager"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/","url":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/","name":"EM 13c target is fully broken !! - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-02-22T09:27:43+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/em-13c-target-is-fully-broken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"EM 13c target is fully broken !!"}]},{"@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\/7151","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=7151"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7151\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7151"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7151"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}