Home > mailing lists

[GENERAL] Oracle to PostgreSQL Migration. - Mailing list pgsql-general

From	PAWAN SHARMA
Subject	[GENERAL] Oracle to PostgreSQL Migration.
Date	May 29, 2017 15:08:52
Msg-id	CAPgXFMSJOLOz+tm+jzkh9GvEpQMUnYWCNPq7RDCmobVKS-BHzg@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] Oracle to PostgreSQL Migration.
List	pgsql-general

Hi All,

I am going to migrate Oracle database into PostgreSQL using ora2pg tools.

I have installed Strawberry Perl.

C:\ora2pg>perl -v

This is perl 5, version 24, subversion 1 (v5.24.1) built for MSWin32-x64-multi-thread

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>

entry in sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Please suggest.!!!!!!!!!!!!!!

-Pawan

From: Albe Laurenz
Date: 29 May 2017, 13:27:39
Subject: Re: [GENERAL] plpgsql function with offset - Postgres 9.1

From: Chris Mair
Date: 29 May 2017, 15:19:42
Subject: Re: [GENERAL] Oracle to PostgreSQL Migration.