SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
652346Apr 21 2009 — edited Feb 10 2020Hi, I am encountering the issue:
[oracle@webdev ~]$ sqlldr system/bestit77@test10g control = /tmp/result.ctl
SQL*Loader: Release 10.2.0.4.0 - Production on Mon Apr 20 23:42:33 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
I downloaded an instantclient, and installed basic, sqlplus packages. the sqlplus could connect every remote services. but sqlldr could not with the above errors.(the command sqlldr was copied from installed oracle database.)
why? i have tested that the sqlldr can imported the data into the remote service(test10g) on local service. should i install sqlldr with the instantclient rather than only copy from the database server?