ORA-600(1403)和ORA-7445($cold_kslgetsl)錯誤
10.2.0.2 RAC的ASM例項,出現這兩個錯誤並導致例項的崩潰。
錯誤資訊為:
Thu Apr 12 18:55:42 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 lan901 192.168.0.0 configured from OCR for use as a cluster
interconnect
Interface type 1 lan900 198.5.1.0 configured from OCR for use as a public
interface
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.2.0.
System parameters with non-default values:
large_pool_size = 12582912
instance_type = asm
cluster_database = TRUE
instance_number = 2
remote_login_passwordfile= EXCLUSIVE
background_dump_dest = /u01/app/oracle/admin/+ASM/bdump
user_dump_dest = /u01/app/oracle/admin/+ASM/udump
core_dump_dest = /u01/app/oracle/admin/+ASM/cdump
asm_diskstring = /hpap/rdsk/*
asm_diskgroups = DATE, AEG2_CTL, CTL, DATA, AEG2_DATA
Cluster communication is configured to use the following interface(s) for this
instance
192.168.0.112
Thu Apr 12 18:55:43 2007
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=26298
DIAG started with pid=3, OS id=26300
PSP0 started with pid=4, OS id=26302
LMON started with pid=5, OS id=26304
LMD0 started with pid=6, OS id=26306
LMS0 started with pid=7, OS id=26308
MMAN started with pid=8, OS id=26310
DBW0 started with pid=9, OS id=26313
LGWR started with pid=10, OS id=26316
CKPT started with pid=11, OS id=26321
SMON started with pid=12, OS id=26324
RBAL started with pid=13, OS id=26353
GMON started with pid=14, OS id=26380
Thu Apr 12 18:55:44 2007
Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_ckpt_26321.trc:
ORA-07445: exception encountered: core dump [$cold_kslgetsl()+1424] [SIGSEGV]
[Address not mapped to object] [0x3FFFFFFF812FA310] [] []
Thu Apr 12 18:55:44 2007
lmon registered with NM - instance id 2 (internal mem no 1)
Thu Apr 12 18:55:44 2007
Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_ckpt_26321.trc:
ORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not
readable
ORA-07445: exception encountered: core dump [$cold_kslgetsl()+1424] [SIGSEGV]
[Address not mapped to object] [0x3FFFFFFF812FA310] [] []
Thu Apr 12 18:55:45 2007
Reconfiguration started (old inc 0, new inc 6)
ASM instance
List of nodes:
0 1
Global Resource Directory frozen
Communication channels reestablished
* allocate domain 1, invalid = TRUE
* domain 1 valid = 1 according to instance 0
* allocate domain 2, invalid = TRUE
* domain 2 valid = 1 according to instance 0
* allocate domain 3, invalid = TRUE
* domain 3 valid = 1 according to instance 0
* allocate domain 4, invalid = TRUE
* domain 4 valid = 1 according to instance 0
Thu Apr 12 18:55:45 2007
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Thu Apr 12 18:55:45 2007
LMS 0: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Thu Apr 12 18:55:45 2007
LMS 0: 0 GCS shadows traversed, 0 replayed
Thu Apr 12 18:55:45 2007
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Thu Apr 12 18:55:45 2007
Errors in file /u01/app/oracle/admin/+ASM/udump/+asm2_ora_26212.trc:
ORA-00600: internal error code, arguments: [1403], [], [], [], [], [], [], []
Thu Apr 12 18:55:46 2007
USER: terminating instance due to error 81
Instance terminated by USER, pid = 26212
可以看到,ASM例項剛剛啟動,就由於ORA-7445[$cold_kslgetsl]錯誤和ORA-600[1403]錯誤以及ORA-81錯誤導致了例項被中止。
雖然ORA-7445對應的錯誤在MOS上幾乎沒有記載,不過ORA-600[1403]錯誤在10.2.0.2的RAC版本上有明確的bug記載:Bug 5128575 RAC install of 10.2.0.2 does not update libknlopt.a on all nodes。導致問題的原因是由於在按照10.2.0.2時,一個庫檔案libknlopt.a沒有複製到遠端站點並編譯到oracle可執行檔案中,導致遠端節點出現DUMP的情況,可能出現的錯誤包括ORA-600[1403]和ORA-81等。
解決該問題的方法是複製$ORACLE_HOME/rdbms/lib/libknlopt.a檔案到所有遠端站點,然後在遠端站點重新編輯oracle可執行檔案make -f ins_rdbms.mk ioracle。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/4227/viewspace-733661/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-600(kcblasm_1)和ORA-7445(kxhfNewBuffer)錯誤ASM
- ORA-600(kcbshlc_1)和ORA-7445(kggchk)錯誤GC
- 資料字典不一致造成大量ORA-600和ORA-7445錯誤
- ORA-7445(opipls)錯誤
- ORA-7445(_kkqtnloCbk)錯誤QT
- ORA-7445(kglLockIterator)錯誤
- ORA-7445(kkfipbr)錯誤
- ORA-600(kghfremptyds)和ORA-600(kghasp1)錯誤REM
- ORA-7445(qerixGetKey)錯誤
- ORA-7445(opitca)錯誤
- ORA-7445(kqlSubheapPin)錯誤APP
- sql出現結果集錯誤以及出現ora-600或者ora-7445錯誤的解決方法思路SQL
- ora-600 / ora-7445 loopOOP
- ORA-7445(ksxpsigosderr)錯誤Go
- ORA-600(KSFD_DECAIOPC)和ORA-600(kfioReapIO00)錯誤AIAPI
- ORA-600(kffmXpGet)錯誤
- ORA-7445(_intel_fast_memcpy.A)錯誤IntelASTmemcpy
- ORA-600(kcbchg1_12)和ORA-600(kdifind:kcbget_24)錯誤
- ORA-600(ktfbbsearch-8)和ORA-600(kewrose_1)錯誤ROS
- ORA-600(kjbrchkpkeywait:timeout)和ORA-600(kclcls_8)錯誤AI
- 儲存故障時的ORA-7445錯誤
- ORA-7445(dbgrmqmqpk_query_pick_key)錯誤MQ
- ORA-600 kcblasm_1和kghasp1錯誤ASM
- ORA-600(kgh_heap_sizes:ds)和ORA-600(kghGetHpSz1)錯誤
- ORA-600(kcbgcur_1)錯誤GC
- ORA-600 [ttcgcshnd-1 ]錯誤GC
- ORA-600(kclgclk_7)錯誤GC
- ORA-600(kcbnew_3)錯誤
- ORA-600(qersqCloseRem-2)錯誤REM
- ORA-600(qctopn1)錯誤
- ORA-600(kcblasm_1)錯誤ASM
- ORA-600(qkaffsindex5)錯誤Index
- ORA-600(kghuclientasp_03)錯誤client
- ORA-600(ttcgcshnd-2)錯誤GC
- ORA-600(kolaslGetLength-1)錯誤
- ORA-600(kssadd: null parent)錯誤Null
- ORA-600(504)(row cache objects)錯誤Object
- ORA-600(ktrgcm_3)錯誤GC