Re: Help - Creating Remote database links

You need to put quotes around your service name or tnsname i.e. 'test' that is if you are using SQL*Net v2.0 or higher.

If you are on SQL*Net v.1, then use 't:network_node:test'

Good luck !!!

www.oracleguru.net

Kevin Seneviratne <kevins_at_connect.com.au> wrote in article <35C84E9F.D6131247_at_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 - 11:40:59 CDT