Startup upgrade, add temp space, and re-run catupgrd.
Sent from my iPad
On Aug 31, 2015, at 6:38 PM, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
I have no problem adding space to TEMP, I'm just not sure how I would do it
at this point since some things were upgraded to 12c. Do I try to open the
database as 12c and re-run the perl upgrade script or just catupgrd? Or do I
try to open it as 11g? Or do I restore and start the process all over?
Sandy
On Mon, Aug 31, 2015 at 3:53 PM, Ls Cheng <exriscer@xxxxxxxxx> wrote:
Hi
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@xxxxxxxxx>
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
--
Sandy
GHX
