strace showed nothing.
This is Red Hat 4.3 32-bit for database and apps
No major activity was performed for the last 2 months, not even any
patches applied :-)
On Thu, Jan 29, 2009 at 8:30 PM, Vikram <vikramsingh120@xxxxxxxxx
<mailto:vikramsingh120@xxxxxxxxx>> wrote:
Ashwin,
Interesting! Can you run "strace -p <pid>" on the f60gen commands
that are spawned as part of adadmin generating forms? Upload the
trace file please. If strace is not available, try truss.
Has there been any activity on the server before the issue was
reported?
What was the major activity performed successfully on this
instance? and what was the first event that noticed this error?
What OS is this server?
-Vikram
On Thu, Jan 29, 2009 at 10:49 PM, Ashwin <ashdbablog@xxxxxxxxx
<mailto:ashdbablog@xxxxxxxxx>> wrote:
List,
I have a wierd issue.
Our 11i instance reported concurrent manager problems and we
restarted the apps services and the database.
Current scenario: -
- Oracle Database (9.2.0.6) and listener are up and running
- Starting Apps services starts up everything but when we
login to the forms, we are able to open the form but when we
try closing the form, it hangs
- The concurrent services start but nothing runs
- We see processes for all the services but they do not run
- Load average is 0.01, CPU usage around 0.6% which is never
the case
- adadmin run for generate of forms keeps the workers in
'Assigned' status and they never run. They have to be killed.
Its like they are frozen. There is no activity.
I checked the following: -
- No errors in any log files i.e. alert logs, apache logs,
concurrent manager logs (moved them and created new sets to
avoid file size issues)
- Archive log is enabled and working fine
- All the Diagnostic tests from IZU_TOP as well as aoljtest
are working fine.
- APPLSYS, APPS, GUEST accounts are fine and validating
- No end-dated or locked users in FND_USER or DBA_USERS
- strace of f60webmx does not show any significant errors
(except a phrase like "The Guest user cannot b" which is why i
checked the GUEST user)
- Relinked all executables
- Ran autoconfig (it ran successfully)
I have a Sev1 SR running but no significant throughputs.
Nothing seems to resolve the issue. Any ideas?