Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP! - SQL*NET from 8.1.6 to 7.3.4

RE: HELP! - SQL*NET from 8.1.6 to 7.3.4

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 9 Nov 2000 07:20:10 -0600
Message-Id: <10675.121557@fatcity.com>


The Global_Name was the problem.
Thanks!

-----Original Message-----
From: ddorr.cs_at_clearstream.com [mailto:ddorr.cs_at_clearstream.com] Sent: Thursday, November 09, 2000 6:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: HELP! - SQL*NET from 8.1.6 to 7.3.4

The error comes from a GLOBAL_NAME = TRUE setting : in this case the DBLINK name must match the DB global name.

For the second part ( finqual1 connecting to KMINSTL1.WORLD ), you must have somewhere in a tnsnames.ora a service named finqual1 ! Check for $TNS_ADMIN, or maybe a $HOME/.tnsnames.ora ...

> ----------
> From: Smith, Ron L.[SMTP:rlsmith_at_kmg.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, November 08, 2000 23:06
> To: Multiple recipients of list ORACLE-L
> Subject: RE: HELP! - SQL*NET from 8.1.6 to 7.3.4
>
> Here is the link.
> CREATE PUBLIC DATABASE LINK LCLAIMS_FINQUAL1.KMG.COM
> CONNECT TO LCLAIMS IDENTIFIED BY password USING 'finqual1'
> ;
> Here is my last attempt at the tnsnames. It has gone through several
> encarnations.
> finqual1.KMG.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = world)
> (PROTOCOL = TCP)
> (HOST = reliant)
> (PORT = 1525))
> )
> (CONNECT_DATA =
> (SID = finqual1)
> (GLOBAL_NAME=FINQUAL1.world)
> )
> )
>
> The listner on the server has been working for years. There is no
> kminstl1
> on
> any server, in any tnsnames.ora or listener.ora file.
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
>
>
> -----Original Message-----
> Sent: Wednesday, November 08, 2000 3:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Give us more information as of how you create the dblink. And what is the
> tnsnames.ora file look like in the 816 box. Can you find the kminstl1
> entry
> in your tnsnames.ora file?
>
> Winnie
>
>
>
>
>
> "Smith, Ron L." <rlsmith_at_kmg.com>@fatcity.com on 11/08/2000 12:46:37 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
> I am trying to connect an 8.1.6 instance to a 7.3.4 instance through a
> database link. I get and error message something like:
> ORA-02085 Database Link FINQUAL1.KMG.COM connects to KMINSTL1.WORLD.
> There
> is no KMINSTL1.world anywhere. The link points to FINQUAL1.
> Can anyone help?
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.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
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Winnie_Liu_at_infonet.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
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.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
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: ddorr.cs_at_clearstream.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
Received on Thu Nov 09 2000 - 07:20:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US