# Re: Trouble configuring Toad for oracle 9.7.2 commercial with instant client

**URL:** <https://forums.toadworld.com/t/re-trouble-configuring-toad-for-oracle-9-7-2-commercial-with-instant-client/25856>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 18, 2013, 7:29am UTC](https://forums.toadworld.com/t/re-trouble-configuring-toad-for-oracle-9-7-2-commercial-with-instant-client/25856 "2013-07-18T07:29:36Z")\
**Posts on this page:** 1\
**Page:** 1

<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:** [July 18, 2013, 7:29am UTC](https://forums.toadworld.com/t/re-trouble-configuring-toad-for-oracle-9-7-2-commercial-with-instant-client/25856/1 "2013-07-18T07:29:36Z")

</div>

You might have success searching Google for these errors. A quick search of net8 admin yields many hits.

The only things I can think of off hand are to first verify that your listener is running and that the db is started and registered with it. At the shell prompt execute...

lsnrctl status

Is it running? Do you you see your DB listed there as a service?

If not running, execute lsnrctl start. Run lsnrctl status again. Is the db showing?

If db not showing execute sqlplus / as sysdba. When you get to the SQL\> prompt execute alter system register; and then get out of SQL\*Plus. Execute lsnrctl status again. Do you see your db? If so, try Toad again. If your db is installed locally on your machine  
I'd change the host in the tnsnames.ora file to be either localhost or 127.0.0.1 if it's currently using your network machine name.

Michael

On 07/18/2013 01:31 AM, kushal.mahajan wrote:

> Yes, i did that with cmd . Pinged and saw two service names which were listed by listener . These are CLRExecProc and PLSExecProc if i am remembering it corrrectly .AFter editing my tnsnames.ora file with service name listed by listener and  
> On hitting connect button i got a **net8 admin** error this time . Tried logon option of oracleservicesXE under services.msc . AFter restarting too , not able to see the results .
> 
> Regards,  
> Kushal Vedant Mahajan

> * * *
> 
> From:  
> [bounce-mstaszew@toadworld.com](mailto:bounce-mstaszew@toadworld.com)
> 
> To: [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)
> 
> Subject: Re: [Toad for Oracle - Discussion Forum] Trouble configuring Toad for oracle 9.7.2 commercial with instant client
> 
> Date: Wed, 17 Jul 2013 19:11:35 +0000
> 
> **[ Re:  
> Trouble configuring Toad for oracle 9.7.2 commercial with instant client](http://gyk.r.mailjet.com/redirect/qjqwtxtj8c6ngtm6tw041j/gyk.r.mailjet.com/redirect/zy9mt2v1ffo9z6tgkdxwbh/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40005.aspx#40005)**

> Reply by Michael Staszewski  
> You have a configuration issue. We have work in this area scheduled for Toad 12.1 to assist in resolving these issues.
> 
> On Login window, click the TNSNames Editor button. Verify that the host for the TNS names entry you're using is correct. Can you ping that host? In the TNSNames Editor you should also try to tnsping the database. See the lightning bolt icon on the toolbar.  
> Also, can you connect with SQL\*Plus using that same client?
> 
> On 07/17/2013 02:52 PM, kushal.mahajan wrote:

> > **[ RE:  
> > Trouble configuring Toad for oracle 9.7.2 commercial with instant client](http://gyk.r.mailjet.com/redirect/c89stb2kyz0o5qyv8lhb7s/gyk.r.mailjet.com/redirect/jfj3hhwf894ltw8otcn45z/gyk.r.mailjet.com/redirect/8zj5hjdtqg9xwv627ny108/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40004.aspx#40004)**

> > Reply by kushal.mahajan  
> > well i installed a 10.1 instant client and it does resolved the problem .
> > 
> > But on connecting i got a ORA 12514 error now.

> > To reply, please reply-all to this email.
> > 
> > [ Stop  
> > receiving emails](http://gyk.r.mailjet.com/redirect/ch3dttsyqx0olccbfjzlfw/gyk.r.mailjet.com/redirect/k97zh0278vdzrg7n20783w/gyk.r.mailjet.com/redirect/qhlxhlz21s14lvo25k1nrc/www.toadworld.com/products/toad-for-oracle/f/10/t/19855.aspx?subscribe=false) on this subject.
> > 
> > Or [  
> > Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/nd7ztrdh1jxmjyl3kogxo3/gyk.r.mailjet.com/redirect/g8sjtl6cwg0ng6ol7b4clo/gyk.r.mailjet.com/redirect/l54ptc9vcynbdqc7hq2zzj/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> > 
> > Toad for Oracle - Discussion Forum

> > [Flag](http://gyk.r.mailjet.com/redirect/gr71t688ls0x71nqyn5lb1/gyk.r.mailjet.com/redirect/drb6hqc2yn1oswwgf3w9v3/gyk.r.mailjet.com/redirect/sfrztgmn4ryylyp77ypytr/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40004.aspx?AbuseContentId=dc86b4fb-a754-4656-99c0-fc8c74477641&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> > this post as spam/abuse.

> > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

> To reply, please reply-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/3hf7txjhnmr32sd93scmhm/gyk.r.mailjet.com/redirect/4mpstrgsn7c3w23lkp54hj/www.toadworld.com/products/toad-for-oracle/f/10/t/19855.aspx?subscribe=false)  
> on this subject.
> 
> Or [  
> Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/yj4dtk062w74oof9tyd9hz/gyk.r.mailjet.com/redirect/m8qctdyxtcv58lbqowcpwk/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/y0mttwbho807olrcpd2pgz/gyk.r.mailjet.com/redirect/xzkrh5hj87q0z7kmpnpp5h/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40005.aspx?AbuseContentId=7ed2469b-4673-4b37-b011-11fab96b59ce&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

> * * *

> [View and reply online](http://gyk.r.mailjet.com/redirect/z1w8tc6vld0yh9o4k0zrsr/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40012.aspx#40012) or  
> reply-to-all to this email.
> 
> [Stop receiving emails](http://gyk.r.mailjet.com/redirect/jhhmtfn2yg7qk7xt7xxwco/www.toadworld.com/products/toad-for-oracle/f/10/t/19855/mute.aspx) on this subject.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://gyk.r.mailjet.com/redirect/2olyhpo4swwxgcf128b5bo/www.toadworld.com/products/toad-for-oracle/f/10/p/19855/40012.aspx?AbuseContentId=f2d55494-0ec2-4806-b0b3-65315485383b&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
> this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)
