Man... I did something to my workstation... and i can't figure out what i did. I've checked the registry, and the tnsnames.ora file is located where it's supposed to be...but suddenly i can't get to any of my databases...

I checked and i still have read access to the tnsnames file... so that can't be the reason...

I've even tried editing the registry to include TNS_ADMIN and specifying a different path... but i cant get in anywhere.. getting the same:
ora-12222:tns no such protocol adapter
or ... tns canot resolve host name message.

I tried doing TNSPING and get
Message 3509 not found; No message file for product=NETWORK, facility=TNS

... i'm not sure what this message means... can you tell me...

how do i resolve this problem??? i thought i did all the right troubleshooting, but apparently not!@ :(