Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 10645 invoked from network); 2 Feb 2007 10:25:47 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 10:25:40 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EB065D3737; Fri, 2 Feb 2007 11:24:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17641-01; Fri, 2 Feb 2007 11:24:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8AEA45D3723; Fri, 2 Feb 2007 11:24:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Feb 2007 11:22:54 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6EBD05D3689 for ; Fri, 2 Feb 2007 11:22:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17276-06 for ; Fri, 2 Feb 2007 11:22:54 -0500 (EST) Received: from outbound1-sin-R.bigfish.com (outbound-sin.frontbridge.com [207.46.51.80]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D7A25D3475 for ; Fri, 2 Feb 2007 11:22:51 -0500 (EST) Received: from outbound1-sin.bigfish.com (localhost.localdomain [127.0.0.1]) by outbound1-sin-R.bigfish.com (Postfix) with ESMTP id 4AC6A13F813D for ; Fri, 2 Feb 2007 16:23:47 +0000 (UTC) Received: from mail18-sin-R.bigfish.com (unknown [10.3.252.3]) by outbound1-sin.bigfish.com (Postfix) with ESMTP id 1C1AD1C9007A for ; Fri, 2 Feb 2007 16:23:47 +0000 (UTC) Received: from mail18-sin (localhost.localdomain [127.0.0.1]) by mail18-sin-R.bigfish.com (Postfix) with ESMTP id D45B6D00FB for ; Fri, 2 Feb 2007 16:23:46 +0000 (UTC) X-BigFish: VP Received: by mail18-sin (MessageSwitch) id 1170433426834951_8985; Fri, 2 Feb 2007 16:23:46 +0000 (UCT) Received: from dsmtpg04.col.discoverfinancial.com (unknown [12.41.53.18]) by mail18-sin.bigfish.com (Postfix) with ESMTP id 5983EF7806D for ; Fri, 2 Feb 2007 16:23:41 +0000 (UTC) Received: from dsmtpg03.novus.relay (DSMTPG03 [12.41.53.14]) by dsmtpg04.col.discoverfinancial.com with ESMTP id l12GNa738942 for ; Fri, 2 Feb 2007 11:23:36 -0500 Received: from dfscolm02.co.discoverfinancial.com (dfscolm02.co.discoverfinancial.com [199.12.96.170]) by dsmtpg03.novus.relay with ESMTP id l12GNQ233196 for ; Fri, 2 Feb 2007 11:23:26 -0500 In-Reply-To: <85c1fb130702011510r402697f1j4add714241715bbb@mail.gmail.com> Subject: Re: problems with dblink in oracle 10.2.0.2 To: amonte Cc: oracle-l@freelists.org Message-ID: From: genegurevich@discoverfinancial.com Date: Fri, 2 Feb 2007 10:22:21 -0600 X-MIMETrack: Serialize by Router on DFSCOLM02/MSRV/DFSI(Release 7.0.1FP1|April 17, 2006) at 02/02/2007 10:22:22 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-archive-position: 45079 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: genegurevich@discoverfinancial.com Precedence: normal Reply-to: genegurevich@discoverfinancial.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net Yes, that is what I do. I have the same user existing on local and remote DB and I am creating the dblink the way you have it thank you Gene Gurevich amonte To genegurevich@discoverfinancial.com 02/01/2007 05:10 cc PM oracle-l@freelists.org Subject Re: problems with dblink in oracle 10.2.0.2 Dont tell me you are using remote os authentification? Are you saying server 1 has user ops$adm1 server 2 has user ops$adm1 and in server 1 as ops$adm1 you do create database link xxx using 'yyy' ? On 2/1/07, genegurevich@discoverfinancial.com < genegurevich@discoverfinancial.com> wrote: Hi all: I have spend 2 weeks trying to get help from Oracle support on this (time well wasted). Here is my issue. I am running oracle 10.2.0. on aix 5.3 on a local server and on a remote server. I have oracle id externally authenticated on both sides. I can connect as sqlplus / to local DB and as sqlplus /@remoteDB. I have created a db link on a local database : create database link remoteDB using 'remoteDB' When I try to use it I get an error: desc user_tables@remoteDB ERROR: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from PCCS03 (this is my remote DB) The remote instance is up (I can tnsping id and connect via sqlplus). What is the problem here. I have been using dblinks created this way in oracle 8 and 9 and never had this issue. Is there anything new in oracle 10 related to this? Does anyone know? TIA Gene Gurevich -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l