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...
by XTIVIA | Apr 5, 2013 | Blog, Databases
We have a client who needs to run monthly reports from their financial application. When we first started working for them, the monthly report took nearly a week to complete. We noticed a huge amount of logfile waits and did the classic tuning task of...
by XTIVIA | Feb 20, 2013 | Blog, Data Management, Databases
We had a Virtual-DBA customer request that we install and configure a new Grid Control agent on a new server with existing databases. While there are several ways to do this, we wanted the customer to be able to perform this task by themselves in the future. The...
by XTIVIA | Feb 11, 2013 | Blog, Data Management, Databases
Encountering the ORA-01502 error due to unusable indexes in Oracle can be challenging. A client called with an issue running a script from a 3rd party vendor. He was getting Oracle error ORA-01502 while running the supplied script. The ORA-01502 is basically stating...
by Doug Groves | Feb 1, 2013 | Blog, Databases
I recently came across an issue in a 2 node RAC, Oracle 11gR2 environment for one of our Virtual-DBA clients. The client dba had created a new spfile and placed it in ASM for node 1 and then tried to restart the instance using srvctl. The instance...
by XTIVIA | Jan 28, 2013 | Blog, Databases
Have you ever had a situation where Oracle database software or services have not been uninstalled properly or completely on a Windows OS? Well this happens more often that we would like. The options left to us at this point are either painstaking editing of the OS...
by XTIVIA | Jan 22, 2013 | Blog, Data Management, Databases
The other day our monitoring system had thrown a couple of alerts for a client. It was reporting there were errors in the client’s alertlog. I logged in and checked the alertlog and sure enough there were multiple dreadred ORA-00600 errors being reported in the...
by XTIVIA | Dec 12, 2012 | Blog, Data Management, Databases
Recently I received a call concerning failing backup jobs being taken via Expdp. I logged in to our Virtual-DBA client’s site and immediately checked the alertlog for errors. The below errors were found in the alertlog. Exporting orcl on DBHOST01 Sun Dec 16...
