Solved

Multiple Oracle Homes Problem

Posted on 2004-09-26
8
1,200 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
[X]
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
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

751 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