Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Multiple Oracle Homes Problem

Posted on 2004-09-26
8
1,198 Views
Last Modified: 2008-02-01
I have setup multiple oracle homes to install different oracle db versions & developer products. When developing applicatoins using vb - oledb, how could I point the connection to refer to the oracle home I want so that the required tns information would be available.
0
Comment
Question by:swtirs
8 Comments
 
LVL 7

Accepted Solution

by:
BobMc earned 60 total points
ID: 12158177
The home that is used will be the one that the tool is installed into.
What you can do is set an environment variable TNS_ADMIN that points to a directory contain a common set of tns files.
All you homes will then use this directory
0
 
LVL 6

Assisted Solution

by:Jankovsky
Jankovsky earned 60 total points
ID: 12158480
There ase two significant parameters in registry user by third part sw.

(HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES)

DEFAULT_HOME (name of the default home to be used - probably)
LAST_HOME (number of the home - sometimes)

0
 
LVL 8

Assisted Solution

by:annamalai77
annamalai77 earned 60 total points
ID: 12158904
hi there

u can use the above 2 methods mentioned or create a tnsnames.ora file which will contain all the entries of different databases running in the server. copy this file and put in all of the oracle_home/network/admin folder.

regards
annamalai
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 60 total points
ID: 12158999
part of the connection string is the machine name in the net and either:
1. instance SID and port the listener listens
2. alias in the tnsnames.ora the listener uses when listens.

So you have to investigate which method your fronend uses.
0
 
LVL 23

Assisted Solution

by:seazodiac
seazodiac earned 60 total points
ID: 12159029
well,

to find out the current ORACLE_HOME or to switch the default ORACLE_HOME to the one desired:

Go to -->START---->programs----->oracle installation products---->home selector------> Whatever ORACLE_HOME is displayed, it's the default current ORACLE_HOME.  you can  use the dropdown list to change ORACLE_HOME value.


Now you need to put all your existing Oracle database services (TNSNAMES entries ) into one TNSNAMES.ORA file , place this file in the

"%CURRENT_ORACLE_HOME%/network/admin "folder
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle sql query 7 74
Create file system directory from Oracle 10g 4 24
capture vmstat info and insert it into an oracle table 31 35
date show only hh:mm 2 25
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question