on 06-05-2008 8:59 AM
Hello,
In the R3 system (4.6C, BRCONNECT 6.20 patch level 136, TOOLS HP-UX 11.23, oracle 9.2), we have scheduled a job CleanupLogs in DB13. The program works successfully but while displaying details logs following error occures.
BR252E Function fopen() failed for '/oracle/<SID>/sapreorg/cdxzmglv.cln'
at location file_printout-1
BR253E errno 2: No such file or directory
External program terminated with exit code 5
Job creates log file cdxzmglv.cln'
in '/oracle/<SID>/sapcheck/cdxzmglv.cln' but while diplaying it is looking at location as above mentioned in error.
Through Brtools we are able to display job log successfully.
Further , other jobs sheduled in DB13 , detail log display works
correctly. The problem is only with CleanupLogs job.
We would like know why while creating and displaying logs it seeks different location.
Request for your guidence please.
Regards
Kailash
Hello,
This looks like a parameter problem.
Do this:
a) Call Transaction SM51 and log on to the instance on the database server
b) Call Transaction DB03 -> Active parameters to display any parameter that points to sapreorg
c) Change it to point to saptrace, i can't recollect which one to change so use your own judgement
d) Change the same parameter in OS level also in init<SID>.ora
For reference, have a look at the following note:
SAP Note Number: 305740 - Display Optimizer Trace File (ORACLE)
Although the note doesn't point to CleanupLogs, it talks about the error that you see in your log.
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kailash,
Please check if the /oracle/<SID>/sapreorg/ exists and permissions of /oracle/<SID>/sapreorg/ are correct and accessible to ora<sid> userid.
Regards,
Siddhesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.