User pinged me and reported that there concurrent programs are erroring out with signal 25.Below are the details.
Error Message in request Log file:
===================================
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 7275485 Review your concurrent request log and/or report output file for more detailed information.”
Program was terminated by signal 25.
Metalink id:
========
Error: Signal 25 Concurrent Program Completes with Error [ID 842850.1]
Symptoms
Problem Statement:
When attempting to run a concurrent program which is accessing file "reports.log" in directory $APPLCSF/$APPLLOG then following error occurs:
When attempting to run a concurrent program which is accessing file "reports.log" in directory $APPLCSF/$APPLLOG then following error occurs:
Error:
emsg:was terminated by signal 25
emsg:was terminated by signal 25
Cause:
File size of "reports.log" has reached its maximum limit at operating system which is 2GB. If $APPLCSF/$APPLLOG/reports.log will be huge -- 2GB in size, then reports can not append anything else to it and hence concurrent program accessing reports.log for its execution will error out.
Solution
========
1. Stop the concurrent manager.
2. Check the size of reports.log file and if file size is more than 2 GB then rename/truncate existing "reports.log" in directory $APPLCSF/$APPLLOG and create a empty "reports.log". One can do a find command as well.
$ find $INST_TOP -name reports.log
cd $APPLCSF/$APPLLOG
bash-3.2$ls -lrth reports.log
-rw-r–r– 1 applmgr dbamgr 2.1GB Mar 05 23:00 reports.log
bash-3.2$ cp -r reports.log reports.log_BKP
bash-3.2$ > reports.log
3. Start the concurrent manager.
4. Retest the issue.
The best way is learn to teach !!!!!!!!!!!!!!!
No comments:
Post a Comment