Wednesday, April 25, 2007

tnsnames.ora - both handy and annoying when lost!

I have become so accustomed to have SIDs configured in tnsnames.ora - never having to remember anything.

After migrating to a new laptop yesterday, I lost all my connection information (doh!) and have had to resort back to the SQL Plus connect string. How beautiful it is:

sqlplus user/password@//10.10.10.10:1521/sid

0 comments: