Words I Don’t Use, Part 2: “Holistic”

The second “word I do not use” is holistic.

When people use the word “holistic” in my industry (Oracle), it means that they’re paying attention to not just an individual subcomponent of a system, but to a whole system, including (I hope) even the people it serves.

But trying to differentiate technology services by saying “we take a holistic view of your system” is about like differentiating myself by saying I’ll wear clothes to work. (more...)

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 (more...)

Step-By-Step SLOB Installation and Quick Test Guide for Amazon RDS for Oracle.

Before I offer the Step-By-Step guide, I feel compelled to answer the question that some exceedingly small percentage of readers must surely have in mind–why test with SLOB? If you are new to SLOB (obtainable here) and wonder why anyone would test platform suitability for Oracle with SLOB, please consider the following picture and read this blog post.

SLOB Is How You Test Platforms for Oracle Database.

Simply put, SLOB is the right tool (more...)

The Best KScope I’ve Been to

OK, so KScope17 was my first KScope, don’t be petty about it. I also know that it’s been already a month, but I’ve been doing a lot and didn’t have time to write. A week after KScope we’ve been to a family vacation in Alaska, then I went to a concert in Seattle (Counting Crows … Continue reading The Best KScope I’ve Been to

Changing user passwords and expiry in Azure AD



We've now had users created for a while in Azure AD - and here I'm talking about users that have been created directly in Azure AD - not anything that has been replicated from some 'normal' AD on prem.

What we've discovered (surprisingly....) is that the passwords on these accounts expire and have to be changed (after we think 90 days by default - but not 100% sure on that).

This is an issue (more...)

Linux memory usage

One of the principal important configuration settings for running an Oracle database is making appropriate use of memory. Sizing the memory regions too small leads to increased IO, sizing the memory regions too big leads to inefficient use of memory and an increase in memory latency most notably because of swapping.

On Linux, there is a fair amount of memory information available, however it is not obvious how to use that information, which frequently leads (more...)

Redo OP Codes:

This posting was prompted by a tweet from Kamil Stawiarski in response to a question about how he’d discovered the meaning of Redo Op Codes 5.1 and 11.6 – and credited me and Julian Dyke with “the hardest part”.

Over the years I’ve accumulated (from Julian Dyke, or odd MoS notes, etc.) and let dribble out the occasional interpretation of a few op codes – typically in response to a question on (more...)

Licensing|Circle – Oracle Licensing Comprehensive training course (12 modules)



We finally can release the pre-launch discount code for Licensing|Circle - the comprehensive training course on Oracle Licensing. The discount code for the full course is "OracleSeniorDBA10" and this code is valid until 15-Aug-2017. The full course with 12 modules is here:




As mentioned earlier, Oracle Licensing can be a complex subject, and a lack of its understanding for Oracle professionals (including DBAs) could almost certainly lead to substantial financial risk (more...)

That’s Not A Latch


"They all looked very much like the residents of any small valley to which you've never been."
-- Norton Juster, The Phantom Tollbooth

While investigating latches another interesting process popped up that’s smaller and lighter, that performs a similar function, called a mutex. So what is a mutex? By definition it’s a mutual exclusion object that locks memory structures to prevent concurrent sessions from changing the same object at the same time, so in (more...)

Fast Now, Fast Later

The following is the text of an article I published in the UKOUG magazine several years ago (2010), but I came across it recently while writing up some notes for a presentation and thought it would be worth repeating here.

Fast Now, Fast Later

The title of this piece came from a presentation by Cary Millsap and captures an important point about trouble-shooting as a very memorable aphorism. Your solution to a problem may look (more...)

Quick tip–database link passwords

If you are relying on database links in your application, think carefully about how you want to manage the accounts that you connect with, in particular, when it comes to password expiry.

With a standard connect request to the database, if your password is going to expire soon, you will get some feedback on this:



SQL> conn demo/demo@np12
ERROR:
ORA-28002: the password will expire within 6 days


Connected.


But when using those same credentials via (more...)

In Memoriam – 2

This is the second of two items that my mother typed out more than 25 years ago. I had very mixed emotions when reading it but ultimately I felt that it was a reminder that, despite all the nasty incidents and stupid behaviour hyped up by the press and news outlets, people and organisations are generally kinder, gentler and more understanding than they were 60 years ago.

This story is about the birth of my (more...)

Updated PythonDBAGraphs to work from IDLE

I switched from Enthought Canopy to IDLE for Python development when I got my new corporate laptop a few weeks back. Yesterday I realized that I was unable to run a Matplotlib graph from IDLE in my current configuration. Also, I could not find a way to pass command line arguments into my Pyth0nDBAGraphs scripts from IDLE. So, I put in a couple of fixes including an update to the README explaining how to pass (more...)

Oracle Scheduler Fail To Send Email Notifications

In this blog post I would like to share an interesting issue we encountered couple of months ago related to scheduler job email notifications. As some of you may know, starting with Oracle 11.2 you can subscribe to receive notification emails from a scheduler job. You can define an email to be sent on various job events (job_started, job_completed, job_failed etc.). The job email notification is defined with DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION procedure.

I (more...)

VMware Workshop : It’s a Wrap!

Just a few quick comments to wrap up the whole“VMware Expert Database Workshop Program Oracle Edition” event…

Running Oracle workloads in virtualised environments is not a new thing for me. On my desktop I mostly use VirtualBox, but in the data centre it’s always VMware. I first started to run Oracle workloads on VMware about 15 years ago and have never really had any problems from a technology perspective. I’ve never been a VMware administrator, (more...)

VMware Workshop : The Journey Home

It was a later start today. I headed down to breakfast at about 08:15 to meet Heli (and family) and Johannes. It was the first time I had made it to the hotel breakfast this week. Over time more people filtered in to say hello and goodbye. 🙂

From there it was back to my room to write some blog posts and continue the process of playing catch-up with the stuff I have missed while I (more...)

Words I Don’t Use, Part 1: “Methodology”

Today, I will begin a brief sequence of blog posts that I’ll call “Words I Don’t Use.” I hope you’ll have some fun with it, and maybe find a thought or two worth considering.

The first word I’ll discuss is methodology. Yes. I made a shirt about it.

Approximately 100% of the time in the [mostly non-scientific] Oracle world that I live in, when people say “methodology,” they’re using it in the form that (more...)

Log Buffer #517: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

Protecting Financial Data with Oracle WebCenter and Adobe LiveCycle

Oracle Forms 12c oracle.security.jps.JpsException Error after Database change

The Future of Content Management: Oracle Content & Experience Cloud

Today Oracle released a very large „monster“ Upgrade. This July 2017 Update includes the first time the new RU „Release Upgrade“ and RUR „Release Update Revision“ Patches.

Cloud Ward: Who Will Win the Battle (more...)

VMware Expert Database Workshop Program Oracle Edition – Day 3

Day 3 kicked off again with another early start at 7am, yawn 🙂

Again, it was a very intense day, with lots of presentations and then ending with video interviews of each attendee:

  • Dean Bolton from VLSS, talked to us about “License Fortress from VLSS”
    • Very interesting product, where VLSS can advise you how to run your Oracle on VMware, then protect you from Oracle with the License Fortress guarantee, that has lawyers ready to (more...)

VMware Workshop : Day 3

Day 3 started the same way as day 2. I woke up and felt like a total zombie due to lack of sleep.

The agenda for “VMware Expert Database Workshop Program Oracle Edition” day 3 was packed and looked something like this.

  • “License Fortress from VLSS” by Dean Bolton
  • “VMware vSphere Core & SDDC – Networking – NSX & VCNS” by Chris Rohan
  • “VMware Experts Event – Brocade and VMware Technology and the VMware Solutions (more...)