Re: [GENERAL] Oracle to PostgreSQL Migration.

Поиск
Список
Период
Сортировка
От PAWAN SHARMA
Тема Re: [GENERAL] Oracle to PostgreSQL Migration.
Дата
Msg-id CAPgXFMQV0bFRu5tm0HF7yU1VLFrRpKKO5xcN8yaicHAWqfaavg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Oracle to PostgreSQL Migration.  (Chris Mair <chris@1006.org>)
Ответы Re: [GENERAL] Oracle to PostgreSQL Migration.  (Chris Mair <chris@1006.org>)
Список pgsql-general
Дерево обсуждения


On Mon, May 29, 2017 at 2:49 PM, Chris Mair <chris@1006.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@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>

В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Mair
Дата:
Сообщение: Re: [GENERAL] Oracle to PostgreSQL Migration.
Следующее
От: Chris Mair
Дата:
Сообщение: Re: [GENERAL] Oracle to PostgreSQL Migration.