Bus error(coredump) while running SQL*Loader in HP Unix 11


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Bus error(coredump) while running SQL*Loader in HP Unix 11
# 1  
Old 04-23-2007
Bus error(coredump) while running SQL*Loader in HP Unix 11

Hi All,

I am getting coredump error, when I try to execute Oracle SQL*Loader from Shell script in Unix environment. But SQL*Loader from local machine runs fine with same database.

SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 05:23:47 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

sql.ksh[3]: 8438 Bus error(coredump)

Can you please guide me to resolve this error.

Thank you very much.
Regards,
Srinivas
# 2  
Old 04-23-2007
Windows 2 Unix??

If you are moving the script from Windows to Unix and trying it out, it could be a issue with special character - '^M' at the end of each line. Try ftp'ing the file as ascii and make sure there are no special characters at the end of each line(search forums for help on this). Also, if you could post a snapshot of the script that you are using, it would help.
# 3  
Old 04-23-2007
Bus error(coredump)

Hi,

control file is
OPTIONS ( ERRORS=99999999)
LOAD DATA
INFILE=${/usr/sap/A2/xchange/dataload/bwload/inbound/OOCQFULL.DAT}
INTO TABLE "OOCQ03DY_TMP"
INSERT
(PRODHNO POSITION(01:18),
PAPRODHNO POSITION(19:36),
PHITEMNM POSITION(37:54),
PHITEMDS POSITION(55:94),
PHITCDNM POSITION(95:134),
PDHRLVCD POSITION(135:135),
PRODTY POSITION(136:137),
PDRLFL POSITION(138:138),
PDFCFL POSITION(139:139),
PDCPFL POSITION(140:140),
MKSRSQNO POSITION(141:153),
PDPBFL POSITION(154:154),
PHIMPCDS POSITION(155:224),
PDDAUDFL POSITION(225:225),
PHODMCD POSITION(226:228),
PRODCGGP POSITION(229:248),
PNFMTCD POSITION(249:250)
)

ksh file is

#!/bin/sh
. /home/bwload/.profile
$ORACLE_HOME/bin/sqlldr as/as2005@AMERICAS.NET control=gpg.ctl
log=gpg.log
retcode=`echo $?`
case "$retcode" in
0) echo "SQL*Loader execution successful" ;;
1) echo "SQL*Loader execution exited with EX_FAIL, see logfile" ;;
2) echo "SQL*Loader exectuion exited with EX_WARN, see logfile" ;;
3) echo "SQL*Loader execution encountered a fatal error" ;;
*) echo "unknown return code";;
esac


and the error i am getting is
ksh sql.ksh

SQL*Loader: Release 9.2.0.6.0 - Production on Mon Apr 23 07:17:58 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

sql.ksh[3]: 4555 Bus error(coredump)
SQL*Loader execution successful
logout

Regards,
Srinivas
# 4  
Old 04-23-2007
a few things

First, This assignment is wrong in the control file-
Quote:
INFILE=${/usr/sap/A2/xchange/dataload/bwload/inbound/OOCQFULL.DAT}
Since you are specifying the full path and not using a variable, there is no need for the ${..}. Change to
Quote:
INFILE=/usr/sap/A2/xchange/dataload/bwload/inbound/OOCQFULL.DAT
Then, in the script, you have the set of statements like this -
Code:
$ORACLE_HOME/bin/sqlldr as/as2005@AMERICAS.NET control=gpg.ctl
log=gpg.log
retcode=`echo $?`

Here you are taking return code of the logfile name assignment that you do. So, it should always return 0. Move the logfile assignment to the top and have the return code check immediately after the sql*loader call.
Code:
log=gpg.log
$ORACLE_HOME/bin/sqlldr as/as2005@AMERICAS.NET control=gpg.ctl
retcode=`echo $?`

Also, check for any special chars in your control file.

Last edited by ranj@chn; 04-23-2007 at 04:55 AM.. Reason: correction
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies

2. UNIX for Dummies Questions & Answers

Call SQL LOADER FROM UNIX

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies

3. Shell Programming and Scripting

sql loader for inserting the data from multiple fields from unix

Hi , I have my log file something like this (07/29/2009 00:02:24.467) 367518 (07/29/2009 00:02:26.214) 949384011 (07/29/2009 00:02:26.236) 367524 (07/29/2009 00:02:28.207) 949395117 (07/29/2009 00:02:28.240) 337710 (07/29/2009 00:02:30.621) 949400864 I am trying to insert the data... (3 Replies)
Discussion started by: rdhanek
3 Replies

4. HP-UX

Need help on Bus error(coredump)

Hi all, I am quite weak in C but I need to get some work done. Hope someone can help me out. I keep getting this error when i try to run my C application in my HP-UX 10.20 machine. Some code snippet: Month(DBTime) =====This is a function which will return variable "CutOffTime" to be use... (5 Replies)
Discussion started by: Vision©
5 Replies

5. Shell Programming and Scripting

how to handle sql loader errors in unix

hi all, how to handle sql loader errors in unix shell ?? thanks in advance gemini (3 Replies)
Discussion started by: gemini106
3 Replies

6. UNIX for Dummies Questions & Answers

bus error (coredump)

Hi all, I am getting bus error problem in SunOS. Can you please help me out in this regard. Actually, my entire code till the last line has been executed. But after tht i am getting a bus error. Please help me. Thanks in advance. Charu. (4 Replies)
Discussion started by: charu
4 Replies

7. UNIX for Dummies Questions & Answers

problems running a sql loader script

Hi Folks, I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat... (2 Replies)
Discussion started by: jibbadiah
2 Replies

8. UNIX for Advanced & Expert Users

Bus Error(coredump)

Hi, I am using HP-UX. While i try to run the Sqlplus command using the shel script in encounter the following error: <shell script name>: some number Bus Error(coredump) What may be the reason behind this. I read few previous threads in this forum where i found some similar case. There it was... (2 Replies)
Discussion started by: Jayesh
2 Replies

9. UNIX for Dummies Questions & Answers

Bus error(coredump

aix 5.3 ML1 system was functioing well, when suddenly telnet session hung and then I got the following message "Bus error(coredump)" would appreciate if anyone would assist as to what to do next. (3 Replies)
Discussion started by: Student37
3 Replies

10. Shell Programming and Scripting

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 ORA-12535:... (4 Replies)
Discussion started by: sveera
4 Replies
Login or Register to Ask a Question