Project Description

Oracle Home Selector Allows to switch between different oracle homes - therefore helps using multiple oracle homes on one machine. Exists in two versions - GUI (WPF) application and console application.

Download latest version: Oracle Home Selector - v1.8

GUI application - main window:

ohs18a.png

Console application - help message:
> orahome.exe -h
Oracle Home Selector (Console) - v1.8.0.0

Usage:
orahome [-c|-l|-h|-i:<HomeNumber|HomeName>|-s:<HomeNumber|HomeName>]

Parameters:
-current [-c] - Shows current home's information.
-help [-h] - Shows this help message.
-list [-l] - Shows list of installed oracle homes.
-details [-d] - Returned detailed information. Works with parameters -current, -list and -set.
-info [-i] - Shows information for the specified oracle home
-set [-s] - Changes the current oracle home to the specified one. Home's name or number can be specified.

Functionality

  • Shows list of installed oracle homes and detailed information for them.
  • Shows current oracle home.
  • Allows to change current oracle home.
  • Allows to synchronize easily files tnsnames.ora and sqlnet.ora
  • Supports Oracle 8i, 9i, 10g, 11g (32bit and 64bit)

How it works

In order to change current oracle home, it's required to make the following actions:
  • Registry - changes values in SOFTWARE\ORACLE
  • Register a number of libraries
  • Environment Variables - set paths to oracle home

System Requirements

  • Windows XP/Vista/7 (both x86 and x86_64 are supported). Other versions were not tested.
  • .NET 4.0
  • Oracle Client

More Screenshots

Home information:
tool01.jpg

File synchronize utility:
tool02.jpg

tags: oracle home selector, oracle home locator, managing oracle homes

Last edited Jan 22, 2013 at 10:31 AM by alekseiv, version 17

Comments

alekseiv Feb 26, 2014 at 12:10 PM 
oraOLEDBpus11.dll is for Oracle Provider for OLE DB.
As I understand, Oracle Provider for OLE DB is not installed in your second oracle home.

pappaduna Feb 7, 2013 at 1:21 PM 
Nice tool.
I got a problem when switching oracle homes from 10g tot 11.
The following error on screen:
oraOLEDBpus11.dll: can't find object
Is there a workaround?

thx for the reply