database link

From: Alan Wamser <awamser_at_haysmed.com>
Date: Wed, 26 May 1999 15:25:15 -0500
Message-ID: <7ihlft$8q71@news.midusa.net>

I am trying to create a database link between two databases on different machines. I added an entry in to the tnsnames.ora and then create the link in oracle. I get the following error...

SQL> select * from v$database_at_build1;

                         *

ERROR at line 1:
ORA-12154: TNS:could not resolve service name

The nsnames.ora file looks like this...

build1.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL= TCP)
(Host= 172.16.2.9)
(Port= 1526)

    )
    (CONNECT_DATA = (SID = build1)
    )
  )

I create the db link using this command:

create database link build1 connect to <username> identified by <password> using 'build1'

The system I am creating the link on is RedHat 5.2 running Oracle 8.0.5 and the host system is AIX running Oracle 7.3.3.

Thanks,
Alan Received on Wed May 26 1999 - 15:25:15 CDT