Running version 8.6 along side with 10.5.1

I have a user that wants to run two versions of toad for oracle on his computer for testing purposes. He has installed toad 8.6 and 10.5.1.

He has Oracle client 11.2.0 installed and gets the error OCI 11.1.0.1.0 is not supported. This is of cause because toad 8.6 does not support 11g.

The question is now - can i install 10g on this computer and run toad 8.6 successfully as well as toad 10.5.1?

How should the installation be done correctly to get this working eg:
toad 8.6 and oracle client 10g
toad 10.5.1 and oracle client 11g

I hope someone can help me out here…

Thanks in advance.

Morning Lars,

...
He has Oracle client 11.2.0 installed and gets the error OCI
11.1.0.1.0 is not supported. This is of cause because toad
8.6 does not support 11g.

The question is now - can I install 10g on this computer and
run toad 8.6 successfully as well as toad 10.5.1?
I suspect that you need to install an older version of Oracle client as
well as the 11g client. Once this has been done, when you open the New
Session dialogue in Toad 8.6, you will be able to select the non-11g
client to be used as Toad's default Oracle client.

Good luck.

And then, when you have done this, go into your registry and set up an
entry for TNS_ADMIN in the non-11g client that points to the
network/admin location for the 11g client - that way, both clients will
use the same sqlnet, tnsnames.ora etc files.

I would probably go for a 8i or 9i client. 9i if you have no 7.x
databases to connect to!

Cheers,
Norm. [TeamT]

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

Another option is to use a virtual machine to run the other Toad / Oracle client
combination? Depending off course on a lot of circumstances, like hardware, OS,
etc.

Groetjes,
Wim

On Thu, Oct 21, 2010 at 11:32, Dunbar, Norman (Capgemini)

wrote:

Morning Lars,

>> ...

He has Oracle client 11.2.0 installed and gets the error OCI
11.1.0.1.0 is not supported. This is of cause because toad
8.6 does not support 11g.

The question is now - can I install 10g on this computer and
run toad 8.6 successfully as well as toad 10.5.1?

I suspect that you need to install an older version of Oracle client as
well as the 11g client. Once this has been done, when you open the New
Session dialogue in Toad 8.6, you will be able to select the non-11g
client to be used as Toad's default Oracle client.

Good luck.

And then, when you have done this, go into your registry and set up an
entry for TNS_ADMIN in the non-11g client that points to the
network/admin location for the 11g client - that way, both clients will
use the same sqlnet, tnsnames.ora etc files.

I would probably go for a 8i or 9i client. 9i if you have no 7.x
databases to connect to!

Cheers,
Norm. [TeamT]

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

Thanks alot Norm,

This makes it a bit more clear, although i still need some more in-depth information about the the last part of your reply:

“And then, when you have done this, go into your registry and set up an
entry for TNS_ADMIN in the non-11g client that points to the
network/admin location for the 11g client - that way, both clients will
use the same sqlnet, tnsnames.ora etc files.”

What do i need to do exactly? Where is this entry - could you write how to do this in the case that i install 10g and 11g fx…and what is the selecthome.bat file for, that exists in the 11g bin directory?

Hope you can clarify this for me. Many thanks!

Morning Lars,

Thanks alot Norm,
Welcome.

... both clients will use the same sqlnet, tnsnames.ora etc
files."
What do I need to do exactly?
Ok, start->run.
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
through HOME4.

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,
stop clicking!

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!
See above! :wink:

Cheers,
Norm. [TeamT]

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

Great Norman - really appreciate all of your time spend answering.

Now actually i solved the problem with the OCI error otherwise.

I found out that i could just make a new connection, choose the entry “default_home” (being 8i) and tick the box “make this default home for toad”.
This worked beautifully.

I suppose this is because all the things you have explained already were done somehow?

Thanks alot.

Hi Lars,

Great Norman - really appreciate all of your time spend answering.
Welcome.

Now actually i solved the problem with the OCI error otherwise.

I found out that i could just make a new connection, choose
the entry "default_home" (being 8i) and tick the box "make
this default home for toad". This worked beautifully.
That works, but without the TNS_ADMIN setting, you need to update the
tnsnames.ora file in both homes, if you wish to use Toad 8 and Toad 10
(or 11) to connect to the same database.

Cheers,
Norm. [TeamT]

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

Actually looking at the Toad versus Oracle history diagram (link below) we find
that 8.6 came out after 10g – so it should work with 10g client. But note
that some features of the database such as client side caching and others then
will not work.

This diagram is quite useful and I would save a bookmark to it. Because anytime
oracle version versus toad version questions come up – even questions like
can toad x support oracle y feature z – the answer is here in one simple
picture J

http://www.toadworld.com/Portals/0/ToadOracle/Toad%20Roadmap%202010.pdf

That’s especially easy to do if you’re on Windows 7 – which
includes a VM engine and a built-in license to run a copy of XP J

Hi Bert,

This diagram is quite useful and I would save a bookmark to
it. Because anytime oracle version versus toad version
questions come up - even questions like can toad x support
oracle y feature z - the answer is here in one simple picture J

http://www.toadworld.com/Portals/0/ToadOracle/Toad%20Roadmap%
202010.pdf

Thanks. I've updated the FAQ on AskToad.com :

http://asktoad.com/DWiki/doku.php/faq/answers/getting_started#toad_versi
on_history_-_which_one_should_i_use

and removed the (out of date) jpeg ropadmap and instered a link to the
pdf that you gave. This implies that the link you gave will remain in
force and be updated as and when required?

The old jpeg on Ask Toad was slightly out of date.

Cheers,
Norm. [TeamT]

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

That's especially easy to do if you're on Windows 7 - which
includes a VM engine and a built-in license to run a copy of XP J

Fires up copy of Windows 7 Professional on laptop.
Has a quick look around.
Nope, I can't see it!
Shuts down.

Boots into Linux.
Ah, look, Oracle's VirtualBox. Nice!

I prefer to use VirtualBox and at the moment, I've got Toad 10.6 running
in an XP VM plus, Oracle Enterprise Linux 64 bit running in another VM
with 11.2.0.2 working, and, a third VM with Linux Mint 9 64 bit running!

Now, if only I could ping the "servers" from the host, life could get
pretty interesting! RAC on a laptop anyone?

Cheers,
Norm. [TeamT]

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

It too is now out of date- but less so – and I have asked our toad world
web guy to update and let me know – and then I’ll also have him
update the wiki

You have to download and install a small extra but free package from MS web site
– I don’t have the link handy – but google search it

Then you simply install it and use just like other vm software such as virtual
box and vmware – plus the XP license is built in for free –
otherwise you pay MS

Plus the windows vm offers some nice little user features – such as place
win XP toad image on win 7 desktop and then anytime you double click win 7 will
auto run the vm in the background and display toad within your current desktop
– so it’s totally transparent that toad is in a vm J

btw, here is the permanent link to the Release History PDF:
http://toadfororacle.com/servlet/KbServlet/download/4266-102-12611/ReleaseHistory
_ToadForOracle

We’re consolidating content across ToadWorld so all Toad for Oracle
content will be available in our domain instead of scattered across TW. Please
be patient while we iron out the kinks :slight_smile:

While consolidating don’t forget to update it.

I suggest some color coding in the Toad features list below each release.

Anything that is not in standard Toad should be red .

Anything that used to be in extra charge options (such as Toad debugger) but
moved to standard Toad should be green .

Hi Melanie,

btw, here is the permanent link to the Release History PDF:
http://toadfororacle.com/servlet/KbServlet/download/4266-102-
12611/ReleaseHistory_ToadForOracle

Thanks. I'll fix the link in AskToad tonight or tomorrow.

Cheers,
Norm. [TeamT]

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

I already fixed it in AskToad, Norm :slight_smile:

Erwin, I have asked our PM for an update (he maintains the file). I’ve
also passed on your color-coding suggestions.

I already fixed it in AskToad, Norm :slight_smile:
Erwin, I have asked our PM for an update (he maintains the file). I've also
passed on your color-coding suggestions.

And I just superseded that version with an added link to get2know v10 page. :slight_smile:

Rich -- [TeamT]

Disclaimer: If I got a $75K fine, I'd quit too. I couldn't afford not to.