# Earliest Toad version to support Oracle 11g **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [February 15, 2012, 10:06am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034 "2012-02-15T10:06:09Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![1250patriiiiiiiiiick](https://avatars.discourse-cdn.com/v4/letter/1/49beb7/32.png) [@1250patriiiiiiiiiick](https://forums.toadworld.com/u/1250patriiiiiiiiiick)\ **Post date:** [February 15, 2012, 10:06am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/1 "2012-02-15T10:06:09Z")
Hi! We will be soon migrating databases from Oracle 10g to 11g. There are different versions of Toad being used in the team in function of the acquisitions we made. My question is therefore: What is the minimum version of Toad REQUIRED to connect to Oracle 11g and be able to do usual developers operations: select, … compile packages, …? In some places ([http://old.nabble.com/Oracle-11g-td14686864.html](http://old.nabble.com/Oracle-11g-td14686864.html)), I find that version 9.5 is the minimum and in the following, I understand that any version will do as far as your SQL\*net client is on par with the DB version: [http://asktoad.com/DWiki/doku.php/faq/answers/database\_versions#what\_version\_oracle\_database\_servers\_does\_toad\_support](http://asktoad.com/DWiki/doku.php/faq/answers/database_versions#what_version_oracle_database_servers_does_toad_support) Thank you in advance for clarifying this to me! Patrick ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [February 15, 2012, 10:17am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/2 "2012-02-15T10:17:51Z")
To me the main issue is passwords: Oracle 11g has default that passwords are now case sensitive. Older versions of Toad (pre-11) all basically raised all passwords before sending to database – so you will get error saying cannot connect. That to me is reason enough to require toad \>= 11 for oracle \>= 11g ---
**Author:** ![1250patriiiiiiiiiick](https://avatars.discourse-cdn.com/v4/letter/1/49beb7/32.png) [@1250patriiiiiiiiiick](https://forums.toadworld.com/u/1250patriiiiiiiiiick)\ **Post date:** [February 15, 2012, 10:56am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/3 "2012-02-15T10:56:16Z")
So, IIUC, we could just pay attention to capitalize all our passwords when migrating to Oracle 11g, communicate it through the team, and this should be a non issue. ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [February 15, 2012, 10:56am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/4 "2012-02-15T10:56:16Z")
On 15/02/12 16:56, Patrick wrote: > So, IIUC, we could just pay attention to capitalize all our passwords > when migrating to Oracle 11g, communicate it through the team, and this > should be a non issue. You could set the initialisation parameter SEC\_CASE\_SENSITIVE\_LOGON = false to get around the problem. However, that would reduce the security of the database a tad. Other things to watch for in a default 11g database are: - The default profile limits password life time to 180 days then you have to change it. - the initialisation parameter (in Enterprise Edition) CONTROL\_MANAGEMENT\_PACK\_ACCESS defaults to allowing use of the tuning and/or performance packs even if they are not licensed. Set this to NONE if you don't have those licenses. The first is a PITA the second could allow Oracle to sue you. Nice defaults! -- Cheers, Norm. [TeamT] ---
**Author:** ![1250patriiiiiiiiiick](https://avatars.discourse-cdn.com/v4/letter/1/49beb7/32.png) [@1250patriiiiiiiiiick](https://forums.toadworld.com/u/1250patriiiiiiiiiick)\ **Post date:** [March 1, 2012, 3:38am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/5 "2012-03-01T03:38:14Z")
Hi! Thank you for those useful tips! But… My original question remains. Can anybody confirm my assumptions? TIA! Patrick ---
**Author:** ![wimdelange\_062](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@wimdelange\_062](https://forums.toadworld.com/u/wimdelange_062)\ **Post date:** [March 1, 2012, 3:38am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/6 "2012-03-01T03:38:14Z")
I have reread the emails and the best answer was given by Bert Scalzo: Toad 11. If you are only interested in queries and compilations, I think a lot of toad versions qualify, but you can get into some problems as described. I would say, use at least version 9? But forget about the DBA options and other interesting stuff that Toad delivers. If you are only interested in querying and compilation, you could switch to the free product of Oracle itself. SQL Developer. There is a nice discussion going on just now on this forum about the differences betweed Toad and SQLdeveloper. Groetjes, Wim 2012/3/1 Patrick ``` Message from: patriiiiiiiiiick ``` Hi! ``` Thank you for those useful tips! But... My original question remains. Can anybody confirm my assumptions? TIA! Patrick ``` * * * ``` Historical Messages ``` Author: Patrick Date: Thu Mar 01 01:38:14 PST 2012 Hi! ``` Thank you for those useful tips! But... My original question remains. Can anybody confirm my assumptions? TIA! Patrick ``` \_\_ ``` Author: Norman Dunbar Date: Wed Feb 15 08:56:16 PST 2012 On 15/02/12 16:56, Patrick wrote: > So, IIUC, we could just pay attention to capitalize all our passwords > when migrating to Oracle 11g, communicate it through the team, and this > should be a non issue. You could set the initialisation parameter SEC_CASE_SENSITIVE_LOGON = false to get around the problem. However, that would reduce the security of the database a tad. Other things to watch for in a default 11g database are: * The default profile limits password life time to 180 days then you have to change it. * the initialisation parameter (in Enterprise Edition) CONTROL_MANAGEMENT_PACK_ACCESS defaults to allowing use of the tuning and/or performance packs even if they are not licensed. Set this to NONE if you don't have those licenses. The first is a PITA the second could allow Oracle to sue you. Nice defaults! -- Cheers, Norm. [TeamT] __ Author: Patrick Date: Wed Feb 15 08:56:16 PST 2012 So, IIUC, we could just pay attention to capitalize all our passwords when migrating to Oracle 11g, communicate it through the team, and this should be a non issue. __ Author: Bert Scalzo Date: Wed Feb 15 08:17:51 PST 2012 To me the main issue is passwords: Oracle 11g has default that passwords are now case sensitive. Older versions of Toad (pre-11) all basically raised all passwords before sending to database – so you will get error saying cannot connect. That to me is reason enough to require toad >= 11 for oracle >= 11g __ Author: Patrick Date: Wed Feb 15 08:06:09 PST 2012 Hi! We will be soon migrating databases from Oracle 10g to 11g. There are different versions of Toad being used in the team in function of the acquisitions we made. My question is therefore: What is the minimum version of Toad REQUIRED to connect to Oracle 11g and be able to do usual developers operations: select, ... compile packages, ...? In some places ( http://old.nabble.com/Oracle-11g-td14686864.html ), I find that version 9.5 is the minimum and in the following, I understand that any version will do as far as your SQL*net client is on par with the DB version: http://asktoad.com/DWiki/doku.php/faq/answers/database_versions#what_version_ oracle_database_servers_does_toad_support Thank you in advance for clarifying this to me! Patrick __ _______________________________________ ``` ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [March 1, 2012, 4:38am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/7 "2012-03-01T04:38:01Z")
Toad 10.1 (Q4-09) officially states support for Oracle 11g R2 (Q3-09). But there were changes in 11g R2 that evolved on the Oracle side after initial release so I would advise strongly Toad \>= 10.5. ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [March 1, 2012, 4:41am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/8 "2012-03-01T04:41:02Z")
Yes – I double checked and could see going one major release earlier (i.e. 10.5). But then you lose multi-byte/Unicode support – and since the default for databases is now Unicode, I still think 11.0 is the real and best answer. But this user seems far more interested in how far back can I go than issues like what’s recommended – just what can I get away with. So 10.5 in that case …… ---
**Author:** ![Stephen.Beausang\_734](https://avatars.discourse-cdn.com/v4/letter/s/bc8723/32.png) [@Stephen.Beausang\_734](https://forums.toadworld.com/u/Stephen.Beausang_734)\ **Post date:** [March 1, 2012, 9:18am UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/9 "2012-03-01T09:18:41Z")
Wim … the speed issue will probably not make today’s Beta, I will have it in for Monday ---
**Author:** ![duneria](https://avatars.discourse-cdn.com/v4/letter/d/df788c/32.png) [@duneria](https://forums.toadworld.com/u/duneria)\ **Post date:** [February 4, 2016, 11:29pm UTC](https://forums.toadworld.com/t/earliest-toad-version-to-support-oracle-11g/11034/10 "2016-02-04T23:29:07Z")
lle