# How to connect oracle database from toad ?

**URL:** <https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 14, 2016, 9:03pm UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849 "2016-01-14T21:03:36Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 14, 2016, 9:03pm UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/1 "2016-01-14T21:03:36Z")

</div>

Hi  
I have installed OEL6.5 and oracle grid 11g installed inside VMWARE machine whereas I have installed **TOAD FOR ORACLE** freeware on windows 7. I need to know how do i connect to oracle database.

Please advise.

Thanks

Ujjwal

---

<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:** [January 15, 2016, 5:26am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/2 "2016-01-15T05:26:35Z")

</div>

same as always. Make sure the machine that Toad is on can see the database server on the network. Add it to tnsnames.ora, and you’re done.

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 15, 2016, 4:46pm UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/3 "2016-01-15T16:46:02Z")

</div>

I am getting following error message and could not get connected. By the way how do i Enter the TNSNames.ora file location . Since oracle is installed inside VMWARE test machine and TOAD is installed at windows 7 OS. Please recommend any url if you have for the configuration.

![6866.2.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/c2774c3d9688cb6eac15c241225f1248682309cb.jpeg)

Checking that error says about ORA FILE PATH.

 ![5327.3.jpeg](https://global.discourse-cdn.com/quest/original/2X/e/e2a732a987ccdd1e3b35b228184692d56ccd28a8.jpeg)

However connecting through PUTTY or SSH it works below is an output

![8032.1.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/760c395dcf91ad8543d2474e540e798057dcabc5.jpeg)

Please advise

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [January 16, 2016, 9:15am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/4 "2016-01-16T09:15:58Z")

</div>

Do you have an Oracle client installed (32 bit client for 32 bit Toad and 64 bit client for 64 bit Toad)? Can you connect via SQL\*Plus? You have to create the TNSNames entry yourself. Much of this information is covered in the getting started guide in the documentation folder. You may also want to review connecting to an Oracle Database in the Oracle documentation.

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 16, 2016, 9:05pm UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/5 "2016-01-16T21:05:51Z")

</div>

I have installed ORACLE ENTERPRISE LINUX 6.5 AND ORACLE 11G GRID one inside VMWARE machine which is of X86\_64bit. But I have install Toad for ORACLE 64 inside wondows 7. I haven’t installed sqldeveloper at windows 7. I am downloading it and will let you know the output from sqldeveloper but I wonder what is the reason that i am not been able to connect to ORACLE from Toad ? Isn’t there any online url like connecting ORACLE installed in VMWARE machine from Toad which is instaled at windows 7.

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 17, 2016, 1:05am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/6 "2016-01-17T01:05:25Z")

</div>

Hello Gregory.

I am now able to connect through SQLDEVELOPER, Please find the attached screenshot herewith. However I am not been able to connect through TOAD. Please find the error message that i received while connecting ORACLE from TOAD. Besides I checked the SUPPORTIVE PLATFORM from this [URL](http://www.toadsoft.com/Toad_Products_Platforms_Supported.htm) which has no any issue. its compatible. Please let know how this error can be solved **No valid Oracle clients found. You need at least one 64-bit client properly configured.**

SQL DEVELOPER CONNECTED SUCCESSFULLY

 ![orcl.jpeg](https://global.discourse-cdn.com/quest/original/2X/9/95d90ac5e4d6d3f050aeb5961f8214b237f2aa28.jpeg)

TOAD ERROR SCREENSHOT

![2210.toad.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/708fd3c8943faeddd297aa7d16a67fee79af12e9.jpeg)

---

<div class="post-metadata">

**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:** [January 17, 2016, 1:25am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/7 "2016-01-17T01:25:00Z")

</div>

I don't know about vmware but for virtual box you need to be able to access the guest os, Oracle linux in your case, from the host. To do this both need to have their network configured on the same net. In virtual box I use a bridged network for the guest and it then appears on the same net as my host.

Vmware might have a similar setting.

Good luck.

Cheers,

Norm [TeamT]

On 17 January 2016 08:32:23 GMT+00:00, Ujjwal Rana [bounce-Ujjwal\_Rana@toadworld.com](mailto:bounce-Ujjwal_Rana@toadworld.com) wrote:

> **[RE: How to connect oracle database from toad ?](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58272#58272)**

> Reply by Ujjwal Rana  
> I have installed ORACLE ENTERPRISE LINUX 6.5 AND ORACLE 11G GRID one inside VMWARE machine which is of X86\_64bit. But I have install Toad for ORACLE 64 inside wondows 7. I haven't installed sqldeveloper at windows 7. I am downloading it and will let you know the output from sqldeveloper but I wonder what is the reason that i am not been able to connect to ORACLE from Toad ? Isn't there any online url like connecting ORACLE installed in VMWARE machine from Toad which is instaled at windows 7.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27202?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58272?AbuseContentId=5e9bfb25-1e24-4958-930f-d914f08e5e0d&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

--

Sent from my Android device with K-9 Mail. Please excuse my brevity.

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 17, 2016, 1:33am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/8 "2016-01-17T01:33:42Z")

</div>

But If I am able to connect through SQL DEVELOPER which is installed in windows 7 then i should be able to get connected from TOAD as well. Getting connected from SQL DEVELOPER means there is no issue of getting connecting from windows sql developer to oracle installed inside vmware. I have configured NAT for this and its perfectly getting connected from SQL DEVELOPER but in case of TOAD i believe there has to be some other reasons for not getting connected.

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [January 17, 2016, 5:37am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/9 "2016-01-17T05:37:09Z")

</div>

SQL Developer uses JDBC to connect. Toad uses OCI and therefore requires an OCI client installed. Can you connect via SQL\*Plus?

On Jan 17, 2016, at 8:34 AM, Ujjwal Rana [bounce-Ujjwal\_Rana@toadworld.com](mailto:bounce-Ujjwal_Rana@toadworld.com) wrote:

> **[RE: How to connect oracle database from toad ?](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58275#58275)**

> Reply by Ujjwal Rana  
> But If I am able to connect through SQL DEVELOPER which is installed in windows 7 then i should be able to get connected from TOAD as well. Getting connected from SQL DEVELOPER means there is no issue of getting connecting from windows sql developer to oracle installed inside vmware. I have configured NAT for this and its perfectly getting connected from SQL DEVELOPER but in case of TOAD i believe there has to be some other reasons for not getting connected.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27202?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58275?AbuseContentId=213dadf0-3f8f-4e72-8d77-858de25db501&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 17, 2016, 7:02am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/10 "2016-01-17T07:02:19Z")

</div>

Yes I am able to connect from SQL PLUS. So what i need to do for OCI client installed. Do i have to installed it under windows 7 or inside OEL6.5 ? Is there any online installation guide url for OCI. Please advise.

[http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [January 17, 2016, 7:06am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/11 "2016-01-17T07:06:31Z")

</div>

It needs to be installed on the same machine that Toad is installed on. Please read the installation guide and the getting started guide that come with Toad.

On Jan 17, 2016, at 10:04 AM, Ujjwal Rana [bounce-Ujjwal\_Rana@toadworld.com](mailto:bounce-Ujjwal_Rana@toadworld.com) wrote:

> **[RE: How to connect oracle database from toad ?](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58277#58277)**

> Reply by Ujjwal Rana  
> Yes I am able to connect from SQL PLUS. So what i need to do for OCI client installed. Do i have to installed it under windows 7 or inside OEL6.5 ? Please advise.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27202?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58277?AbuseContentId=40470248-cc35-4774-9590-4269741d9278&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

---

<div class="post-metadata">

**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:** [January 17, 2016, 7:36am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/12 "2016-01-17T07:36:48Z")

</div>

On 17/01/16 15:04, Ujjwal Rana wrote:

> \*RE: How to connect oracle database from toad ?

> -

> 

> Reply by Ujjwal Rana

> 

> Yes I am able to connect from SQL PLUS. So what i need to do for OCI

> client installed. Do i have to installed it under windows 7 or inside

> OEL6.5 ? Please advise.

> 

If you are able to connect to the database (on your VMWARE OEL 6.5

system) from your Windows 7 system, then you already have an OCI client

installed and, more importantly, working. All you need now is for Toad

to be able to find it.

You can, on the session -\> New Session dialogue, click on the drop down

list named "Connect Using" to see the list of Oracle Homes that Toad has

found.

If there are none, then ask yourself the following question, did you

install Toad 32 or 64 bit? And did the Oracle install have the same

number of bits?

Toad requires to connect to the OCI supplied in the Oracle client that

has the same number of bits. So 64 bit Toad cannot see or connect to a

32 bit OCI, and nor can a 32 bit Toad connect to a 64 bit client.

Assuming both "bits" are the same, is you Oracle client's "bin" folder

on %PATH%? Start a CMD session and check it by typing echo %PATH% into

it. Look for the Oracle installed client's "bin" folder on the output.

If it's not there, Control Panel -\> System -\>Advanced Tab and add the

path to your own environment variables for PATH.

Stop and restart Toad to see if it gets picked up - check the drop down

again. If so, you should now be able to connect, if not, something is

horribly wrong! ☹

I suspect your problem is because you don't have the same number of bits

in Toad as you do in your Oracle client install on Windows 7.

HTH

--

Cheers,

Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [January 17, 2016, 7:38am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/13 "2016-01-17T07:38:06Z")

</div>

Your Windows 7 machine where Toad resides must have an Oracle client 64-bit installed and configured properly. Look at the documentation Greg mentioned and Google installing and configuring an Oracle client.

On Jan 17, 2016, at 12:08 AM, Ujjwal Rana [bounce-Ujjwal\_Rana@toadworld.com](mailto:bounce-Ujjwal_Rana@toadworld.com) wrote:

> **[RE: How to connect oracle database from toad ?](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58272#58272)**

> Reply by Ujjwal Rana  
> I have installed ORACLE ENTERPRISE LINUX 6.5 AND ORACLE 11G GRID one inside VMWARE machine which is of X86\_64bit. But I have install Toad for ORACLE 64 inside wondows 7. I haven't installed sqldeveloper at windows 7. I am downloading it and will let you know the output from sqldeveloper but I wonder what is the reason that i am not been able to connect to ORACLE from Toad ? Isn't there any online url like connecting ORACLE installed in VMWARE machine from Toad which is instaled at windows 7.

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/27202?subscribe=false) on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/27202/58272?AbuseContentId=5e9bfb25-1e24-4958-930f-d914f08e5e0d&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

---

<div class="post-metadata">

**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:** [January 17, 2016, 7:48am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/14 "2016-01-17T07:48:04Z")

</div>

It seems my reply above didn’t come through via email correctly. Sigh! Try again …

If you are able to connect to the database (on your VMWARE OEL 6.5 system) from your Windows 7 system, then you already have an OCI client installed and, more importantly, working. All you need now is for Toad to be able to find it.

You can, on the session -\> New Session dialogue, click on the drop down list named “Connect Using” to see the list of Oracle Homes that Toad has found.

If there are none, then ask yourself the following question, did you install Toad 32 or 64 bit? And did the Oracle install have the same number of bits?

Toad requires to connect to the OCI supplied in the Oracle client that has the same number of bits. So 64 bit Toad cannot see or connect to a 32 bit OCI, and nor can a 32 bit Toad connect to a 64 bit client.

Assuming both “bits” are the same, is you Oracle client’s “bin” folder on %PATH%? Start a CMD session and check it by typing echo %PATH% into it. Look for the Oracle installed client’s “bin” folder on the output. If it’s not there, Control Panel -\> System -\>Advanced Tab and add the path to your own environment variables for PATH.

Stop and restart Toad to see if it gets picked up - check the drop down again. If so, you should now be able to connect, if not, something is horribly wrong!

I suspect your problem is because you don’t have the same number of bits in Toad as you do in your Oracle client install on Windows 7.

HTH

Cheers,

Norm. [TeamT]

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 17, 2016, 7:59am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/15 "2016-01-17T07:59:42Z")

</div>

Thanks Gregory Issue has been solved now. Thank You for the Guidance. This is how i solved:-

1. Dowloaded OCI from this url : [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html](http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

2. Installation and Configuration for OCI followed through this url : [https://www.youtube.com/watch?v=W2OF7\_9D9cY&list=PL84eGeGIy8oyu-3OyvHj7-XwK7VsJdhTf](https://www.youtube.com/watch?v=W2OF7_9D9cY&list=PL84eGeGIy8oyu-3OyvHj7-XwK7VsJdhTf)

3. Once you Download ZIP file (For Example I downloaded 64 Bit), Extract/UNZIP the ZIP File, Type the location of UNZIP FOLDER inside **VARIABLE VALUE  
C:\Users\Administrator\Downloads\Compressed\instantclient-basic-win-x86-64-11.2.0.1.0\instantclient\_11\_2**

![path.jpeg](https://global.discourse-cdn.com/quest/original/2X/6/624bd1c3ac0a4b6fe9b56b2bcd2e2e0b862b7846.jpeg)

1. From Sql Developer or Sqlplus I checked the following statement output : **SELECT \* FROM V$NLS\_PARAMETERS;**

![5483.toad2.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/305d3e46f47c2db4fb2ee6dd4b628ce6214bc9bd.jpeg)

1. Right Click My Computer, Click Advanced Setting, Click on ADVANCE Tab, Under START & RECOVERY…Click on ENVIROMENTAL TAB, Click on NEW and Type as following :-

![8206.toad1.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/3238e7afd22c4e897e8f3a776aa3153c72a980a3.jpeg)

**5. And Finally start TOAD**

---

<div class="post-metadata">

**Author:** ![Ujjwal\_Rana](https://avatars.discourse-cdn.com/v4/letter/u/ecae2f/32.png) [@Ujjwal\_Rana](https://forums.toadworld.com/u/Ujjwal_Rana)\
**Post date:** [January 17, 2016, 8:18am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/16 "2016-01-17T08:18:05Z")

</div>

I installed TOAD for 64 bit. Its because I have x86\_64 bit.

Even oracle is also x86 64 bit. I have already mentioned about it above.

No its not about BIT issue. Its about OCI not been installed like Gregory has mentioned above SQL Developer uses JDBC to connect and Toad uses OCI and therefore requires an OCI client installed. This is the main reason for not getting connected otherwise I would have faced other more issue related to BIT. 🙂

---

<div class="post-metadata">

**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:** [January 17, 2016, 11:48am UTC](https://forums.toadworld.com/t/how-to-connect-oracle-database-from-toad/34849/17 "2016-01-17T11:48:11Z")

</div>

Evening.

Sorry, I missed the bit where you said you had installed 64 bit versions of Toad and Oracle.

However, you did say that you were able to connect using SQL\*Plus which uses OCI to connect. Therefore you must have had a viable OCI installed already that Toad could gave used.

However, it’s good to hear that you can now connect to your database. Have fun.

Cheers,

Norm [TeamT]
