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"                                                  
                                                
                      <clive.hybart            To:      Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>                    
                      @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).

Reply via email to