Useful Suspects

I lost hours trying to resolve this:

“ORA-12154: TNS:could not resolve the connect identifier specified”

It requires lots of determination not to swear and rant about the possible causes of this message but in my case (Windows 7 64bits), it turns out that Toad doesn’t like to be installed in a folder with ‘()’s like ‘C:\Program Files (x86)’

I installed in C:\Toad\ and the problem is resolved.

Of course to reach there I had to resolve some other issues (for the same error message) like:
– Installing 32bits version of Oracle Client (10.2.0.1)
– Instant client didn’t work for me.

Hope it helps.

Author: Selim (8)

If you are one of those unlucky guys who have to live in both worlds, design/develop the front end, and the server side functionality and test, and … you got me… I find it quite effective to start and finish a fully functional UI first than start coding the back end.
* By fully I mean the 80%-20% fully.
* Even if you write some mock-up code to mimic your biz logic related objects, it’s OK, and takes generally less time than you think to throw away the prototype and replace it with the real stuff.
* This might be a personal trait/flaw, but having something visual in front of me helps me to understand the problem better.

Author: Selim (8)