{"id":85,"date":"2013-05-16T14:12:42","date_gmt":"2013-05-16T17:12:42","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=85"},"modified":"2014-03-20T11:39:32","modified_gmt":"2014-03-20T14:39:32","slug":"setup-database-target-oem12c","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/","title":{"rendered":"Howto setup a new database target on Oracle EM 12c Cloud Control"},"content":{"rendered":"

In this post, we will make Oracle EM 12c monitor a new target (in which case it will be a Oracle Database non-RAC).<\/p>\n

In this example, we are dealing with an Oracle 11gR2 single instance database running on a Linux x86_64.<\/p>\n

The steps to be performed are:<\/p>\n

    \n
  1. Configure the Linux OS of the database to be monitored.<\/li>\n
  2. Configure the Oracle database to be monitored.<\/li>\n
  3. Deploy OS agent using EM 12c.<\/li>\n
  4. Add the database to the panel in EM 12c.<\/li>\n<\/ol>\n

    Let’s start.<\/p>\n

    The first step is to create the user on the target OS that will insure the implementation of the client’s agent in EM. Open the operating system of the target database and run the following commands:<\/p>\n

    (As root)<\/p>\n

    [root@oradbserver ~]# useradd -g oinstall emc12\r\n[root@oradbserver ~]# passwd emc12\r\nChanging password for user emc12.\r\nNew UNIX password: #Generate a random long password and write down, that user is in the group oinstall and can do great damage.\r\nRetype new UNIX password:\r\npasswd: all authentication tokens updated successfully.\r\n[root@oradbserver ~]# mkdir -p \/u02\/app\/emc12\/emagent\r\n[root@oradbserver ~]# chown -R emc12:oinstall \/u02\/app\/emc12<\/pre>\n
    Now that the user is already created, lets set the hostname of the EM server and set the PATH variable:<\/p>\n
    ### Add the following lines at the end of emc12 profile\r\numask 027\r\n\r\nexport ORACLE_HOME=\/u02\/app\/emc12\/emagent\/core\/12.1.0.2.0\r\n\r\nPATH=$PATH:$ORACLE_HOME\/bin\r\n\r\n### Add the following lines at the end of \/etc\/hosts\r\n\r\n#EMC 12C\r\n10.1.1.10 ec12mntrjr001.localdomain ec12mntrjr001<\/pre>\n
    Now, log into the instance to be monitored, unlock and change DBSNMP password. Put a random long password, and write down.<\/p>\n
    alter user DBSNMP identified by faoi32i98aj1la account unlock;<\/pre>\n
    Now that the OS and DB is already ready to be monitored, we open the EM 12c and add the host.<\/p>\n
    Log into the EM with the SYSMAN or a user who has administrator permission. Go to “Setup -> Add Target -> Add Targets Manually.” Click the “Add Host …”.<\/p>\n
    Let the name of the session as it is. Press “Add” and fill in the IP of the server where the user emc12 was configured.<\/p>\n
    \"\"<\/p>\n
    On the next page, fill in the data and the directory created on the server. There is no problem if the user emc12 does not have permission to run the “sudo” command, we will run the root.sh script manually\u00a0at the end.<\/p>\n
    \"\"<\/p>\n
    Check the information and click “Next”. On the next page, select “Deploy Agent” and wait. It will take a while depending on the link between the server and client.<\/p>\n
    The best way to monitor progress is to open the target OS and run the following command:<\/p>\n
    [root@oradbserver emagent]# du -sh \/u02\/app\/emc12\/emagent\/\r\n129M    \/u02\/app\/emc12\/emagent\/<\/pre>\n
    In this case, only 129 MBs of total was\u00a0transferred. The size can vary, but it is almost 231 MBs.<\/p>\n
    NOTE: If your connection to the EM drops for some reason, it will continue running the deployment job. You can go back to execution screen going through the menu “Setup -> Add Target -> Add Targets Manually”, going on the “Add Host Results” and selecting the session of agent deploy (probably the last).<\/p>\n
    Once finished, we should check if there is any warining. The case that there is only referring sudo permissions, we can ignore.<\/p>\n
    \"\"<\/p>\n
    Select the “Continue -> Continue All Hosts” and wait for the end of the deployment.<\/p>\n
    \"\"<\/p>\n
    Now it’s time to run the root.sh script on the host:<\/p>\n
    [root@oradbserver emagent]# \/u02\/app\/emc12\/emagent\/core\/12.1.0.2.0\/root.sh\r\nFinished product-specific root actions.\r\n\/etc exist\r\n\r\nCreating \/etc\/oragchomelist file...\r\nFinished product-specific root actions.<\/pre>\n
    Click “Done” and good job, agent deployed. Let’s now add the target database.<\/p>\n
    Go to “Targets -> Database”. In this new screen, select “Add -> Oracle Database.”<\/p>\n
    Fill in the IP of the target server and proceed:<\/p>\n
    \"\"<\/p>\n
    At this point, the agent will try to locate any target trackable on your database server. When finished, it will display your instance as the screenshot below:<\/p>\n
    \"\"<\/p>\n
    Click Configure and enter the password of DBSNMP, already defined. Take the opportunity to rename the database and the database system. Finally, test the connection, click “Next” and then “OK”.<\/p>\n
    \"\"<\/p>\n
    When you return to the Home screen, go to “Finish” and then “Save”.<\/p>\n
    Ok, your target is set. Now you can monitor your database. Go on the “Targets -> Databases”, open your body and monitor your database.<\/p>\n
    \"\"<\/p>\n
     <\/p>\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n
    Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-85","post","type-post","status-publish","format-standard","hentry","category-oem12c-en","item-wrap"],"yoast_head":"\nHowto setup a new database target on Oracle EM 12c Cloud Control - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Step by step of how to setup a new database target on Oracle EM 12c Cloud Control.\" \/>\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.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"Howto setup a new database target on Oracle EM 12c Cloud Control\",\"datePublished\":\"2013-05-16T17:12:42+00:00\",\"dateModified\":\"2014-03-20T14:39:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/\"},\"wordCount\":603,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/img_5193f41611950.png\",\"articleSection\":[\"Enterprise Manager 12c\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/\",\"name\":\"Howto setup a new database target on Oracle EM 12c Cloud Control - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/img_5193f41611950.png\",\"datePublished\":\"2013-05-16T17:12:42+00:00\",\"dateModified\":\"2014-03-20T14:39:32+00:00\",\"description\":\"Step by step of how to setup a new database target on Oracle EM 12c Cloud Control.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/img_5193f41611950.png\",\"contentUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2013\\\/05\\\/img_5193f41611950.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2013\\\/05\\\/setup-database-target-oem12c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Howto setup a new database target on Oracle EM 12c Cloud Control\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Howto setup a new database target on Oracle EM 12c Cloud Control - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Step by step of how to setup a new database target on Oracle EM 12c Cloud Control.","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.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"Howto setup a new database target on Oracle EM 12c Cloud Control","datePublished":"2013-05-16T17:12:42+00:00","dateModified":"2014-03-20T14:39:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/"},"wordCount":603,"commentCount":3,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/05\/img_5193f41611950.png","articleSection":["Enterprise Manager 12c"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/","url":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/","name":"Howto setup a new database target on Oracle EM 12c Cloud Control - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/05\/img_5193f41611950.png","datePublished":"2013-05-16T17:12:42+00:00","dateModified":"2014-03-20T14:39:32+00:00","description":"Step by step of how to setup a new database target on Oracle EM 12c Cloud Control.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#primaryimage","url":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/05\/img_5193f41611950.png","contentUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2013\/05\/img_5193f41611950.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2013\/05\/setup-database-target-oem12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Howto setup a new database target on Oracle EM 12c Cloud Control"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/85","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=85"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/85\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=85"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=85"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=85"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}