Upgrade Failed: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP (Doc ID 2172276.1)

Last updated on AUGUST 16, 2016

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.14.2 and later
Information in this document applies to any platform.

Symptoms

On :  2.15.1 version, Installation
 

In acceptance environment, a production copy (OHI version 2.14.2.0.21) was upgraded to version 2.15.1.0.0, but the upgrade failed.

TEMP space was set to 126GB.

SQL> select sum(bytes)/1024/1024/1024 from dba_temp_files;

SUM(BYTES)/1024/1024/1024
-------------------------
               126.998032

ERROR
-----------------------
SEVERE 7/15/16 10:50 PM:liquibase: Error executing SQL insert into fin_trans_detail_proc_data

java.sql.SQLException: ORA-12801: error signaled in parallel query server P046, instance lxdbdc02.hphc.org:ohipqa22 (2 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP


STEPS
-----------------------
The steps given in the 2.15.1.0.0 Release Notes were followed.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot prove they can upgrade the production database to version 15.1.

Changes

 

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