• ASH and AWR - Database - EM13c - Enterprise Manager - Oracle

    Management Packs, Restricted Use Licenses and the Enterprise Manager

    There was a question posted on Oracle-l forum today that should have a blog post for easy lookup for folks.  Regarding your Enterprise Manager repository database, (aka OMR.)   This database has a restricted use license, which means you can use it for the Enterprise Manager repository, but you can’t add partitioning to it or RAC or dataguard features without licensing those features.  You also can’t use the diagnostic and tuning pack features available in Enterprise Manager on the repository database without licensing it outside of the EMDiagnostics tool.  You can view information about the license that is part of…

  • EM13c

    EM13c Upgrade Tips- Part II

    There is a flurry of excitement about Enterprise Manager 13c and I’m blown away by how many customers are looking not just to install and test out the new release, but have plans already underway to upgrade to it.  At Oracle, we’re covering a lot of information that will help make that upgrade easier and I want to make sure I share what we learn with the public so you can be as cool about upgrades as we are. Your Repository is Going to be a Single Tenant Database 12c You MUST upgrade your repository, (OMR) to 12.1.0.2 Also plan on applying the…

  • EM13c

    Adding Targets in Enterprise Manager 13c

    The only thing that is constant is change. There were some major changes to Enterprise Manager with 13c and many of them may seem small to someone who knows the product well, but then again, it may trip you up as you’re accustomed to features working as you knew them in EM12c.  One of these features is the manual edition of targets through the guided process. Adding a Target  The Setup menu is still on the right, it just has some company now in the new EM13c interface: Click on Setup, Add Target, Add Targets Manually. This is where the…

  • EM13c

    Installing a New Enterprise Manager 13c Environment

    As I patiently wait for approvals to post my Oracle Management Cloud blog posts, I thought I would just post on Enterprise Manager 13c and answer questions that have been posed to me via email and comments. Is there anything new I need to watch for as I install EM13c? Your management repository database should be a single-tenant 12.1.0.2 database. Disable adaptive_features parameter in the database you will use for your repository. Update the /etc/security/limits.conf file to set soft nofiles to 30000 from previous common setting of 8192 session_cached_cursors parameter should be set to 500 Even though it may warn you…

  • Enterprise Manager - Oracle - Oracle Management Cloud

    Oracle Open World 2015, Survival of the Fittest!

    So I’m about to depart for one day in San Antonio, Tx. to present at the International Performance and Capacity Conference, but I wanted to try to get another blog post out, this time regarding my survival at the 2015 Oracle Open World. I’m not sure if it just that the schedule was a month later than usual or that it was just more demanding this year, but I left on Friday, feeling utterly exhausted and judging by the tweets and posts from others on social media, I don’t think I was the only one!  I always regret what I didn’t…

  • Database - DBA Life

    Oracle Open World and Oak Table World Schedule!

    So I’ll be heading out for Oracle Open World 2015 in just over another week.  This is the first year in a while that I won’t be speaking, (my own fault, as dummy here hasn’t figured out how to submit sessions internally yet, duh!)   but I’m still going to support the demo grounds, meet with customers and speak at Oak Table World! Per Steve Karam, if you need to know who’s speaking and why you should attend the sessions at the Children’s Museum, well here’s a few: Jonathan Lewis – Yes. That Jonathan Lewis. Also an alien of extraordinary…

  • EM12c Performance - Oracle

    Creating a Trace File from EM12

    Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action. Enterprise Manager also removes some of the syntax options that could get a developer or app support person that is less specialized in creating trace files, all the options and the knowledge of the syntax, etc. from getting into trouble, which creates an option for everyone to be successful. The proposed solution that I’ll post here is where the EM12c user will be able to create trace files, but the DBA will control the…

  • DBA Life - Enterprise Manager - Oracle - Raspberry Pi

    Upcoming Raspberry Pi Family Coding Day Project

    I’ve had a lot of people email and message me asking me what I’m doing with the Raspberry Pi and I wanted to share before the actual RMOUG Quarterly Education Workshop, (QEW) this Friday at Elitches. So a little history-  When I was a kid, I was a real handful.  My mother used to come into my room and I’d have created “webs” out of yarn strung from every piece of furniture and twisted into patterns.  I used to take apart radios and use the parts to create new toys, figuring out how the electronics worked.  Dolls suddenly became cyborgs…

  • Enterprise Manager - Oracle

    Ten Things in Enterprise Manager to Improve a DBA’s Sleep at Night

    Happy Birthday to me!  So for my birthday, I give a present to you…  As I want all DBAs to sleep better at night, here are the top ten features you can use in Enterprise Manager Cloud Control to offer a good night’s rest instead of during the day at your desk… 🙂 1.  Disable the Default Rule Sets Shipped with Cloud Control. Yes, you heard me.  I believe you should use them as a starting point or an example, but don’t put them into production.  These were examples set by development to see all that you could be notified…

  • Enterprise Manager

    Enterprise Manager and Services, Part I

    The term “Service” is used to represent numerous objects within Enterprise Manager 12c.  Although the most common reference to the term is related to the Oracle Management Service, (OMS), in this blog post, we are going to drill down and refer to all services identified in the drop down menu from Targets, Management Services and Repository. The two main services we are going to cover here are set up as part of the Oracle Enterprise Manager 12.1.0.4 installation and shouldn’t be edited or reconfigured, but I think it’s good to know where everything is if you should ever need to investigate it or are…