Monitoring Exalytics (linux 5) with EM13C – Part 1

Fresh Install of EM 13C and the challenges of pushing a 12.1.0.5 agent for linux 5 from EM13C.

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 !!! Lets try and export the agent on the host again. Agent Extracted !!! J

Exalytics Configuration

Log onto your ILOM and ensure the SP system identifier is entered. Log onto your exalytics system As Root

Agent Install onto exalytics

Create a directory on the Target: **This is a known BUG (Heartbeat Status : OMS responded illegally [ERROR- Failed to Update Target Type Metadata]) Download Patch
Patch 22581985: 12.1.0.5.0 agent & 13.1 OMS returns ERROR- Failed to Update Target Type Metadata
 
Install it and verify it as per previous patch. We are now ready to Discover the Exalytics system in EM13C.  

Oracle OpenWorld 2015

Oracle Openworld is an annual Oracle convention for business decision-makers, IT management, and line of business end users. The conference normally takes place around mid-September, this year it was late October. Presentations take place by Oracle, Consulting companies as well as community members. I believe the presentations by the community provide the best information. Around February/March I submitted a paper to present, unfortunately was not selected this year. This year Oracle were looking for the word cloud in the topics. The extent people go to so that there paper is selected is amazing. I was speaking to one person and they submitted the same paper 3 times worded differently, 1 of them had the word cloud in the title and it was accepted. So it’s very important that you pay attention to what they are looking for and base your presentation around these areas. I have to say I really enjoy going to Openworld and this was my fourth time, you will always learn new things and also get to network with different Oracle product teams as well as community members all in 1 place. On my flight over, I think half the people on the plane were attending Openworld and it was great to pass the time speaking to various community members on the flight over to San Francisico. For me, the following announcements were important, If you are thinking of upgrading, I have marked the key benefits to upgrade with a ‘*’: 1) OBIEE 12C - Oracle BI 12c is now generally available. BI 12c is the strategic foundation of Oracle’s analytics platform, delivering significant new value and lower total cost of ownership. *Easy to upgrade: BI 12c offers a radically simple and robust upgrade from 11g, saving customers time and effort in moving to the new version. BI 12c includes a free utility to automate regression testing, the Baseline Validation Tool, which verifies data, visuals, catalog object metadata, and system-generated SQL across 11g and 12c releases. *Faster: Sophisticated in-memory processing includes BI Server optimizations and support for multiple in-memory data stores, while in-memory Essbase on Exalytics offers enhanced concurrency and scalability, as well as significant performance gains. *Friendlier: Usability updates throughout BI 12c demonstrate Oracle’s continued commitment to making analytics as fast, flexible, and friendly as they are powerful and robust. A new user interface simplifies the layout for the homepage, Answers, and Dashboards, making it easier for users to quickly see what’s important; HTML-5 graphics improve view rendering; and it’s easier for users to create new groups, calculations, and measures, for simpler, more direct interaction with results. (Chargeable) More Visual: A consistent set of Data Visualization capabilities are now available across Oracle BI Cloud Service and Oracle BI 12c, as well as the upcoming Oracle Data Visualization Cloud Service, offering customers a continuity of visual experience unmatched by our competitors. Business users can point and click to upload personal data and blend it with IT-managed data in BI 12c, which automatically infers connections between data sets. Visualizing data is as easy as dragging attributes onto the screen, with optimal visualizations automatically displayed – no modeling or upfront configuration required. Related data is automatically connected, so highlighting data in one visual highlights correlated data in every other visual, immediately showing patterns and revealing new insights. These insights, along with narrative comments, can be shared as interactive visual stories, enabling seamless collaboration that drives fact-based decisions. – This is an additional license if you want to use the Visual Analyzer (VA) which is a shame, you will need to speak to your local Oracle Representative for pricing. *More Advanced: Predictive analysis is more tightly integrated, enabling customers to more easily forecast future conditions based on existing data points, group elements that are statistically similar, and expose outliers. BI 12c includes the ability to run the free Oracle R distribution on BI Server, and extend existing analytics with custom R scripts, which can point to any engine (R, Oracle Database, Spark, etc.) without needing to change the BI RPD to deliver results. More Mobile: Keyword search (“BI Ask”) empowers users to literally talk to their data, asking questions and having visualizations automatically created as responses, opening up an easy entry point for authoring. Additionally, the interface for iOS has been completely redesigned; and Mobile BI for Android offers sharing and following for nearby devices, as well as the ability to project any dashboard or story to GoogleCast-enabled devices. Bigger Data: BI 12c enables customers to use new data, from local, Oracle, and Big Data sources, including personal files uploaded by users; direct access to data in Hyperion Financial Management and Hyperion Planning applications; and ODBC access to Cloudera Impala. Apache Spark will be accessible via native Spark SQL in an upcoming update. Higher ROI, Lower TCO: Streamlined administration and life cycle management reduce the time and resources required to manage BI 12c, decreasing costs and increasing value for this and future releases. Enhancements include separating metadata from configuration; simpler, more robust security; easier backup, restore, and disaster recovery; hot patching of metadata; and many more. 2) Oracle Database 12c Release 2 - Beta Continuing to lead the database industry with ongoing innovations, Oracle today introduced beta availability for Oracle Database 12c Release 2. With its unique multitenant architecture and dual format in-memory database technology, Oracle Database 12c is already helping customers embrace the cloud, deliver real-time analytics and harness Big Data. Oracle Database 12c Release 2 further simplifies the journey to the cloud and provides efficient delivery of database services, with greater consolidation density and more administrative agility at cloud scale. Focus areas that are planned for Oracle Database 12c Release 2 include: * Improved Agility and Capacity with Enhancements to Oracle Multitenant: Planned enhancements include online movement of pluggable databases between servers, data centers and the Oracle Cloud. * Refinements to Oracle Database In-Memory: Features to boost performance, automate management, now you can use in-memory on your active standby Enhanced Support for Big DataAnalytics: In addition to enhancements to Database In-Memory, plans include spatial performance improvements and improved support for graph analytics. Hundreds of other new features: Drivers for all the key programming languages and frameworks have been enhanced. The release includes improvements to all the other main areas of customer interest including security, high availability, scalability, performance, and manageability. If you were thinking of going, make sure you get ready for OpenWorld 2016, which will take place around 16th-20th September 2016.