For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hi Guys,
Where to download and install sqlldr utility ? Need a solution ASAP.
Please check the below screenshot:
Regards,
Monojit
Posting a couple of cropped pictures as "information" about the issue is a start I guess but doesn't really give all information...
Start a command prompt and set your path to include %ORACLE_HOME%\bin, assuming you are on windows and you have an Oracle database client install on the computer you are trying to run sqlldr from, as the first picture suggests you have...
Note sqlldr is a command line utility not a sqlplus command.
The sqlldr utility is available via a database install and a database client install. and instantclient 12.2 and higher
What version database are you wanting to load data into?
For the instantclient 12.2 and above you can download the basic, sqlplus and tools zips to get a later version of sqlplus and sqlldr.
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
Hi ,
Thanks for your reply. I am providing my database related details. Please check and confirm whether the link you have provided , is compatible with my current database or not.
BANNER
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
You would need to visit MOS and view the compatability matrix, but in theory instantclient 12.2 zips should be as usuallly Oracle supports tools and database within 2 major versions.
If you are actually on the database server, then as I said, you will have access to sqlldr already.
So are you connecting to a local or remote database?
I am connecting to a remote database. If I run it in my client system , will this version work properly ?
If you set it up correctly, yes.
Try the version 19 first (that is still part of the 12.2 Oracle version family)
o Instantclient-basic or instantc-basicLite
o iinstantclient-tools
o and optional instantclient-sqlplus
For what ever OS and architecture you clinet OS machine is.
If you encounter errors then try downloading and installing 12.2. instead
Thanks for your reply . Please check the below screenshot :
The version , you have mentioned , will be with my current windows version ?
As you apear to have 64bit win10 then download from here:
The following:
https://download.oracle.com/otn_software/nt/instantclient/19600/instantclient-basic-windows.x64-19.6.0.0.0dbru.zip
or
https://download.oracle.com/otn_software/nt/instantclient/19600/instantclient-basiclite-windows.x64-19.6.0.0.0dbru.zip
If you do not require multi-lingual stuff,
And these tools packages:
https://download.oracle.com/otn_software/nt/instantclient/19600/instantclient-sqlplus-windows.x64-19.6.0.0.0dbru.zip
https://download.oracle.com/otn_software/nt/instantclient/19600/instantclient-tools-windows.x64-19.6.0.0.0dbru.zip
Once you have installed the basic OR basicliite you unzip the other zips into the same directory.
You will need to add the instantclientN_NN directory path to the PATH variable.
You will also need to set the TNS_ADMIN variable to where ever your tnsnames.ora and sqlnet.ora files reside on your clinet machine so instantclient tools can connect to remote database.
sqlplus is a great tool for debugging/testing (as well as being a great all round client tool) your instantclient setup is correct..
Which version should I choose , on the link you have attached.
Start with 19.6 as shown in reply #8
Hi,
Got it , Thanks for your support . I will update if I face any issues , while installing ..
