Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> datafile offline,recover , then ok. why?

datafile offline,recover , then ok. why?

From: biti_rainy <biti_rainy_at_itpub.net>
Date: 26 Apr 2004 04:11:14 -0000
Message-Id: <20040426035454.CD65E72C98B@turing.freelists.org> 





hi,all





### Problem statement or Question: ###


A datafile was automatically put into offline, and there was a lot ora-600 
thereafter. From trace files, we noted there was some error:
KCF: write/open error block=0x1b1d online=1
file=31 /opt/oracle/oradata/ocn/memberrs02.dbf
error=27061 txt: 'Linux Error: 12: Cannot allocate memory'
before the file was put into offline. After we met this error, we rebooted our 
oracle instance, and recovered this datafile. It then became ok. We want to 
know the exact cause to our problem. Is it because we are using aio? If you 
could help me, I would be very appreciated.





### Errors and Messages: ###


ksedmp: internal or fatal error


ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], 
[]


----- Call Stack Trace -----


calling call entry argument values in hex
location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------


ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 0 ? A4C1590 
?


ksfdmp()+14 call ksedmp()+0 3 ? BFFEB1E0 ? 985B69D ?
AD5CFA0 ? 3 ? AD510F4 ?



kgerinv()+177 call ksfdmp()+0 AD5CFA0 ? 3 ?
kgeasnmierr()+35 call kgerinv()+0 AD5CFA0 ? AD9E22C ? A549A20 
?


0 ? BFFEB218 ?



kclassertlel()+52 call kgeasnmierr()+0 AD5CFA0 ? AD9E22C ? A549A20 
?








/opt/oracle/admin/ocn/bdump/ocn2_dbw0_29343.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production


ORACLE_HOME = /opt/oracle/products/9.2.0
System name: Linux


Node name: ocn2

Release: 2.4.9-e.37smp
Version: #1 SMP Mon Jan 26 11:29:50 EST 2004
Machine: i686




Instance name: ocn2


Redo thread mounted by this instance: 2


Oracle process number: 7


Unix process pid: 29343, image: oracle_at_ocn2 (DBW0)





No hits on kgerinv kgeasnmierr kclassertlel




>From alert log:



.. 


Fri Apr 23 17:26:52 2004


ARC1: Completed archiving log 13 thread 2 sequence 9583
Fri Apr 23 17:43:08 2004


KCF: write/open error block=0x1b1d online=1
file=31 /opt/oracle/oradata/ocn/memberrs02.dbf
error=27061 txt: 'Linux Error: 12: Cannot allocate memory
Additional information: -1


Additional information: 8192'


Automatic datafile offline due to write error on
file 31: /opt/oracle/oradata/ocn/memberrs02.dbf
Fri Apr 23 17:43:08 2004


Errors in file /opt/oracle/admin/ocn/bdump/ocn2_dbw0_29343.trc:
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
Fri Apr 23 17:43:14 2004


Errors in file /opt/oracle/admin/ocn/bdump/ocn2_dbw0_29343.trc:
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
Fri Apr 23 17:43:16 2004


Errors in file /opt/oracle/admin/ocn/bdump/ocn2_dbw0_29343.trc:

ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []


..


Fri Apr 23 17:52:33 2004


Errors in file /opt/oracle/admin/ocn/bdump/ocn2_dbw0_29343.trc:

ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcllrem_2], [], [], [], [], [], [], []
ORA-00600: internal error 




Fri Apr 23 17:52:43 2004


Shutting down instance (abort)


License high water mark = 476


Instance terminated by USER, pid = 19337
Fri Apr 23 17:52:54 2004


Starting ORACLE instance (normal)


Fri Apr 23 17:52:54 2004


Global Enqueue Service Resources = 10946, pool = 4
Fri Apr 23 17:52:54 2004


Global Enqueue Service Enqueues = 16733


LICENSE_MAX_SESSION = 0



LICENSE_SESSIONS_WARNING = 0


GES IPC: Receivers 3 Senders 3 
GES IPC: Buffers Receive 1000 Send 1230 Reserve 1000
GES IPC: Msg Size Regular 396 Batch 2048


SCN scheme 2


Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0



SYS auditing is disabled


Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 500


timed_statistics = TRUE


..




  



Best regards



yahoo id: feng_chunpei


A new dba from china








Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


Received on Sun Apr 25 2004 - 23:04:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US