I have been given a DB account and set of connection information to add into my tnsnames.ora file on my PC. Each time I try and connect I get the following error ORA-12154: TNS: could not resolve the connect identifier specified, yet a colleague who has a different query tool (SQL Developer) can manually input the connection details and connect fine. Can anyone give any clues as to what may be going wrong? The entry in tnsnames.ora is in this format:
ourDB=(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ourserver)(PORT=1525)) (CONNECT_DATA= (SID=PROD)))
OK (0 msec)
Any tips what could be going wrong? it isnt credentials they work fine, it cant be firewall/IP fitering due to my collegue having similar access to me. so it must be something wrong in tnsnames.ora?