{"id":5734,"date":"2015-10-16T12:41:42","date_gmt":"2015-10-16T10:41:42","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/"},"modified":"2015-10-16T12:41:42","modified_gmt":"2015-10-16T10:41:42","slug":"dbsnmp-expiring-password-manually-triggering-metrics-collections","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/","title":{"rendered":"dbsnmp expiring password, manually triggering metrics collections"},"content":{"rendered":"<p>When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c.<\/p>\n<p>An interesting way to solve this problem is to create a metric extension detecting in how many days the password will expire:<\/p>\n<p>You realize the operation as follows:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4145 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1.png\" alt=\"dbsnmp1\" width=\"605\" height=\"480\" \/><\/a><\/p>\n<p>You define the collection frequency to 1 day<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4146 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp2.png\" alt=\"dbsnmp2\" width=\"546\" height=\"295\" \/><\/a><\/p>\n<p>You define the SQL request<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4147 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp3.png\" alt=\"dbsnmp3\" width=\"605\" height=\"130\" \/><\/a><\/p>\n<p>You define the metrics columns<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4148 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp4.png\" alt=\"dbsnmp4\" width=\"498\" height=\"413\" \/><\/a><\/p>\n<p>The metric extension defined, saved as deployable, published and applied to your database targets you will be told when the dbsnmp password will expire.<\/p>\n<p>In case the dbsnmp password is about to expire, such an incident will be created:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4150 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp7.png\" alt=\"dbsnmp7\" width=\"605\" height=\"53\" \/><\/a><\/p>\n<p>By the way, you will notice that the incident created by the password expiry will not be evaluated before one day, even if you change the password and the incident will remain in the EM12c incident manager.<\/p>\n<p>Of course you can use the Reevaluate Alert button in the incident manager page:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4149 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp6.png\" alt=\"dbsnmp6\" width=\"605\" height=\"197\" \/><\/a><\/p>\n<p>Nevertheless with EM12c, you have the possibility to manually trigger the metric collection by using the emctl control agent runCollection command.<\/p>\n<p>For example, if you need to reevaluate the dbsnmp_expiry metric collection manually and not waiting one day, you will have to use the following command:<\/p>\n<p>emctl control agent runcollection OMSREP:oracle_database &#8216;ME$dbsnmp_expiry&#8217;<\/p>\n<p>The metric will be reevaluated and the incident will disappear.<\/p>\n<p>Manually triggering the metrics can be very helpful when you administer a lot of targets. The usual case is when you receive a tablespace full alert. You increase or add a data file to correct the error, but as previously the metric collection will not be evaluated immediately and the generated incident will always be present.<\/p>\n<p>The syntax of the command described in the Oracle documentation is:<\/p>\n<p>emctl control agent runCollection &lt;targetName&gt;:&lt;targetType&gt; &lt;collectionItemName&gt;<\/p>\n<p>&nbsp;<\/p>\n<p>Oracle\u2019s documentation tells us to look in xml files located in $AGENT_BASE\/plugins in order to find the collectionItemName:<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">oracle@vm12c:\/u01\/app\/oracle\/agent12cR5\/plugins\/ [agent12c] ls\noracle.sysman.beacon.agent.plugin_12.1.0.5.0\noracle.sysman.emrep.agent.plugin_12.1.0.5.0\noracle.sysman.db.agent.plugin_12.1.0.8.0\noracle.sysman.oh.agent.plugin_12.1.0.5.0\noracle.sysman.db.discovery.plugin_12.1.0.8.0\noracle.sysman.oh.discovery.plugin_12.1.0.5.0\noracle.sysman.emas.agent.plugin_12.1.0.8.0\noracle.sysman.xa.discovery.plugin_12.1.0.6.0\noracle.sysman.emas.discovery.plugin_12.1.0.8.0<\/pre>\n<p>&nbsp;<\/p>\n<p>In our case we have a look in oracle.sysman.db.agent.plugin_12.1.0.8.0\/default_collections and have a look at the database.xmlp file, you have to search Tablespaces Full:<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">======================================================================\n== Category: Tablespaces Full - 10i - locally managed - not CDB\n======================================================================\n--&gt;\n&lt;CollectionItem NAME=\"problemTbsp_10i_Loc\"&gt;\n&lt;ValidIf&gt;\n&lt;CategoryProp NAME=\"VersionCategory\" CHOICES=\"10gR2;10gR203;10gR204;10gR205;11gR1;11gR2;11gR202;12c\"\/&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&lt;CategoryProp NAME=&#8221;MetricScope&#8221; CHOICES=&#8221;DB&#8221;\/&gt;<\/p>\n<p>&lt;CategoryProp NAME=&#8221;DBCategoryDetails&#8221; CHOICES=&#8221;FullLLFile;none;TRUE;FALSE;1;0&#8243;\/&gt;<\/p>\n<p>&lt;\/ValidIf&gt;<\/p>\n<p>&lt;Schedule&gt;<\/p>\n<p>&lt;IntervalSchedule INTERVAL=&#8221;30&#8243; TIME_UNIT=&#8221;Min&#8221;\/&gt;<\/p>\n<p>&lt;\/Schedule&gt;<\/p>\n<p>In order to manually trigger the tablespace full alert, we use the command:<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">oracle@vm12c:\/u01\/app\/oracle\/agent12cR5\/ [agent12c] emctl control agent runCollection OMSREP:oracle_database problemTbsp_10i_Loc\nOracle Enterprise Manager Cloud Control 12c Release 5\nCopyright (c) 1996, 2015 Oracle Corporation. All rights reserved.\n---------------------------------------------------------------\nEMD runCollection completed successfully<\/pre>\n<p>There is also an easy way to find all the collectionItemName. All those collections are scheduled by the agent, so if you run the command:<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">oracle@vmtestoraem12c:\/u01\/app\/oracle\/ [agent12c] emctl status agent scheduler | grep oracle_database | grep OMSREP\n2015-09-24 15:16:53.222 : oracle_database:OMSREP:UserLocksCollection\n2015-09-24 15:16:55.432 : oracle_database:OMSREP:Response\n2015-09-24 15:16:57.805 : oracle_database:OMSREP:wait_sess_cls_10i\n2015-09-24 15:17:12.566 : oracle_database:OMSREP:observer_11g\n2015-09-24 15:17:42.703 : oracle_database:OMSREP:haconfig2_collection\n2015-09-24 15:18:41.928 : oracle_database:OMSREP:Recovery_Area\n2015-09-24 15:18:51.331 : oracle_database:OMSREP:latest_hdm_findings_coll_item\n2015-09-24 15:18:54.788 : oracle_database:OMSREP:dgprimarydb_collection\n2015-09-24 15:19:09.136 : oracle_database:OMSREP:adr_alert_log_rollup\n2015-09-24 15:19:38.388 : oracle_database:OMSREP:incident_meter\n2015-09-24 15:19:59.818 : oracle_database:OMSREP:topWaitEvents_col\n2015-09-24 15:20:16.315 : oracle_database:OMSREP:db_alertlog_coll_12\n2015-09-24 15:20:32.234 : oracle_database:OMSREP:haconfig4_collection\n2015-09-24 15:20:48.166 : oracle_database:OMSREP:memory_usage_coll_item\n2015-09-24 15:20:48.307 : oracle_database:OMSREP:activity_pending\n2015-09-24 15:20:49.534 : oracle_database:OMSREP:archFull\n2015-09-24 15:20:59.886 : oracle_database:OMSREP:haconfig3_collection\n2015-09-24 15:21:14.840 : oracle_database:OMSREP:db_inst_pga_alloc_11g\n2015-09-24 15:21:43.593 : oracle_database:OMSREP:rac_global_cache_10i\n2015-09-24 15:21:47.527 : oracle_database:OMSREP:dataguard_11gR2\n2015-09-24 15:22:09.095 : oracle_database:OMSREP:memory_usage_sga_pga\n2015-09-24 15:22:11.189 : oracle_database:OMSREP:sga_pool_wastage_10i\n2015-09-24 15:22:19.278 : oracle_database:OMSREP:UserAudit\n2015-09-24 15:22:21.311 : oracle_database:OMSREP:Database_Resource_Usage_10i\n2015-09-24 15:22:45.416 : oracle_database:OMSREP:sysTimeModel_col\n2015-09-24 15:23:41.486 : oracle_database:OMSREP:db_inst_opt_sga\n2015-09-24 15:23:43.516 : oracle_database:OMSREP:instance_efficiency_10i\n2015-09-24 15:23:51.902 : oracle_database:OMSREP:system_response_time_per_call_10i\n2015-09-24 15:24:32.947 : oracle_database:OMSREP:wait_bottlenecks_10i\n2015-09-24 15:24:53.137 : oracle_database:OMSREP:topSqlMonitoringList_col\n2015-09-24 15:25:04.134 : oracle_database:OMSREP:instance_throughput_10i\n2015-09-24 15:26:19.263 : oracle_database:OMSREP:service_10i\n2015-09-24 15:33:34.681 : oracle_database:OMSREP:log_full\n2015-09-24 15:33:35.160 : oracle_database:OMSREP:problemTbsp_10i_Loc\n2015-09-24 15:33:35.223 : oracle_database:OMSREP:problemTbsp_10i_Dct\n2015-09-24 15:33:35.474 : oracle_database:OMSREP:problemTbspTemp_10i_Loc\n2015-09-24 15:33:35.504 : oracle_database:OMSREP:problemTbspUndo_10i_Loc\n2015-09-24 15:33:35.797 : oracle_database:OMSREP:dbjob_status\n2015-09-24 15:33:37.800 : oracle_database:OMSREP:audit_failed_logins\n2015-09-24 15:33:38.363 : oracle_database:OMSREP:aq_monitoring_alerts\n2015-09-24 15:33:38.455 : oracle_database:OMSREP:streams_processes_count_item\n2015-09-24 15:33:38.762 : oracle_database:OMSREP:streams_statistics\n2015-09-24 15:33:40.027 : oracle_database:OMSREP:Temporary File Status\n2015-09-24 16:03:34.340 : oracle_database:OMSREP:scn_instance_collection\n2015-09-24 16:03:34.671 : oracle_database:OMSREP:db_inst_cpu_usage\n2015-09-24 16:03:38.055 : oracle_database:OMSREP:DatabaseVaultRealmViolation_collection\n2015-09-24 16:03:38.222 : oracle_database:OMSREP:DatabaseVaultRealmConfigurationIssue_collection\n2015-09-24 16:03:38.239 : oracle_database:OMSREP:DatabaseVaultCommandRuleViolation_collection\n2015-09-24 16:03:38.542 : oracle_database:OMSREP:DatabaseVaultCommandRuleConfigurationIssue_collection\n2015-09-24 16:03:39.403 : oracle_database:OMSREP:DatabaseVaultPolicyChanges_collection\n2015-09-24 16:03:39.871 : oracle_database:OMSREP:scn_growth_collection\n2015-09-24 18:03:25.455 : oracle_database:OMSREP:oracle_dbconfig\n2015-09-24 18:03:33.694 : oracle_database:OMSREP:ocm_instrumentation\n2015-09-24 18:03:33.712 : oracle_database:OMSREP:mgmt_sql\n2015-09-24 18:03:33.714 : oracle_database:OMSREP:has_resources\n2015-09-24 18:03:33.905 : oracle_database:OMSREP:sizeOfOSAuditFiles_collection\n2015-09-24 18:03:34.589 : oracle_database:OMSREP:problemSegTbsp\n2015-09-24 18:03:34.849 : oracle_database:OMSREP:ha_dg_target_summary\n2015-09-24 18:03:34.858 : oracle_database:OMSREP:invalid_objects_rollup\n2015-09-24 18:03:35.003 : oracle_database:OMSREP:tbspAllocation\n2015-09-24 18:03:35.917 : oracle_database:OMSREP:haconfig1_collection\n2015-09-24 18:03:36.848 : oracle_database:OMSREP:audit_failed_logins_historical\n2015-09-24 18:03:38.968 : oracle_database:OMSREP:mgmt_database_listener_config\n2015-09-24 18:03:38.996 : oracle_database:OMSREP:exadataCollection\n2015-09-24 18:03:39.449 : oracle_database:OMSREP:scn_max_collection\n2015-09-24 18:03:39.546 : oracle_database:OMSREP:db_instance_caging\n2015-09-24 18:03:47.855 : oracle_database:OMSREP:oracle_cdbconfig\n2015-09-24 22:08:59.848 : oracle_database:OMSREP:ME$dbsnmp_expiry<\/pre>\n<p>&nbsp;<\/p>\n<p>You will find the entire collection item name you can reevaluate with the emctl control agent runCollection command.<\/p>\n<p>For a host target, the behavior is equivalent:<\/p>\n<p>oracle@vmtestoraem12c:\/u01\/app\/oracle\/ [agent12c] emctl status agent scheduler | grep host | grep vmtestoraem12c<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">2015-09-24 15:22:12.565 : host:vm12c:Processes_diagnosticsLinux\n2015-09-24 15:23:45.713 : host:vm12c:LoadLinux\n2015-09-24 15:23:52.670 : host:vm12c:ProgramResourceUtilizationLinux\n2015-09-24 15:24:10.227 : host:vm12c:PagingActivityLinux\n2015-09-24 15:24:41.241 : host:vm12c:TotalDiskUsageLinux\n2015-09-24 15:25:34.795 : host:vm12c:CPUUsageLinux\n2015-09-24 15:26:19.727 : host:vm12c:FileMonitoringLinux\n2015-09-24 15:26:31.792 : host:vm12c:NetworkLinux\n2015-09-24 15:27:26.153 : host:vm12c:DiskActivityLinux\n2015-09-24 15:33:35.080 : host:vm12c:proc_zombieLinux\n2015-09-24 15:33:46.489 : host:vm12c:LogFileMonitorLinux\n2015-09-24 15:34:22.695 : host:vm12c:FilesystemsLinux\n2015-09-24 18:02:53.840 : host:vm12c:host_storage\n2015-09-24 18:02:54.169 : host:vm12c:HostStorageSupport\n2015-09-24 18:02:54.201 : host:vm12c:DiscoverTargets\n2015-09-24 18:02:55.599 : host:vm12c:oracle_security\n2015-09-24 18:02:56.532 : host:vm12c:Swap_Area_StatusLinux\n2015-09-24 18:26:28.295 : host:vm12c:ll_host_config<\/pre>\n<p>&nbsp;<\/p>\n<p>Conclusion:<\/p>\n<p>Depending of the metric evaluation frequency, it might be very useful to manually trigger the metric collections in order to cleanup false open incidents in the Enterprise Manager Cloud 12c console.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":5741,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[215],"type_dbi":[],"class_list":["post-5734","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-oracle-enterprise-manager"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>dbsnmp expiring password, manually triggering metrics collections - 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\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"dbsnmp expiring password, manually triggering metrics collections\" \/>\n<meta property=\"og:description\" content=\"When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-16T10:41:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"605\" \/>\n\t<meta property=\"og:image:height\" content=\"480\" \/>\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=\"7 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\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"dbsnmp expiring password, manually triggering metrics collections\",\"datePublished\":\"2015-10-16T10:41:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\"},\"wordCount\":542,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png\",\"keywords\":[\"Oracle Enterprise Manager\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\",\"name\":\"dbsnmp expiring password, manually triggering metrics collections - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png\",\"datePublished\":\"2015-10-16T10:41:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png\",\"width\":605,\"height\":480},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"dbsnmp expiring password, manually triggering metrics collections\"}]},{\"@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":"dbsnmp expiring password, manually triggering metrics collections - 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\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/","og_locale":"en_US","og_type":"article","og_title":"dbsnmp expiring password, manually triggering metrics collections","og_description":"When you use Enterprise Manager Cloud control 12c, the monitor username commonly used is dbsnmp. Depending on the Oracle profile used for this user, the dbsnmp password can expire, and as a consequence multiple targets will be seen in a pending status by Enterprise Manager Cloud control 12c. An interesting way to solve this problem [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/","og_site_name":"dbi Blog","article_published_time":"2015-10-16T10:41:42+00:00","og_image":[{"width":605,"height":480,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"dbsnmp expiring password, manually triggering metrics collections","datePublished":"2015-10-16T10:41:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/"},"wordCount":542,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png","keywords":["Oracle Enterprise Manager"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/","url":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/","name":"dbsnmp expiring password, manually triggering metrics collections - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png","datePublished":"2015-10-16T10:41:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbsnmp1-1.png","width":605,"height":480},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbsnmp-expiring-password-manually-triggering-metrics-collections\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"dbsnmp expiring password, manually triggering metrics collections"}]},{"@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\/5734","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=5734"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5734\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5741"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5734"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}