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