Re: Distributed databases

Try the following:

1. On NT1 you must be able to connect to the service of NT2.
2. On NT2 you must also be able to connect to NT1.

So this may not have anything to do with your client. The servers must be able to reach another when you create a database link, not the client.

Martin

pradyumn_at_my-deja.com wrote:
>
> I have a query about networking Oracle in Windows NT. Can somebody
> please help?
>
> I have two NT servers, called NT1 and NT2. I have two databases as
> follows:
>
> Server:NT1
> Database name: oracle1
> SID: orcl
>
> Server: NT2
> Database name: oracle2
> SID: orcl
>
> I have a client machine (NT Workstation), from where I want to log on to
> oracle1 database on NT1, and from within that login, I want to access
> some tables from oracle2 database on NT2.
>
> Using Net8 Easy Config utility on the client machine, I have created a
> new service as follows:
>
> Service name: service1
> Using: Named pipes (Microsoft networking)
> Server name: NT1
> Pipe name: ORAPIPE
> Database SID: orcl
>
> Using this service, I can connect to the database from the client
> machine as follows:
>
> connect amar/am @service1
>
> Similarly, on the client machine, I have created another service as
> follows:
>
> Service name: service2
>
> Using: Named pipes (Microsoft networking)
> Server name: NT2
> Pipe name: ORAPIPE
> Database SID: orcl
>
> Using this service, I can connect to the database from the client
> machine as follows:
>
> connect akbar/ak @service2
>
> Now, if I connect to one database, I cannot access data from another
> database using database link. In database oracle1, I have created a link
> as follows:
>
> create database link mylink
> connect to akbar identified by ak
> using 'service2';
>
> The database link gets created without any error message. However, when
> I give the following command:
>
> select * from table1_at_mylink;
>
> I get the following error:
>
> ORA-12203: TNS: unable to connect to destination
>
> I think that I am missing some step. But what I am missing is not known
> to me.
>
> Can somebody please help?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Nov 27 1999 - 11:32:20 CST