We're working more and more with azure related services at the moment and I've been looking in to the different ways that azure infrastructure can be created/managed other than through the web gui. The web gui is of course fine for basic tasks but we're looking at better ways of automating and reporting on what we have in Azure so have been looking at alternatives.
Oaktable World Las Vegas is happening at Collaborate 2016! Many thanks to Tim Gorman, Alex Gorbachev and Mark Farnham for organizing!
Free Oaktable World t-shirts available at Delphix booth 1613 on Tuesday and at the Oaktable World talks on Wednesday. Also available at the Delphix booth is free copies of Mike Swing’s “the little r12.2.5 upgrade essentials for managers and tema members”. Mike will be doing Q&A at the Delphix booth Tuesday 1:15-2:00 and book (more...)
While at Collaborate 2016, a number of us were surprised that people still aren’t using Corrective Actions and in EM13c, there are a number of cool ones built into the system to make your life easier. In this post, we’ll use the very valuable, Add Tablespace corrective action to ensure the DBA is no longer woke up at night, automating the tedious task of adding logical space by (more...)
Becoming a mentor was not a direct path for me. Even though I inspired people with my perseverance and common sense, I had no inclinations for a corner office position, (I often joke about passing up the corner offices in a fight to get to the server room) and this is often a trait that is expected for someone who is titled with “Mentor.”
I was hit by a vaguely interesting issue again when moving data from one database to another recently and thought it was worth a write up. I recreated the problem using a simple case to illustrate the problem more clearly.
The destination db was created using the following command
The source db was creating using this command
create database character set al32utf8;
And before you say that wasn't the command you used - (more...)
Data is exploding and Exadata is catching up. With the proliferation of cloud technology and in-memory databases; Oracle Exadata X6-2 and X6-8 has it all. It seems to be an ideal platform for hyper-convergence for any data center running Oracle products.
Following are some of the salient features of Oracle X6:
The compute nodes have twenty two-core Intel Xeon E5-2699 v4 processors
The memory is DDR4 and of size 256Gb and it can be expanded (more...)
If you've visited the Cloudera documentation lately, you might have noticed some new links down at the bottom of each page. The doc team implemented a system of Wiki-style categories, covering various themes for each page:
And more aspects of interest to readers
Let's take an example from the Impala docs:
You start by viewing any page related to
Sometime soon, there will be an update to the first edition of the "Getting Started with Impala" book from O'Reilly. It'll have about 30 new pages covering new features such as analytic functions, subqueries, incremental statistics, and complex types. This is where the e-version from O'Reilly proves its worth, because existing owners will get a free update.
O'Reilly store page
If you are using Proxy accounts to access users, for example as a DBA to do a release to a schema owner, how do you know the login was via proxy instead of directly with the password? This information is handily recorded in the audit, assuming you have audit switched on and use “audit session”.
I would recommend that everyone does this anyway, as it’s a useful tool when troubleshooting connection problems – you can (more...)
I mean this in the nicest way, but some of you lot are weird. I’m not aiming this at individuals (though there of plenty of “personalities” amongst you) but at whole damned countries.
One thing about social media is that when you tweet, blog, facebook or whatever – you are potentially communicating beyond your own culture. This is especially true when you are doing so to a community that is spread across the globe in (more...)
I wanted to import a datapump dumpfile to my laptop, and I wondered if I can install Oracle XE to ubuntu guest. I thought it would be easy because I installed Oracle 10g XE to ubuntu for several times, but I saw that Oracle doesn’t provide debian packages for Oracle 11g XE. So I needed to convert the RPM to debian package (and fix incompatibility problems). Therefor, I installed “alien” package and other required tools (more...)
5th April 2016, Oracle announced arrival of Exadata X6-2. Overview of all its capabilities can be found HERE. Check DataSheet for list of hardware components and capacity of each X6-2 rack. Sometimes, Oracle changes hardware specifications for its racks e.g X5-2 was released with 4TB HDD initially, but after few months the datasheet was modified and…
We’ve all encountered a situation when you want to check a simple query or syntax for your SQL and don’t have a database around. Of course, most of us have at least a virtual machine for that, but it takes time to fire it up, and if you work from battery, it can leave you without power pretty quickly. Some time ago, Oracle began to offer a new service called “Oracle Live SQL” . It provides (more...)
It’s that time of year again and the massive undertaking of the Collaborate conference is upon us. This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database.
The conferene is held in different cities, but recently its been sticking (more...)
While at Collaborate on Monday, Oracle has been offered a spot to highlight The Oracle Management Cloud. OMC is a suite of next-generation monitoring and management cloud services designed for heterogeneous environments, all empowered by Oracle’s own cloud! The first three OMC services (Application Performance Monitoring, Log Analytics and IT Analytics) were launched at OpenWorld 2015. Both Log Analytics and IT Analytics contain must-have capabilities (more...)