Jun 9, 2020 5:45:00 AM by Mathew Phan
I was having a hard time trying to connect to one of my test databases. It took a lot of trial and error until I realized it was because I was using an Oracle 19c client to connect to an Oracle 11g database—and they are not compatible.
What saved me a lot of time in testing and figuring this out was installing different versions of the Oracle instant client rather than having to install the full client for each test.
Instant clients are really helpful when you don't need to install all the utilities and drivers of a full client. It's also helpful when you don't have access to run full clients on the computer you're using - for example, a contractor who is using a loaner laptop. And sometimes, like in my situation, they're just handy to have in order to quickly test compatibility between different client, database, and application versions.
Here are my steps to quickly install an instant client and connect to a database using Toad® for Oracle.
Ta-da. That's it. A light weight, quickly installed Oracle Instant Client to play around with. You can test or keep this instant client. You just won't have access to some utilities like import/export exe, tkprof, data pump, etc – but if you don’t need them, then you’re good to go.
Try Toad for Oracle now
Already in a trial? Talk to sales or buy now online.
Already a loyal fan of Toad for Oracle? Renew now.
Technical brief: Top Five Reasons to Choose Toad Over SQL Developer
Head over to theToad for Oracle forum on Toad World®! Chat with the me, the other Toad developers, and lots of experienced users.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Written by Mathew Phan
Mathew Phan began his career as a technical support engineer for Toad for Oracle soon after graduating from the University of California, Irvine, where he obtained a bachelor's degree in computer and information science. Mat has devoted his entire 14-year career with the Toad family of database solutions and held various positions helping to shape the direction and growth of Toad. Early in his tenure, his focus was on Oracle databases from a developer point of view. Now as a systems consultant, he continues to work with customers to build effective solutions that meet their needs.