作者: Maclean Liu, post on September 9th, 2011 有网友反映windows 2003 上的10.2.0.4数据库，MMON的Slave后台进程报带有NEWLEN: MESSAGES的相关日志，如:
*** ACTION NAME:(Auto ADDM Slave Action) 2011-09-09 18:00:12.053 *** MODULE NAME:(MMON_SLAVE) 2011-09-09 18:00:12.053 *** SERVICE NAME:(SYS$BACKGROUND) 2011-09-09 18:00:12.053 *** SESSION ID:(797.606) 2011-09-09 18:00:12.053 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: newlen: 0 [kdl_trim]: . . . → Read More: MMON Slave日志[KDL_TRIM]: NEWLEN: MESSAGES
作者: Maclean Liu, post on August 4th, 2011 客户的一套11.2.0.1 RAC系统采用ASM diskgroup 存放ocr和votedisk，该REG diskgroup中的某个LUN disk由于硬件的原因损坏了，导致冗余的votedisk表决磁盘有一个处于OFFLINE状态，客户希望能删除该OFFLINE的votedisk并新增一个可用的。
在删除该votedisk文件时出现了CRS-4258的错误，错误如下:
crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1. OFFLINE 5b3380d6367e4f94bf19e9db5f2f684e () [] 2. ONLINE 6802e6d139354fb3bf95725dd01a02fd (/dev/ocr2) [REG] 3. ONLINE a433d51ebd2d4facbfc8e95b017f5393 (/dev/asm-disk1) [REG] 4. ONLINE 3784d344bffa4f6ebff21c4dd3c873bd (/dev/asm-disk2) [REG] Located 4 voting disk(s). crsctl delete css votedisk 5b3380d6367e4f94bf19e9db5f2f684e CRS-4258: . . . → Read More: CRS-4258: Addition and deletion of voting files are not allowed because the voting files are on ASM
作者: Maclean Liu, post on August 1st, 2011 一套Windows上的11.2.0.1单实例数据库在database open阶段出现了ORA-07445:core dump [kcflfi()+466] [INT_DIVIDE_BY_ZERO] [] [PC:0x500282E] [] []内部错误，具体的出错日志如下:
LOG CONTENT =======================ALERT.LOG============================ Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST ARCH: Warning; less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST init.ora parameter Autotune of undo retention is turned on. IMODE=BR ILAT =84 . . . → Read More: Oracle内部错误:ORA-07445[kcflfi()+466] [INT_DIVIDE_BY_ZERO]一例
作者: Maclean Liu, post on July 25th, 2011 一套Linux x86-64上的11.2.0.1 4节点RAC系统中LMS GCS服务进程遭遇到内部错误ORA-00600[kjbmprlst:shadow],导致节点实例意外终止,具体日志如下:
Fri Jul 08 02:04:43 2011 Errors in file /u01/app/oracle/diag/rdbms/PROD/PROD1/trace/PROD1_lms1_536.trc (incident=1011732): ORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/PROD/PROD1/incident/incdir_1011732/PROD1_lms1_536_i1011732.trc Fri Jul 08 02:04:44 2011 Trace dumping is performing id=[cdmp_20110708020444] Errors in file /u01/app/oracle/diag/rdbms/PROD/PROD1/trace/PROD1_lms1_536.trc: ORA-00600: internal error code, arguments: [kjbmprlst:shadow], . . . → Read More: Oracle RAC内部错误:ORA-00600[kjbmprlst:shadow]一例
作者: Maclean Liu, post on July 10th, 2011 KJC: Wait for msg sends to complete是一种只会发生在RAC环境中的等待事件，目前对于该等待事件已知的信息不多。 KJ意为Kernel Lock Management Layer，Messaging Enhancements (KJC)。 猜测该等待事件为global enqueue message的网络传输等待,前台进程和后台进程如LMS、LMD均可能发生该等待事件。
select name,parameter1,parameter2,parameter3,wait_class from v$event_name where name like ‘%KJC%’; NAME PARAMETER1 —————————————————————- —————————————————————- PARAMETER2 PARAMETER3 —————————————————————- —————————————————————- WAIT_CLASS —————————————————————- KJC: Wait for msg sends to complete msg dest|rcvr mtype Other SQL> select * from gV$system_Event where event like ‘%KJC%’; . . . → Read More: Oracle等待事件KJC:Wait for msg sends to complete
作者: Maclean Liu, post on April 28th, 2011 一套Itanium HP-UX上的9.2.0.5系统最近出现了ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [],内部错误，其错误日志如下:
Mon Apr 18 12:32:20 2011 ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [], [], [] ARC0: Completed archiving log 6 thread 1 sequence 831803 Mon Apr 18 12:32:22 2011 ORA-00600: internal error code, arguments: [kgskdecrstat1], [], [], [], [], [], [], . . . → Read More: Oracle内部错误:ORA-00600[kgskdecrstat1]一例
作者: Maclean Liu, post on April 19th, 2011 一套SUNOS 5.10上的单节点10.2.0.3系统出现了ORA-07445: exception encountered: core dump [SIGFPE] [Integer divide by zero] [42788866] [] [] []内部错误，具体trace日志如下:
mon_ora_17633.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /oracle/oracle/product/10.2.0 System name: SunOS Node name: monitor-a Release: 5.10 Version: Generic_139556-08 Machine: i86pc ksedmp: internal or fatal error ORA-07445: exception . . . → Read More: ORA-07445:[SIGFPE] [Integer divide by zero]内部错误一例
作者: Maclean Liu, post on March 24th, 2011 一套Sparc Solaris上的10.2.0.1数据库，告警日志中出现ORA-07445:[_memcmp()+88] [SIGSEGV]内部错误日志，具体日志如下:
Errors in file /global/oracle1/centDB/admin/centDB/udump/centdb_ora_8749.trc: ORA-07445: exception encountered: core dump [_memcmp()+88] [SIGSEGV] [Address not mapped to object] [0x000000010] [] /global/oracle1/centDB/admin/centDB/udump/centdb_ora_8749.trc Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /global/oracle1/ORAHOME1/product/10.2/db_1 System name: SunOS Node name: ora03ud-us Release: 5.10 Version: Generic_142900-13 Machine: sun4u . . . → Read More: Oracle内部错误ORA-07445:[_memcmp()+88] [SIGSEGV]一例
|
|
最新评论