PSUB jobs remain in 'Submitted' Status.

(Doc ID 1470256.1)

Last updated on JULY 02, 2012

Applies to:

Oracle Clinical - Version 4.6.0 and later
Information 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=t175481

 

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

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 hundreds of Community platforms