ankushthavali

In this blog, We will try to understand how to resolve the ORA-01722 error. Problem Statement ora-01722 invalid number in oracle Solution First describe the table and check for data types by using desc command Check the type of data you are inserting and type of column An ORA-01722 error occurs when an attempt is […]

This is common error which will occur on oracle database. ora-03113 end-of-file on communication channel Following are the reason to get the error Database goes down abruptly Server goes down and there is no communication with server Solutions Check the alert log file. reason can be anything and accordingly you need to act If you […]

Sometimes you will see the error message related to tns. Error message will be like this. ORA-12154: TNS could not resolve service name specified Solutions Check if your listener is up and running Check if listener is listening to database services. Look for tnsnames.ora file. database entry needs to be available there Syntax error in […]