Troubleshooting

When he tried deleting archivelog manually with RMAN on primary db host, he got following warning:

“归档日志未删除, 因为备用或上游捕获进程需要它”

0 db block gets
0 consistent gets
0 physical reads
0 redo size
0 bytes sent via SQL*Net to client
0 bytes received via SQL*Net from client
0 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
62 rows processed

Control Seq=53995=0xd2eb, File size=594=0x252
File Number=0, Blksiz=16384, File Type=1 CONTROL
Logical block number 1 (header block)

其中有两个编号段比较特殊
1，错误编号-10000到-10999 不是真正的错误，是保留下来用于debug使用
2，错误编号-20000到-20999是自定义异常，错误信息最大2048B

HANG ANALYSIS:
==============
Open chains found:
Chain 1 : :
<0/1777/32406/0x5275fca0/13913/SQL*Net message from client>
— <0/1477/37455/0x5275e4e8/16043/enq: TX - row lock contention>

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []

Basically this error is raised because LGWR timmed out.

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P23″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P24″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P21″ 0 rows
. . imported “WEEJAR”.”HASH_OBJ”:”SYS_P22″ 0 rows

ORA-00096: invalid value db,extended for parameter audit_trail, must be from among extended, xml, db_extended, false, true, none, os, db

[oracle@dbserver1 bin]$ ./opmnctl startall
failed to start a managed process after the maximum retry limit
[error 13079] [ecid: -] No matching CACHE element found in

PRVF-5184 : Check of following Udev attributes of “rac2:/dev/asm-diskc” failed: “[Owner: Found=’root’ Expected=’grid’, Group: Found=’root’ Expected=’asmadmin’, Permissions: Found=’0600′ Expected=’0660′]”

Oracle Error :: INS-35171
Target database memory (stringMB) exceeds at least one of the selected nodes available shared memory (string MB).

注意当用veriable变量绑定时sqlplus autotrace有可能显示的执行计划不是实际的，用dbms_xplan.display_cursor查看