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…
-
-
SQL Monitor is one cool tool. Via EM12c, it empowers everyone, (yes, that means the developer, too, so give them the access to view this data via Cloud Control, please!) This is a top five list, but it doesn’t stop there, just remember, this is my favorite features when using Cloud Control with SQL Monitoring. Once logged into the database, you can gain access to SQL Monitor by clicking on Performance –> SQL Monitoring. 1. High Level View The main view of active and inactive processing, (just remember, SQL Monitor processes will age out, so keep that in mind that this…
-
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…
-
So I’m going to start this post with an admission- I don’t have access to a cloud environment to test this out, but I know what I would do first if I experienced slow response time on database creation or cloning via EM12c to the cloud and I would like to at LEAST post what I would do to give others the chance to test it out and see if it offers them some help. Knowing what is causing slow performance is essential to trouble shooting any problem. I’ve had a few folks come to me with complaints that their hybrid…
-
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…
-
More and more companies are consolidating environments. Server sprawl has a high cost to any business and finding ways to consolidate to more powerful servers or to the cloud is a productive undertaking for any company. The Consolidation planner in Enterprise Manager has been around for quite some time, but many still don’t utilize this great feature. Creating a Consolidation Project You can access the Consolidation Planner from the main Enterprise menu from Cloud Control in EM12c. There are two consolidation types currently available physical to physical, (P2P) or physical to virtual, (P2V) consolidation. For our example, we’ll perform a…
-
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…
-
I had a chance to take a closer look at the Zero Data Loss Recovery Appliance, (ZDLRA) via Cloud Control today and really liked the dashboard that’s included in the plugin for the product. This post isn’t going to cover the installation of the plugin or configuration- I was just intrigued by the dashboard and wanted to go over the great features that are part of it. Accessing the ZDLRA As with any Targets, the ZDLRA is going to show up in the All Targets menu and also has a target type filtered drop down in the Targets menu. All…
-
The sales, support and technical teams were brought into the Denver Tech Center office to do some advanced training in Hybrid Cloud. There were many take-aways from the days we spent in the office, (which is saying a lot- most of you likely know how much I hate working anywhere but from home… :)) and I thought I would share a bit of this information with those that are aching for more details on this new and impressive offering from release 5. If you’re new to Hybrid Cloud and want to know the high level info, please see my blog…
-
Last week’s release of 12.1.0.5 was a pleasant surprise for everyone out in the Oracle world. This release hit the bulls-eye for another cloud target of Oracle’s, announcing the introduction of Enterprise Manager 12c’s offering a single pane of glass management of the hybrid cloud. The EM12c team has been been trained and testing out the new features of this release with great enthusiasm and I have to admit, pretty cool stuff, folks! Why is the Hybrid Cloud Important? Many companies are still a bit hesitant to embrace the cloud or due to sensitive data and security requirements, aren’t able to…
-
A common issue I’ve noted are dump files generated from the AWR Warehouse, but upon failure to transfer, the dumpfiles simply exist, never upload and the data is stuck in a “limbo” state between the source database, (target) and the AWR Warehouse. This can be a very difficult issue to troubleshoot, as no errors are seen in the actual AWR Warehouse “View Errors” and no data from the source is present in the AWR Warehouse. Empowered by EM Jobs If you go to Enterprise –> Jobs –> Activity and inspect the Log Report after a search for %CAW% jobs that perform…
-
Here’s a quick guide to my schedule of sessions at IOUG Collaborate 2015 for this year. I’m looking forward to seeing everyone next week, (I’ll be arriving on Saturday, so I really should say in a couple days) and have no doubt we’re up for another phenomenal conference at Las Vegas, this year at the Mandalay! Additionally, there are some great opportunities in professional development at the IOUG Strategic Leadership Program. I’ll be speaking with James Lui on how to improve your value with personal brands and social media. I’m the WIT luncheon speaker on Monday, so for those of you that…
-
Just over a year ago, it became public that I was leaving Enkitec for Oracle. Most folks had similar questions surrounding my decision, including my logic in giving up my ACE Director, an assumption that I would just disappear into the Oracle “machine”, considering the sheer size of the company and with my prominent company work history, what had prompted the decision. In this last year, my career has definitely surprised more than a few folks. I, in no way, disappeared into Oracle. In fact, I’ve been made more prominent and in doing so, assisted in shining a light on the…
-
Collaborate 2015 at the Mandalay in Las Vegas is just around the corner and the sheer amount of Enterprise Manager focused content is phenomenal! Oracle partners and power users around the world come together each year to provide the lucky attendees the best in use cases, tips and technical know -how regarding the best infrastructure management tool in the industry. If you are one of the lucky masses who attend this incredible conference from IOUG, Quest and OAUG, you’ll be searching the massive schedule of sessions for the presenters that will get you to the level of expertise you desire…
-
Database Replay is a feature in EM12c that a lot of folks are unfamiliar with, but once they learn about it, well, now then they figure out how valuable it really is. Where the ADDM Comparison Report comes in really handy when you want to see what changed, think about how much more value there is if you could test out what a change in parameters, patches, or in code would do to a database and THEN use the ADDM Comparision Report to view the “What if’s”? This is where Database Replay really enhances the comparison report feature. along with…
-
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…
-
I’ve had a few folks ask me a similar question about the AWR Warehouse, occuring numerous times this week. “How can I limit what the user of the AWR Warehouse can view in the AWR Warehouse?” “How can I add source databases to the AWR Warehouse without DBA privileges?” This topic bridges into the area of confusion of use of the EM12c environment, (which I consistently promote for use by DBAs, Developers and all of IT) and then the AWR Warehouse, which shares it’s user interface as part of cloud control, that currently is a DBA’s deep analysis and research…
-
Every job comes with tasks that no one likes to perform and database administration is no exception. Patching is one of those necessary tasks that must be performed and when we are expected to do more with less everyday, the demands of patching another host, another agent, another application is often a task that no one looks forward to. It’s not that it goes wrong, but that it’s just tedious and many DBAs know there are a lot of other tasks that could be better use of their time. Patching is still an essential and important task that must…