-1

Hi I am working with SQL*Loader but its give me an error

SQL*Loader-128: unable to begin a session

ORA-28040: No matching authentication protocol.

My Oracle is 12c and SQL*Loader version is 9.2. enter image description here What i have to do?

Serenity
  • 35,289
  • 20
  • 120
  • 115
Ashique Sheikh
  • 155
  • 2
  • 4
  • 13

1 Answers1

5

I'd give serious consideration to upgrading to a more recent version of SQL*Loader.

(Oracle 9 went out of support over 6 years ago)

cagcowboy
  • 30,012
  • 11
  • 69
  • 93
  • Do I need to install instant client or install oracle setup? – Ashique Sheikh Jul 14 '16 at 12:11
  • Pretty sure that SQL*Loader needs Oracle Client (not just instant client). But I suggest you check. – cagcowboy Jul 14 '16 at 12:12
  • Yes, SQL\*Loader is part of the (full) Oracle Client. Presumably this error affects all of your Oracle client tools including SQL*Plus? Did you google "ORA-28040: No matching authentication protocol"? A lot of the results point to an Oracle client config issue. – William Robertson Jul 14 '16 at 12:21