Tuesday, July 17, 2012

ORA-445 backgroup process didnt spawn.

error:
ORA-00445: background process "J000" did not start after 120 seconds

cause:
it should be resource issue.

solution:
check if this happens at peak time.
select * from v$resource_limit; to see if any limit is reached.


reference:
http://www.orafaq.com/forum/t/163934/0/
https://forums.oracle.com/forums/thread.jspa?threadID=2141050

No comments:

Post a Comment