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 XTIVIA | Feb 10, 2013 | Blog, Business Intelligence, Databases, Portals
A very large gift given to us user interface developers in Liferay 6.1 is the inclusion of SASS support. One of the many ways SASS comes in handy is handling prefixed CSS rules – instead of having to specify each rule every time you, say, want to declare a gradient,...
by XTIVIA | Feb 6, 2013 | Blog, Data Warehousing, Databases
We all worry about the performance of our servers. It is what separates the DBAs from the pretenders. You just never know just what setting will be the one that makes the big difference. The worst part is that the setting that works today may hinder or not even...
by XTIVIA | Feb 5, 2013 | Blog, Databases
Recently we migrated one of our client’s SQL Server instances to a new server. During the migration we had moved the storage to the new server so the old server didn’t have some of the disk drives that were previously mounted on it. After the migration the...
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 31, 2013 | Blog, Databases
Msg 1205, Level 13, State 68, Line 10 Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Msg 5069, Level 16, State 1, Line 10 ALTER DATABASE statement...
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 Asier Del Pozo | Jan 17, 2013 | Blog, Databases, Portals
There are many tools for monitoring applications. One that we may want to use is JAMon, the Java Application Monitor; it can be really useful for discovering what the hell is going on in our application. We are going to view a quick introduce in it. But first, a...
by Kathleen Long | Jan 4, 2013 | Blog, Data Management, Databases
Every database holds different business data and has its own recovery needs. Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking...
