Upgrade to 11g failure ORA-04023
SteeveAug 28 2007 — edited May 16 2011I installed OEL5. Then Installed Oracle 11g. Note that this is a fresh install, i don't have 10g installed on that machine. I copied a database from another Linux machine. That database has been shutdown cleanly(shutdown immediate).
I'm following the Oracle® Database Upgrade Guide: http://download.oracle.com/docs/cd/B28359_01/server.111/b28300.pdf
I ran the netca before running the dbua.
I ran the dbua, got a weird error.(i dont have that error details)
I decided to check the alertlog, which was giving me the following 2 errors:
Error 1:
Deprecated system parameters with specified values:
background_dump_dest
user_dump_dest
End of deprecated system parameter listing
Error 2:
Errors in file /opt/oracle/app/oracle/diag/rdbms/jukprprd/jukprprd/trace/jukprprd_rvwr_18783.trc:
ORA-38701: Flashback database log 22 seq 22 thread 1: "/OraArch1/JUKPRPRD/flashback/o1_mf_3dvpb149_.flb"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
So i removed the dest parameter in my init.ora file.
I i did startup mount;
alter database flashback off;
To get rid of the flashback error(i copied the datafiles and control files, but i did not copied the fra from my clean shutdowned database).
Anyways, i restarted the dbua and i received the following error:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
If i run manualy the utlu111i.sql script, i get;
SQL> @utlu111i.sql
ERROR:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
DECLARE
*
ERROR at line 1:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
ERROR:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
Anyone has experience this error? google and metalink gives nothing regarding this error:
The only result i get from google is the following:
ORA-04023: Object stringstringstringstringstring could not be validated or authorized
Cause: A number of attempts were made to validate or authorize an object but failed.
Action: Please report this error to Oracle Support Services.
I will create a tar for this if this post those not help.