Skip to Main Content
  • Questions

  • Sqlldr is throwing OCI.dll exception with Oracle 12.2 Instant Client

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Nimish.

Asked: June 14, 2018 - 6:48 am UTC

Last updated: June 15, 2018 - 6:46 am UTC

Version: Oracle Instant Client 12.2

Viewed 1000+ times

You Asked

Hi,

I have downloaded Oracle 12.2 Instant Client (both SQLPlus and Tools) and on my Window 7 64 Bit system from http://www.oracle.com/technetwork/topics/winx64soft-089540.html
I have unzipped the all files to C:\oracle122, along with by tnsnames.ora.

I also have set the ORACLE_HOME and TNS_ADMIN variables to C:\oracle122.

When I am trying to execute sqllrd from C:\oracle122, i am facing following exception
"The procedure entry point slldironly could not be located in the dynamic link library oci.dll"

I also have Oracle 11g Client + Oracle 11g XE installed on my system and I also have installed Visual Studio 2013 redistributable.

Please help.

Regards,
Nimish Garg

and Connor said...

Did you download "base" as well ?

INSTANT_CLIENT

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

You are awesome!

Nimish Garg, June 15, 2018 - 6:35 am UTC

Oh that was my bad! Thank you for pointing out the issue so quickly :)
Connor McDonald
June 15, 2018 - 6:46 am UTC

glad we could help
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database