OFSA_AUTHENTICATE.REQUESTROLE from DUAL and ORA-03113 Errors when Logging into OFSA (Doc ID 367929.1)

Last updated on DECEMBER 11, 2007

Applies to:

Oracle Financial Data Manager - Version: 4.5 to 4.5.39
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA) 4.5

Symptoms

When attempting to logging into OFSA modules  modules either as a regular user or schema owner the following error occurs.


ERRORS:

SELECT ofsa_authenticate.requestrole from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

STEPS:

1. Login to OFSA modules and the above error occurs.
2. Login to SQL*Plus and the same error occurs on query below:
    SELECT ofsa_authenticate.requestrole FROM dual;

Changes

Upgraded RDBMS database from 9.2.05 to 9.2.07.

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