| From: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Oracle to PostgreSQL Migration. |
| Date: | 2017-05-29 09:08:52 |
| Message-ID: | CAPgXFMSJOLOz+tm+jzkh9GvEpQMUnYWCNPq7RDCmobVKS-BHzg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
Copyright 1987-2017, Larry Wall
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Mair | 2017-05-29 09:19:42 | Re: Oracle to PostgreSQL Migration. |
| Previous Message | Albe Laurenz | 2017-05-29 07:27:39 | Re: plpgsql function with offset - Postgres 9.1 |