About the ORA-12154 Error

TNS:could not resolve service name This error, seen as ORA-12154, means SQL*Net could not find the database alias specified for a database connection in the TNSNAMES.ORA file or other naming adapter. The database alias is specified after the “@” character in a database connection string. For example, if the connect string “SYSTEM/MANAGER@PROD” is used, “PROD” […]

Read More

Snapshot Too Old Error In Oracle: Developer Coding Issue

Oracle holds undo information in case you need to roll back a transaction and also to keep a read-consistent version of data. Learn why this can sometimes cause Snapshot Too Old errors.

Read More

ORA 06502 Numeric or Value Error

The error ORA-06502 PL/SQL can be addressed by modifying the data, how it’s declared or the operations on it. Learn more.

Read More