Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dFGqG-0003bc-Qc for pgsql-general@arkaria.postgresql.org; Mon, 29 May 2017 09:20:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dFGqG-0007Bj-8l for pgsql-general@arkaria.postgresql.org; Mon, 29 May 2017 09:20:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFGqF-0007BZ-Ka for pgsql-general@postgresql.org; Mon, 29 May 2017 09:19:59 +0000 Received: from smtp1.hushmail.com ([65.39.178.135]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dFGqB-0001vc-JG for pgsql-general@postgresql.org; Mon, 29 May 2017 09:19:58 +0000 Received: from smtp1.hushmail.com (localhost [127.0.0.1]) by smtp1.hushmail.com (Postfix) with SMTP id 576D240722 for ; Mon, 29 May 2017 09:19:51 +0000 (UTC) Received: from smtp.hushmail.com (w1.hushmail.com [65.39.178.83]) by smtp1.hushmail.com (Postfix) with ESMTP; Mon, 29 May 2017 09:19:49 +0000 (UTC) Subject: Re: Oracle to PostgreSQL Migration. To: PAWAN SHARMA , pgsql-general@postgresql.org References: From: Chris Mair Message-ID: <342051cfd508755a032d133ed0ab666e@smtp.hushmail.com> Date: Mon, 29 May 2017 11:19:42 +0200 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org > I am facing below issue while running below command. > > *C:\ora2pg>ora2pg -c ora2pg.conf* > DBI connect('host=;sid=;port=',',...) failed: ORA-01017: invalid username/p > assword; logon denied (DBD ERROR: OCISessionBegin) at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 1376. > FATAL: 1017 ... ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin) > Aborting export... > > even I am able to login in Oracle with same and If you can login from the same host using sqlplus like this: sqlplus myuser/mypass@myhost:1521/mysid then you likely can have ora2pg connect too. Just make sure that in ora2pg.conf you put the lines: ORACLE_DSN dbi:Oracle:host=myhost;sid=mysid ORACLE_USER myuser ORACLE_PWD mypass Bye, Chris. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general