Oracle

TNSNAMES.ORA File - The Complete Guide

Apr 10, 2017 · 8 min read · sql ·

The TNSNAMES.ORA file is an important file when working with Oracle. Learn all about what it is, its location, and how to create and edit it in this article.

ORA-12514 Cause and Solution

Apr 7, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting an "ORA-12514 TNS listener does not currently know or service requested in connect descriptor" error? Learn what causes it and how to resolve it in this error.

ORA-01400: cannot insert null into (string) Solution

Mar 29, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten the "ORA-01400 cannot insert null into (string)" error? Learn what causes this and how to resolve it in this article.

ORA-00972 identifier is too long Solution

Mar 24, 2017 · 2 min read · sql-errors ·

Share on:

Have you gotten an "ORA-00972 identifier is too long" error? Learn what caused it and how to resolve it in this article.

ORA-00001 Unique Constraint Violated Solution

Mar 22, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten an "ORA-00001 unique constraint violated" error? Learn what has caused it and how to resolve it in this article.

ORA-12154 TNS Connection Identifier Solution

Mar 15, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten an "ORA-12154 TNS could not resolve the connect identifier specified" error? Learn what causes it and how to resolve it in this article.

ORA-01031 insufficient privileges Solution

Mar 10, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting the "ORA-01031 insufficient privileges" error? Learn what causes this error and how to resolve it in this article.

ORA-00937: not a single-group group function Solution

Mar 8, 2017 · 3 min read · sql-errors ·

Share on:

Have you received an ORA-00937 not a single-group group function error? Learn what it is and how to fix it in this article.

ORA-00907: missing right parenthesis Solution

Mar 3, 2017 · 3 min read · sql-errors ·

Share on:

Did you get an ORA-00907 missing right parenthesis error? Learn what caused it and how to resolve it in this article.

ORA-06502 PLSQL numeric or value error Solution

Mar 1, 2017 · 8 min read · sql-errors ·

Share on:

Are you getting an ORA-06502 error message when working with Oracle SQL? Learn how to resolve it and what causes it in this article.