DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Friday, April 11, 2014

Expdp Hangs :-

Experience on EXP JOB Hangs :-

Oracle DB Version - 10.1/Sun Solaris 5.8

Expdp/Exp hangs for more than 4 hrs, No errors were reported in the alert log and no blocking Session.

After some time received timeout session error.

By checking the above, we found as a root cause that Exp job started a week back didn't complete properly. It's holding up any new Exp job.

I Killed a Exp session from the database, but Still in the database as a "KILLED" state. So I decided lets kill the OS process of the Exp Session. But It looks like "ora_dw001_SID". I'm not sure that I can kill this process, So raised a TAR with oracle to get confirmation to do it.

After killing this OS process, Session went away from the database, I can start a New Exp backup without any Issue.

So,

1. After killing the Session from the database, make sure It's go away from the DB and Server.

2. If you see any process like "ora_dw001_SID" that holds your Exp job, you can safely kill this, It's not a BACKGROUND PROCESS, It's  a worker for Exp job.



 

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.