ORA-4023 Object SYS.STANDARD could not be validated or authorized when Upgrading RDBMS from 10.2.0.2
Source: Win2003 32bit, Oracle 10.2.0.2
Destination: Win2008 32bit, Oracle 11.2.0.3
Due to some constraint, we are upgrading from 10.2 to 11.2 by means of restoring from RMAN (resetlogs is acceptable and expected). Both machine is isolated, no 10.2 Oracle Home available at the destination server. The source database is in production, nothing about DDL or DML can be done including @utlu112i.sql.
Database had been restored with necessary followup actions including rename redo and tempfiles.
Following ALTER DATABASE OPEN RESETLOGS UPGRADE, we did:
Case 1) SQL> @utlu112i.sql
catupgrd.sql complained "Preparation not done".
Case 2) oracle# dbua
Both complained:
ORA-4023: Object SYS.STANDARD cound not be validated or authorized.