From: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> |
---|---|
To: | Chris Mair <chris(at)1006(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Oracle to PostgreSQL Migration. |
Date: | 2017-05-29 11:00:35 |
Message-ID: | CAPgXFMQV0bFRu5tm0HF7yU1VLFrRpKKO5xcN8yaicHAWqfaavg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, May 29, 2017 at 2:49 PM, Chris Mair <chris(at)1006(dot)org> wrote:
> I am facing below issue while running below command.
>>
>> *C:\ora2pg>ora2pg -c ora2pg.conf*
>> DBI connect('host=<servername>;sid=<SID>;port=<port>',<username>',...)
>> 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 <username> and <password>
>>
>
> If you can login from the same host using sqlplus like this:
>
> sqlplus myuser/mypass(at)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.
>
>
>
Hi Chris,
C:\ora2pg>ora2pg -c ora2pg.conf
[========================>] 2/2 tables (100.0%) end of scanning.
[> ] 0/2 tables (0.0%) end of scanning.
[========================>] 2/2 tables (100.0%) end of table export.
-- Generated by Ora2Pg, the Oracle database Schema converter, version 18.1
-- Copyright 2000-2017 Gilles DAROLD. All rights reserved.
-- DATASOURCE: dbi:Oracle:host=<server_name>;sid=<mysid>;port=1521
SET client_encoding TO 'UTF8';
\set ON_ERROR_STOP ON
CREATE TABLE test (
id bigint,
name varchar(30)
) ;
CREATE TABLE mytab (
id bigint,
name varchar(30),
dt timestamp
) ;
DBD::Pg::st execute failed: ERROR: relation "mytab" does not exist
LINE 1: INSERT INTO mytab (id,name,dt) VALUES ($1,$2,$3)
^ at C:/Strawberry/perl/site/lib/Ora2Pg.pm line 11574.
FATAL: ERROR: relation "mytab" does not exist
LINE 1: INSERT INTO mytab (id,name,dt) VALUES ($1,$2,$3)
^
Aborting export...
C:\ora2pg>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Mair | 2017-05-29 12:58:54 | Re: Oracle to PostgreSQL Migration. |
Previous Message | Chris Mair | 2017-05-29 09:19:42 | Re: Oracle to PostgreSQL Migration. |