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 | Mar 28, 2014 | Blog, Data Management, Databases
In cases when a database change needs to be made there are some good rules that when used can save you a lot of time down the road. Run changes via scripts – Scripts add for precise execution and help remove human error when it comes to typos. When creating scripts...
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 Kathleen Long | Jan 23, 2014 | Blog, Data Management, Databases
Bloated Transaction log in Simple recovery mode will not shrink Received a request today from a Virtual-DBA customer asking XTIVIA to help troubleshoot why a database which is only 50MBs in size would have a transaction log of 181GB. My first thought fell to an open...
by XTIVIA | Jan 15, 2014 | Blog, Data Management, Databases
What you need to know about Database Mirroring In recent months I have set up database mirroring for a number of clients. Why you may ask? It is a great option for disaster recovery and even gives the organization additional options when it comes to maintenance...
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...
by XTIVIA | May 13, 2013 | Blog, Data Management, Databases
We have a Virtual-DBA client that was rapidly running out of space for one of their databases in VMWare. To rectify the problem we decided to move a few tablespaces to a new LUN/disk presented to the VMWare OS. We had a scheduled downtime window so we didn’t need to...
by XTIVIA | May 13, 2013 | Blog, Data Management, Databases
This Saturday we were scheduled to patch eight oracle 11gR2 databases with the latest CPU/SPU set for one of our Virtual-DBA clients. The databases were running in a zone on Solaris 10. This is normally a pretty straight forward process, but this weekend we ran into...
by XTIVIA | May 7, 2013 | Blog, Data Management, Databases
So today we had a Virtual-DBA client ask us to help them patch their Oracle Financials R12 for a bug they were having a problem with. So I thought I would share with you the process we used to patch their server. They had sent me the patch number that Oracle support...
