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

Do you have some huge sys/system owned segments?

catupgrd can be re-run

On Mon, Aug 31, 2015 at 11: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