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

My bad. IGNORE PREVIOUS.

It should be the same as: select * from global_name.

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

> 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).

-- 
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).