Hi i have read all the other posts about this error but i cant seem to find on how can i fix this problem. i already tried all the suggestions you told to other people encountering this but it seems it doesnt work on me. here are the details:
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I was trying to export a table thru Enterprise Manager Console and i always got failed. Also, i tried exporting using a DOS command: "exp userid=ora_88836/ora_88836 file=wyndat.dmp owner=ora_88836" and thru this i get to have an error ORA-12560: TNSrotocol adapter error. Then i tried logging thru the SQL Plus using (ora_88836/ora_88836) with a Host string as tree i got connected then i exited the SQL Plus. Then i tried logging in SQL Plus using (ora_88836/ora_88836) without a Host String i get the error TNSrotocol adapter error.
I am not sure this will solve your problem.
Since you are getting protocol adapter error while using sqlplus without net service names, please check this..
If you have 2 oracle homes in your machine, make the two tnsnames.ora files identical. (ORACLE_HOMEx\network\admin)
Convergys, Hyderabad, India