by XTIVIA | Aug 27, 2014 | Blog, Data Management, Databases
So I wanted to throw a quick reminder out there of a nice feature that came along with Oracle 10g and datapump exports and imports. The feature I’m referring to is the ability to detach and reattach to export and import jobs. To detach from an export or import you...
by XTIVIA | Aug 19, 2014 | Blog, Data Management, Databases
So tonight we were helping a Virtual-DBA client apply an PSU patch for an ASM/GI Oracle home. It’s a bit different in the fact that you use opatch auto instead of opatch apply or napply. You also need an OCM response file before you can run opatch auto. First...
by XTIVIA | May 28, 2014 | Blog, Data Management, Databases
So for various reasons I run into orphaned datapump jobs either due to a session failure during the import or for some other unknown reason for a failed import. What I wanted to show you really quick was how to find them and how to remove them so you can run your...
by XTIVIA | Apr 3, 2014 | Blog, Databases
If you’re like me, you tend to brush off concerns of compatibility between Oracle Client and Server versions. After all, SQL*Plus hasn’t changed much in the last 15-20 years, and I’ve gotten used to being able to connect to pretty much any...
by XTIVIA | Mar 31, 2014 | Blog, Data Management, Databases
So I just wanted to share this quick write up on how to stop and start your Oracle database and listener automatically on a Linux server. I use this approach for 10g, 11g, and 12c and so far I haven’t had any issues. Oracle provides the means to do this using scripts...
by XTIVIA | Feb 14, 2014 | Blog, Data Management, Databases
I was working with a customer the other day and they were asking for some help setting up dbconsole for their 12c database. It seems that it wasn’t working out of the box and they needed some help configuring it. So of course I said sure no problem! I have done...
by XTIVIA | Jan 31, 2014 | Blog, Data Management, Databases
If you have ever tried to install a Linux distro on XenServer you have probably run into the installation showing the non-GUI version. Which is perfectly useable, but sometimes it’s just faster and easier to click through the install. So how I get around this issue is...
by XTIVIA | Jan 30, 2014 | Blog, Data Management, Databases
So at one time or another most of us have run into an issue where no matter what we install or try we just can’t get a unix system to throw an x window for anything. Well I personally have run into this issue often enough that I thought I would throw together a...
by Doug Groves | Jul 10, 2013 | Blog, Databases
Ran into an interesting situation recently with a managed services client running Oracle 11.1.0.7.0 Enterprise Edition on Linux in a two node RAC environment with Dataguard. The client asked to have the dataguard instance changed over to read/write to do some testing....
by XTIVIA | May 24, 2013 | Blog, Data Management, Databases
A couple a days ago we had a client contact us and ask us to take a look as their Oracle Cloud Control 12c. They were having issues with a few targets that were reporting as being down on one screen and up on another. We logged into the server and tried to run ./emctl...