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