In PL/SQL developer, you can change your default oracle home when connecting to a database. Query reporter don't have this option so you can flip flop between oracle homes. Is there a solution to this? Thanks!

The Query Reporter use the Primary Oracle Home by default. This is the home that is listed first in the PATH environment variable.

To use a different home, you can change the PATH, or use the OracleHome command-line parameter. For example:
Note that this is the logical name of the home, and not a registry key name or directory name.

Marco,

Where should I put the command line parameter? I tried putting it on the properties screen but
I noticed that in your example, the command line didn't include ".exe" as in "QueryReporter.exe". I'm a bit confused.

Sonny

You should indeed use the shortcut properties. If forgot to include the extension, which is indeed also present:

Marco,

Here's the command line I put in there - "C:\Program Files\Query Reporter\QueryReporter.exe" OracleHome=OraHome81

It didn't work for me. I got an error message saying "Unknown Parameter ORACLEHOME=". Note that there's no spaces before and after the equal sign on the command line. But when I put the spaces, I don't get the error message anymore but it don't list the 8.1 databases. It still lists the 10g databases.

Hmm, can you modify your PATH environment variable and change it so that the BIN subdirectory of your primary oracle home is listed first?

It works when I put the 8.1 path first before the 10g path. But I don't want to go with this solution since I will always have to change the PATH everytime I want to access the other database list.

Note that you can configure each database list by using the Oracle Net Configuration Assistant. You can also create a single tnsnames.ora file for both homes, and use the TNS_ADMIN variable to point to this file.

Try creating a .cmd file which changes your path to see the 8i bin directory before the 10g and then invokes the queryreporter as above.

Create a shortcut to run the .cmd file and point the icon to the queryreporter.exe.

this should allow you access to a secondary oracle home for the program.

use the regular shortcut to get to the 10g stuff.