List:General Discussion« Previous MessageNext Message »
From:Srikalyan Tangirala Date:March 12 2007 2:47pm
Subject:RE: tool to migrate data from oracle to mysql
View as plain text  
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:arunkumarpg@stripped] 
Sent: Monday, March 12, 2007 3:37 AM
To: Ananda Kumar
Cc: mysql@stripped
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 <anandkl@stripped> 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
>


Thread
tool to migrate data from oracle to mysqlAnanda Kumar12 Mar
  • Re: tool to migrate data from oracle to mysqlArun Kumar PG12 Mar
    • Re: tool to migrate data from oracle to mysqlDavid Griffiths12 Mar
  • RE: tool to migrate data from oracle to mysqlSrikalyan Tangirala12 Mar
  • Re: tool to migrate data from oracle to mysqlMartijn Tonies12 Mar
  • How can I increase the size of the tableSrikalyan Tangirala13 Mar
    • Re: How can I increase the size of the tableDan Nelson13 Mar
  • Help needed with setting size of the tableSrikalyan Tangirala13 Mar
  • RE: How can I increase the size of the tableSrikalyan Tangirala13 Mar