{"id":19,"date":"2013-03-03T19:27:00","date_gmt":"2013-03-03T19:27:00","guid":{"rendered":"https:\/\/sanmaharjan.com\/2013\/03\/03\/hostname-greater-than-32-character\/"},"modified":"2014-02-03T12:49:03","modified_gmt":"2014-02-03T12:49:03","slug":"hostname-greater-than-32-character","status":"publish","type":"post","link":"https:\/\/sanmaharjan.com\/hostname-greater-than-32-character\/","title":{"rendered":"HostName greater than 32 Character"},"content":{"rendered":"<div dir=\"ltr\">When your server&#8217;s hostname exceeds 32 character, then there might have an issue of creating or Running enterprise Manager repository.<br \/>\nfor a solution here are the steps to follow.<br \/>\ngot to folder $ORACLE_HOME\/sysman\/admin\/emdrep\/sql\/core\/latest\/self_monitor<span><span>$ cd $ORACLE_HOME\/sysman\/admin\/emdrep\/sql\/core\/latest\/self_monitor<\/span><\/span><\/p>\n<p>backup the sqlfile self_monitor_post_creation.sql to any other name incase you need it.<br \/>\n<span><span>$ cp self_monitor_post_creation.sql self_monitor_post_creation_bk.sql<\/span><\/span><\/p>\n<p>and edit word &#8220;<span>l_host_name\u00a0 varchar2(32)<\/span>&#8221; to &#8220;<span>l_host_name\u00a0 varchar2(50)<\/span>&#8221; in 2 places of <span><span>self_monitor_post_creation.sql file<\/span><\/span><\/p>\n<p>and recreate the enterprise manager repository<br \/>\n<span>\u00a0$ emca -config dbcontrol db -repos recreate <\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>When your server&#8217;s hostname exceeds 32 character, then there might have an issue of creating or Running enterprise Manager repository. for a solution here are the steps to follow. got to folder $ORACLE_HOME\/sysman\/admin\/emdrep\/sql\/core\/latest\/self_monitor$ cd $ORACLE_HOME\/sysman\/admin\/emdrep\/sql\/core\/latest\/self_monitor backup the sqlfile self_monitor_post_creation.sql to any other name incase you need it. $ cp self_monitor_post_creation.sql self_monitor_post_creation_bk.sql and edit word &#8220;l_host_name\u00a0 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[31],"tags":[29,28,27,26,30,12],"_links":{"self":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/19"}],"collection":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":2,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":28,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/posts\/19\/revisions\/28"}],"wp:attachment":[{"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sanmaharjan.com\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}