What “Makes” History

While at conferences, I attend a lot of dinners/social events outside of the day time festivities and although the topics on the table are often technical, sometimes they veer off to those of each person’s interest.  Discussions with me often fall into one of my areas of interest, which happens to be history, (American, European or Russian…)  Many who know me realize that if I hadn’t ended up in the technical world, I might have become a history teacher.  The common question during these conversations is “Who is your favorite American president?”  When I answer “Andrew Johnson”, I always get a quizzical look, often followed by some hoping to correct me, “You mean Andrew Jackson, right?”  I’ll stand by my answer, stating no, although I can talk about Jackson, our 7th president for hours, it was our 17th president, Andrew Johnson that I was referring to.

payday loans lenders online

So often we all hear the popular, the much conversed about, the “buzz words”.  Even if we take the topic of databases and I were enter an area with five folks who work with databases and say the following words:

“SQL*Plus, inline function, Mark Hurd and RAC”

They would all have some thoughts on most of the subjects above.  They’ve read the headlines and the white papers, even if they haven’t been introduced personally to any of it, then if I proceeded to say:

“csscan, mutual recursion, Charles Rozwat and emdiag”

I might not be so lucky and would have at least a few wondering what a few of these were.  I have a tendency to find value in what may impact our day to day world, even when we don’t realize it.  How many of us know Mark Hurd and his impact to us as DBA’s, but may not realize Charles Rozwat’s impact as he heads up My Oracle Support is understandable.  His impact is much less visible.  History is one of those things, if you may not know about it and in turn you don’t realize how much it impacts you or you fail to repeat it… :)

Andrew Johnson had a tough road.  When Abraham Lincoln, aware that the civil war was turning and coming into the Union’s favor, started to look towards the future and how he was going to embrace the south back to the union.  He had taken the 7th president, (speak of the devil..:)) Andrew Jackson’s “never forsake the union” stance to heart and knew that he had quite the challenge ahead of him in his second term with the Northern Republicans wanting nothing more than the South to pay for the civil war in blood….even after the war was about to be won.  These folks were angry and they wanted the confederacy to pay for a very long time…

To address this, he chose a Southern Democrat, former Tennessee Senator Andrew Johnson, who was one of the few who had stayed loyal to the Union even after his home state of Tennessee had seceded to the confederacy.  The 1864 election upon him, Lincoln counted on the next four years to take Johnson under his wing, have him help enfold the south back into the Union successfully, without the terrible plans of vengeance planned by those around him.  Many questioned Lincoln’s choice, but no one dared to challenge him on it.  Lincoln knew that without Johnson, a Southerner, along with him in the White House, the chance of the Confederacy trusting him, would be unlikely.  He foresaw Johnson as someone who might be able to ascend to the presidency after his second term and do so successfully and trusted him only as ol’ Abe would.

Johnson was known for drinking heavily, but few knew why or why he was so against slavery.  His pro-abolitionist views had sparked many a fight with his Southern neighbors.  What most didn’t realize is that Andrew Johnson was the only president to comprehend slavery from a personal perspective.  At the age of 8 yrs old, he and his older brother were  legally sold into apprenticeship to a local tailor due to the unfortunate loss of his father and financial difficulties of his mother to make ends meet even after remarrying.  For a number of years, he and his brother endured the situation until they found a chance to escape and traveled throughout the south to escape the bounty on his head.  He truly understood some of what slaves were experiencing and understood why it could not go on or allowed to simply “die out” as some of the Confederates had claimed would occur if just left alone.  Lincoln had become aware of his history and found it incredibly moving, as well as important to the cause.

There was one thing that Lincoln, nor Johnson considered though-  Lincoln’s assassination.  This unexpected turn of history rewrote all the Lincoln’s well-laid plans.  Johnson was left in a less than hospitable environment.  The Northern Republicans expected after Lincoln’s assassination that Johnson would just go back to Tennessee, but he didn’t.  He fought and won his right to be president- one, that many of the existing cabinet had accused under whispered breaths, might be behind Lincoln’s assassination, confederate plots and any other political espionage they could consider.  They were more taken aback when he planned on going forward with Lincoln’s plans to embrace the south and bring our American brothers back into the Union.  This was unacceptable for Northern Republicans and they chose at that time to put Andrew Johnson through, what might be, the most miserable four year term any president has endured.

Not only did they lock him out of his own cabinet meetings, they proceeded to leave him locked in the middle of a tug-of-war between the North and the old-South, attempting to rebuild what it once had.  The south had very few men left to lead, but many of the ones who could, had been those that had been part of the former south.  The north wanted none of this and demanded Union generals be put in place.  Johnson fought this with vetoes and battles on capital hill.  As the congressional fights intensified, with what they viewed as a “Pro-Southern” president, (while the south viewed Johnson as a traitor), The Congress passed measures so that Johnson couldn’t even elect or terminate his own cabinet officials.  This lead the way to Johnson being the only other president, outside of Bill Clinton to be impeached.  He only avoided removal from office by one vote.

Johnson has been long vilified as this president that was against the North post the Civil War and against civil liberties.  The truth was, he was one man against terrible odds that could not proceed with Lincoln’s plans or any plans for that matter.  His failure left a long line of former civil war generals as future presidents, more failures in the reconstruction of the south and left it open to the carpet-bagger area, one of the most historically interesting times in Southern history, but a time that shows its impacts even today.

Johnson’s time in office is as pivotal to American history as Lincoln’s in many ways.  We just choose to remember Lincoln with monuments and book upon book in libraries and book stores.  Johnson was remembered when he finally came home, a defeated man post his presidency to find that his home town, the one that had called him a traitor on his departure for Washington as vice-president, had hung a sign, “Welcome Home Andrew Johnson, Our Hero”.

 

 

 

RMOUG 2013, All the Glory, Half the Calories of Other Conferences!

I’m always taken aback how much conferences cost, even if they are way cheaper options than many formal classes.  Education costs money, we all know that, but considering how little it costs to attend RMOUG Training Days, I always tell people, this is one of the best training opportunities anyone can take advantage of.

I need to remind folks of some of the highlights of this great conference that I am very proud to be the Training Days director of.  This year you have new speakers like Oracle Open World’s Technologist of the Year, Arup Nanda along with so many other great speakers like Frits Hoogland, Andy Colvin and John Clarke.  These folks are going to offer some great new content, as are our great return speakers like Maria Colgan, Tim Gorman, Cary Millsap and Dominic Delmolino.  It will be held once again at the wonderful Colorado Convention Center in downtown Denver, Colorado.

Support of Oracle’s ACE/ACED program is phenomenal again this year.  If you aren’t familiar with this program, its the Oracle community’s way of recognizing the database specialists who continue to give back to their Oracle Community.  For more information about this incredible program, check out OTN ACE FAQ.  The ACE and ACE Directors that will be present at RMOUG this year:

ACE Directors:  Alex Gorabchev, Debra Lilley, Arup Nanda, Bradley Brown, Sheeri Cabral, Tim Gorman, Kent Graziano, Frits Hoogland, Dan Hotka, Peter Koletzke, Cary Millsap, Daniel Morgan, Mogens Norgaard, Kerry Osborne, Gwen Shapira, Scott Spendolini, Floyd Teter

ACE: Karl Arao, Christo Kutrovsky, Michael Abbey, Jordan Braunstein, Karen Morton, Stewart Bryson, Chris Ostrowski, Andy Colvin, Kellyn Pot’Vin, Jared Still, Mark Farnham, Michael Fons, Mike Swing, Jeff Jacobs, George Trujillo, John King, Martin Widlake

Our keynote speaker this year is Mogens Norgaard, Oak Table founder, Director at Miracle of Denmark and our favorite “Great Dane”,  will be providing us with some phenomenal insight on where the database world is heading and the impact of mobile data.

Please, also check out the University Sessions and Cary Millsap’s Mastering Trace Data on the 11th.  These are additional cost from the conference, but considering the value they provide, what a great opportunity everyone who attends this conference is offered!

February is coming up quick! Hope to see you there! :)

Enkitec E4 2013 Abstract Submissions are Open!

If you know Exadata and you want to present with the best of the best on the subject in one of the more exclusive and fun conferences around, come join me at the Enkitec E4 2013 conference in Irving, Tx this August 5th and 6th!

This is your chance to share your Exadata knowledge with attendees who goal is to learn new Exadata skills.  Last years conference was incredibly successful and had an A+ list of presenters and attendees.

To find out more and to keep up to date with the latest news on the event, check out Enkitec’s E4 site.

E4 2013 Button

 

Apples vs. Oranges vs. Jelly Bean

How many computers are in your home?  After a quick search on the web, I found that the average number of computers in the American home has increased from 2009′s numbers of 75% having 1-2 computers to 86% having two or more for 2012.  I believe portable devices such as smart phones and tablets have kept it down to that amount vs. each individual in the home demanding one each.  I live in a techie family.  Yes, just counting me, I am the proud owner of two laptops, a client laptop, a tablet and a smart phone.  Each of the kids have their own desktops and the older two also have laptops.  We add Tim’s into this mix and we are up to 11 pc’s in this house for five people.  That is not counting the portable devices, keep in mind!

I love my tablet, a seven inch Android Google Nexus that goes with me everywhere.  My Android smartphone never leaves my sight.  It is my life-line to work, can be used as a hotspot if no other is available and a brand new “downgrade” due to my tablet, to a Samsung Galaxy SIII mini, (yes, I said I went to the mini…)  I take my 11.6 inch ASUS Zenbook with me when I present, as the 2.4lb weight, full feature ultrabook makes a huge difference when traveling.  I love the keyboard on my 15 inch ASUS I-7 laptop for day to day work from home.  It is my work pc and it’s what I’m typing on right now.  Windows 7 is on all my pcs and as is, supports my day to day work well.

At no time, have I ever requested my tablet, my smartphone and my computers to have the same operating system.

As a single consumer of computer electronics, I do some pretty good consuming.  I buy at least two pc’s a year, rarely upgrade existing equipment and simply want what is needed to take care of the company I work for, my clients and my family.  My tablet and smartphone history have been content and satsified with Android.  I have no complaints about the products- they quite simply rock, both Samsung and ASUS.  When PC’s first demanded we upgrade to Windows 7, I had some issues.  Missing drivers, incompatibility issues that weren’t cured by changing compatibility modes, etc., but I survived.  Now Windows 8 is upon us.  I’ve worked with it a little bit and it is beyond me who at Microsoft thought this was a great idea.  That the smartphone, tablet and workstation OS must all be the same OS.  Everything is going cloud-  yeah, yeah, I know.  Trust me, I’ve heard, but what I use my laptops for are completely different than what I use my tablet and smartphone for.  I do want them to share files and apps, (that’s what applications and dropbox are for…)  I don’t need them to have the SAME operating system.

It’s not just the interface OS that is the same.  Under the covers, it is ALL attempting to be the same.  For someone like myself, who spends hours at the keyboard, I have no interest in the chicklet style keyboard present on most new laptops for serious typing sessions.  The consistent need for a command line interface and tools that often do not keep up with the “latest” in OS versions, well, this need to force those purchasing a new system to upgrade is ridiculous.  I have no desire to learn Windows 8.  I’m comfortable with Windows 7 and Droid, so what does this mean for me as a consumer?

Yes, my next computer will most likely be a Mac.  I’ve never had anything against Apple, love their products and what they offer, but I have always been a Windows person for my pc’s and a droid person for my second products.  I don’t see me leaving for an IPad or IPhone, but for my computer, I’ve been alienated by an OS that does not suit my professional needs and demands that I once again leave my OS comfort zone to learn a new interface.  I dislike the results of this little OS experiment.  I believe consistent, varied product and interface choices are what motivates technology to continue to improve and mature, but the monopoly methodology of “we control tightly with Mac” had kept me from finding it the right product for me and now I find Microsoft’s “all OS’ must be the same” to be worse than the former.  Apple at least recognizes the unique utilization of different hardware in a person’s daily life.

I’m sure others have already stated their own frustration with the “OS must be the same for all products” line that Microsoft has headed into.  Use the right tool for the job, I say and Windows 8 is not going to cut it for my daily work routine.  I really loved oranges, too.

RMOUG- Tomorrow is Last Day for Early Bird Pricing!

Thought I would spend my lunch hour with my Training Days Director hat on and telling folks about RMOUG Training Days 2013 today.  Tomorrow is the last day to take advantage of early bird pricing.  If interested in the details, click here.

The conference, as many know will be held on February 12th and 13th with the 11th reserved for OTN Day, University Sessions and Cary Millsap’s Mastering Trace Data.  Tomorrow is the last day to get the great early bird pricing for registration, so it’s a great time to get in on the best price for 150+ sessions, take advantage of registering for free OTN day with Kris Rice, Maria Colgan, David Peake and Jeff Smith, (seats are limited!) or if you want to get in some more deep sessions, we have for a small cost, University sessions.  These four hour sessions are on various topics for DBA’s and Developers from John King, Scott Spendolini, Jean-Pierre Djicks and others.  Again, seating is limited, so register soon or lose out on the opportunity to attend these great additional offerings from RMOUG.  Cary Millsap has been gracious enough to offer his one day course, that can easily be registered and paid for through us, on the 11th.  His Mastering Trace Data is one of my absolute favorites, so I can recommend the value of this seminar.

This year for the conference, we have over 30 Oracle ACE and ACE Director’s speaking.  I would like everyone attending to know how incredibly important that is.  With the changes in how Oracle pays for ACE Director travel, know that each of these directors have invested their own time and money to travel and speak at Training Days and I’m honored to have them here.  Our ACE support is second to none for regional conferences and I’m always thrilled with how gung-ho everyone is about RMOUG Training Days.

We are again located at the Colorado Convention Center, taking up the same ballrooms and conference rooms.  Free WIFI will be provided and Arrisant did a wonderful job sponsoring our mobile app for the event, which will be Guidebook.  If you haven’t seen this app, it rocks!  I used it the first time at a couple SQLPass events and couldn’t believe hoe fluid and easy to use it was over other event apps I’d tried.  It has a full twitter feature built into the app, allows with a simple scan or web page download to add the app and the events guidebook to your own mobile device.  It has a schedule builder with reminders and email options to keep you on track throughout the event.  I’m very much looking forward to adding this to our conference this year.

We’ve really gone for seriously crazy content this year.  Attendees will have the advantage of seeing presenters they’ve never had the opportunity to see before in Denver, along with old favorites, too.  Maria Colgan, Cary Millsap, Kerry Osborne, Alex Gorbachev, Debra Lilley, Gwen Shapira will be back, along with new speakers like Frit Hoogland, Galo Balda, Alex Fatkulin and Michael Abbey, to name just a few.

Another newer aspect of the conference is that we are realizing how many DBA’s and Developers with the changes in their environments are expected to know a lot more about platforms other than just Oracle.  We introduced through our Quarterly Education Workshops, (very successfully) MySQL sessions and we are now going to provide some excellent MySQL sessions at Training Days this year from the likes of Kevin Larson and Sheeri Cabral.  We have Steve Jones, one of the greats from SQL Server Central presenting, along with one of my buddies and co-authors from our latest book, Chris Shaw and a number of others giving you what you need to help support SQL Server environments.

For those of you in the Big Data world, it is a smorgasbord of offerings.  We have Hadoop, NoSQL and sessions on how it all fits in with Oracle.  Exadata has almost enough sessions to have it’s own category!  If you want to know about new Oracle 12c features or EM12c, yes, you have come to the right place.

Our keynote this year is from the wonderful Mr. Mogens Norgaard from Miracle in Denmark.  Mogen will be speaking on the great frontier of mobile development and how it impact the database world.  He spoke back at RMOUG in 2006 or 2007, but all I remembered was he was my favorite RMOUG speaker of all time, so I was thrilled when he agreed to speak this year!

For the women out there that wonder if it is worth spending the time from work to go to a technical conference, (we are always the ones that agree to stay behind, don’t we??)  There is a session after lunch for Women in Technology.  I will be heading up a panel with Karen Morton, Maria Colgan, Gwen Shapira, Alex Gorabchev and Debra Lilley.  We are going to be discussing with the audience how we can involve women more in Oracle User Groups, in conferences and in IT networking in general.  Group participation is a large part of this session, it will not be just a panel of folks up stage talking.  We really want to know where the database community can improve the lives of the women that are part of it so they can contribute and benefit from it in return.

There are a number of other wonderful additions to this conference.  I always appreciate how much everyone receives for the incredibly low cost.  If you have any questions, email me, always glad to help and want to publicly thank everyone for all the support they give RMOUG.

See you in February!! :)

Redgate Webinar from Dec. 12th 2012

If you are interested in a replay for my webinar with Redgate on the EM CLI, (Enterprise Manager Command Line Interface) it can be found here.

The corresponding slides, including scripts and syntax explanations are located on Enkitec’s slideshare link here.

Hopefully you will start seeing more from me in the future as I’ve now recovered from the last six weeks of “fun” and am back on my feet! :)

Fall Down Seven Times, Get Up Eight- Medical Profession Rant

It’s been such a long time since I posted anything on my blog.  I had this post, last save time was on Dec. 13th, which is ironic considering the subject and what ended up happening that day.  I’m going to ramble a bit, but there is a message here folks… :)

I’ve always been a strong believer of the old Hebrew saying, “Fall down seven times, get up eight”.  I’ve lived by it, which most who know me well enough, realize that it’s not just part of my DBA methodology, it’s also an integral part of my life.  When I was in my 20′s, I wasn’t a techie at all.  I was working as an auditor for a company in Colorado when I started experiencing strokes between the ages of 21-26 years of age.  I had five documented strokes, that until a very dedicated and brilliant Neurologist diagnosed the cause of, I was told no one could deter from occurring and that I’d be blind before I was 40.  Through this doctor’s excellent care and help from a Rhuematologist and Hematologist, they figured out the odd auto-immune issue, combined with a natural tendency to have very low blood pressure so that I was stroke-free for almost 19 years.  I’m now onto my way to turning 46, was left with 48% of my visual field gone, (eyes are fine, it’s the striate cortex of the right hemisphere that isn’t able to “translate” data any longer, showing up as damaged in MRI scans.)  I have very, very few, long-term memories from about the age of 19-26 years of age.  All other damage that occurred was addressed with physical therapy and speech therapy.  If you consider the years that I am impacted memory wise, yes, had to start looking for a new career, wasn’t like I could perform my previous one any longer.  I started first by selling shoes, then computers, which outside of being a woman in her late 20′s selling computers, which meant I did very, very well, I found out I had a knack for software.  That was 1995 and by 1997 I was doing desktop support for a large telecom company who ended up putting me through my Oracle 8 certification classes and made me a DBA by 1999.

Now with the years gone by, children born, (by oldest just turned 18, youngest is 12 yrs old)  I thought I was pretty safe and had no worries.  I had a couple surgeries and lasik without any issue and was secure in the fact that I understood everything I needed to know about my condition, knew it hindered me from receiving care as much as it helped me to know when I did enter the hospital what to keep doctors from doing to me that might kill me, (no, you can’t thin my blood…no there is no concern about clots, I have a BLEEDING problem, not a clotting one, pretty much get the heck away from me before you kill me…)  I have an excellent primary care physician that I appreciate for his knowledge and natural skill in the medical field.

I went in for surgery  on November 10th.  It was unexpected, but I checked into a hospital that was very aware of my medical history, even went over it with me before they checked me in.  As it was unexpected, they had decided to do exploratory surgery due to my abdominal pain and discovered I had a ruptured ovarian cyst and simply removed it all in one swoop to avoid any complications.  The standard procedure when many have any type of bleeding, is for the anesthesiologist to lower your blood pressure to lessen bleeding.  Many aren’t aware of this- I know I wasn’t.  Unfortunately, my old medical condition surprised the anesthesiologist as my blood pressure “dipped” twice, very low and upon recovery, I found I had some new areas that were missing, including “spots” across my central right visual field that were just plain annoying.  My vision seemed a bit blurry, too, but when I squinted to clear the vision, which would commonly work for anyone who knows what it’s like to have blurry vision, it just didn’t improve.  It should be noted, as with any of my children’s births, previous surgeries, again, didn’t partake in any pain medications.  I have a high threshold for pain and found no need of them.  I bounced back quickly, but the vision issue and what caused it, was of high concern.

My primary care physician followed up with an eye exam, (always have to prove it’s not the eyes first before you go to the brain…) and then onto an MRI scan once that came back as “eyes all good!”  I received a great set of glasses that addressed the distortion and for the first time in my life, the unending glare that happens to many with visual field damage.  With the new glasses, I was able once again, to drive at night.

During this follow-up time, I was the lucky recipient on Dec. 13th of kidney stones and had to go into the same hospital ER for these.  I had been directed there, even after the surgery, as the best place to go due to a urologist on site.  After a visit that shall just go down as the “one of the worst care given at a hospital in my life and lucky I got home alive” situations, I then had to see my doctor for a referral to a urologist to actually get the kidney stone broken up, as my ER trip just ended up in me going in with severe pain and then being released in severe pain, drugged up and in worse shape than when I entered the place.  My MRI’s are not back yet and we go in to discuss my procedure to break up the stone with the urology specialist.  The nursing assistant comes back to the room and says, “I’m sorry, but I can’t get anyone to perform the procedure on you without a medical release from your doctor due to the assumed stroke from last month.”  Which translated to me, returns as “Yes, we know what needs to be done, but due to a mistake that no one in the medical industry will admit to, no one will now perform the procedure you need to have done now unless someone else takes responsibility for any mistakes we might make.”

There are times when you realize that figuring out some medical mysteries are more threatening to your future health than just addressing the results and going forward to get the care you need.  My primary physician went after them the next day and we took the whole stroke issue off the table immediately.  I ended up going a full week with a kidney stone that required a surgical procedure because so much of the medical profession is too worried about red tape, managing pain vs. addressing the problem and forget about caring for the unique patient in front of them.  I will never give up my primary care physician.  I have no doubt Dr. Michael Archer will keep me alive for a long time.  His “strong-arming” of the medical staff at different locations not only got me what I needed, it also made me realize I needed to request copies of my medical records to see just how poorly I was cared for.  If I have to return to an ER or hospital, I’m pretty sure all bets are off.  You can be sure I will never return to St. Anthony’s North Hospital and I recommend anyone in the Northern Denver area to avoid it.  I am now recovering at home after the surgical procedure being performed on the 23rd of December and have one more follow-up visit to complete the process.  The delay in my care put me more behind, caused me more lost time in work- thank God it was the holidays, first time I’ve ever actually take pain medication, yes, kidney stone procedures beat out child birth and other surgeries I’ve had for amount of pain.  It resulted in a request for more recovery time-  It would have been much more difficult had I not worked for a great company like Enkitec and worked from home.  I’ve lost out on almost six weeks of writing time on the EM12c book, playing lead author and helping out with other areas for the book, RMOUG Training Days work that requires my time has gone pretty well, thanks to Tim’s involvement, he’s often been able to answer issues for me when I’ve been laid up.

We, as patients need to be ever vigilant and constantly push for the care we deserve from the medical profession.  The damage that can be done because someone didn’t take the time to read a full chart or a nurse didn’t have time to take a full medical history of the patient or understand the patient’s unique physiology, pain thresholds, etc. put us at risk. Removing the humanity from health care is true cause for most of our failures in this area of American healthcare, which we in turn have just responded with more insurance choices to address.

So my final message is this-  The medical profession has a few bright stars in it and everyone else is just following what it says in a medical book on an issue or the policies of a hospital.  To protect your loved ones when they enter a  hospital is an incredibly demanding task.  Ask every nurse, every doctor to explain what they are doing and if anything doesn’t function, (the call button, the phone, etc…) demand that they correct the situation immediately.  If you aren’t getting the care you need, demand to see the facilities patient rights documentation and file complaints.  Everyone deserves to receive the care that will help them live a long and healthy life.  If the medical staff can not perform their job, find someone else more qualified to do so.

NoCOUG/RMOUG Presentations- November!

I had the opportunity to speak yesterday at the NoCOUG, (Northern California Oracle User Group) Fall Conference and today at the RMOUG, (Rocky Mtn. Oracle User Group) Quarterly Education Workshop.  Why? Considering I had surgery this last Saturday, I may be a glutton for punishment, but I did enjoy both events, (RMOUG’s is still going on right now as I type this post… :) )

I did the same presentation for both events, my “Sherlock Holmes for the DBA”, a favorite that goes through optimization features available in Oracle, (ASH, AWR and tracing) along with how and why to perform optimization exercises effectively in a database environment.

I also spent a couple minutes chatting with the RMOUG members before I began, discussing a conversation that occurred the day before at lunch with Maria Colgan, Jeff Jacobs, Iggy Fernandez and Tim Gorman about the success of RMOUG and the value of this incredible user group.  I asked them to share this to their managers, along with the investment into the community with Training Days coming up in February.  The content and value of this conference just can’t be beat and hopefully I shared some of this with the group today! :)

Anyone interested in my slides from the last two days presentations, please feel free to download them from my Google drive site: Sherlock Holmes for the DBA

Thanks to Gwen Shapira and Iggy Fernandez for everything at NoCOUG and Carolyn Fryc for having me speak locally.  Always a pleasure!


EM12c, Damage Control

I love EM12c, don’t get me wrong.  I wouldn’t post about it so much in my blog, tweet about it, working on two Apress books in support of the product if I didn’t.  The features, the broad range of support it provides the future of the database and development arena for Oracle is something that many have only dreamed about.  The problem is, some would say, is that some dreamed a bit too much and forgot to dot their i’s and cross their t’s.  Then when offered a work around to an i that wasn’t dotted or a t uncrossed, a choice to offer no better answers than a politician in the last election is offered.

The main EM12c product, in it’s initial release, possessed the main features that functioned quite well and with a bit of help from EMCLI, (Enterprise Manager Command Line Interface) commands, a DBA could use the newer main features for almost any environment.

In the main components, very few bugs existed, and as a few of us braved this new world,  we were offered work-arounds and a couple simple patches.  As news of advanced features and capabilities were broadcasted, folks started to explore them and that was when, in my opinion,  the “damage” started.

The features-  everything from auto deployment to synthetic monitoring to administration groups, required:

1.  The administrator to relearn how to perform management tasks that they had previously known how to easily deploy or configure in previous versions of Enterprise Manager.

2.  The previous versions of how these features worked had often been removed from the the new EM12c product offering to ensure that the replacement feature would be used.

3.  The new version of these previous features often experienced bugs hindering them from being deployed or configured as documented, requiring the administrator to open and SR with Oracle Support.

Oracle then chose to take the stance, “Apply BP1, (Bundle Patch1) which was supposed to correct most of these problems.  It is an involved process that requires not just a standard backup of the database, but the OMS home and other components.  It requires a downtime that for some, is considerable and difficult to commit to due to their reliance on the EM12c features.  The largest problem was, upon applying the BP1, there were still a large amount of bugs that existed, along with new ones that were introduced by the sheer quantity of patches included in BP1.

Now, the downtime complaint, Oracle addressed by creating a “recommended high availability” white paper with RAC, but at that point, having an EM12c environment without licensing, offered as part of your Enterprise Licensed production environment goes out the window and that wasn’t a great marketing message to many companies where the administrator had to sell how important having a monitoring system was in the first place.

For me, I have a number of clients that are only allocated 30-70 hours of my time a month.  They worked very hard to allocate project hours through their company to have me implement an EM12c environment for them after I convinced them it was the way to go, (and I still feel it is!)  Now, for me to approach those customers and tell them that after the work I did for them to set up their EM12c environment, patch it to BP1, (if that was required for bugs they’ve experienced…) to now correct the other bugs, plus the bugs that were implemented as part of BP1, () by upgradng to release 2 because I was instructed to in an Oracle Support SR or on my blog or in an email chain, etc?

This product came out just over one year ago.  I believe in this product.  I tell peers, “EM12c is the best way to monitor your database environment, but ensure you are going release 2.”  I do get a lot of complaints directed my way as folks know how much I work with this product.  Even if I don’t have the answer other than, “Oracle says this is fixed in release 2…” they know I will at least understand when they say a feature is not designed as user friendly as it might have liked or there is a bug that requires an EMCLI command or a bug that hinders a feature from working.  I too often give an optimistic response that “..this product is offering a whole new world of features at the administrator’s fingertips and yes, there are still some things that may need working out.  Yes, you will need to become familiar with EMCLI, it is a must with EM12c…” that it is a response that is burned into my brain.

Oracle, no matter how much release 2 was needed, I find that a second release after one year of a product shows a disconnection from the business and that of the needs of the administrators who are working with the Enterprise Manager product.  To have a release 2 of a product that has been on the market for just a year, again, is not a strong marketing strategy with your customers.  Wouldn’t it have been smarter to offer the main components and then release the ones that weren’t ready, one at a time after you had perfected them?

And… if I offer a fix for an earlier release on my blog or in an email, I would advise not commenting how it’s fixed in release 2.  That’s just insulting to the folks who are in the front lines, working with a feature that was released before it was ready.

 

Administration Group Creation Failure in EM12c

Sometimes you want to change the way you are managing, monitoring or notifying in your EM12c environment that may require you to delete and recreate you administration groups.  If you are testing out administration groups, then you may very likely create, delete and recreate, as they are not something you can edit as you go along, (the system even warns you of this as you create them.

As I was working through a unique notification issue and how to handle it with administartion groups, I experienced a failure on creation after the deletion of a former admin group in EM12c, BP1:

As the previous admin group had been deleted and this failed, it was obvious that something hadn’t cleaned up properly after the previous admin group.  I’m not a fan of tearing into the SYSMAN schema, but this one was worth a look at not much was connected to it to begin with.

The error gave us a clear indicator of what we needed to look into:

We now knew what column and the table this came from.  How much data was contained in this table?

As there was only one row and it only contained the group hierarchy row info, I made a copy of the table, deleted the row, then committed it.

Can I now create my administration group?

Success.  I removed the copy of the table and proceeded to create the new monitoring templates for the groups.

Knowing the data behind the scenes, still making a copy of it, “just in case” is important when you are required to do a quick fix so toproceed forward when a job to clean up something like an administration group hasn’t cleaned up as much as it should have.