Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid

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

From: Thomas Day <tday6_at_csc.com>
Date: Wed, 10 Dec 2003 07:29:26 -0800
Message-ID: <F001.005D9706.20031210072926@fatcity.com>

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 <ORACLE-L_at_fatcity.com>                    
                      @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/password_at_location" is fine.
Any ideas, peeps ?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Day
  INET: tday6_at_csc.com

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: ListGuru_at_fatcity.com (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). Received on Wed Dec 10 2003 - 09:29:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US