My Oracle Support Banner

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.


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 [] [] [] [] [] []


Import OFSA schema into another instance.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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