OIF SSO Fails With Error 500: DiscoveryCreateException: ORA-01950: No Privileges On Tablespace

(Doc ID 1646140.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Identity Federation - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

OIF SSO is failing with Error 500 Internal Server error.

The OIF diagnostic log shows error ORA-01950: no privileges on tablespace.

For example:


Steps to reproduce
=============
1. Issue an OIF SSO request e.g. IdP-initiated SSO at /fed/idp/initiatesso
2. The login page is displayed
3. Submit valid credentials
4. HTTP-500 Internal Server Error occurs.


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