Home > Documentation > Oracle to MySQL > FAQ

I have multiple Oracle homes installed on my system. Can this cause a problem while using Oracle-to-MySQL?

Yes, it will be a problem, since the program doesn't know to which Oracle home it should connect. Use TNS_ADMIN environmental variable to point to the directory where you wish to take tnsnames.ora from.

Another option to specify "active" Oracle home is to set TNS_ADMIN parameter in the Windows registry as follows:

  1. open regedit
  2. go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
  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

Have more questions? Contact us