SQL*Loader-704 & ORA-12535 error , Oracle 9i AIX, Windows Client

From: <xtanto_at_hotmail.com>
Date: 28 Mar 2005 04:49:06 -0800
Message-ID: <1112014146.347102.306500@f14g2000cwb.googlegroups.com>

Hi All,

I try to run SQL*Loader from Windows Client to Oracle 9i server on AIX. The control file is in the windows machine.

C:\SqlLdr user/password_at_myoradb control=mycontrol.ctl

(the data is 300,000 rows, on the same control file)

I get this error :

SQL*Loader-704 : Internal error : ulconnect: OCIServerAttach [0] ORA-12535: TNS:Operation timed out.

FYI, from the same machine, TNSPing is OK, SQL*Plus run perfectly.

What is wrong here ?
Should I copy the CTL file into the AIX Server and run the SQL*Plus from AIX client console ?

Thank you for your help,
Krist Received on Mon Mar 28 2005 - 06:49:06 CST