I am in serious trouble with jobs scheduled in my report generation DB as the jobs are not at all running and because of this I need to manually run(that too many should run at midnight
Please tell me what could be the possible reason for this and how can i resolve it.
There are no logs at all as it is not at all executing.
But I checked my alert log there i find these:
Mon Jul 29 20:30:49 2013
Error 2068 trapped in 2PC on transaction 3.24.5722. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 3.24.5722 rolled back, some remote DBs may be in-doubt
ORA-02068: following severe error from REPORTDB2CSCDB
ORA-03113: end-of-file on communication channel
Kindly help. I am in serious trouble.
Thanking you in advance.