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

Thanks all for prompt replies.

I have copied ojdbc7.jar under "C:\Program Files (x86)\Java\jre7\lib" and

SET CLASSPATH="C:\Program Files (x86)\Java\jre7\lib"
still no luck.

On Sun, Dec 28, 2014 at 1:57 PM, Harshad Adalkonda <
adalkondaharshad(at)gmail(dot)com> wrote:

> 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
>