|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem with SQL loader | risshanth | UNIX for Dummies Questions & Answers | 2 | 11-01-2007 11:08 PM |
| Bus error(coredump) while running SQL*Loader in HP Unix 11 | srinivas_paluku | UNIX for Advanced & Expert Users | 3 | 04-23-2007 12:53 AM |
| error running COBOL - ".loader does not exist" | jbrubaker | UNIX for Dummies Questions & Answers | 16 | 08-02-2006 09:21 AM |
| XML WorkFlow Loader - Plz help | VanithaS | UNIX for Advanced & Expert Users | 0 | 07-24-2006 11:40 PM |
| resolve_symbols: loader error: dlopen: | gfhgfnhhn | High Level Programming | 1 | 06-29-2006 07:08 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
04-19-2005
|
|||
|
|||
SQL loader error
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  peration timed outwhats the reason for this ? thanks in advance srini 
|
| Forum Sponsor | ||
|
|
|
04-19-2005
|
||||
|
||||
|
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.
|
|
04-19-2005
|
||||
|
||||
|
Here is the output if you cant get the oerr command to work.
Code:
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.
|
|
04-19-2005
|
|||
|
|||
|
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.
|
|
04-19-2005
|
|||
|
|||
sqlldr error
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
|
|||
| Google The UNIX and Linux Forums |
Linear Mode
