job abort:Unable to initialize the Direct Path Context

vijaynaidu · Post by **vijaynaidu** » Mon Dec 08, 2008 1:46 am

Hi all,

Pleae help in this issue...

xfmjobname: Internal Error: Unable to initialize the Direct Path Context
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

please provide information regarding this......

Thanks in advance....

mahadev.v · Post by **mahadev.v** » Mon Dec 08, 2008 3:07 am

Whats your job design? Are you trying to load a table or read from one? Looks like there is a lock on what every you are trying to access, and the job failed because of that. Post your job design and also is "xfmjobname" a database stage?

srinagesh · Post by **srinagesh** » Mon Dec 08, 2008 3:20 am

Code: Select all

ORA-00054: resource busy and acquire with NOWAIT specified

Suggests that this is a Oracle Database issue. Probably some kind of lock on the Table.

vijaynaidu · Post by **vijaynaidu** » Mon Dec 08, 2008 4:46 am

Issue resolved....

Tried killing the job.... thereafter tried for running the jobs thrice....it was successfull now.....

thanks for quick response...........