DSXchange

Hi

we are using a datastage job that loads the data into a table,
when we load the data into old database we dont have any issue with loading the data into a table,
but right now while we are trying to load the same data into new database we are getting the SIGBUS error.
i Tested to load a sample data with 7 rows by creating a new table in new database to check the connectivet,
the connectivet is good and the table is created and data is loaded into that table.

Please can any one help me in this issue. Its very Urgent.

Not able to get much from your query.

Old database/New Database ...which database? Can you also paste your error message.

Not sure whether this will help you-
viewtopic.php?t=105535&highlight=SIGBUS

Hi

we are using a datastage job that loads the data into a table using OLD Oracle database,
when we load the data into old Oracle database we dont have any issue with crating & loading the data into a table,

but right now while we are trying to load the same job with same data pointing to New Oracle Database we are getting the SIGBUS error. Following is the error.

Ora_Stage,0: Operator terminated abnormally: received signal SIGBUS


i Tested to load a sample data with 7 rows by creating a new table in new Oracle database to check the connectivity using a datastage job.
the connection is good and the table is created and data is loaded into that table.

Please can any one help me in this issue.

What is "new" about this New Oracle Database? Is it a different version from the OLD Oracle Database? One 9i and one 10g for example?

kkumardatastage wrote:Its very Urgent.

We don't do "urgent". DSXchange is an all-volunteer site whose members post when, as and if they can. If you need "urgent" sign up with your official support provider for priority service, and learn just how expensive "urgent" is.

You posted this at 2am my time. NOTHING is urgent at 2am.

Hi

Thanks for your reply, the New Oracle Database version is 10g and the Old Oracle Database is 9i. Please help me to fix this problem.

Thanks

Does your PATH environment variable when the job runs include the parent directory of the sqlldr command?

Does the executing user ID have write permissions to whatever directory you specified for the control and data files, and to the scratchdisk (where the log and bad files are written by default)?

Please delete your duplicate post before anyone responds to it.

In your shoes, I would check with your official support provider to see if this is a known issue with 11g.

We got solution for SIGBUS issue. we need to have oracle EE patch, this makes SIGBUS issue solved.

Solution installing the Oracle EE patch:
http://www-01.ibm.com/support/docview.w ... wg21395472


Thanks
k