| From: | Chris Mair <chris(at)1006(dot)org> |
|---|---|
| To: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Oracle to PostgreSQL Migration. |
| Date: | 2017-05-29 09:19:42 |
| Message-ID: | 342051cfd508755a032d133ed0ab666e@smtp.hushmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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(at)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PAWAN SHARMA | 2017-05-29 11:00:35 | Re: Oracle to PostgreSQL Migration. |
| Previous Message | PAWAN SHARMA | 2017-05-29 09:08:52 | Oracle to PostgreSQL Migration. |