SAP oracle database crash with errore:ORA-00490: PSP process terminated

[Former Member]

Hi ALL,

Our oracle database crash with errore code in trace : ORA:00490; i started database again and it working fine; but could not fine reason of down and what is this erroe all about

can some help me

Errors in file /oracle/SRD/saptrace/background/srd_pmon_28096.trc:

ORA-00490: PSP process terminated with error

Tue Nov 25 09:00:57 2008

PMON: terminating instance due to error 490

Instance terminated by PMON, pid = 28096

Thanks,

Dinesh

[stefan_koehler · Accepted solution]

Hello Dinesh,

please post the content of the tracefile "/oracle/SRD/saptrace/background/srd_pmon_28096.trc".

Regards

Stefan

[Former Member]

Hi Dinesh,

For ORA-00490: PSP process terminated with error , this error will occur because of the process spawner died .

What Spawner process will do: Spawne process is like ora_psp0_<SID> - The Process Spawner will spawn Oracle processes as needed.

Resolution : Warm start instance

Hope your doubt is cleared.

Thanks

Kishore

[Former Member]

Hi stefen,

please find the trace file as below

/oracle/SRD/saptrace/background/srd_pmon_28096.trc

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

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/SRD/102_64

System name: SunOS

Node name: nzlsfn23

Release: 5.10

Version: Generic_137111-01

Machine: sun4u

Instance name: SRD

Redo thread mounted by this instance: 1

Oracle process number: 2

Unix process pid: 28096, image: oracle@nzlsfn23 (PMON)

• 2008-11-25 09:00:57.497

• SERVICE NAME:(SYS$BACKGROUND) 2008-11-25 09:00:56.210

• SESSION ID:(24.1) 2008-11-25 09:00:56.194

Background process PSP0 found dead

Oracle pid = 6

OS pid (from detached process) = 28098

OS pid (from process state) = 28098

dtp = 38000afd8, proc = 497000860

Dump of memory from 0x000000038000AFD8 to 0x000000038000B020

38000AFD0 00000005 00000000 [........]

38000AFE0 00000004 97000860 00000000 00000000 [.......`........]

38000AFF0 00000000 50535030 00020000 00000000 [....PSP0........]

38000B000 00006DC2 00000000 00000000 48E50DA4 [..m.........H...]

38000B010 00000001 000E3273 00040081 00000000 [......2s........]

Dump of memory from 0x0000000497000860 to 0x0000000497001048

497000860 02010000 00000000 00000000 00000000 [................]

497000870 00000000 00000000 00000000 00000000 [................]

497000880 00000004 97042570 00000004 97047810 [......%p......x.]

497000890 00000004 97028E68 00000004 97045BE8 [.......h......[.]

4970008A0 00000000 00000000 00000004 97045C70 [..............\p]

4970008B0 00000004 97045C70 00000004 97047800 [......\p......x.]

4970008C0 01060000 00000000 00000004 97025ED8 [..............^.]

4970008D0 00000004 97028E68 00000006 00000000 [.......h........]

4970008E0 00000000 00000000 00000000 00000000 [................]

4970008F0 00000000 00000000 00000004 97042490 [..............$.]

497000900 00000004 970425A0 00000000 00000000 [......%.........]

497000910 00000000 00000000 00000000 00000000 [................]

Repeat 3 times

497000950 00000003 00000000 00000000 00000000 [................]

Repeat 1 times

497000970 00000000 00000000 00000000 00000000 [................]

497000980 00000004 00000000 00000000 00000000 [................]

497000990 00000003 00000000 00000000 00000000 [................]

Repeat 1 times

4970009B0 00000004 00000000 00000000 00000000 [................]

4970009C0 00000005 00000000 00000000 00000000 [................]

4970009D0 00000003 00000000 00000000 00000000 [................]

4970009E0 00000000 00000000 00000000 00000000 [................]

Repeat 8 times

497000A70 00000000 00000000 00000004 97000A78 [...............x]

497000A80 00000004 97000A78 00000000 00000000 [.......x........]

497000A90 00000000 00000000 00000004 97000A98 [................]

497000AA0 00000004 97000A98 00000000 00000000 [................]

497000AB0 00000000 00000000 00000000 00000000 [................]

Repeat 2 times

497000AE0 00000000 00000000 00000018 00000030 [...............0]

497000AF0 00000001 00000B3D 00000004 970037D0 [.......=......7.]

497000B00 00000004 580096B0 00000001 00000000 [....X...........]

497000B10 00000000 00000000 00000000 00000000 [................]

Repeat 2 times

497000B40 00006DC2 00000000 00000000 00000000 [..m.............]

497000B50 00000000 00000000 00000000 00000000 [................]

Repeat 2 times

497000B80 00000004 97000860 00000000 00000000 [.......`........]

497000B90 00000000 00000000 00000000 00000000 [................]

Repeat 7 times

497000C10 00000004 97000C10 00000004 97000C10 [................]

497000C20 00000000 00000000 00010000 00000000 [................]

497000C30 00000000 00000117 0000000A 00000000 [................]

497000C40 00006DC2 00000000 00000000 48E50DA4 [..m.........H...]

497000C50 00000001 00000000 00000000 00000000 [................]

497000C60 00000000 00000000 00000000 00000000 [................]

Repeat 2 times

497000C90 00000000 00000000 00000003 FFFFFFFF [................]

497000CA0 00000000 00000000 00000000 00000000 [................]

Repeat 13 times

497000D80 73726461 646D0000 00000000 00000000 [srdadm..........]

497000D90 00000000 00000000 00000000 00000000 [................]

497000DA0 00000000 00000006 6E7A6C73 666E3233 [........nzlsfn23]

497000DB0 00000000 00000000 00000000 00000000 [................]

Repeat 2 times

497000DE0 00000000 00000000 00000000 00000008 [................]

497000DF0 554E4B4E 4F574E00 00000000 00000000 [UNKNOWN.........]

497000E00 00000000 00000000 00000000 00000000 [................]

497000E10 00000000 00000008 32383039 38000000 [........28098...]

497000E20 00000000 00000000 00000000 00000000 [................]

497000E30 00000000 00000005 6F726163 6C65406E [........oracle@n]

497000E40 7A6C7366 6E323320 28505350 30290000 [zlsfn23 (PSP0)..]

497000E50 00000000 00000000 00000000 00000000 [................]

497000E60 00000000 00000000 00000000 00000016 [................]

497000E70 00000000 00000002 00000000 00000000 [................]

497000E80 00000000 00000000 00000000 00000000 [................]

Repeat 8 times

497000F10 00000000 00000000 00000000 00020000 [................]

497000F20 00000000 00000000 00000000 00000000 [................]

497000F30 00000000 00000000 00000003 9E1F6748 [..............gH]

497000F40 00000004 97001728 00000004 97000758 [.......(.......X]

497000F50 00000000 00000000 00000003 9E26B5B0 [.............&..]

497000F60 00000000 00000000 00000000 00000000 [................]

Repeat 1 times

497000F80 00000004 97000F80 00000004 97000F80 [................]

497000F90 00000000 00040000 00000000 00000000 [................]

497000FA0 00000000 00031A55 00000000 0004D7DD [.......U........]

497000FB0 00000000 00071A55 00000000 00000000 [.......U........]

497000FC0 00000000 00000000 00000000 00000000 [................]

497000FD0 00000000 00000828 00000000 000000E0 [.......(........]

497000FE0 00000000 00000828 00000000 00000000 [.......(........]

497000FF0 00000000 00000000 00000000 00000000 [................]

Repeat 4 times

497001040 00000002 00000000 [........]

error 490 detected in background process

ORA-00490: PSP process terminated with error