SQL & PL/SQL

Announcement

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!

Execute control file from Unix command prompt

Oracle_MonkeyFeb 1 2019 — edited Feb 1 2019

How to execute control file from command prompt in UNIX ?

I did this

sqlldr myuser@myhost:1521/password control=/folder1/ctrl/loader.ctl

But i am getting the below error

bash: sqlldr: command not found.

I am using the below command now

$ORACLE_HOME/bin/sqlldr DBUSERNAME/PWD@TNS_NAME control=/pathto_ctl/ctl_file.ctl

but getting the below error

SQL*Loader: Release 11.2.0.4.0 - Production on Fri Feb 1 08:14:49 2019

SQL*Loader-128: unable to begin a session

ORA-01017: invalid username/password; logon denied

But i am able to connect to DB in sql developer with same password

This post has been answered by Hans Steijntjes on Feb 1 2019

Jump to Answer

Added on Feb 1 2019

3 comments

1,347 views