by XTIVIA | Feb 10, 2015 | Blog, Data Management, Databases
ORA-01555 Snapshot Too Old The snapshot too old error is a very common error we get asked about on a regular basis. It’s also a pretty simple error to avoid if you know what to look for and how to configure your queries and the Oracle database. The error is basically...
by XTIVIA | Feb 4, 2015 | Blog, Data Management, Databases
This error comes up pretty often and can be caused by a lot of different things. Usually, this is a pretty easy one to solve. It’s mostly just a syntax error and you forgot part of your SQL statement. You need a select, a column, from clause, and optionally a...
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 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 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...