ORACLE error ,Unable to find log file

Roopanwita · Post by **Roopanwita** » Wed May 21, 2008 4:11 am

Hi,
while loading from a sequential file to a ORACLE table ,I am getting error
"ora_tgt,3: The system(sqlldr CONTROL=<**>ctl LOG=<**>log BAD=ora<**>log.bad SILENT=header PARFILE=ora<**>par) failed; see the log file for the Oracle specific message.".

I have gone through the post and found that , cause of error is written in log file....

But i m unable to find log file..
( i have checked config file and frm there node defined path I have checked, still unable to figreout log file location).

Can anyone please help me out.

ArndW · Post by **ArndW** » Wed May 21, 2008 4:25 am

I can't recall where they are written either, but did search the whole file system from root using "find . -name ora.*bad -print 2>/dev/null" to find the relevant directory. Of course on a big system that find might take a while...

mahadev.v · Post by **mahadev.v** » Wed May 21, 2008 4:30 am

The .bad and .log files are created in the scratch disk that is defined in configuration file used to run the job.

Roopanwita · Post by **Roopanwita** » Wed May 21, 2008 5:25 am

I have found out.
Thanks