Oracle Home

[Roadkill]

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!

 

[Marco Kalter]

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:

"C:\Program Files\QueryReporter" OracleHome=OraDb11g_home1

Note that this is the logical name of the home, and not a registry key name or directory name.

 

[Roadkill]

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

 

[Marco Kalter]

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

"C:\Program Files\QueryReporter.exe" OracleHome=OraDb11g_home1

 

[Roadkill]

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.

 

[Marco Kalter]

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

 

[Roadkill]

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.

 

[Marco Kalter]

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.

 

[johnsod]

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.