Re: database link problem in oracle 8

In article <7ckru1$coo$1_at_nnrp1.dejanews.com>,   kvsraju_at_my-dejanews.com wrote:
> Hi,
> Here i have a problem with DATABASE LINK
> i have my database in machine name "COM-SERVER"
> my client is in machine name "c-296"
> and another personnel oracle database in machine name "c-318"
>
> Now
> i am able to connect database "oracle" in "COM-SERVER" machine using an alias
> from c-296.
>
> i am able to connect database "oracle" in "c-318" machine using an alias from
> c- 296.
>

Hi there.

The TNS service name will be looked up in the tnsnames.ora file on the machine where the database is running. Try tnsping <SID> from each machine and one of them should fail; if so make changes to the file.

If this isn't the problem then examine the service name you have specified in you database links. This is what gets looked up in tnsnames.ora.

I hope this helps.
Mark.
> but when i try to access the table in c-318 database from "com-sever" database
> through machine c-296 using
>
> select * from accounts_at_rdlk;
>
> it is giving an error saying
> ORA-12154: TNS:could not resolve service name
>
> i am able to connect to that database using an alias but i am not able to
> access object using the database link WHY?
>
> Thanx in Advance
>
> kvsraju
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 18 1999 - 01:57:19 CST