Today's Misleading Oracle Error

By kev on November 7, 2007 7:50 AM | Comments (2)

[Moozik: Japan - Taking Islands In Africa]

Oracle has some bizarre and very misleading error messages sometimes. Take today's gem:

ORA-12162: TNS:net service name is incorrectly specified

Something wrong with the tnsnames.ora file right? Nope. What that error is trying to tell me is that I don't have an ORACLE_SID environment variable set. Obviously ;-)

[Tagged: ]

2 Comments

Tony said:

http://www.oracle.com/pls/db92/db92.drilldown?book=a96525&remark=docindex&expand_all=1

Any time you get one of Oracle's infamously vague error codes, plug it in here. You will get more info, sometimes even helpful info. Sometimes not :)

November 7, 2007 9:30 AM
kev said:

Thanks for that. I'll keep that in mind for future use - and I'm sure I'll need it. I just ended up googling for the answer ;-)

November 7, 2007 10:26 AM

Leave a comment

About this Entry

This page contains a single entry by kev published on November 7, 2007 7:50 AM.

Gary Numan's Replicas Tour 2008 was the previous entry in this blog.

Developer vs Manager is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.