Home » RDBMS Server » Server Utilities » sqlldr from Instantclient-21.9 on Win64: missing oranl.dll (Instantclient, 21.9.0.0, Windows64)
sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687440] Thu, 09 March 2023 09:34 Go to next message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
I've successfully downloaded and unzipped these components:

instantclient-basic-windows.x64-21.9.0.0.0dbru.zip
instantclient-jdbc-windows.x64-21.9.0.0.0dbru.zip
instantclient-odbc-windows.x64-21.9.0.0.0dbru.zip
instantclient-sdk-windows.x64-21.9.0.0.0dbru.zip
instantclient-sqlplus-windows.x64-21.9.0.0.0dbru.zip
instantclient-tools-windows.x64-21.9.0.0.0dbru.zip


Then wished to run program `sqlldr` from 'tools',
but it wouldn't start: it complains about missing dll's such as:

oranl.dll, oranls.dll, oracore.dll, oraxml.dll

Indeed, such files do not exist. (Though they might still exist inside oraociei.dll)

[Updated on: Thu, 09 March 2023 09:47]

Report message to a moderator

Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687443 is a reply to message #687440] Thu, 09 March 2023 09:53 Go to previous messageGo to next message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
Now, I'll try installing Visual C Redistributable from here:
https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170
https://aka.ms/vs/17/release/vc_redist.x64.exe

Edit: Nope Sad

[Updated on: Thu, 09 March 2023 13:12]

Report message to a moderator

Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687445 is a reply to message #687443] Thu, 09 March 2023 13:17 Go to previous messageGo to next message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
Same problem:
https://www.reddit.com/r/oracle/comments/uofc8k/cant_get_sqlldrexe_running_on_windows_10_machine/
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687446 is a reply to message #687445] Thu, 09 March 2023 14:45 Go to previous messageGo to next message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
Oh well, once extracted these dll's from the full client, I got another missing dll errors. I'll try to list them all:

oraasmclnt.dll
oracell.dll
oraclient.dll
oraclsce.dll
oracommon.dll
oracore.dll
orageneric.dll
orahasgen.dll
oraldapclnt.dll
oran.dll
orancds.dll
orancrypt.dll -- renamed from orancryptd.dll
orangsmshd.dll
oranhost.dll
oranl.dll
oranldap.dll
oranls.dll
oranro.dll
orantcp.dll
orantns.dll
oraocr.dll
oraocrb.dll
oraocrutl.dll
oraons.dll
oraplp.dll
orapls.dll
oraslax.dll
orasnls.dll
oraunls.dll
orauts.dll
oravsn.dll
orawsec.dll
oraxml.dll
orazt.dll
oraztkg.dll


Let's not throw stones: anyone can forget a file or thirty five when building a package from a dozen file. Especially for an obscure platform like Win64.
(Though I think these do exist inside oraociei.dll, but I cannot find any documentation about it.)

[Updated on: Thu, 09 March 2023 23:25]

Report message to a moderator

Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687766 is a reply to message #687446] Mon, 29 May 2023 10:58 Go to previous messageGo to next message
aspepper
Messages: 1
Registered: May 2023
Junior Member
I'm having the same problem with the installation of the Instant Client for Windows X64 version 21.10.0.0.0.

I downloaded and extracted the following files, and when running SQL*Loader (sqlldr.exe), it reports the same issues.

instantclient-basiclite-windows.x64-21.10.0.0.0dbru.zip
instantclient-basic-windows.x64-21.10.0.0.0dbru.zip
instantclient-jdbc-windows.x64-21.10.0.0.0dbru.zip
instantclient-odbc-windows.x64-21.10.0.0.0dbru.zip
instantclient-precomp-windows.x64-21.10.0.0.0dbru.zip
instantclient-sdk-windows.x64-21.10.0.0.0dbru.zip
instantclient-sqlplus-windows.x64-21.10.0.0.0dbru.zip
instantclient-tools-windows.x64-21.10.0.0.0dbru.zip
Initially, I only extracted the instantclient-basic and instantclient-tools due to the nature of my requirement. I just need to perform the import of the entire SQL Server 2017 database into Oracle 19c.

Have you made any progress in resolving this issue?

Keep me informed, please!

Alex Pimenta
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687767 is a reply to message #687766] Mon, 29 May 2023 11:31 Go to previous messageGo to next message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
Download the full client and it will work. (The one which is not the InstantClient.)
https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html
(See also this: https://logic.edchen.org/oracle-client-vs-oracle-client-home/ )
Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687793 is a reply to message #687767] Sun, 04 June 2023 06:13 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3244
Registered: January 2010
Location: Connecticut, USA
Senior Member
Basic Instant Client contains no tools - just connectivity. If you want Instant Client tools you need, in addition, download and install Tools Instant Client - https://download.oracle.com/otn_software/nt/instantclient/2110000/instantclient-tools-windows.x64-21.10.0.0.0dbru.zip
Check https://www.oracle.com/database/technologies/instant-client.html for various instant client packages.

SY.



[Updated on: Sun, 04 June 2023 06:14]

Report message to a moderator

Re: sqlldr from Instantclient-21.9 on Win64: missing oranl.dll [message #687794 is a reply to message #687793] Sun, 04 June 2023 08:13 Go to previous message
NevemTeve
Messages: 21
Registered: November 2017
Junior Member
@Solomon Yakobson
Thank you for your valuable addition.
Previous Topic: Exclude View in IMPDP using Network Link Giving error.
Next Topic: How to exclude Multiple tables by using EXPDP
Goto Forum:
  


Current Time: Mon Sep 25 14:47:48 CDT 2023