Dear All,
DB version : Oracle 10.2.0.3 EE
OS : AIX 5300-10
Recently, the database just restarted by itself. I've looked at the alert.log, but can't determine why it crashed.
Wed Dec 23 19:04:08 2009
Starting background process EMN0
EMN0 started with pid=22, OS id=848092
Wed Dec 23 19:04:08 2009
Shutting down instance: further logons disabled
Wed Dec 23 19:04:08 2009
Stopping background process CJQ0
Wed Dec 23 19:04:08 2009
Stopping background process MMNL
Wed Dec 23 19:04:09 2009
Stopping background process MMON
Wed Dec 23 19:04:10 2009
Shutting down instance (immediate)
License high water mark = 13
Wed Dec 23 19:04:10 2009
Stopping Job queue slave processes
Wed Dec 23 19:04:10 2009
Process OS id : 860378 alive after kill
Errors in file
Wed Dec 23 19:04:11 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Dec 23 19:04:18 2009
Process OS id : 1056862 alive after kill
Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/RADPRDMH/udump/radprdmh_ora_1339404.trc
Wed Dec 23 19:04:19 2009
Process OS id : 905290 alive after kill
Errors in file /u01/app/oracle/product/10.2.0/db_1/admin/RADPRDMH/udump/radprdmh_ora_1339404.trc
Wed Dec 23 19:04:21 2009
ALTER DATABASE CLOSE NORMAL
Wed Dec 23 19:04:22 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Dec 23 19:04:22 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 10191
Successful close of redo thread 1
Wed Dec 23 19:04:22 2009
Completed: ALTER DATABASE CLOSE NORMAL
Wed Dec 23 19:04:22 2009
ALTER DATABASE DISMOUNT
There is no core dump file generate. Below is the radprdmh_ora_1339404.trc.. how do I read this please? Is it the cause of the restart?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name: AIX
Node name: radar01
Release: 3
Version: 5
Machine: 00C9F9104C00
Instance name: RADPRDMH
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 1339404, image: oracle@radar01 (TNS V1-V3)
*** SERVICE NAME:(SYS$USERS) 2009-12-23 19:04:10.927
*** SESSION ID:(148.16994) 2009-12-23 19:04:10.927
----------------------------------------
SO: 70000008c1f5888, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=15, calls cur/top: 70000008c2a5d00/70000008c2a5d00, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 70000008c1f7028 97 0
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 70000008f1cc018 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000008c2174c8
O/S info: user: oracle, term: UNKNOWN, ospid: 860378
OSD pid info: Unix process pid: 860378, image: oracle@radar01 (J000)
Short stack dump: unable to dump stack due to error 72
Dump of memory from 0x070000008C1E9748 to 0x070000008C1E9950
70000008C1E9740 0000000B 00000000 [........]
70000008C1E9750 07000000 8F50F1D8 00000010 0003139D [.....P..........]
70000008C1E9760 07000000 8C2A5D00 00000003 0003139D [.....*].........]
70000008C1E9770 07000000 8F3416B0 0000000B 0003139D [.....4..........]
70000008C1E9780 07000000 8F250630 00000004 00031291 [.....%.0........]
70000008C1E9790 07000000 8ADBF9B0 0000005D 0003139D [...........]....]
70000008C1E97A0 07000000 8CCFA740 00000007 0003139D [.......@........]
70000008C1E97B0 07000000 8CCFA820 00000007 0003139D [....... ........]
70000008C1E97C0 07000000 8F250630 00000004 00031291 [.....%.0........]
Repeat 3 times
70000008C1E9800 00000000 00000000 00000000 00000000 [................]
Repeat 20 times
*** 2009-12-23 19:04:18.938
----------------------------------------
SO: 70000008c1f6068, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=17, calls cur/top: 0/70000008c2a83e0, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 70000008c1f7028 97 0
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 70000008f1cc018 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000008c2174c8
O/S info: user: oracle, term: UNKNOWN, ospid: 1056862
OSD pid info: Unix process pid: 1056862, image: oracleRADPRDMH@radar01
Short stack dump: unable to dump stack due to error 72
Dump of memory from 0x070000008C1E9950 to 0x070000008C1E9B58
70000008C1E9950 00000008 00000000 07000000 8F50F9D0 [.............P..]
70000008C1E9960 00000010 0003139D 07000000 8C2A83E0 [.............*..]
70000008C1E9970 00000003 0003139D 07000000 8F3417C0 [.............4..]
70000008C1E9980 0000000B 0003139D 07000000 8C285AA0 [.............(Z.]
70000008C1E9990 00000004 00031291 07000000 8CCF1970 [...............p]
70000008C1E99A0 00000007 0003139D 07000000 8CCF1A50 [...............P]
70000008C1E99B0 00000007 0003139D 07000000 8CCF1EB0 [................]
70000008C1E99C0 00000007 0003139D 07000000 8CCF6A80 [..............j.]
70000008C1E99D0 00000007 0003139D 00000000 00000000 [................]
70000008C1E99E0 00000000 00000000 00000000 00000000 [................]
Repeat 22 times
70000008C1E9B50 00000000 00000000 [........]
----------------------------------------
SO: 70000008c1f6848, type: 2, owner: 0, flag: INIT/-/-/0x00
(process) Oracle pid=19, calls cur/top: 0/70000008c2a8960, flag: (0) -
int error: 1089, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 70000008c1f7028 97 0
last post sent: 0 0 24
last post sent-location: ksasnd
last process posted by me: 70000008f1cc018 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000008c2174c8
O/S info: user: oracle, term: UNKNOWN, ospid: 905290
OSD pid info: Unix process pid: 905290, image: oracleRADPRDMH@radar01
Short stack dump: unable to dump stack due to error 72
Dump of memory from 0x070000008C1E9B58 to 0x070000008C1E9D60
70000008C1E9B50 00000007 00000000 [........]
70000008C1E9B60 07000000 89724E98 00000010 0003139D [.....rN.........]
70000008C1E9B70 07000000 8C2A8960 00000003 0003139D [.....*.`........]
70000008C1E9B80 07000000 8F341C00 0000000B 0003139D [.....4..........]
70000008C1E9B90 07000000 8F24DCD0 00000004 00031291 [.....$..........]
70000008C1E9BA0 07000000 8CCF1C10 00000007 0003139D [................]
70000008C1E9BB0 07000000 8CCF1CF0 00000007 0003139D [................]
70000008C1E9BC0 07000000 8CCF1DD0 00000007 0003139D [................]
70000008C1E9BD0 00000000 00000000 00000000 00000000 [................]
Repeat 24 times
*** 2009-12-23 19:04:22.744 61287 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2009-12-23 19:04:22.760 61287 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
Thanks