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...
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...
