Multiple Oracle Homes Problem

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.
swtirsAsked:
Who is Participating?
 
BobMcCommented:
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
 
JankovskyCommented:
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
 
annamalai77Commented:
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
 
schwertnerCommented:
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
 
seazodiacCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.