Database link errors with ORA-12541: TNS:no listener
Hello,
I have an unusual situation.
We have 3 databases on 3 seperate servers(prd,tst and dev).
I am able to create database links from prd to dev & test to dev but not dev to test or dev to prd.
I receive a ORA-12541: TNS:no listener error when I try to access something through the links from dev to tst or dev to prd.
The dba has verified that the listener is up.
I've checked the *.ora files and it appears to be ok on all three servers.
We recently had to re-install the database on the dev server (which is also new) so I am suspect that we missed something but can't seem to id what we missed.
It is odd to me that we can create links "to" the dev database but not "from" the dev database.
Any thoughts/suggestions.