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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 28 Mar 2005 04:59:53 -0800
Message-ID: <1112014793.670142.170940@f14g2000cwb.googlegroups.com>

xtanto_at_hotmail.com wrote:
> 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

Is your Oracle client version also 9i?

Regards
/Rauf Received on Mon Mar 28 2005 - 06:59:53 CST