Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv

Yes. The name must be equal to select name from v$database.

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 11, 2003 4:54 PM

> Clive,
>
> If the GLOBAL_NAMES parameter is set to true, then you must create the
> database link with the same name as the database to which it connects.. Is
> that the case?
>
> Mark
>
>
>
> -----Original Message-----
> Hybart, Clive
> Sent: 11 December 2003 12:24
> To: Multiple recipients of list ORACLE-L
> inv
>
>
> On UNIX 8.1.7 global_names = true
>
> On Zos 390 9i global_names = false
>
>
> Is this causing a mismatch perhaps ?
>
> Regards
>
> Clive
>
> -----Original Message-----
> Sent: 10 December 2003 12:10
> To: Multiple recipients of list ORACLE-L
> inv
>
>
> Clive,
> during the upgrade has the global_names parameter somehow been changed
> from false to true? This would cause the connection to be refused if the
> link name does not match the global_name for the target database.
>
> Cheers,
> Mike Hately
>
> -----Original Message-----
> On Behalf Of Hybart, Clive
> Sent: 10 December 2003 10:39
> To: Multiple recipients of list ORACLE-L
>
>
>
> Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between
> a Unix box (8.1.7.0) and the mainframe fails.
> However sqlplus using the same connection syntax "Connect
> username/password_at_location" is fine.
> Any ideas, peeps ?
>
>
>
> ************************************************************************
> ********************
> E mail Disclaimer
>
> You agree that you have read and understood this disclaimer and you
> agree to be bound by its terms.
>
> The information contained in this e-mail and any files transmitted with
> it (if any) are confidential and intended for the addressee only. If
> you have received this e-mail in error please notify the originator.
>
>
> This e-mail and any attachments have been scanned for certain viruses
> prior to sending but CE Electric UK Funding Company nor any of its
> associated companies from whom this e-mail originates shall be liable
> for any losses as a result of any viruses being passed on.
>
> No warranty of any kind is given in respect of any information contained
> in this e-mail and you should be aware that that it might be
> incomplete, out of date or incorrect. It is therefore essential that you
> verify all such information with us before placing any reliance upon it.
>
> CE Electric UK Funding Company
> Lloyds Court
> 78 Grey Street
> Newcastle upon Tyne
> NE1 6AF
> Registered in England and Wales: Number 3476201
>
> ************************************************************************
> ********************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hately, Mike (LogicaCMG)
> INET: mike.hately_at_nedl.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: Hybart, Clive
> INET: clive.hybart_at_metoffice.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).