by XTIVIA | Feb 2, 2015 | Blog, Data Management, Databases
This error occurs due to the fact that your connection to the Oracle server is no longer available or that the server couldn’t respond to the client’s requests. This is usually called by an Oracle server issue or a networking issue. You can start...
by XTIVIA | Feb 1, 2015 | Blog, Data Management, Databases
ORA-01722 Invalid Number This error occurs when you try to convert a character string into a number, and the string can’t be converted into a valid number. So what is a valid number you ask? A valid number to Oracle would be a digit between 0-9, a negative or...
by XTIVIA | Jan 30, 2015 | Blog, Data Management, Databases
Cursors in SQL Server allow developers to iterate through a collection of values, normally based off a select statement. This is very useful for scripts that must apply to many items at once. More often than not that is iterating through database names to make changes...
by XTIVIA | Jan 26, 2015 | Blog, Data Management, Databases
The ORA-600 is an internal Oracle error that can be reported by a very serious error. A lot of times this error can’t be solved by an onsite DBA and needs direct help from Oracle to help troubleshoot the issue. If the trace files from the error don’t prove...
by XTIVIA | Jan 26, 2015 | Blog, Data Management, Databases
Tip # 3 – Maintain your SQL Server Top 10 Tips for SQL Server Performance and Resiliency This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common...
by XTIVIA | Jan 24, 2015 | Blog, Data Management, Databases
ORA-12154: TNS:could not resolve the connect identifier specified This is one of the most common Oracle errors and it is basically telling you that you are trying to connect to a database name that is unknown to the system. The most common cause are typos in your...
by XTIVIA | Jan 21, 2015 | Blog, Portals
We had a requirement in an AngularJS portlet to make jQuery DataTable columns dynamic. Normally, DataTable fetches a JSON object that contains the headers and uses that object to instantiate the DataTable. Doing it the Angular way is a bit different. The...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
It’s well known that Oracle has some of the most complicated licensing practices when dealing with virtual hosts/machines. Not only complicated, but also very expensive. I recently work on a project involving a database move to one of the popular cloud...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Tip # 2 – Check your Security Top 10 Tips for SQL Server Performance and Resiliency This article is part 2 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Oracle subscription for node down event pending. You will sometimes see this message on an Oracle database from 10g forward as that is when the default subscription to the Oracle Notification Service(ONS) was introduced. In a single instance environment it is...
by XTIVIA | Jan 19, 2015 | Blog, Data Management, Databases
Often enough I have to mess around with shell scripts and even more often I have to spend a considerable amount of time debugging scripts. Though whenever I find myself having to debug a script I often use this little bit of code to help me step through my code to...
by XTIVIA | Jan 18, 2015 | Blog, Enterprise Java, Portals
Are you using Liferay’s Solr 4 Search Engine EE? If so, you need to checkout XTIVIA Search! There are 2 parts to XTIVIA Search: XTIVIA’s solr4 web plugin XTIVIA’s search hook plugin The following features are included: Improved Performance...
by XTIVIA | Jan 16, 2015 | AWS, Blog, Enterprise Infrastructure
by XTIVIA | Jan 12, 2015 | Blog, Data Management, Databases
Tip Number 1 – Check your Backups Top 10 Tips for SQL Server Performance and Resiliency I have been a consultant for a number of years and lost track of how many different servers I have worked on a long time ago. However, today as sit down and think, it...
