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 converter?

Yes, it might 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