Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-4023 Object SYS.STANDARD could not be validated or authorized when Upgrading RDBMS from 10.2.0.2

edited Jan 29, 2014 2:20PM in Database Install/Upgrade/Opatch (MOSC) 5 commentsAnswered
Hello Everyone,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center