Hi all,

I have a question regarding Database link with tnsnames.ora.

I created a db link a few weeks ago. It worked fine.
Just one day, it failed, the error message saying:
Couldn't find hostname, or host doesn't exist.

I could link to remote DB side by typing connect syuan/***@remote_db.

Only Db link didn't work. Later I changed the host to ip address instead of host name. Then everything works fine.

My question is why? I do not work at remote side. I do not know what happen in remote side. I am sure local I did not do anything.

Anyone has any idea?


Thanks in advance!


Stacy