Converters for Microsoft SQL Converters for MySQL Converters for IBM DB2 Converters for MS Access Converters for Adobe PDF Converters for DBase/FoxPro Converters for Microsoft Excel Converters for Oracle Converters for Postgres MSSQL-to-Excel Converter MSSQL-to-MySQL Converter Intelligent Converters Software Access-to-MySQL Converter
migrate oracle to mysql, oracle to mysql converter, oracle2mysql, free download, shareware
FAQ  |  Site map  |  Contact Us
About Us How to Buy All Products Discounts Migration Service Support Become a Partner Articles

Oracle to MySQL FAQ

[Oracle-to-MySQL homepage]  [Download Oracle-to-MySQL]  [Buy Oracle-to-MySQL]

On this page you can find the most frequently asked questions regarding Oracle-to-MySQL converter. If your question is not answered here, please contact us at

What doesn this error means: "The application has failed to start because OCI.dll was not found"?
OCI.DLL is supplied by the Oracle Corporation and is a part of the Oracle version 7.3.4 (or later) client software installation. You need to install Oracle client and networking components on your system to use Oracle-to-MySQL. Also, please make sure that the path to Oracle components folder is in $PATH system variable.
Go to Top

I have multiple Oracle homes installed on my system. Can this cause a problem while using Oracle-to-MySQL converter?
Yes, it will be a problem, since the program doesn't know to which Oracle home it should connect. You can resolve this using TNS_ADMIN environmental variable to point to the directory where you wish to take tnsnames.ora from. Or you can set TNS_ADMIN parameter in the Windows registry as follows:
1) open regedit
3) you will find subkeys named HOME0, HOME1, etc. Select the one you wish to use with Oracle-to-MySQL converter.
4) add TNS_ADMIN variable for this home and enter the path to tnsnames.ora file in this variable
Go to Top

What are the system prerequisites for Oracle-to-MySQL?
At least 32 MB RAM, Oracle client and networking components must be installed.
Go to Top

What if I don't have direct connection to Oracle server?
You need to export Oracle database into dump file using Oracle EXP tool (see manual on this tool). Then you can migrate that dump file to MySQL server using our OraDump-to-MySQL converter.
Go to Top

Does Oracle-to-MySQL converter support automation?
Oracle-to-MySQL converter does not support automation directly. However, there is console version of the program o2sagent.exe in the installation directory. It supports command line arguments and can be called from any script. So, it is possible to write a simple batch script and execute it recurrently using any Windows scheduler. Please refer to 'Command line' article of the product documentation for the further information.
Go to Top