Problem accessing DB Link

I've created a DB link from one database to another (Oracle 8i on linux).

However, when I try to access data on the linked database, I get the following...

  1* select * from rjs.a_at_RJS
SQL> select * from rjs.a_at_RJSDB
  2 ;
select * from rjs.a_at_RJSDB

                    *

I don't have any problem connecting normally to either database.

I've double checked the TNSNAMES.ORA and LISTENER.ORA files, which seem ok to me...

Here they are...

listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

tnsnames.ora...

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = AMDPENTIUM3)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = ORCL)

    )
  )

DEMO =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linux)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = DEMO)

    )
  )

RJS =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCAL = TCP)(HOST = linux)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = RJS)

    )
  )

RJS2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCAL = TCP)(HOST = linux)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = RJS2)

    )
  )

Can anyone shed any light on why I get the error.

Thanks in Advance.

Replies by email also please

RS. Received on Mon Jan 29 2001 - 15:19:18 CET