Thanks alot Norm,
… both clients will use the same sqlnet, tnsnames.ora etc
What do I need to do exactly?
Type regedit and click OK.
Navigate to HKEY_LOCAL_MACHINE/software/oracle
On the left tree, you will see HOMEn where n is a zero based counter for
all the Oracle Homes you have installed. I have 5 so I have HOME0
Click each HOMEn in turn (on the left) and look on the right at the
entry for ORACLE_HOME - if you don’t see one, don’t worry, just move on
to the next HOMEn. When you find the ORACLE_HOME for the non-11g entry,
On the right, look for TNS_ADMIN, if found double-click it and change
the value to be your full path to the 11g install and add \network\admin
on the end.
If it’s not there, then create it as follows:
Right click in the right side and select NEW from the context menu.
Select STRING VALUE form the next menu.
When you see NEW VALUE #1, type in TNS_ADMIN (letter case doesn’t
matter) and press ENTER.
Double click on the new entry named TNS_ADMIN. The edit string dialogue
will be displayed.
Type (or paste) in the ORACLE_HOME path for the 11g client and tag on
\network\admin and click ok.
Job done. Exit from regedit. From now, your non-11g client install will
use the sqlnet.ora and tnsnames.ora files (plus others as needed) from
the 11g install. You only have to change the files once (in the 11g
home) and both clients will see the changes.
…and what is the selecthome.bat file for, that
exists in the 11g bin directory?
I don’t have an 11g client on my windows box, but I assume it’s a
utility that allows you to set the PATH and ORACLE_HOME etc environment
variables to select and use a new client. Similar to “. oraenv” on Unix.
However, with Toad, you don’t need it. Simply install the new (say 10g)
client and then edit your system variables in Control
Panel->System->Advance->Environment Variables and remove the path to 10g
client from PATH - leave only the 11g client. Remove all entries that
relate to anywhere in the 10g client install tree.
This way, you won’t have a potential problem with DLLs being loaded from
different Oracle client versions - ask me how I know!
Hope you can clarify this for me. Many thanks!
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk