# SQL loader error

**URL:** <https://community.unix.com/t/sql-loader-error/152879>\
**Category:** Shell Programming and Scripting\
**Created:** [April 19, 2005, 1:16pm UTC](https://community.unix.com/t/sql-loader-error/152879 "2005-04-19T13:16:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sveera](https://community.unix.com/letter_avatar/sveera/32/6_449c533f586939b6e5f246632a46421f.png) [@sveera](https://community.unix.com/u/sveera)\
**Post date:** [April 19, 2005, 1:16pm UTC](https://community.unix.com/t/sql-loader-error/152879/1 "2005-04-19T13:16:02Z")

</div>

Hi friends,  
i am getting the following error when i am using sql loader.  
SQL\*Loader: Release 8.1.7.4.0 - Production on Tue Apr 19 13:00:07 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

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

```
                 whats the reason for this ?

```

thanks in advance  
srini

---

<div class="post-metadata">

**Author:** ![google](https://community.unix.com/user_avatar/community.unix.com/google/32/65_2.png) [@google](https://community.unix.com/u/google)\
**Post date:** [April 19, 2005, 1:20pm UTC](https://community.unix.com/t/sql-loader-error/152879/2 "2005-04-19T13:20:03Z")

</div>

Looks like SQL\*Loader cannot connect to Oracle. Based up the error thrown, the tnsnames.ora file is not available, not readable, etc.

At the command line, type the following (be sure to have your set your ORACLE\_HOME variable):

oerr ora 12535 This will report what the error was and it will give you a short and long description. It may also give you a clue on how to resolve the issue, though many of the Oracle errors are cryptic or not very useful.

---

<div class="post-metadata">

**Author:** ![google](https://community.unix.com/user_avatar/community.unix.com/google/32/65_2.png) [@google](https://community.unix.com/u/google)\
**Post date:** [April 19, 2005, 1:22pm UTC](https://community.unix.com/t/sql-loader-error/152879/3 "2005-04-19T13:22:27Z")

</div>

Here is the output if you cant get the oerr command to work.

```nohighlight
Oracle error 12535
"TNS:operation timed out"
// *Cause: The requested connection could not be completed within the
timeout period specified by the CONNECT_TIMEOUT parameter in listener.ora.
This error arises from the tnslsnr.
// *Action: Either reconfigure CONNECT_TIMEOUT to be 0, which means wait
indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if
the timeout is unacceptably long, turn on tracing for further information.

```

---

<div class="post-metadata">

**Author:** ![tmarikle](https://community.unix.com/letter_avatar/tmarikle/32/6_449c533f586939b6e5f246632a46421f.png) [@tmarikle](https://community.unix.com/u/tmarikle)\
**Post date:** [April 19, 2005, 1:27pm UTC](https://community.unix.com/t/sql-loader-error/152879/4 "2005-04-19T13:27:02Z")

</div>

sqlldr can't find your database connection information. Ex. sqlldr user/pwd@dbid

If you specified your dbid then the database connection may not be found in the ORACLE\_HOME that you are referencing. ORACLE\_HOME is clearly being referenced, otherwise, your error text would be more cryptic. Check where ORACLE\_HOME points to and then look in $ORACLE\_HOME/network/admin/tnsnames.ora for your database ID.

---

<div class="post-metadata">

**Author:** ![sveera](https://community.unix.com/letter_avatar/sveera/32/6_449c533f586939b6e5f246632a46421f.png) [@sveera](https://community.unix.com/u/sveera)\
**Post date:** [April 19, 2005, 4:04pm UTC](https://community.unix.com/t/sql-loader-error/152879/5 "2005-04-19T16:04:23Z")

</div>

Hi friends,  
thanks a lot for your responses . actually the solutions that both of you gave might have helped me but i came to know from my network group that there is some network problem and so i am not able to connect.  
thanks a lot again .  
i learnt from your solutions that you gave.  
bye  
veeras
