Solved

Multiple Oracle Homes Problem

Posted on 2004-09-26
8
1,195 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 47

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
performance tunning sql insert - challenging one 2 42
Outer Query not returning data - SQL HELP 16 50
Oracle Subquery bad Join 11 59
Oracle Pivot Question 8 43
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now