Page 1 of 1

job abort:Unable to initialize the Direct Path Context

Posted: Mon Dec 08, 2008 1:46 am
by vijaynaidu
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....

Posted: Mon Dec 08, 2008 3:07 am
by mahadev.v
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?

Posted: Mon Dec 08, 2008 3:20 am
by srinagesh

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.

resolved

Posted: Mon Dec 08, 2008 4:46 am
by vijaynaidu
Issue resolved....

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


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