Oracle 9i and database link to Oracle on Novell Netware

From: Jon Waterhouse <jonwaterhouse_at_mail.gov.nf.ca>
Date: 23 May 2002 07:32:38 -0700
Message-ID: <39206c8b.0205230632.311413ae@posting.google.com>

I have 9i personal installed on my desktop (running NT). Our main server is running 8.1.6 on Novell Netware, the listener is set up with SPX.

I would like to make a link from my machine to the main server so I can copy some tables over. I added the following to the 9i TNSNAMES.ORA
ORACLE =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = SPX)(SERVICE = HRE_DATA_lsnr))     )
(CONNECT_DATA =

      (SERVICE_NAME = oracle)
    )
  )
and set up a database link as
CREATE DATABASE LINK CONNECT TO <myID on 8.1.6> IDENTIFIED by <my password on 8.1.6> USING 'ORACLE'

This fails with an ORA-12538: TNS: no such protocol adapter.

I think this is because 9i will no longer recognize or use SPX? Is this correct?

Going the other way, I have tried the following (string copied from 9i NAMES.ora):
create database link jonlink CONNECT to (my ID on 9i> IDENTIFIED BY <my password on 9i> using
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=13dw48a023)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=jonora)))';

which fails with 12545: Connect fails because target host or object does not exist.

Is there something else I should try?

Thanks,

Jon Received on Thu May 23 2002 - 09:32:38 CDT