Migration from oracle to mysql on linux system
Posted by:
Jennifer Lu
Date: September 24, 2008 02:51PM
Hi,
I need to migrate oracle data to mysql.
I downloaded migration tool kits on my linux machine (reh4.6), then, I
ran run_migration_simple to connect to my oracle server, I got the
following errors:
# ./run_migration_simple
Exception in thread "main" java.lang.UnsatisfiedLinkError:
/var/tmp/mysql/usr/lib/mysql-gui/migration-toolkit-script/java/libmyx_grt_java.so:
libmysqlclient_r.so.15: cannot open shared object file: No such file or
directory at java.lang.ClassLoader$NativeLibrary.load(Native
Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1751)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1676)
at java.lang.Runtime.loadLibrary0(Runtime.java:823)
at java.lang.System.loadLibrary(System.java:1030)
at com.mysql.grt.GrtCallbackNative.setApplicationPath(Unknown
Source)
at com.mysql.grt.Grt.setCallback(Unknown Source)
ERROR: An exception occurred while setting up a native callback.
Please check if all required libraries are present.
** (grtsh:4008): WARNING **: Error initializing Java module loader
(10009).
MySQL Migration Toolkit - Script Version 1.1.9exp
-------------------------------------------------
Initializing migration environment...
Initialisation complete.
Please choose a database system:
--------------------------------
1. MaxDB Database Server
2. Oracle Database Server
3. Sybase Server
4. Generic Jdbc
5. MySQL Server
6. MS Access
7. MS SQL Server
0. Abort
Source Database System: 2
Please choose a connection:
---------------------------
1. Create new connection
0. Abort
-1.Delete a connection
Connection: 1
Creating new connection to Oracle Database Server ...
-----------------------------------------------------
Please enter the connection parameters.
Please choose a driver:
1. Oracle Thin JDBC Driver using SID
2. Oracle Thin JDBC Driver using Service
0. Abort
Driver: 1
SID: 920TEST
Hostname: moss
Port: [1521]
Username: jenn
Password: jenn
Connection String: jdbc:oracle:thin:@moss:1521:920TEST
Connection name (leave blank not to store):
Testing connection to Oracle Database Server ...
------------------------------------------------
error executing script: scripts/MigrationScript.lua:470: the GRT
function ReverseEngineeringOracle.getVersion doesnot exist
Do I miss any file? Appreciate the help.
Subject
Views
Written By
Posted
4008
September 05, 2008 03:40AM
Migration from oracle to mysql on linux system
4821
September 24, 2008 02:51PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.