ORACLE Patchset 4 Upgrade

[Former Member]

Hello,

done a ORACLE Patchset 4 Upgrade from 10.2.0.2 up to 10.2.0.5 on AIX 5.3 - including all Pre - and Post Installation Tasks listed in the Readme Files -

especially testet the Timezone conditions before the upgrade to Patchset 4 - everything okay

everything works fine on my System - but since finished the Upgrade getting a trace file every hour in /oracle/<SID>/saptrace/background in form

e11_m000_1101826.trc

with the following ORA-00904 Error

root@rottalegg:/oracle/E11/saptrace/background> cat e11_m000_1101826.trc

Dump file /oracle/E11/saptrace/background/e11_m000_1101826.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/E11/102_64

System name: AIX

Node name: rottalegg

Release: 3

Version: 5

Machine: 00066107D600

Instance name: E11

Redo thread mounted by this instance: 1

Oracle process number: 45

Unix process pid: 1101826, image: oracle@rottalegg (m000)

• ACTION NAME:(Auto-Flush Slave Action) 2011-07-07 12:00:13.537

• MODULE NAME:(MMON_SLAVE) 2011-07-07 12:00:13.537

• SERVICE NAME:(SYS$BACKGROUND) 2011-07-07 12:00:13.537

• SESSION ID:(265.1255) 2011-07-07 12:00:13.537

• KEWROCISTMTEXEC - encountered error: (ORA-00904: "SYS"."DBMSSWRF_INTERNAL"."AWR_DECODE_OBJECT_TYPE": invalid identifier_

)

• SQLSTR: total-len=1815, dump-len=240,

STR={insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type }

• KEWRAFM1: Error=13509 encountered by kewrfteh

could not find any resolving task anywhere - DB and SAP System is running without any Problems or Error Messages otherwhere

Thanks for a Feedback

Regards

Peter

[Former Member · Accepted solution]

Hi,

This happens while refereeing an invalid alias in a select statement.

Run catproc.sql script to fix this error.

Refer Note 662644 - Composite SAP Note: ORA-00942

Regards,

SBK

[Former Member · Accepted solution]

Hello,

thanks for answering so quick - but have still one question belong to Note 582427 - I have done script catupgrd.sql immediately after the upgrade with dbua in STARTUP UPGRADE mode followed by script utlrp.sql in STARTUP NORAMAL mode - I could read in note 582427 that this script catupgrd.sql do the same for ORACLE >= 10.2 as the catproc.sql and catalog.sql for ORACLE DB 9i -

My question - where is the difference in running catproc.sql on my ORACLE >=10.2 and furthermore when running catproc.sql I have to rerun utlrp.sql again ??? cause of this

running catalog and catproc will make your packages/procedures invalid. You will have to recompile them.

Thanks for feedback

Regards

Peter

[Former Member · Accepted solution]

Thanks a lot - I have done your workaround and it fixes the problem -

first done catproc.sql and second done utlrp.sql being sure not having any invalid objekts in DB -

works perfect

thanks

peter