Re: Creation of Database Link

Aik Khoon wrote:

> Hi,
>
> I have trouble creating database link (from DB2 to DB1) to work in
> replication. The error raised is always 02019 : connection to remote
> database not found when I tried to create SNAPSHOTs for the SCOTT.EMP. The
> SNAPSHOT LOG is created without any error.
>
> I have created the Net8 Services using Net8 Assistant.
>
> E.g. in TNSNAMES.ORA
>
> DB1.WORLD = (DESCRIPTION=
> (ADDRESS=
> (PROTOCOL=TCP)
> (HOST=TOP)
> (PORT=1521))
> (CONNECT DATA=(SID=DB1))))
>
> In Oracle8 NT, I typed the following command in SCOTT account
>
> CREATE DATABASE LINK DB1 CONNECT TO SCOTT IDENTIFIED BY TIGER USING
> 'DB1.WORLD';
You are creating a link named DB1. This must match the name you used in your CREATE DATABASE statement.

<clipped>

> Concept wise, do I have to have the same TNSNAME.ORA entries on both
> database servers.

I think the TNSNAMES.ORA file on each server should contain an entry for the other server.

> Because I am new (one week only) to Oracle, any questions raised before is
> regretted.

To be safe, you can search www.dejanews.com before posting questions. Good luck.

> Thanks,
> Aik Khoon
Received on Fri Apr 30 1999 - 14:14:06 CDT