Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver - Mailing list pgsql-admin

From Harshad Adalkonda
Subject Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver
Date
Msg-id CANnQH_ggyoqhBxuqF5ZM9A7YvUXY4cnowwz8iuWejCeWZRKGXw@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver  (Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com>)
List pgsql-admin

On Sun, Dec 28, 2014 at 8:55 PM, Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.com> wrote:

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@gmail.com> wrote:

On Sat, Dec 27, 2014 at 9:59 PM, Sandeep Gondhalekar <sandeep.gondhalekar1@gmail.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



Hi Sandeep,

The driver copying location is wrong

Copy driver to C:\Program Files (x86)\Java\jre7\lib\ext\ location

copy both oracle & postgresql drivers under above location.

I hope now this time it will solve your porblem.

Thanks & Regards,

Harshad Adalkonda 

Database Administrator

http://www.shreeyansh.com

pgsql-admin by date:

Previous
From: Sandeep Gondhalekar
Date:
Subject: Re: [ADMIN] java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver
Next
From: girish R G peetle
Date:
Subject: PostgreSQL file system based restore from Linux to Windows