Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver

From: Harshad Adalkonda <adalkondaharshad(at)gmail(dot)com>
To: Sandeep Gondhalekar <sandeep(dot)gondhalekar1(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver
Date: 2014-12-28 08:27:19
Message-ID: CANnQH_gC=XBoSKpizK_G87Qz3gt=3Ze3Ty-9KMpxLfK8umCuBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Dec 27, 2014 at 9:59 PM, Sandeep Gondhalekar <
sandeep(dot)gondhalekar1(at)gmail(dot)com> wrote:

> I am using Oracle 12c to test migration from Oracle to PostgreSQL. I am
> using windows OS. I have copied ojdbc7.jar file under lib folder of
> "EnterpriseDB-MigrationToolkit"
>
> I am getting following error:
>
>
> E:\sandeep\postgres\EnterpriseDB-MigrationToolkit>runMTK.bat -verbose on
> -source
> dbtype "oracle" @//localhost:1521/pdbsales.igatecorp.com
> Source database connectivity info...
> conn =jdbc:oracle:thin:@//localhost:1521/pdbsales.igatecorp.com
> user =scott_name
> password=******
> Target database connectivity info...
> conn =jdbc:postgresql://localhost:5432/postgres
> user =postgres
> password=******
> Connecting with source Oracle database server...
> Error: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>
> One or more schema objects could not be imported during the migration
> process. P
> lease review the migration output for more details.
>
> Migration logs have been saved to
> C:\Users\gondhasa.IGATECORP\.enterprisedb\migr
> ation-toolkit\logs
>
> ******************** Migration Summary ********************
>
> Total objects: 0
> Successful count: 0
> Failure count: 0
>
Hi Sandeep,

First you need to copy ojdbc7.jar in proper location, then *edit* the
*toolkit.properties* file which is located in *etc* folder of installation
of MTK.

*Example:*

SRC_DB_URL=jdbc:oracle:thin:@localhost:1521:xe
SRC_DB_USER=hr
SRC_DB_PASSWORD=hr

TARGET_DB_URL=jdbc:postgresql://localhost:5432/postgres
TARGET_DB_USER=postgres
TARGET_DB_PASSWORD=postgres

After saving the *toolkit.properties *file run runMTK.bat from cmd as
follows:

runMTK.bat -sourcedbtype source_database_name -targetdbtype
target_database_name schema_name

*Example:*

runMTK.bat -sourcedbtype oracle -targetdbtype postgres public

I hope this will solve your problem.

Thanks & Regards,

Harshad Adalkonda
Database Administrator

http://www.shreeyansh.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sandeep Gondhalekar 2014-12-28 15:25:38 Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver
Previous Message Jackson Isaac 2014-12-27 18:04:02 Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver