This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Oracle Bulk Load - SQLLDR Path Issue

Hemanth
New Contributor

โ€Ž04-04-2018 11:44 AM

Hi,

I am trying to use the Oracle Bulk Load option for inserting the data, currently getting the issue for SQLLDR path. I have provided the path of SQLLDR like this and SQLLDR is available in this path on Oracle Database Server. Tried with both
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr.exe
u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr

Error Message
Failure: Specified SQLLDR path is not an executable file, Reason: Snap failed unexpectedly and did not provide any reason

Please could suggest me on the path of SQLLDR.

0 Kudos
10 REPLIES 10

dmiller
Admin Admin
Admin

โ€Ž04-05-2018 08:54 AM

I believe you need an opening /, as in:
/u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr


Diane Miller
Community Manager
0 Kudos

Hemanth
New Contributor
In response to dmiller

โ€Ž04-05-2018 09:08 AM

Tried with opening / as /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr this also did not work.

0 Kudos

mthirani
Employee
Employee
In response to Hemanth

โ€Ž04-05-2018 09:15 AM

Have you tried using the suggestions in the snap for this field?
Also make sure the ORACLE_HOME, PATH and ORACLE_SID is set appropriately in the plex for oracle. For example:

export ORACLE_HOME=โ€œ/u01/app/oracle/product/11.2.0/xeโ€
export ORACLE_SID=โ€œXEโ€
export PATH=$ORACLE_HOME/bin:$PATH

0 Kudos

cstewart
Former Employee
In response to Hemanth

โ€Ž04-05-2018 09:43 AM

Are you running on a Groundplex node that you have access to? (SQLLDR is not available in Cloudplex environments) .

0 Kudos