# Invalid ORACLE\_HOME error in TOAD13.1.0.78

**URL:** <https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 8, 2021, 6:50pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344 "2021-03-08T18:50:25Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 6:50pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/1 "2021-03-08T18:50:25Z")

</div>

Team,

I am getting 'Invalid Oracle Home: C:\PRABU\Softwares\WINDOWS.X64\_193000\_client\_home\bin' error when I try to connect to my database using TOAD 13.1.0.78. However, the ORACLE\_HOME system variable is not set till bin directory, but it is set as 'C:\PRABU\Softwares\WINDOWS.X64\_193000\_client\_home'. The system variable screenshot is attached. Please help me to resolve this issue. Thank you!

![System Variable](https://global.discourse-cdn.com/quest/original/2X/6/6004d57efdff03849f48ff782103623617d71df1.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 6:54pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/2 "2021-03-08T18:54:47Z")

</div>

Don't add an ORACLE\_HOME environment variable.  
Add C:\PRABU\Sofwares\WINDOWS.X64\_193000\_client\_home to your system path instead.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:06pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/3 "2021-03-08T19:06:26Z")

</div>

Thank you! I have tried removing ORACLE\_HOME and also updated the PATH variable without the bin folder. But, my client itself is being shown up in Installed Clients-\> Connect Using drop down.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 7:10pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/4 "2021-03-08T19:10:20Z")

</div>

Ok, so is it working now? You may also need to add a TNS\_ADMIN environment variable to specify the folder where your tnsnames.ora file is.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:11pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/5 "2021-03-08T19:11:57Z")

</div>

I have TNS\_ADMIN added already 'C:\PRABU\Softwares\WINDOWS.X64\_193000\_client\_home\network\admin'

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 7:16pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/6 "2021-03-08T19:16:04Z")

</div>

Great, so is the problem solved?

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:17pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/7 "2021-03-08T19:17:45Z")

</div>

No, its still the same issue. I had it added even before posting this topic. But, facing the error.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 7:22pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/8 "2021-03-08T19:22:53Z")

</div>

Are you using 32 or 64 bit Toad?  
32 bit Toad requires a 32 bit Oracle client.  
64 bit Toad requires a 64 bit Oracle client.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:23pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/9 "2021-03-08T19:23:27Z")

</div>

Both my TOAD and Oracle client are 64-bit.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 7:27pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/10 "2021-03-08T19:27:15Z")

</div>

Try an older Oracle client then. Oracle 19.3 client is much newer than Toad 13.1 so they could not have been certified to work together. Remove the 19.3 client and try a 12.1 or 12.2 client instead.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:31pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/11 "2021-03-08T19:31:01Z")

</div>

I cannot use another Oracle client since my organization had upgraded it... Can I try to use TOAD 13.3, will that work?

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 7:45pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/12 "2021-03-08T19:45:23Z")

</div>

At the beginning of this thread, you said that the error message included "bin".

Is there a bin folder in your Oracle client? If so, move the files from the bin folder to the folder above, then delete the bin folder.

If that is not the problem, then try Toad 13.3.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 7:58pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/13 "2021-03-08T19:58:16Z")

</div>

I tried that option now and getting new error as 'Can't initialize OCI. Error -1'

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 8, 2021, 8:02pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/14 "2021-03-08T20:02:11Z")

</div>

zip up your instant client folder and email it to me. [john.dorlon@quest.com](mailto:john.dorlon@quest.com)

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 8, 2021, 8:12pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/15 "2021-03-08T20:12:24Z")

</div>

okay! I will. Before that, I will give a try for 13.3 installation and check once.

---

<div class="post-metadata">

**Author:** ![prabusuccess](https://avatars.discourse-cdn.com/v4/letter/p/fbc32d/32.png) [@prabusuccess](https://forums.toadworld.com/u/prabusuccess)\
**Post date:** [March 10, 2021, 4:59pm UTC](https://forums.toadworld.com/t/invalid-oracle-home-error-in-toad13-1-0-78/52344/16 "2021-03-10T16:59:56Z")

</div>

I have installed TOAD for Oracle 13.3 and the issue has been resolved in this version. Eventhough the ORACLE\_HOME in TOAD is pointing to bin folder [but the environment variable doesn't], the error is not being thrown and I am able to make the connection without any issues. Thank you @JohnDorlon for your time and assiatance!
