Hi All:
We are trying to migrate the oracle database to mysql using the
MySQL migration kit. During the process, when we have specified the source
and target information and tried to establish a connection, the error we have
got is the following:
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using Service
Opening connection ...
Connection jdbc:oracle:thin:oracle/1oracle@//172.31.22.65:5500/GOES
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringOracle.getSchemata :Io exception: Bad packet type
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:3
2)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEn
gineeringGeneric.java:101)
com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(ReverseEngineering
Oracle.java:43)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)
What could be the possibility of the error? Any Suggestions?
Best,
Sri
-----Original Message-----
From: Arun Kumar PG [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 3:37 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Subject: Re: tool to migrate data from oracle to mysql
http://www.mysql.com/products/tools/migration-toolkit/
There is a video presentation as well here for ORacle to MySQL migration.
Thanks,
- Arun
On 3/12/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi Friends,
> Does any body know of any tool available for migrating data from oracle to
> mysql. Can you please pass on the url.
>
> regards
> anandkl
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
