Sifar.Works mostly on technology, money, life & soul

Resolve oracle error codes to meanings in Linux/Oracle

i watched over the shoulder of one of my office mate as she used this cool trick/feature  in an attempt to troubleshoot an issue that i was having with my shell script. It had failed with a cryptic oracle error and i had idea what it was. so she came in and showed how to find what the oracle error message means from the code.

I sure saved me a a ton of time as normally i would have fired up my firefox and would have wasted another 20 mins of my time gawking over tons of ways to do the same.

Its pretty simple, just orr ora <error #>

Example:

$ oerr ora 0001
00001, 00000, "unique constraint (%s.%s) violated"
// *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
//         For Trusted Oracle configured in DBMS MAC mode, you may see
//         this message if a duplicate entry exists at a different level.
// *Action: Either remove the unique restriction or do not insert the key.
$

i will sure dig further on this and see what other things can be learnt like this.