After OFSA Schema Import, Users Unable to Login to OFSA - ORA-29540 Error (Doc ID 252418.1)

Last updated on MARCH 20, 2013

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Oracle Financial Data Manager - Version: 4.5

Checked for relevance on 20-Mar-2013.

Symptoms

After completing a full import of an OFSA schema into a test instance, when logging in as a non-dba user to OFSA, several ORA-29540 errors are reported.

When troubleshooting the issue, the following was completed:

Upon querying for invalid 'JAVA CLASS' objects, there are no java class objects.

You find the following errors in the jar log file:

the tpol_jar.log contains:
initialization complete
loading : oracle/ofsa/tpol/server/LogWriter
creating : oracle/ofsa/tpol/server/LogWriter
Error while creating class oracle/ofsa/tpol/server/LogWriter
ORA-03113: end-of-file on communication channel

You also find the following in the alert.log:

Errors in file /orasw/oracle/admin/orpfnofs/udump/ora_149910_orpfnofs.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []

Changes

Import OFSA schema into another instance.

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