Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed databases
Try the following:
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