The Cool Stuff
Oracle has introduced a new way of transporting data from one platform to another in 12c. The new feature is called “Full Transportable Export”. This enhancement works from 126.96.36.199 and later and is a great way to move data, as it allows for an easy-to-use combination of Export Data Pump and Transportable Tablespaces. The documentation specifically praises it as a means to move from an 11g Release 2 database into (more...)
About 14 months ago I spotted a problem with the PDB Logging Clause. I opened an SR and several months later I got a patch, which unfortunately didn’t fix the issue, just altered the symptom somewhat. I wrote about that patch here.
Yesterday I got a new patch, which actually does fix the problem, so now the PDB Logging Clause works as documented!
I’ve updated the PDB Logging Clause article to reflect the change.
I realise (more...)
I like it when stuff just “works”.
I’ve been using Virtual Box 4 for a long time now, and since my needs are relatively simple (ie, run a VM!) then I’ve not had any great cause to move to version 5. But today I had a spare few minutes and thought “Well, its probably time”.
So the steps I followed were:
- run the installer
- start version 5
And .. well, all my stuff (more...)
It is official. I will be doing my Delphix presentation at Oaktable World during the Oracle OpenWorld conference at the end of this month. My talk is at 9 am on Tuesday, October 27.
I will describe our journey as a new Delphix customer with its ups and downs. I tried to have the spirit of a user group talk where you get a real person’s experience that you might not get from a more (more...)
I have previously announced that Delphix now has a free version available called Delphix Express as well as how to install Delphix Express.
In this blog will look at an example of virtualizing your first database and not only the database but virtualizing the application as well.
What does virtualizing mean? Like in the world of virtual machines where we make multiple virtual machines on one set of hardware, in the world of virtual data (more...)
directory is filesystem directory created at root level of mounted drive for ext file systems. It is used by file system check tools (fsck) for file recoveries.
In MySql world it can cause confusion or possible problems with synchronisation in Galera cluster configuration. Let’s check some examples.
I have MySQL database with datadir=/data in configuration file. I have deleted lost+found directory and restarted MySQL service.
When I list my databases this is result:
There’s an interesting “debate” going on under AskTom at the moment. It’s hardly cause for major concern, but anyone is welcome to add their thoughts as comments to this blog post. (Naturally, if your comments agree with my opinion, then that’s great. If your comments don’t agree, then I’ll post them and ignore them – ah the joys of being a blog owner)
So here’s the issue. When we are posting (more...)
Yes! It’s that time of the year again when we start planning for the premier Oracle OpenWorld. So let’s get right into it! Read more here – Top 8 Strategies to Thrive at Oracle OpenWorld . . . . . . Realted article – Advanced Sessions at Oracle OpenWorld 2015 . . .
The post Top 8 Strategies to Thrive at Oracle OpenWorld appeared first on VitalSoftTech.
If you're read some of my older stories on this blog you'll know I've had some interesting battles with flashback over the past couple of years... don't get me wrong i think it's (arguably) the best feature introduced over the past 10 years (i'm talking about all the different flavours of flashback with that comment).
Today i hit a whole series of random errors discovered a minor new (well new to me) syntax to a (more...)
That’s not really a problem but annoying issue I had with OEM 12c. Once a standby database is promoted, the database system for the same is showing as metric collections error OR Status Pending.
The standby database doesn’t need its own system since it will join the primary database system. The solution is to associate the standby database with the primary system and then remove the standby database system.
For example – we’ve got primary (more...)
What’s the most important attribute to consider when you want to buy a new storage system? More critical than performance, more interesting than power and cooling requirements, maybe even more important than price? Whether it’s an enterprise-class All Flash Array, a new drive for your laptop or just a USB flash key, the first question on anybody’s mind is usually: how big is it?
Yet surprisingly, at least when it comes to All Flash Arrays, (more...)
I’ve lost track of the number of times I’ve worked with systems that didn’t run brilliantly because every database operation was the “row at a time” methodology. Typically you see hundreds of routines (either in the database in PL/SQL) or further up the chain in C#, Java etc, and the “alarm bells” start ringing in my head when all of those routines are prefixed with “GET_” and the input parameter looks like a primary (more...)
Since the upgrade to Cloud Control 188.8.131.52, we’ve been having a couple of issues, mostly around EMCLI.
Some of our databases use Service Guard, so you don’t know which node they are running on. Rather than having an agent per package, we have one on each node. One of my colleagues wrote a little script to check which node the instance is running on, and relocate it if it has moved. This (more...)
In the comments from yesterday’s post, Jonathan Roden mentioned the release of El Capitan. At that point, I hadn’t even heard about it. Being the naive idiot I am, I jumped head long into it.
The download was about 3G, which didn’t take too long. The upgrade itself took quite a while. That included one failure. During the installation, the system rebooted, as it said it would, and I thought it was over, but it was (more...)
I’m a bit of a dinosaur when it comes to how long I’ve been using Oracle. But you should never stop learning. That’s why I’m participating in a cool OpenWorld session in a few weeks, all about the modern technologies and frameworks that can now be used to build awesome applications on top of the Oracle database. Come along – you’ll see some exciting stuff. This session is all about modern (more...)
There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 184.108.40.206 instances. ora_acms_bt9prod1 ora_lreg_bt9prod1 ora_p00w_bt9prod1 ora_aqpc_bt9prod1 ora_m000_bt9prod1 ora_p00x_bt9prod1 ora_asmb_bt9prod1 ora_mark_bt9prod1 ora_p00y_bt9prod1 ora_cjq0_bt9prod1 ora_mman_bt9prod1 ora_p00z_bt9prod1 ora_ckpt_bt9prod1 ora_mmnl_bt9prod1 ora_ping_bt9prod1 ora_dbrm_bt9prod1 ora_mmon_bt9prod1 ora_pmon_bt9prod1 ora_dbw0_bt9prod1 ora_o000_bt9prod1 ora_ppa6_bt9prod1 ora_dbw1_bt9prod1 ora_p000_bt9prod1 ora_ppa7_bt9prod1 ora_dbw2_bt9prod1 ora_p001_bt9prod1 ora_psp0_bt9prod1 ora_dbw3_bt9prod1 ora_p002_bt9prod1 ora_pxmn_bt9prod1 ora_dbw4_bt9prod1 […]
This post is based on a problem I was asked to look at recently.
A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 database. He was matching the rows on a key column then checking the corresponding values from a different column and reporting them if they did not match. His query returned almost 2000 rows but they appeared to have equal, not different values. Five people looked at (more...)
In 2014, myself and a few other well known speakers in the Atlanta area were added to the board of directors for the Georgia Oracle User Group (GaOUG). With us being added to the Board of Directors, we initatied a rebranding of the user group from GOUSER to GaOUG in Feburary 2015, with much success. Then followed that event up with two quarterly events in April and July 2015, which proved to be an even (more...)