ORA-7445 followed by ORA-472

[Former Member]

Hi All,

My System Configuration is

CPU: Intel Xeon Dual Core 2.5GHz.

RAM: 8 GB

Databse : Oracle 10.2.0.2

Interim Oracle Patch: 18

SAP: Solution Manager

OS: Windows 2003 Standard Edition x86_64

I have install the system successfully. I stop the SAP system & database for backup but is not starting while I chek the log files I found that the database is crashed. I check the log files & found the below error

Dump file f:\oracle\smn\saptrace\background\smn_pmon_3160.trc

Tue Jul 28 17:23:42 2009

ORACLE V10.2.0.2.0 - 64bit Production vsnsta=0

vsnsql=14 vsnxtr=3

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

Process Id: 0x00000cd4 Thread Id : 0x00000c58 Time : Tue Jul 28 17:23:42

Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

-

---

Registers -

---

ip=0000000077EF1CD6 sp=000000000BB7B628 rp=0000000000000000

r1=000000003AF40000 r2=00000000049D0E50 r3=00000000000001D0

r4=0000000000000010 r5=000000000BB7B628 r6=0000000000000000 r7=00000000049D0E50

r8=00000000049D0000 r9=0000000000000048 r10=0000000000000000 r11=0000000000000000

r12=0000000000000246 r13=0000000000000000 r14=0000000000000006 r15=0000000000000048

-

---

End of Registers -

---

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Abrupt exit from ksedmp in Exception Handler

• 2009-07-28 17:23:42.140

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77EF1CD6] [ADDR:0x1D0] [UNABLE_TO_READ] []

----- Call Stack Trace -

---

calling call entry argument values in hex

location type point (? means dubious value)

-

---

-

---

-

---

-

---

0000000077EF1CD6 0000000000000000 000000000 000000000 000000000

000000000

0000000077EF3CB7 CALL??? 0000000077EF1CD6 000000000 077EF3B0C 000000001

000000100

000007FF771B813D CALL??? 0000000077EF3CB7 000000010 000000000 000000048

000000010

0000000000000010 CALL??? 000007FF771B813D 000000000 000000048 000000010

000000000

-

---

Binary Stack Dump -

---

========== FRAME [1] (0000000077EF1CD6 -> 0000000000000000) ==========

Inaccessible memory range: 0000000000000000 -> 0000000000000400

========== FRAME [2] (0000000077EF3CB7 -> 0000000077EF1CD6) ==========

Dump of memory from 0x000000000BB7B620 to 0x000000000BB7B870

00BB7B620 00460019 00000001 77EF3CB7 00000000 [..F......<.w....]

00BB7B630 00000000 00000000 77EF3B0C 00000000 [.........;.w....]

00BB7B640 00000001 00000000 00000100 00000000 [................]

00BB7B650 00000000 00000000 00000000 00000000 [................]

In alert_sid.log file is

ALTER DATABASE MOUNT

Tue Jul 28 17:23:42 2009

Errors in file f:\oracle\smn\saptrace\background\smn_pmon_3160.trc:

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x77EF1CD6] [ADDR:0x1D0] [UNABLE_TO_READ] []

Tue Jul 28 17:23:44 2009

PSP0: terminating instance due to error 472

Tue Jul 28 17:23:44 2009

Errors in file f:\oracle\smn\saptrace\background\smn_mman_3164.trc:

ORA-00472: PMON process terminated with error

I am not able to understand the error is due to memory or I have missed something to apply.

Please help me to solve this.

Thanks,

Sachin

[Former Member]

Sachin,

Your SMON and PMON process died .Check memory,Swap Space

Note 541695 - ORA-00470/ORA-00471/ORA-00472/ORA-00473/ORA-00474

ORA-7445 related to OS (Generally AIX) -Note 833535 - ORA-7445: exception encountered: core dump [kghalf]

Try to start only db through db only check sga size should be > 512M.

SurendraJain

Edited by: Surendrajain2003 on Jul 31, 2009 4:35 PM

Edited by: Surendrajain2003 on Jul 31, 2009 4:36 PM

[markus_doehr2]

> OS: Windows 2003 Standard Edition x86_64

Standard edition is not supported for SAP systems...

For you error: I suggest upgrading to 10.2.0.4 plus latest interim patch. If the error still occurs then, I'd open an OSS call to let the support investigaTe.

Markus

[Former Member]

Hi Markus,

Thanks for your quick reply.

As per the Standard SAP Installation Guide Windows Server 2003 Standard / Enterprise / Datacenter Edition is suppoted.

See the document Page 48 Hardware and Software requirements.

[https://websmp206.sap-ag.de/~sapidb/011000358700000512392008E/solman_40_sr4_win_ora.pdf]

Thanks,

Shambo

[markus_doehr2]

> As per the Standard SAP Installation Guide Windows Server 2003 Standard / Enterprise / Datacenter Edition is suppoted.

You're right - I was wrong - I wasn't aware of that.

Markus

[former_member204746]

follow Markus' recommendation of upgrading to 10.2.0.4 and also install minipatch 22 or above if it is available.