| PMON FAILURE. [message #61997] |
Wed, 16 June 2004 22:35  |
vp
Messages: 25
Registered: January 2002
|
Junior Member |
|
|
Can someone pls. help me with this error? I run an alter table move command for a huge table and the instance crashes.
Thanks, vp
Thu Jun 17 15:15:11 2004
PMON: terminating instance due to error 470
Thu Jun 17 15:15:12 2004
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jun 17 15:15:12 2004
Errors in file c:oracleadminprod2bdumpprod2DBW0.TRC:
ORA-00470: Message 470 not found; No message file for product=RDBMS, facility=ORA
Thu Jun 17 15:15:12 2004
Instance terminated by PMON, pid = 2604
Dump file c:oracleadminprod2bdumpprod2ALRT.LOG
Thu Jun 17 15:15:52 2004
ORACLE V8.1.7.4.1 - Production vsnsta=0
|
|
|
|
|
|
| Re: PMON FAILURE. [message #62013 is a reply to message #62006] |
Thu, 17 June 2004 17:27  |
vp
Messages: 25
Registered: January 2002
|
Junior Member |
|
|
Mahesh,
Thanks for replying. The following is the log. I could restart the instance without a problem but still I am surprised a simple move command can make the instance fail. I tried with nologging option....and it seems to be stable for other big tables...Please clarify.
Thanks, vp.
**********
Dump file c:oracleadminprod2bdumpprod2DBW0.TRC
Thu Jun 17 15:15:12 2004
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: prod2
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 2600, image: ORACLE.EXE
*** 2004-06-17 15:15:12.078
*** SESSION ID:(2.1) 2004-06-17 15:15:12.015
error 470 detected in background process
ORA-00470: Message 470 not found; No message file for product=RDBMS, facility=ORA
**************
|
|
|
|
| Re: PMON FAILURE. [message #62014 is a reply to message #62013] |
Thu, 17 June 2004 21:20 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
You have problems with your LGWR process. This error say that he are unexpectly died. Try to see why it occur. I think that this is OS error. Tr to see alert.log for other information. Also verify if LGRW are write any trace in BDUMP directory.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
