Cannot login, Error in Prosight.log: ORA-25153: Temporary Tablespace is Empty (Doc ID 2152574.1)

Last updated on JUNE 22, 2016

Applies to:

Primavera Portfolio Management - Version 9.0 SP2 and later
Information in this document applies to any platform.

Symptoms

On: OPPM (found in 15.1 release but can occur in other OPPM releases as it's a database issue):

When attempting to log into OPPM, the user cannot login and is taken back to the login screen. The following error occurs in the prosight.log:

ERROR
-----------------------
ORA-25153: Temporary Tablespace is Empty

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to OPPM login page and attempt to login
2. User cannot login and is taken back to login screen

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use OPPM

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