Re: dblink no listener - normal connection works
From: <phil_herring_at_yahoo.com.au>
Date: Wed, 14 Jul 2010 17:35:32 -0700 (PDT)
Message-ID: <71dc603a-7784-45d8-9ba7-ca4961335520_at_m17g2000prl.googlegroups.com>
Do you have more than one Oracle home on the server?
Date: Wed, 14 Jul 2010 17:35:32 -0700 (PDT)
Message-ID: <71dc603a-7784-45d8-9ba7-ca4961335520_at_m17g2000prl.googlegroups.com>
Do you have more than one Oracle home on the server?
By default, a DB link will use the TNS names file in the database home. However, it's possible that when you run tnsping, you're using another Oracle home with a different TNS names file.
- Phil