on 07-30-2009 11:17 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.