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!
Click Here to Expand Forum to Full Width