0

I'm trying to run sql loader with the following syntax on a remote bbdd:

sqlldr user/password@host.sid control=loader_control_file.ctl

(where host.sid is the remote bbdd tnsnames entry) and it gives the following error

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12546: TNS:permission denied

I have the connection configured in my local tnsnames.ora, tnsping resolves the sid and sqlplus connects (and works) correctly so apparently tnsnames setup is good.

I've also tried EZconnect syntax

sqlldr user/password@//host:1521/sid control=loader_control_file.ctl

buts gives the same error

I have no idea of what is wrong here. Any help?

Secun
  • 1
  • 1
  • https://stackoverflow.com/questions/19966848/tnsping-ok-but-sqlplus-gives-ora-12154?rq=1 – alexherm Sep 28 '20 at 22:42
  • Your connection sting is jacked up somewhere. What happens when you pass hard coded values in the connection string? Try direct connect instead of variables. The error will reveal itself. – alexherm Sep 30 '20 at 00:50
  • maybe just try chmod 777 on the import file. giving everyone access might resolve. – alexherm Sep 30 '20 at 00:53
  • I've tried against a database on another remote server and everything went ok, so I think it should be a misconfiguration on the remote server. The sysop granted me ssh access to the server, so I could load it locally (and it worked). I still don't know where the problem is, but at least I could workaround the issue, Thanks for the help! – Secun Oct 01 '20 at 13:41

0 Answers0