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 later
Information in this document applies to any platform.

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).

the 'AUDIT_TRAIL' database parameter was changed from 'DB' to 'XML'.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.