Oracle error log files

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kashif007
Premium Member
Premium Member
Posts: 216
Joined: Wed Jun 07, 2006 5:48 pm
Location: teaneck

Oracle error log files

Post by kashif007 »

I get the following error

HRY065_TRANSLATE_TBL_LGCY_Ldr,4: The system(sqlldr DEVL1_DB04FDWP/edison1358@ORAP062 CONTROL=ora.1577054.869903.4.ctl LOG=ora.1577054.869903.4.log BAD=ora.1577054.869903.4.log.bad SILENT=header PARFILE=ora.1577054.869903.4.par) failed; see the log file for the Oracle specific message.

Where can I see the log files for this. what location?
I want to see
ora.1577054.869903.4.log and ora.1577054.869903.4.log.bad

Thanks
Regards
Kashif Khan
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

A Search of the Forum would have revealed that, unless you dictate otherwise, they will be found in the directories identified in your current configuration file as scratch disk.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Search for 'all terms' and put in something like "oracle log location". It been discussed here a number of times.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
kashif007
Premium Member
Premium Member
Posts: 216
Joined: Wed Jun 07, 2006 5:48 pm
Location: teaneck

Post by kashif007 »

Found it in the orscht folder
Regards
Kashif Khan
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”