XTIVIA BLOG
File libclntsh.so.11.1 still in use patching Oracle 11gR2
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...
SSIS 2012 Reporting Driver Errors
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...
Patching Oracle Applications R12
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 had...
A DB2 on Windows Upgrade Adventure
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...
Informix DRDA Connections
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...
Bad Application Architecture Limits Tuning Ability
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...
Tweet! Tweet! Need to Integrate Twitter feeds into Liferay?
Twitter is now ubiquitous in the social landscape. More and more organizations are showing twitter feeds in their external facing sites. In a recent project, I was tasked with the integration of Twitter tweets into an Enterprise Portal. In this blog post, I am going to walk...
How to shrink the SQL Server log file?
Error: 9002, Severity: 17, State: 2 The transaction log for database 'mydatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Very often clients come to us requesting assistance because the log file is full and...
SQL Server backup or restore progress
SQL Server 2005/2008: Find backup and restore status/progress Ever wondered how long it would take to complete a backup or restore that is running in the background. I, for one, do not want to keep looking at the job or TSQL that is taking the backup or doing the restore. I...
Elastic Search: A distributed RESTful Search Engine
Traditionally, building portals and/or web sites with "search that just works" has been hard but over the last few years, life has become easier. Various search tools such as Lucene and Solr have emerged, and platforms such as Liferay have integrated with them to provide the...