• AWS - Oracle

    RMOUG Training Days 2018

    So Training Days is coming up in two weeks.  You haven’t registered to attend?  How you feeling about that? Rocky Mountain Oracle User Group, (RMOUG) has the largest Oracle user group grassroots conference each February.  For the 2018 year, we decided to shake it up with: A new venue, The Westminster Westin Conference Center A new management company, EPS Conference Management A new Training Days Director, Komal Goyal A new management software, Bizabo This was a huge undertaking and I have to say, I was worried we wouldn’t be able to pull it off, but it was time.  There’s nothing…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Target, Part IV

    It’s finally time to upgrade our Linux Target!  OK, so we’re not going to upgrade the way a DBA would normally upgrade a database server when we’re working with virtualization. So far, we’ve completed: 1.  Updating our instances so that we’ll have a GUI interface if we’ll need one. 2.  Installed Oracle on the Linux Source and upgraded our Dsource database to 12c   Now we’re done with our Linux Source and onto our Linux Target. Install and Configure VNC and Oracle We’ll run through and install and configure the VNC Viewer requirements just like we did in Part I…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Source, Part III

    This is the Part III in a four part series on how to:  Enable VNC Viewer access on Amazon EC2 hosts.  Install DB12c and upgrade a Dsource for Delphix from 11g to 12c, (12.1)  Update the Delphix Configuration to point to the newly upgraded 12c database and the new Oracle 12c home.  Install DB12c and upgrade target VDBs for Delphix residing on AWS to 12.1 from the newly upgraded source. In Part II, we finished upgrading the Dsource database, but now we need to get it configured on the Delphix side. Log into the Delphix Admin console to make the…

  • AWS - Delphix - Oracle

    Upgrading an Amazon EC2 Delphix Source, Part II

    I’m finally getting back to upgrading the Linux Source for a POC I’m doing with some folks and picking up from where we left off in Part I… Address Display Issue Now that we have our VNC Viewer working on our Amazon host, the first thing we’ll try is to run the Oracle installer, (unzipped location –> database –> runInstaller) but it’s going to fail because we’re missing the xdpinfo file.  To verify this, you’ll need to open up a terminal from Application –> System Tools –> Terminal: $ ls -l /usr/bin/xdpyinfo ls: /usr/bin/xdpyinfo: No such file or directory We’ll…

  • AWS - Azure - Cloud - Oracle - SQLServer

    Delivering Migration Projects on Time

    I did a couple great sessions yesterday for the awesome Dallas Oracle User Group, (DOUG.)  It was the first time I did my thought leadership piece on Making Sense of the Cloud and it was a great talk, with some incredible questions from the DOUG attendees! This points me to a great [older] post on things IT can do to help guarantee tech projects are more successful. DevOps is a standard in most modern IT shops and DBAs are expected to find ways to be part of this valuable solution.  If you inspect the graph, displaying the value of different projects…

  • AWS - Azure - Oracle - SQLServer

    The Chicken Before the Egg of Cloud Migrations

    For over a year I’ve been researching cloud migration best practices.  Consistently there was one red flag that trips me that I’m viewing recommended migration paths.  No matter what you read, just about all of them include the following high level steps: As we can see from above, the scope of the project is identified, requirements laid out and a project team is allocated. The next step in the project is to choose one or more clouds, choose the first environments to test out in the cloud, along with security concerns and application limitations.  DBAs are tested repeatedly as they continue to…