Linux – Error during upgrade : Oracle 11g to 12c

oracleoracle-11goracle-12csuse-linuxupgrade

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.

    1. 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

Best Answer

The real error is:

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

The "solutions" you tried make no sense when you get something like this.

Fix the storage/filesystem first.