Skip to Content
0
Former Member
Jul 07, 2011 at 10:15 AM

ORACLE Patchset 4 Upgrade

54 Views

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