RE: Database link

You probably have GLOBAL_NAME = true.

In this case, you DB link name (LRMI.NOVALISTECH.COM) MUST match your DB global_name ( currently LRMI ).  

> ----------
> From: Witold Iwaniec[SMTP:wiwaniec_at_novalistech.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, October 12, 2000 17:05
> To: Multiple recipients of list ORACLE-L
> Subject: Database link
>
> Hi
>
> Has anyone created database link from Personal Oracle 8.1.6?
> I have used database links with previoous versions, including
> Personal Oracle, and there was no problem. But 8.1.6 does not
> seem to like what I am doing.
>
> Here is extract fom my tnsnames.ora:
>
> LRMI.NOVALISTECH.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = wallyjr)(PORT =
> 1526))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = lrmi)
> )
> )
>
> I can connect without any problems to the database:
> connect wiwaniec_at_lrmi
>
> When I create the database link:
>
> create database link lrmi connect to wiwaniec identified by
> my_pass using 'lrmi'
>
> everything seems to be OK. But when I try to use it:
>
> select count(*) from my_table_at_lrmi;
>
> I get the error:
>
> ORA-02085: database link LRMI.NOVALISTECH.COM connects to
> LRMI
>
> I have tried all variations:
> - use lrmi.novalistech.com as the database link name
> - use 'lrmi.novalistech.com' as connect string
> - use different database link name - my_lrmi, with and without the
> domain but each time I get the error back and the database link
> always has the domain suffix while the connect string does not.
>
> The same syntax for database link works properly in Oracle 8.1.6
> on UNIX when I create link to another dataabse on UNIX.
>
> Is there something specific for Personal Oracle or am I missing
> something?
>
> Thanks
>
> Witold
>
> ======================================
> Witold Iwaniec
> Senior Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Oct 12 2000 - 09:24:31 CDT