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

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


Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

2003-12-10 Thread Hybart, Clive
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password






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

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