PSUB jobs remain in 'Submitted' Status.
(Doc ID 1470256.1)
Last updated on DECEMBER 05, 2019
Applies to:
Oracle Clinical - Version 4.6.0 and laterInformation in this document applies to any platform.
Symptoms
ISSUE:
-------
i.
PSUB jobs stay in SUBMITTED status but seem to work fine for the OPS$OPAPPS user (OS account= opapps).
ii.
The following appears in the opapps psub log file (l<batchjobId>.log) :
LOGNAME=opapps
Connected to database.
Job started.
but only the following appears fo the problem user :
LOGNAME=<LOG_NAME>
iii.
problem user => Unix process stack getting stuck here :
launchps
=> pslaunch
=> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))
iv.
A 'sqlplus' hang is experienced when connecting as slash ie
- OS : log on as problem user
- try to execute 'sqlplus /' which will hang (but is fine for opapps).
Changes
the 'AUDIT_TRAIL' database parameter was changed from 'DB' to 'XML'.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |