Oracle ClientOracle Instant Client

Difference between Oracle Client and Oracle Instant Client

Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients:

Oracle Client

  1. Features
  2. Pros
    • One-stop shopping
    • You may need only one package for your machine comparing to Oracle instant client. That is to say, one install can provide almost everything you need, such as SQL*Plus, tnsping, JDBC drivers, OCI, etc.

    • Ready Environment variables
    • You don’t have to worry about the settings of environment variables. They are all set as registry parameters during installation.

  3. Cons
    • Needs to be installed
    • You have to spend time to install the software, it could be a lengthy work to do. If something is wrong, you may need to uninstall the software and start it over. As a result of uninstallation, there could be some footprints that you have not cleaned out yet.

    • Software conflicts
    • You may see software conflicts in your machine because of newer Java, Windows update, other Oracle clients or 3rd-party tools. Moreover, successful installations do not always guarantee that you can use the software successfully. As I know, it’s a force-closed phenomenon.

Oracle Instant Client

  1. Features
  2. Pros
    • Portable
    • You can just unzip the package and start to use it. Which means, you can put it in any media and then carry it to anywhere. So that boosts your productivity either on database administration or quick client deployment.

    • Light-weight
    • Since every package has its own binaries for specific purpose, so the whole package is pretty small in size and very suitable for software distribution.

    • Pluggable
    • Different versions of Oracle instant clients can coexist in you machine. If you found any conflicts, you can just unplug (delete) the unnecessary versions (folders) anytime you want.

  3. Cons
    • Varying packages
    • Different packages are for different purposes in same version, that can make you confused about which is which. You need to know the purpose of every package including what it has, what it can do. For example, basic package does not contain SQL*Plus, you need another package.

    • Environment variables setting
    • Oracle instant clients are independently operated in your machine. You have to set environment variables by yourself. Sometimes, it’s a tedious job for users to do. In practice, the most important environment variables in Windows would be ORACLE_HOME_NAME, ORACLE_HOME and TNS_ADMIN. At least, you have to know how to set TNS_ADMIN.

    • No tnsping
    • tnsping is a very important utility for DBA to troubleshoot the connectivity problem for users. It’s not in any package of Oracle instant client. At least I don’t see it anywhere. Does there anyone know about that?

Further reading: How to Check 32-bit or 64-bit Oracle Client

Leave a Reply

Your email address will not be published. Required fields are marked *