This is a little something I thought I need to share. We had some issues establishing connection to Oracle. We kept getting the ORA-12154 (TNS:could not resolve the connect identifier specified) without any apparent reason.
The weirdest thing was that in some application the connection was successfully established, while it kept throwing ORA-12154 for other.
After hours of desperate attempts to find the problem - it was finally revealed:
DON'T TRY TO ESTABLISH A CONNECTION FROM A PATH CONTAINING PARENTHESES ('(', ')')!!!!!!
If this was any helpful for you... please feel free to thank me.