Sample Header Ad - 728x90

Error during upgrade : Oracle 11g to 12c

0 votes
1 answer
549 views
While upgrading catupgrade.sql, we are getting below error. >Due to errors found during the upgrade process, the post upgrade actions in catuppst.sql have not been automatically run. >*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE *** > 1. Evaluate the errors found in the upgrade logs and determine the proper action. 2. Execute the post upgrade script as described in Chapter 3 of the Database Upgrade Guide. >REASON: catuppst.sql unable to run in Database: EluxTest Id: 0 ERRORS FOUND: during upgrade CATCTL ERROR COUNT=6 ------------------------------------------------------ >Identifier CATALOG 20-01-27 02:20:04 Script = c1102000.sql ERROR = [ORA-12801: error signaled in parallel query server P000 ORA-01115: IO error reading block from file (block # ) >ORA-01115: IO error reading block from file 2 (block # 215616) >ORA-27072: File I/O error >Additional information: 4 >Additional information: 215616 >Additional information: 212992 >ORA-06512: at line 8 ] STATEMENT = [BEGIN EXECUTE IMMEDIATE 'create unique index WRH$_EVENT_HISTOGRAM_PK on WRH$_EVENT_HISTOGRAM (dbid, snap_id, instance_number, event_id, wait_time_milli, con_dbid) local nologging parallel tablespace sysaux'; EXCEPTION WHEN OTHERS THEN IF (SQLCODE = -942) THEN NULL; ELSE RAISE; END IF; END;] Tried various solutions mentioned below posted online in various forums, but nothing worked. - Increased SGA to 6GB - Altered Data file sysaux01 to AUTOEXTEND OFF - Altered datafile to ONLINE
Asked by Omega (1 rep)
Jan 27, 2020, 12:20 PM
Last activity: Jan 27, 2020, 12:29 PM