Skip to main content

Scheduler Jobs - Error!!!

When trying to execute a scheduled job you may get below error sometimes in Oracle EM.

ERROR

java.sql.SQLException: ORA-02800: Requests timed out ORA-06512: at "SYS.DBMS_ISCHED", line 150 ORA-06512: at "SYS.DBMS_SCHEDULER", line 441 ORA-06512: at line 2 


This is a bug in Oracle. Most of the times, restarting Oracle database may fix the issue.
Basically, an existing bug needs the oracle database restarts in a regular basis.
Restarting oracle database will flushes the database buffer cache.

Comments

Post a Comment

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID
1 comment
Read more