Select a from remote table

From: Hong Yew <yew_at_labyrinth.net.au>
Date: Thu, 3 Sep 1998 18:10:24 +1000
Message-ID: <6smm42$6cm$1@arachne.labyrinth.net.au>

Hi, It'll be great if you can give me a hint to troubleshoot this one.

We are using Personal Oracle to access a remote Oracle 8 NT server .We can't seems to select from a remote table using :

        SELECT * FROM username.table_at_remote_dblink;

We have created a database link of with

        CREATE DATABASE LINK remote_dblink CONNECT TO username
        IDENTIFIED BY password VALUE 'remote_domain'

We are able to CONNECT to the remote site using username/password_at_remote_domain!

When the SELECT is called, we have the following error: TNS-12203: TNS:unable to connect to destination. However, we could do a CONNECT!

This is the full SQLNET.LOG:

---

Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=NMP)(SERVER=NCS_ORA_DEV)(PIPE=ORAPIPE))(CON NECT_DATA=(SID=ORCL)(CID=(PROGRAM=c:\orant\bin\oracle80.exe)(HOST=RAJ32)(US ER=Ntuser))))

  VERSION INFORMATION:

     TNS for 32-bit Windows: Version 8.0.4.0.0 - Production
     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
8.0.4.0.0 - Production
     Windows NT Named Pipes NT Protocol Adapter for 32-bit Windows: Version

 8.0.4.0.0 - Production
  Time: 03-SEP-98 10:48:49
  Tracing not turned on.
  Tns error struct:
    nr err code: 12203
    TNS-12203: TNS:unable to connect to destination     ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 5
    nt OS err code: 0

If you can help me out, I'll be greatly appreciated!

    Thanks,

        Hong Received on Thu Sep 03 1998 - 03:10:24 CDT