Oracle Enterprise Manager is an on premise management platform, we decided to investigate the use of 13c and see what benefits we could get by using this to monitor our exalytics system as well as our other Oracle portfolio including premise and cloud applications. There is many blogs on this but I had some interesting challenges that were difficult to resolve that I wanted to share. During this setup, I did reach out to some well-known EM13C experts that I wanted to say thanks to Kellyn – http://dbakevlar.com – @DBAKevlar and Philip – http://redstk.com/blog – @pbedba. When 13c came out they did not allow you to push or extract an agent that was lets say 12.1.0.5 that you would need if you have linux 5 running. It was OK if you already had an agent already installed and upgraded to 13 on the OMS server. This is where the fun began, In this post I will cover the basics as what was needed to be done to extract a 12.1.0.5 agent and install. Oracle released a few patches for this in the last 6 weeks to help with this which I will also cover.
We are installing this on windows 8, First thing we do is download the following:
- 12c Enterprise database
- Database templates for EM13.
- EM13
Ensure your account has administrator privileges.
DB12c Install
Start the installer for Oracle 12c Database.
Click next
Select install database software only.
For this we are selecting single instance database installation.
We are installing Enterprise Edition.
Remember the password.
Enter the paths and click next.
We have installed the database.
Unzip the database templates for EM to (This will be the location where you have installed the database software, ensure you unzip the templates to the templates folder.
C:\app\kt1\product\12.1.0\dbhome_1\assistants\dbca\templates
C:\app\kt1\product\12.1.0\dbhome_1\BIN
Run dbca.bat as administrator
Select next
Select advanced mode click next.
If you have saved the templates to the correct location you will see the templates in the above screen.
Enter your database name and click next.
Ensure nothing is selected in screen above and click next.
For this example we are using the same password, note your password.
Select create a new listener, and give it a name and the port you want to use.
Select filesystem,Click next.
In the above screen select the following file, which should be where you extracted your templates.: shpool_12.1.0.2.0_Database_SQL_for_EM13_1_0_0_0.sql
Click Next
Click Next
Click Finish
Database Created.
EM13c Install
Select next
Select skip for now, and click next.
As I am installing this on my laptop, I have ignore this error. Still works OK J, I have 8gb memory.
Click Yes
We are doing simple.
Enter your details as well as your host name.
Enter the password you want for your EM, and provide your database connection details.
Select next.
Click Install.
You will see the installation progress.
Downloading Agent Software
Our Exalytics system we need to install the agent 12.1.0.5, Log into your EM13C., Select Setup/Extensibility/Self Update,
Drill down into the agent software.
Select version 12.1.0.5
Click Download
At this point I started hitting problems. 13c did not allow you to push to a 12.1.0.5 agent by default, to be able to do this you will need to patch the EM13C. As when you try to export the agent you get an error as below.
Download Patch 22741755 and install as per Read Me, remember on windows ensure you do this as Administrator. Once done also verify it is Installed !!!
1 |
C:\Users\ktailor\Desktop\p22741755_131000_Generic\22741755>omspatcher lspatches |
Lets try and export the agent on the host again.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
<span style="line-height: 1.5em;">emcli get_agentimage -destination=c:\Agent -platform="Linux x86-64" -version=12.1.0.5.0</span> C:\>set ORACLE_HOME=C:\app\oracle\middleware <span style="line-height: 1.5em;">C:\>set PATH=%ORACLE_HOME%\bin;%PATH%</span> <span style="line-height: 1.5em;">C:\>emcli login -username=sysman</span> Enter password : <span style="line-height: 1.5em;">Login successful</span> C:\>emcli get_supported_platforms ----------------------------------------------- Version = 12.1.0.5.0 Platform = Linux x86-64 ----------------------------------------------- Version = 13.1.0.0.0 Platform = Microsoft Windows x64 (64-bit) ----------------------------------------------- Platforms list displayed successfully. C:\>emcli get_agentimage -destination=c:\Agent -platform="Linux x86-64" -version =12.1.0.5.0 ERROR:You cannot retrieve an agent image lower than 13.1.0.0.0. Only retrieving an agent image of 13.1.0.0.0 or higher is supported by this command. <span style="line-height: 1.5em;">C:\>emcli sync</span> Synchronized successfully <span style="line-height: 1.5em;">C:\>emcli get_agentimage -destination=c:\Agent -platform="Linux x86-64" -version</span> =12.1.0.5.0 === Partition Detail === Space free : 79 GB Space required : 1 GB Check the logs at C:\app\oracle\gc_inst\em\EMGC_OMS1\sysman\emcli\setup/.emcli/g et_agentimage_2016-05-04_11-36-52-AM.log Downloading c:\Agent\12.1.0.5.0_AgentCore_226.zip File saved as c:\Agent\12.1.0.5.0_AgentCore_226.zip Downloading c:\Agent\12.1.0.5.0_PluginsOneoffs_226.zip File saved as c:\Agent\12.1.0.5.0_PluginsOneoffs_226.zip Downloading c:\Agent\unzip File saved as c:\Agent\unzip |
Agent Extracted !!! J
Exalytics Configuration
Log onto your ILOM and ensure the SP system identifier is entered.
Log onto your exalytics system
As Root
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
<span style="line-height: 1.5em;"># pwd</span> /opt/exalytics # chmod +x configure_for_emcc.sh # ./configure_for_emcc.sh Connected. Use ^D to exit. -> show /SP system_identifier <span style="line-height: 1.5em;">/SP</span> Properties: system_identifier = Oracle Exalytics 1301FMJ001 <span style="line-height: 1.5em;">-> Session closed</span> Disconnected Contents of /var/exalytics/info/em-context.info file: system_identifier = Oracle Exalytics 1301FMJ001 Note: If the system_identifier is displayed as blank then it needs to be set through the ILOM web interface and this script needs to be rerun. Configured System Successfully <span style="line-height: 1.5em;"> </span> |
Agent Install onto exalytics
Create a directory on the Target:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 |
mkdir /u01/app/agent mkdir /u01/app/oracle/agentsw <span style="line-height: 1.5em;">Using software like scp copy the file (12.1.0.50_AgentCore…zip) and the 12.1.0.5.0_PluginsOneoffs_226.zip to u01/app/oracle/agentsw then only extract the 12.1.0.50_AgentCore zip.</span> <span style="line-height: 1.5em;">$ unzip 12.1.0.5.0_AgentCore_226.zip</span> <span style="line-height: 1.5em;">Archive: 12.1.0.5.0_AgentCore_226.zip</span> inflating: unzip inflating: agentDeploy.sh inflating: agentimage.properties inflating: agent.rsp extracting: agentcoreimage.zip $ pwd /u01/app/oracle/agentsw ls -ltr total 496072 -rw-rw-r-- 1 oracle oinstall 178 Jun 10 2015 agentimage.properties -rwxr-xr-x 1 oracle oinstall 145976 Jun 10 2015 unzip -rwxrwxr-x 1 oracle oinstall 3775 Jun 10 2015 agent.rsp -rwxrwxr-x 1 oracle oinstall 29124 Jun 10 2015 agentDeploy.sh -rw-rw-r-- 1 oracle oinstall 250059880 Jun 10 2015 agentcoreimage.zip -rw-r--r-- 1 oracle oinstall 250140662 May 4 05:37 12.1.0.5.0_AgentCore_226.zip -rw-r--r-- 1 oracle oinstall 7066252 May 4 05:37 12.1.0.5.0_PluginsOneoffs_226.zip <span style="line-height: 1.5em;">Edit the agent.rsp</span> <span style="line-height: 1.5em;">OMS_HOST=<Enter Hostname></span> EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=<Enter Password> AGENT_INSTANCE_HOME=/u01/app/agent2/agent_inst AGENT_PORT=3872 b_startAgent=true ORACLE_HOSTNAME=<exalytics Hostname> #s_agentHomeName=<Value Unspecified> Save the file. $ ./agentDeploy.sh AGENT_BASE_DIR=/u01/app/agent RESPONSE_FILE=/u01/app/oracle/agentsw/agent.rsp Agent Configuration completed successfully <span style="line-height: 1.5em;">The following configuration scripts need to be executed as the "root" user.</span> #!/bin/sh #Root script to run /u01/app/agent/core/12.1.0.5.0/root.sh To execute the configuration scripts: 1. Open a terminal window 2. Log in as "root" 3. Run the scripts Agent Deployment Successful. Agent deployment log location: /u01/app/agent/core/12.1.0.5.0/cfgtoollogs/agentDeploy/agentDeploy_2016-05-05_16-27-09-PM.log Agent deployment completed successfully. <span style="line-height: 1.5em;">As Root</span> # /u01/app/agent/core/12.1.0.5.0/root.sh Finished product-specific root actions. /etc exist <span style="line-height: 1.5em;">Creating /etc/oragchomelist file...</span> <span style="line-height: 1.5em;">$ pwd</span> /u01/app/agent/agent_inst/bin <span style="line-height: 1.5em;">$ ./emctl status agent</span> Oracle Enterprise Manager Cloud Control 12c Release 5 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 12.1.0.5.0 OMS Version : (unknown) Protocol Version : 12.1.0.1.0 Agent Home : /u01/app/agent/agent_inst Agent Log Directory : /u01/app/agent/agent_inst/sysman/log Agent Binaries : /u01/app/agent/core/12.1.0.5.0 Agent Process ID : 30928 Parent Process ID : 30704 Agent URL : https://exalytics.abc.com:3872/emd/main/ Local Agent URL in NAT : https://exalytics.abc.com:3872/emd/main/ Repository URL : https://abc.Net:1159/empbs/upload Started at : 2016-05-05 16:28:33 Started by user : oracle Operating System : Linux version 2.6.32-400.11.1.el5uek (amd64) Last Reload : (none) Last successful upload : (none) Last attempted upload : (none) Total Megabytes of XML files uploaded so far : 0 Number of XML files pending upload : 1 Size of XML files pending upload(MB) : 0 Available disk space on upload filesystem : 42.22% Collection Status : Collections enabled <span style="background-color: yellow;">Heartbeat Status : OMS responded illegally [ERROR- Failed to Update Target Type Metadata]</span> Last attempted heartbeat to OMS : 2016-05-05 16:35:40 Last successful heartbeat to OMS : (none) Next scheduled heartbeat to OMS : 2016-05-05 16:36:10 --------------------------------------------------------------- Agent is Running and Ready |
**This is a known BUG (Heartbeat Status : OMS responded illegally [ERROR- Failed to Update Target Type Metadata])
Download Patch
|
Install it and verify it as per previous patch.
We are now ready to Discover the Exalytics system in EM13C.