How to solve ORA-12560 tns protocol adapter error?

ORA-12560 tns protocol adapter error : ORA-12560 is a generic protocol adaptor error, which mostly occurs when the database is not up. There are also other reasons the error occur.  Actions to resolve ORA-12560: Go to Start -> Run -> Services.msc in Windows. Locate OracleService < SID > (here OracleServiceORCL) and click on Start to start the Oracle database service … Read more

How to solve oracle error ORA-04061

Oracle error ORA-04061: existing state of <varname>string</varname> has been invalidated. ORA-04061 is a common error that occurs when an attempt is made to resume the execution of the stored procedure using the existing state which has become inconsistent or invalid due to change in any of the dependency objects or the procedure itself has been altered or … Read more

How to solve oracle error ORA-12154

 Oracle error ORA-12154: TNS: Could not resolve the connect identifier specified Oracle error ORA-12154 is a common error related to the local copy of the tnsnames.ora file, listener configuration, and the database name alias.  Ensure the listener is listening to the same service name you are using. Check for a missing/malformed entry in the tnsnames.ora … Read more