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 status oms and we recieved the below error. Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.0.0 ...
Read More About Oracle Cloud Control 12c Reporting Targets Down »

  One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system.  When the application team created the database, it was created using Automatic Storage on the /home filesystem.  This will always happen when the default setting of DFTDBPATH in the DBM configuration file is set to the instance owner's...
Read More About Rolling DB2 tablespace location change using HADR »

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 leave the database online to perform the move. If we had wanted to leave the database online we could have used RMAN to...
Read More About Moving datafiles to a different disk/lun linux Oracle 10gR2 »

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 an issue that we wanted to share. We started by moving the patches to the server and unzipping them in a directory. We...
Read More About File libclntsh.so.11.1 still in use patching Oracle 11gR2 »

Often times when implementing data integration projects - we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has been implemented by quite a few folks and information is available all over the web. Yet when I built the simple workflow, I ran...
Read More About SSIS 2012 Reporting Driver Errors »

Today we had a client ask us to help them patch their Oracle Financials R12
Read More About Patching Oracle Applications R12 »

  Many of our Virtual-DBA clients have DB2 upgrade plans in the works.  One of them wants to move from V9.1 to V10.1 on Windows.  I'll share some of my experience with this project.  Right now I've completed the set up of the 10.1 instance and restored a copy of their database there.  They are now kicking the tires.  Here are some more details:   ...
Read More About A DB2 on Windows Upgrade Adventure »

      One of our Virtual-DBA clients recently contacted me for assistance in setting up connections using the DRDA protocol.   They are moving from Java to .NET for their development work, and when they tried to connect via the .NET drivers, they received the following error: Unable to open socket to server: ERROR [08001] [IBM]...
Read More About Informix DRDA Connections »

  XTIVIA will be a Bronze sponsor at this year’s International Informix Users Group (IIUG) 2013  Informix Conference next week (April 21-24) in San Diego, California.  This conference is the largest IBM Informix gathering in the world and is a technical conference for IBM Informix users.  The IIUG Conference offers a unique opportunity to network with a large...
Read More About 2013 IIUG Informix Conference »

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 increasing the size and number of logfiles, while putting them on alternating disks.  That reduced the processing time from...
Read More About Bad Application Architecture Limits Tuning Ability »