9i report processes won't die after completing successfully

[djmartin]

We are running 9iAS 9.0.2.2 and 9iDB 9.2.0.3, all machines are RedHat Linux.

We have a development 9iAS server whose reports run and cleanup successfully off the 9iDB, and we have 3x9iAS production servers (when we go live) that run reports but they do _NOT_ cleanup successfully. That is, both the main report process and the 9i DBMS_DEBUG / DBMS_PIPE special process persist in the 9iDB after the run has finished. They are both working into the same database.

Is there some hand-shaking between the 9iAS and 9iDB that could be different between the two 9iAS boxes?

Where would I look to find them? I am not a server techie, I need help on this.

Does anyone know why one 9iAS report request cleans up and the other 9iAS report request does not clean up. This is a 100% repeatable activity.

I need an answer in 24 hours please.

David Martin
david.martin@familycourt.gov.au
+61 2 6243 8777
+61 4 0335 0524

 

[djmartin]

We worked with Oracle Support using ODC and they determined that the rwrun.jar on the two machines was different. What we had done was apply one-off patch p2938002_9022_GENERIC to the 'prod' machines and this caused our problem.

David