Re: database link

From: Allan Griffith <allan.griffith_at_stir.ac.uk>
Date: Fri, 28 May 1999 19:15:33 +0100
Message-ID: <374EDD45.ABE83835@stir.ac.uk>

Alan

From the other machine try logging on to build1 with

    sqlplus system/manager_at_build1
If you get the same error, it may mean that the tnsnames.ora file on the build1 machine is either not in the
location identified by $TNS_ADMIN, or doesn't have the entry that is in the file that you provided
an excerpt from, or it may be that the operating system owner of build1 does not have read permission for it.
Include the following lines in sqlnet.ora

    TRACE_LEVEL_CLIENT = 16
    TRACE_UNIQUE_CLIENT = ON
    TRACE_DIRECTORY_CLIENT = /tmp

try logging on again, and this will produce a trace file in /tmp explaining the problem

Good luck

Allan

Alan Wamser wrote:

> 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 Fri May 28 1999 - 13:15:33 CDT