sap update inactivated when system start or restart

[Former Member]

Dear experts

I am a facing an issue related to update inactivated in sm13 when ever I restart or start sap system .

and after many time I activate update from sm13 then it will start.

when I want to delete "to delete" it's give me following dump

Please guide me how to resolved this issue

Regards

[Former Member]

Dear experts

Sorry for delay , Because I am upgrading sap as well as oracle database

Scenario 1

I have done  I create a separate VM machine then create system copy in new machine using oracle database backup method ( using Production Online backup ) after creating system issue was resolved. then I have easily upgrade both sap ( from EHP to EHP7) and oracle database ( from 10g to 12c

Scenario 2

I Have creating same environment as Production ( creation new machine with PRD VMware backup  SO sap database every think same except IP )  But same issue facing infect I also upgrade oracle to 12c.

I am stuck in sap upgrade because of

When I want to delete BW open updates from SMQ1 I received same dump ORA-00600

I also trying to validate structure from BR Tools of tables VBMOD and ARFCSDATA

but same issue also with this

I will  face the same issue in my PRD during sap upgrade

Please help me out to resolved this issue

Regards

Khizer

[Former Member]

The Following are the output of job database verify in DB13 it's show 2 data file data corruption in undo table space undo 4 and undo 5

BR0278W Command output of '/oracle/PRD/102_64/bin/dbv file=/oracle/PRD/sapdata3/undo_4/undo.data4 blocksize=8192':

DBVERIFY: Release 10.2.0.5.0 - Production on Mon Oct 19 17:12:48 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle/PRD/sapdata3/undo_4/undo.data4

Page 705293 is influx - most likely media corrupt

Corrupt block relative dba: 0x0c4ac30d (file 49, block 705293)

Fractured block found during dbv:

Data in bad block:

type: 2 format: 2 rdba: 0x0c4ac30d

last change scn: 0x0001.8dc0425b seq: 0x37 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xd5970205

check value in block header: 0xda26

computed block checksum: 0x3a00

Page 1006481 is influx - most likely media corrupt

Corrupt block relative dba: 0x0c4f5b91 (file 49, block 1006481)

Fractured block found during dbv:

Data in bad block:

type: 2 format: 2 rdba: 0x0c4f5b91

last change scn: 0x0001.87e6851b seq: 0x12 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xd3e50201

check value in block header: 0x6420

computed block checksum: 0x390c

BVERIFY - Verification complete

otal Pages Examined         : 1280000

otal Pages Processed (Data) : 0

otal Pages Failing   (Data) : 0

otal Pages Processed (Index): 0

otal Pages Failing   (Index): 0

otal Pages Processed (Other): 1279998

otal Pages Processed (Seg)  : 0

otal Pages Failing   (Seg)  : 0

otal Pages Empty            : 0

otal Pages Marked Corrupt   : 2

otal Pages Influx           : 2

ighest block SCN            : 3208731970 (1.3208731970)

R0398E DBVERIFY detected corrupted blocks in /oracle/PRD/sapdata3/undo_4/undo.data4

BR0395I Verifying /oracle/PRD/sapdata3/undo_5/undo.data5 using DBVERIFY...

BR0278W Command output of '/oracle/PRD/102_64/bin/dbv file=/oracle/PRD/sapdata3/undo_5/undo.data5 blocksize=8192':

DBVERIFY: Release 10.2.0.5.0 - Production on Mon Oct 19 17:14:10 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = /oracle/PRD/sapdata3/undo_5/undo.data5

Page 797596 is influx - most likely media corrupt

Corrupt block relative dba: 0x0c8c2b9c (file 50, block 797596)

Fractured block found during dbv:

Data in bad block:

type: 2 format: 2 rdba: 0x0c8c2b9c

last change scn: 0x0001.887670be seq: 0x51 flg: 0x04

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xd81b0201

check value in block header: 0xd65a

computed block checksum: 0x5253

DBVERIFY - Verification complete

Total Pages Examined         : 1280000

Total Pages Processed (Data) : 0

Total Pages Failing   (Data) : 0

Total Pages Processed (Index): 0

Total Pages Failing   (Index): 0

Total Pages Processed (Other): 1279999

Total Pages Processed (Seg)  : 0

Total Pages Failing   (Seg)  : 0

Total Pages Empty            : 0

Total Pages Marked Corrupt   : 1

Total Pages Influx           : 1

Highest block SCN            : 3208733966 (1.3208733966)

BR0398E DBVERIFY detected corrupted blocks in /oracle/PRD/sapdata3/undo_5/undo.data5

BR0280I BRBACKUP time stamp: 2015-10-19 17.15.31

Kindly guide me how to resolved it

Best regards

[Mofizur]

Hi Shahid,

Please check below note..

99962 - Error messages when using DBVERIFY

Thanks,

Mofizur

[Former Member]

Hello Khizer,

There are different ways with differing degrees of difficulty to resolve this (depending on your comfort level with Oracle).

Once again depending on your comfort level, the simplest and easiest way would be to:

1. Create a new (temporary) PSAPUNDO99 tablespace

2. Update your spfile to use new PSAPUNDO99 tablespace.

3. Restart Oracle

4. Drop old PSAPUNDO tablespace

5. Create PSAPUNDO tablespace

6. Update your spfile to use PSAPUNDO

7. Restart Oracle

KR,

Amerjit

[isaias_freitas]

Hello,

As you can see at the SM21 entries you have shared, the error ORA-00600 is being raised at the Oracle end.

SAP is then deactivating the update mechanism as it will not be able to perform updates at the database.

The ORA-00600 error must be fixed.

I'm sorry that I cannot give more inputs on the ORA-00600, I do not have knowledge in Oracle.

Regards,

Isaías

[Mofizur]

Hi,

Seems the problem is with Oracle DB.May be The tablespace that is too small (or a DB error in general) forces a ROLLBACK in ABAP. However, since rollbacks or commits are not allowed in the update, a short dump occurs.

Please check the Oracle alert log for more.

376755 - ORA-00600 - what to do?

Thanks,

Mofizur

[Former Member]

Thanks Mofizur

My rollback table space is OK 

select segment_name, tablespace_name, status from dba_rollback_segs;

show segment offline and online no recovery require is the output

following the output of PRD_ora_xx.trc

*** 2015-10-16 14:11:08.297

*** ACTION NAME:(11664) 2015-10-16 14:11:08.296

*** MODULE NAME:(RSM13000) 2015-10-16 14:11:08.296

*** SERVICE NAME:(SYS$USERS) 2015-10-16 14:11:08.296

*** SESSION ID:(64.5) 2015-10-16 14:11:08.296

Dump of buffer cache at level 10 for tsn=4, rdba=59849286

BH (0x296fc79e8) file#: 14 rdba: 0x03913a46 (14/1129030) class: 1 ba: 0x29699a000

  set: 22 blksize: 8192 bsi: 0 set-flg: 2 pwbcnt: 148

  dbwrid: 1 obj: 289483 objn: 289483 tsn: 4 afn: 14

  hash: [35f907cd0,35f907cd0] lru: [296fc7b78,296fc7958]

  ckptq: [NULL] fileq: [NULL] objq: [35a810768,35a810768]

  st: XCURRENT md: NULL tch: 1

  flags: gotten_in_current_mode

  LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]

  buffer tsn: 4 rdba: 0x03913a46 (14/1129030)

  scn: 0x0001.8d911209 seq: 0x01 flg: 0x04 tail: 0x12090601

  frmt: 0x02 chkval: 0x813e type: 0x06=trans data

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x000000029699A000 to 0x000000029699C000

29699A000 0000A206 03913A46 8D911209 04010001  [....F:..........]

29699A010 0000813E 00000001 00046ACB 8D911209  [>........j......]

29699A020 00000001 00320002 03913989 00000000  [......2..9......]

29699A030 00000000 00000000 00000000 00000000  [................]

        Repeat 2 times

29699A060 00000000 00000000 000EFFFF 1F8A1F98  [................]

29699A070 00001F8A 00000000 00000000 000C0100  [................]

29699A080 002AFFFF 03E80412 000003E8 1D37000C  [..*...........7.]

29699A090 18AF1AF4 1427166C 0F7811E4 0ADF0D22  [....l.'...x."...]

29699A0A0 0657089A 00000412 00000000 00000000  [..W.............]

29699A0B0 00000000 00000000 00000000 00000000  [................]

        Repeat 60 times

29699A480 00000000 00000000 00000000 002C0000  [..............,.]

29699A490 3031038A 30300A30 30333030 32343639  [..100.0000309642]

29699A4A0 30303008 30303030 30320831 38303031  [.00000001.201008]

29699A4B0 46053031 4E494F4D 30303008 30303030  [10.FMOIN.0000000]

29699A4C0 08200130 30313032 30313830 30303108  [0. .20100810.100]

29699A4D0 37303030 30310430 20013030 80012001  [00070.1000. . ..]

29699A4E0 53032001 80014454 44545303 1A25C103  [. .STD...STD..%.]

29699A4F0 44545303 20018001 20018001 20018001  [.STD... ... ... ]

29699A500 30038001 80013030 20012001 20018001  [...000... . ... ]

29699A510 20012001 C1022001 03200106 033D58C2  [. . . .... ..X=.]

29699A520 013D58C2 41500380 4150034B 0820014B  [.X=...PAK.PAK. .]

29699A530 30303030 30303030 31303208 31383030  [00000000.2010081]

29699A540 35310630 36303730 30303008 30303030  [0.150706.0000000]

29699A550 30300630 30303030 30303008 30303030  [0.000000.0000000]

        Repeat 2 times

29699A580 30300630 30303030 31303208 31383030  [0.000000.2010081]

29699A590 35310630 36303730 30303008 30303030  [0.150706.0000000]

29699A5A0 30300630 30303030 20012001 58015801  [0.000000. . .X.X]

29699A5B0 31012001 300A2001 30303030 35333431  [. .1. .000001435]

29699A5C0 30300835 30303030 300C3232 30303530  [5.00000022.00500]

29699A5D0 39303030 06353430 30303030 30043030  [0009045.000000.0]

29699A5E0 08303830 30303030 30303030 20018001  [080.00000000... ]

29699A5F0 80012001 58012001 20018001 80012001  [. ... .X... . ..]

29699A600 20012001 20018001 80012001 20012001  [. . ... . ... . ]

29699A610 20018001 80012001 20012001 30303008  [... . ... . .000]

29699A620 30303030 59C20330 30300A1E 30303030  [00000..Y..000000]

29699A630 30303030 30303008 30303030 30300C30  [0000.00000000.00]

29699A640 30303030 30313931 30083238 30303030  [0000191082.00000]

29699A650 01303030 30300880 30303030 36013030  [000...00000000.6]

29699A660 30044D01 01303030 01200120 03200180  [.M.0000. . ... .]

29699A670 0630344C 37303531 80013731 80012001  [L40.150717... ..]

29699A680 80012001 20012001 30082001 30303030  [. ... . . .00000]

29699A690 06303030 30303030 20013030 20018001  [000.000000. ... ]

29699A6A0 20012001 20012001 300A2001 30303030  [. . . . . .00000]

29699A6B0 30303030 00001030 00000000 00000000  [00000...........]

29699A6C0 00000000 20010000 20012001 20018001  [....... . . ... ]

29699A6D0 2C06C102 31038A00 300A3030 33303030  [...,...100.00003]

29699A6E0 34363930 30300830 30303030 32083130  [09640.00000001.2]

29699A6F0 30303130 05303138 494F4D46 3030084E  [0100810.FMOIN.00]

29699A700 30303030 20013030 31303208 31383030  [000000. .2010081]

29699A710 30310830 30303030 31043334 01303030  [0.10000043.1000.]

29699A720 01200120 03200180 03445453 031A08C1  [ . ... .STD.....]

29699A730 01445453 54530380 01800144 01800120  [STD...STD... ...]

29699A740 01800120 03800120 01303030 01200180  [ ... ...000... .]

29699A750 01800120 01200120 01200120 03200180  [ ... . . . ... .]

29699A760 033D58C2 013D58C2 41500380 4150034B  [.X=..X=...PAK.PA]

29699A770 0820014B 30303030 30303030 31303208  [K. .00000000.201]

29699A780 30383030 38300639 30303033 30303008  [00809.083000.000]

29699A790 30303030 30300630 30303030 30303008  [00000.000000.000]

        Repeat 2 times

29699A7C0 30303030 30300630 30303030 31303208  [00000.000000.201]

29699A7D0 30383030 34310639 38343332 30303008  [00809.142348.000]

29699A7E0 30303030 30300630 30303030 20012001  [00000.000000. . ]

29699A7F0 58015801 31012001 300A2001 30303030  [.X.X. .1. .00000]

29699A800 35333431 30300835 30303030 300C3032  [14355.00000020.0]

29699A810 30303530 39303030 06353430 30303030  [05000009045.0000]

29699A820 30043030 08303630 30303030 30303030  [00.0060.00000000]

29699A830 20018001 80015801 20012001 20018001  [... .X... . ... ]

29699A840 80012001 20012001 20018001 80012001  [. ... . ... . ..]

29699A850 20012001 20018001 80012001 20012001  [. . ... . ... . ]

29699A860 30303008 30303030 59C20330 30300A1E  [.00000000..Y..00]

29699A870 30303030 30303030 30303008 30303030  [00000000.0000000]

29699A880 30300C30 30303030 30313931 30083138  [0.000000191081.0]

29699A890 30303030 01303030 30300880 30303030  [0000000...000000]

29699A8A0 36013030 30044D01 01303030 01200120  [00.6.M.0000. . .]

29699A8B0 03200180 0630344C 37303531 80013130  [.. .L40.150701..]

29699A8C0 80012001 80012001 20012001 30082001  [. ... ... . . .0]

29699A8D0 30303030 06303030 30303030 20013030  [0000000.000000. ]

29699A8E0 20018001 20012001 20012001 300A2001  [... . . . . . .0]

29699A8F0 30303030 30303030 00001030 00000000  [000000000.......]

29699A900 00000000 00000000 20010000 20012001  [........... . . ]

29699A910 20018001 002C8001 3031038A 30300A30  [... ..,...100.00]

29699A920 30333030 38333639 30303008 30303030  [00309638.0000000]

29699A930 30320831 38303031 46053031 4E494F4D  [1.20100810.FMOIN]

29699A940 30303008 30303030 08200130 30313032  [.00000000. .2010]

29699A950 30313830 30303108 38303030 30310436  [0810.10000086.10]

29699A960 20013030 80012001 53032001 80014454  [00. . ... .STD..]

29699A970 44545303 3304C103 44545303 20018001  [.STD...3.STD... ]

29699A980 20018001 20018001 30038001 80013030  [... ... ...000..]

29699A990 20012001 20018001 20012001 C1022001  [. . ... . . . ..]

29699A9A0 03200104 033D58C2 013D58C2 41500380  [.. ..X=..X=...PA]

29699A9B0 4150034B 0820014B 30303030 30303030  [K.PAK. .00000000]

29699A9C0 31303208 31383030 35310630 33333630  [.20100810.150633]

29699A9D0 30303008 30303030 30300630 30303030  [.00000000.000000]

        Repeat 3 times

29699AA10 31303208 31383030 35310630 33333630  [.20100810.150633]

29699AA20 30303008 30303030 30300630 30303030  [.00000000.000000]

29699AA30 20012001 58015801 31012001 300A2001  [. . .X.X. .1. .0]

29699AA40 30303030 35333431 30300835 30303030  [000014355.000000]

29699AA50 300C3831 30303530 39303030 06353430  [18.005000009045.]

29699AA60 30303030 30043030 08303430 30303030  [000000.0040.0000]

29699AA70 30303030 20018001 80012001 58012001  [0000... . ... .X]

29699AA80 20018001 80012001 20012001 20018001  [... . ... . ... ]

29699AA90 80012001 20012001 20018001 80012001  [. ... . ... . ..]

29699AAA0 20012001 30303008 30303030 59C20330  [. . .00000000..Y]

29699AAB0 30300A1E 30303030 30303030 30303008  [..0000000000.000]

29699AAC0 30303030 30300C30 30303030 30313931  [00000.0000001910]

29699AAD0 30083038 30303030 01303030 30300880  [80.00000000...00]

29699AAE0 30303030 36013030 30044D01 01303030  [000000.6.M.0000.]

29699AAF0 01200120 03200180 0630344C 36303531  [ . ... .L40.1506]

29699AB00 80013634 80012001 80012001 20012001  [46... ... ... . ]

29699AB10 30082001 30303030 06303030 30303030  [. .00000000.0000]

29699AB20 20013030 20018001 20012001 20012001  [00. ... . . . . ]

29699AB30 300A2001 30303030 30303030 00001030  [. .0000000000...]

29699AB40 00000000 00000000 00000000 20010000  [............... ]

29699AB50 20012001 20018001 2C03C102 31038A00  [. . ... ...,...1]

29699AB60 300A3030 33303030 33363930 30300836  [00.0000309636.00]

29699AB70 30303030 32083130 30303130 05303138  [000001.20100810.]

29699AB80 494F4D46 3030084E 30303030 20013030  [FMOIN.00000000. ]

29699AB90 31303208 31383030 30310830 30303030  [.20100810.100000]

Block header dump:  0x03913a46

Object id on Block? Y

seg/obj: 0x46acb  csc: 0x01.8d911209  itc: 2  flg: E  typ: 1 - DATA

     brn: 0  bdba: 0x3913989 ver: 0x01 opc: 0

     inc: 0  exflg: 0

Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

0x01   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

data_block_dump,data header at 0x29699a064

===============

tsiz: 0x1f98

hsiz: 0xe

pbl: 0x29699a064

bdba: 0x03913a46

     76543210

flag=--------

ntab=0

nrow=0

frre=-1

fsbo=0xe

fseo=0x1f98

avsp=0x1f8a

tosp=0x1f8a

block_row_dump:

end_of_block_dump

*** 2015-10-16 14:11:08.416

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [13011], [289483], [59849286], [26], [59849286], [4], [], []

Current SQL statement for this session:

DELETE FROM "VBMOD" WHERE "VBKEY" = :A0

----- Call Stack Trace -----

calling              call     entry                argument values in hex     

location             type     point                (? means dubious value)    

-------------------- -------- -------------------- ----------------------------

ssd_unwind_bp: unhandled instruction at 0x721031 instr=f

ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?

                                                   7FFF5ABC6550 ? 7FFF5ABC65B0 ?

                                                   7FFF5ABC64F0 ? 000000000 ?

ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?

                                                   7FFF5ABC6550 ? 7FFF5ABC65B0 ?

                                                   7FFF5ABC64F0 ? 000000000 ?

Output of Alert.log

Fri Oct 16 14:10:01 UZT 2015

Completed: ALTER DATABASE OPEN

Fri Oct 16 14:10:06 UZT 2015

Beginning log switch checkpoint up to RBA [0x237d.2.10], SCN: 7503371965

Fri Oct 16 14:10:06 UZT 2015

Thread 1 advanced to log sequence 9085 (LGWR switch)

  Current log# 1 seq# 9085 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf

  Current log# 1 seq# 9085 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf

Fri Oct 16 14:11:08 UZT 2015

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_24934.trc:

ORA-00600: internal error code, arguments: [13011], [289483], [59849286], [26], [59849286], [4], [], []

Fri Oct 16 14:11:08 UZT 2015

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_24936.trc:

ORA-00600: internal error code, arguments: [13011], [289483], [59849286], [46], [59849286], [4], [], []

Fri Oct 16 14:11:09 UZT 2015

Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_24927.trc:

ORA-00600: internal error code, arguments: [13011], [289483], [59849286], [0], [59849286], [4], [], []

Fri Oct 16 14:11:30 UZT 2015

Beginning log switch checkpoint up to RBA [0x237e.2.10], SCN: 7503375633

Fri Oct 16 14:11:30 UZT 2015

Thread 1 advanced to log sequence 9086 (LGWR switch)

  Current log# 2 seq# 9086 mem# 0: /oracle/PRD/origlogB/log_g12m1.dbf

  Current log# 2 seq# 9086 mem# 1: /oracle/PRD/mirrlogB/log_g12m2.dbf

Fri Oct 16 14:15:10 UZT 2015

Completed checkpoint up to RBA [0x237d.2.10], SCN: 7503371965

Fri Oct 16 14:16:34 UZT 2015

Completed checkpoint up to RBA [0x237e.2.10], SCN: 7503375633

Regards