The Gold Agent Image is going to simplify agent management in EM13c, something a lot of folks are going to appreciate. First step to using this new feature is to create a image to be used as your gold agent standard. This should be the agent that is the newest, most up to date and patched agent that you would like your other agents to match. Managing Gold Images You can access this feature via your cloud control console from the Setup menu, Manage Cloud Control, Gold Agent Images. If it’s the first time you’re accessing this, you’ll want to…
-
-
Even though I didn’t have the “official” prerequisite classes of HTML and CSS for the JavaScript class offered by sister Meetup group, Girls Develop it, I decided on Friday that I wanted to take the weekend class and signed up. The class is held at the Turing Development school and it was a great downtown location. Very centralized, no matter if you’re North, South, East or West of the city and the venue is a school, so it’s set up with plenty of power, WiFi and projector with multiple screens. It had started another spring time snow, so I was…
-
This issue can be seen in either EM12c or EM13c AWR Warehouse environments. It occurs when there is a outage on the AWR Warehouse and/or the source database that is to upload to it. The first indication of the problem, is when databases appear to not have uploaded once the environments are back up and running. The best way to see an upload, from beginning to end is to highlight the database you want to load manually, (click in the center of the row, if you click on the database name, you’ll be taken from the AWR Warehouse to the…
-
This morning, after someone added SQL Developer to a Raspberry Pi 3, Jeff Smith pinged me and the question was posed, as it often is, can you run Oracle database server on a Raspberry Pi, (RPI)? The answer is no, you can’t, as there are no binaries for the ARM processor platform that you can compile, so its nothing to do with power, (although it is low powered for a very good reason…) but really due to the processor type. Hopefully that’ll stop those of you building out massive RPI clusters in hopes of creating their own home servers with…
-
I appreciate killing two birds with one stone. I’m all about efficiency and if I can satisfy more than one task with a simple, productive process, then I’m going to do it. Today, I’m about to: Show you why you should have a backup copy of previous agent software and how to do this. Create a documented process to restore previous images of an agent to a target host. Create the content section for the Collaborate HOL on Gold Images and make it reproducible. Create a customer demonstration of Gold Agent Image AND publish a blog post on how to…
-
Although the Raspberry Pi 3 is now available, many people are still interested in it’s cheaper, smaller version, the Raspberry Pi Zero. This version isn’t just smaller, it also requires a Wi-Fi dongle for internet access, (one of the new, great features on the 3 Model!) and one of my main reasons for not recommending it to newbies to the Raspberry Pi, (RPI) world, is that it doesn’t come with the GPIO pins pre-soldered. GPIO, The In and Out to the World GPIO, which stands for General Purpose Input and Output is an excellent feature on this single board computer, allowing…
-
Last night I attended our RMOUG WIT’s movie night. We partnered with Regis and the choice in movie has received a lot of great reviews, titled, Code- Debugging the Gender Gap. The movie resonated with me profoundly, as I was able to connect with not just the women involved in the interviews, but the girls who reminded me of myself when I was young. There were a number of initiatives that made me proud to be part of the IT industry and opportunities still needing our contribution towards change. Once the movie was over, we held a short WIT panel session.…
-
As we migrate to the cloud, secured credentials are starting to become a standard in most DBAs worlds. If you don’t take the time to understand ssh keys and secured credentials, well, you’re not going to get very far in the cloud. Now ssh keys are a way to authenticate to a host without the need for a password. Its far more secure, but takes a little time to set up and comprehension between public and private keys, along with the impact of pass phrases. Private keys shouldn’t be shared, as anyone with access to the private key can generate…
-
This is going to be a multi-post series, (I have so many of those going, you’d hope I’d finish one vs. going onto another one and coming back to others, but that’s just how I roll…:)) As I now have access to the Oracle Public Cloud, (OPC) I’m going to start by building out some connectivity to one of my on premise Enterprise Manager 13c environments. I had some difficulty getting this done, which may sounds strange for someone who’s done projects with EM12c and DBaaS. Its not THAT hard to do, it’s just locating the proper steps when there…
-
The other day I had a customer who was to send me an ASH report after there was a challenge in providing me EM Diagnostics from their repository database. After the report hadn’t been submitted after a number of days, the customer admitted that they would execute an ASH report request and would subsequently kill the session after eight hours or so of non-completion. Although I hadn’t experienced this myself, there are a number of causes behind an ASH report not running and troubleshooting it is a straight forward approach. Analysis The first thing to do, is to gather some…
-
I’ve been working on a test environment consisting of multiple containers in a really cool little setup. The folks that built it create the grand tours for Oracle and were hoping I’d really kick the tires on it, as its a new setup and I’m known for doing major damage to resource consumption… 🙂 No fear, it didn’t take too long before I ran into an interesting scenario that we’ll call the “Part 2” of my Snap clone posts. Environment after Kellyn has kicked the tires. In EM13c, if you run into errors, you need to know how to start…
-
I fly out on Sunday for HotSos and am looking forward to giving a joint keynote with Jeff Smith, as well as giving two brand new sessions on Enterprise Manager New Features. IOUG’s Collaborate is just a month afterwards, so the spring conference chaos is officially under way. With running the RMOUG conference, Feb. 9th-11th, I think you can imagine what my response was like when I realized how much content I had to produce for HotSos’ two sessions and then another four for Collaborate, plus a Hands on Lab. As focused as I’ve been on day job demands for…
-
With EM13c, DBaaS has never been easier. No matter if you’re solution is on-premise, hybrid, (on-premise to the cloud and back) or all cloud, you’ll find that the ability to take on DevOps challenges and ease the demands on you as the DBA is viewed as the source of much of the contention. On-Premise Cloning In EM13c, on- premise clones have been built in by default and easier to manage than they were before. The one pre-requisite I’ll ask of you is that you set up your database and host preferred credentials for the location you’ll be creating any databases…
-
As I’m playing with the AWR Warehouse in EM13c, I noticed a few changes that may send up a red flag and wanted to assist in removing those. As many know, the AWR Warehouse is very dependent upon EM Jobs…even more so now that we’ve moved to EM13c. The EM Job System has gone through quite an overhaul, so let’s go through how this may impact what you’re common to seeing when adding a database to the AWR Warehouse. Discovery After adding a database to the AWR Warehouse in EM13c, you’ll note within just a few minutes, the database will…
-
I thought this was kind of a cool feature- the ability to send a message to appear to specific or all users in the Cloud Control Console. I have to admit that I used to like a similar feature in Microsoft/MSSQL to send network broadcast messages to desktops that offered one more way to get information to users that they might be less inclined to miss. Anyone who’s already deployed/upgraded to Enterprise Manager 13c and wanted to search how to use this feature, it’s not well documented, so I’m going to blog about it and hopefully that will assist those that would like to put…
-
Let’s say you’re on call and you’re woke from a deep, delightful sleep from the pager, stating the Enterprise Manager Cloud Control isn’t available. You log into the host, check the status, it tells you that the Weblogic server is up and everything else is down. The host logs show that the servers were restarted unexpectedly, so you want a clean shutdown before bringing Enterprise Manager back up, so you shut it down and then attempt to start it clean: $ ./emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 1 Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved. Starting…
-
I’ve been feeling quite amorous about the camera features on my Samsung Galaxy 6 Edge phone, but noticed that it wasn’t taking as automatically impressive pictures as usual and sometimes, I even had to focus, (the horror!) I turned the camera over and could see a hairline crack inside the camera lens. It was a really odd place to have damage, as the exterior cover to the lens was fine. The camera is incredibly good, as even can be seen here in a picture that had the quality sucked out of it on Facebook from our trip to Mexico a month…
-
I’m a Leaf on the Wind, Watch How I Soar. This is one of my favorite lines from the movie Serenity. Without Alan Tudyk’s character dying and all at the end of this, (sorry if I ruined the movie for anyone…) this is how a DBA should be in the database environment- skilled, reliable and maybe a little off our rockers. Our job is to protect the data, the database and all of the database. With that said, I’m going to list my Ten Rules of Database Administration. Fixing a performance problem with hardware is the best way to guarantee the return…