RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Message Tnsnames is used to resolve aliases - we are currently looking at the global_names parameter -Original Message-From: Hybart, Clive [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 15:19To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Hi there Clive! :) < SPAN class=814030411-10122003> Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails be tween 8.1.7 (Unix) and 9i (Zos 390) due to invalid 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 ?
Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
How are you resolving your aliases on the unix box and on your client? Are you using onames for both (check your sqlnet.ora at both locations) or are you using local copies of tnsnames.ora? (or some other method). "Hybart, Clive" @metoffice.com> cc: Sent by: Subject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid ml-errors 12/10/2003 05:39 AM Please respond to 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 ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day 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).
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Message Usual ORA-01017 Mark Invalid username/password and yet SQLPLUS is quite happy with the same login -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 11:59To: Multiple recipients of list ORACLE-LSubject: RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid 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 ?
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid 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 ?
