Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade to 11g failure ORA-04023

SteeveAug 28 2007 — edited May 16 2011
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2011
Added on Aug 28 2007
11 comments
23,937 views