Help - Creating Remote database links

From: Kevin Seneviratne <kevins_at_connect.com.au>
Date: Wed, 05 Aug 1998 22:22:55 +1000
Message-ID: <35C84E9F.D6131247@connect.com.au>

Hi All,

I am trying to setup a remote connection from one instance to another
(both on the same server) using

create public database link xx connect to yy identified by zz using test

The link is created but the moment I try to use it freezes for about 5-7 and then comes back with " a link inavlid " message.

All the tns entries etc. seem to be o.k.

tnsnames.ora has

bulkt =
(

   DESCRIPTION=
(

      ADDRESS=
      (PROTOCOL=TCP)
      (PORT=1521)
      (HOST=dbhost)

   )

(

      CONNECT_DATA=(SID=BULKT)
   )
)

test =
(

   DESCRIPTION=
(

      ADDRESS=
      (PROTOCOL=TCP)
      (PORT=1521)
      (HOST=dbhost)

   )

(

      CONNECT_DATA=(SID=test)
   )
)

listener.ora has

dbhost=
(ADDRESS_LIST=
 (ADDRESS=

  (PROTOCOL=tcp)
  (HOST=dbhost)
  (PORT=listener)

 )
)

SID_LIST_dbhost=(SID_LIST=

(SID_DESC=
(GLOBAL_DBNAME=BULKT)
(SID_NAME=BULKT)
(ORACLE_HOME=/opt/oracle/product/7.3.2))

(SID_DESC=
(GLOBAL_DBNAME=test)
(SID_NAME=test)
(ORACLE_HOME=/opt/oracle/product/7.3.2))
)

Have used this many times before on other servers - but can't get this one to work.

Any ideas ?

Many thanks

Kevin. Received on Wed Aug 05 1998 - 07:22:55 CDT