Yes. The name must be equal to select name from v$database. Yechiel Adar Mehish ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]" 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
