Re: Upgrade 11.2.0.4 to 12.1.0.2 failed, unable to extend temp segment

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 31 Aug 2015 17:50:25 -0500
Message-Id: <1616AE46-C0BD-464D-9694-2C6BA49A7D6A_at_gmail.com>

My observations when running parallel ops is that oracle will allocate the DOP*(required space) in temp segments, then release what it does not use. So if your degree of parallelism is 8, oracle will allocate 8 times as much space as it needs, then release the excess when the operation completes.

Sent from my iPad

> On Aug 31, 2015, at 4:17 PM, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> I have a ticket open with Oracle support, but I'm still waiting to hear back from them. I ran the dbupgdiag.sql script. No issues reported. Ran the preupgrd.sql script which indicated temp space was adequate. It did say SYSTEM was too small so I fixed that and the job_queue_processes were too low so I adjusted it as well. Nothing else was reported. Two hours later, the
> upgrade fails with the information below. What do I need to do to complete this upgrade? Do I need to restore back to 11g and redo everything? Guidance is appreciated.
>
>
> Oracle Server
> ORA-01418: specified index does not exist
> ORA-01418: specified index does not exist
> ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
> ORA-12801: error signaled in parallel query server P000
> ORA-12801: error signaled in parallel query server P000
> ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
> ORA-01418: specified index does not exist
> ORA-01418: specified index does not exist
> ORA-12801: error signaled in parallel query server P000
> ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
> ORA-06512: at line 8
> ORA-01418: specified index does not exist
> ORA-12801: error signaled in parallel query server P000
> ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
> ORA-01418: specified index does not exist
> ORA-01418: specified index does not exist
> ORA-12801: error signaled in parallel query server P000
> ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
> ORA-01418: specified index does not exist
> ORA-01418: specified index does not exist
> Oracle Server INVALID 12.1.0.2.0 01:37:10
> JServer JAVA Virtual Machine VALID 12.1.0.2.0 00:07:49
> Oracle Workspace Manager VALID 12.1.0.2.0 00:04:05
> OLAP Analytic Workspace VALID 12.1.0.2.0 00:01:33
> OLAP Catalog OPTION OFF 11.2.0.4.0 00:00:00
> Oracle OLAP API VALID 12.1.0.2.0 00:01:41
> Oracle XDK VALID 12.1.0.2.0 00:01:45
> Oracle XML Database VALID 12.1.0.2.0 00:06:02
> Oracle Database Java Packages VALID 12.1.0.2.0 00:00:52
> Final Actions 00:03:26
>
> Total Upgrade Time: 02:06:26
>
> PL/SQL procedure successfully completed.
>
> --
> Sandy
> GHX

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 01 2015 - 00:50:25 CEST