DB check finished with warnings

[mohsin_m3]

Hello All,

In SAPCHECK latesh .chk file finished with warnings

BR0280I BRCONNECT time stamp: 2009-03-26 10.30.46

BR0815I Number of indexes in schema of owner SAPAUTH: 2

BR0815I Number of indexes in schema of owner SAPR3: 49400

BR0815I Number of indexes in schema of owner SYS: 299

BR0815I Number of indexes/partitions in schema of owner SYSTEM: 228/24

BR0838W Table YSEX_UPL2SAP_1001 not found for segment SAPR3.YSEX_UPL2SAP_1001 - ignoring segment

Kindly help me to resolve the issue.

Regards

Mohsin Mulani

[Former Member]

Mohsin,

Do you see any corrosponding entries into table DBMSGORA? You can access this table via se16. You can also use DB16 for more information.

Manoj

Edited by: Manoj Chintawar on Mar 27, 2009 11:06 AM

[mohsin_m3]

Hello Manoj,

Today i have check latest .chk file in sapcheck folder and found following warnings

ORA-00600: internal error code, arguments: [17069], [0xC0000000A7CDA0D8], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 293225, time: 2009-03-27 10.31.03, message:

ORA-00600: internal error code, arguments: [17069], [0xC0000000A7CDA0D8], [], [], [], [], [], []

BR0976W Database message alert - level: ERROR, line: 293228, time: 2009-03-27 10.31.05, message:

ORA-00600: internal error code, arguments: [17069], [0xC0000000A7CDA0D8], [], [], [], [], [], []

Please help me

Regards

Mohsin

[Former Member]

Mohsin,

Have you made any upgrades to oracle?

Manoj

[mohsin_m3]

Hello Manoj,

U r upsulately right...

Oracle upgrade is going on...

Regards

Mohsin

[Former Member]

Mohsin,

Please check out following link.

[]

Please also check following notes.

Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4

Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0.

Hope this helps.

Manoj

[Former Member]

Hi Mohsin,

Include OBJECT_TYPE also ih the select command

select LAST_DDL_TIME, STATUS , OBJECT_NAME, OBJECT_TYPE from dba_objects

where object_name='YSEX_UPL2SAP_1001 ' ;

And let us know.

Thanks

Manoj

[Former Member]

Was there a recent change for the object 'mentioned ' done in oracle.

Please give us the command you are using for the sapcheck. Also check the object YSEX_UPL2SAP_1001 from database level .

select LAST_DDL_TIME, STATUS , OBJECT_NAME from dba_objects

where object_name='YSEX_UPL2SAP_1001 ' ;

Thanks

Rishi