Oracle 10G and Toad installation

SHARE this post!

My workplace seems to be big fans of Toad software. I have used Toad as just a support guy for three years or so and have barely scraped the functionality needed by the tool. During an app upgrade a few weeks ago there are a few business people that need to run queries and such against the database so we have created read-only accounts to Oracle to facilitate this…oh yes and the installation of Toad on the user machines was needed as well.

One of the things that I found this week after trying to do a minimal install needed of the Oracle client is that when users need to create an ODBC connection as well that they need to have the Administrator install of the Oracle client. When installing the Oracle client there is first and option to deinstall products (and here I was calling it uninstalling for all these years) which is a good thing to do to get rid of 9.2 or other releases of Oracle that you do not need.

Next you have choices between and instant client, runtime, administrator, and custom installs of the Oracle client. If you need ODBC then from trial and error I found that Administrator install is the minimum that you need to get your TNSNames.ora file to have a place to go.

Oh, and if you have no experience with Oracle clients before, remember to drop the known good copy of your tnsnames.ora file into the \network\admin folder so that Oracle and other interfaces to your application can see it.

17 thoughts on “Oracle 10G and Toad installation

  1. Your style is really unique compared to other folks I have read stuff from.
    Thank you for posting when you have the opportunity,
    Guess I will just bookmark this web site.

  2. You made some decent points there. I checked on the net to learn more
    about the issue and found most people will go
    along with your views on this web site.

  3. We are a gaggle of volunteers and starting a brand new scheme in our community.
    Your web site provided us with useful info to work on. You have done an impressive
    task and our entire group might be grateful to you.

  4. I am not sure where you are getting your information, but great
    topic. I needs to spend some time learning more or understanding
    more. Thanks for magnificent info I was looking for this info for my mission.

  5. DreamProxies – Lowest priced USA Private Proxies: Elite high quality, Indefinite data transfer, 1000 mb/s superspeed, 99,9 uptime, Low successive IP’s, Absolutely no usage limitations, Many subnets, USA or perhaps The european union proxies – Obtain Currently –

  6. Howdy would you mind letting me know which webhost you’re
    using? I’ve loaded your blog in 3 completely different browsers
    and I must say this blog loads a lot faster then most.
    Can you recommend a good hosting provider at a honest price?
    Thanks, I appreciate it!

  7. I was curious if you ever considered changing the page layout of
    your site? Its very well written; I love what youve got to say.
    But maybe you could a little more in the way of content so
    people could connect with it better. Youve got an awful lot of text for only having 1 or two images.
    Maybe you could space it out better?

  8. Hello my friend! I want to say that this post is awesome, nice written and include
    approximately all vital infos. I would like to peer more posts like this .

  9. Greetings, I do believe your website could possibly be having internet browser
    compatibility issues. Whenever I take a look at your blog in Safari, it looks fine however when opening
    in I.E., it has some overlapping issues. I simply wanted to give you a quick heads up!
    Other than that, fantastic site!

Leave a Reply

Your email address will not be published.