My Oracle Support Banner

Unable to Login to OFSAA After Upgrading AAI To 8.0.5.1 / "ORA-01000: maximum open cursors exceeded" Error Upon Running saltuserprofiles.sh (Doc ID 2432878.1)

Last updated on AUGUST 08, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

Unable to login OFSAA Application after upgrading OFSAA 8.0.5.1 via Patch 27504805 - CONSOLIDATED FIXES OF ALL ISSUES IDENTIFIED IN AAI COMPONENTS POST 8051 ML

None of the users can log into the OFSAA application anymore. When users attempt to login, error message is being displayed on the screen.

Login was not allowed either while using decrypted credentials data from database.

When verifying installation logs, ORA-01000 error message was found while executing saltuserprofiles.sh script. saltuserprofiles.sh script seems to have been run successfully for only 1000 of the total users.

ERROR

[11778] Please Contact Your System Administrator.

ORA-01000: maximum open cursors exceeded

 

STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:

  1. Apply Patch 27504805.
  2. Check whether there are any login issues in the environment.

Cause

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.