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

2003-12-11 Thread Yechiel Adar
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" <[EMAIL PROTECTED]> Sent: Thursday, December 11, 2003 5:34 PM > Yes. The name must be equal to select name from v$database. >

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

2003-12-11 Thread Yechiel Adar
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 th

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

2003-12-11 Thread Mark Leith
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 U

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

2003-12-11 Thread Hybart, Clive
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

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

2003-12-10 Thread Hately, Mike (LogicaCMG)
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: