ORACLE 9i-23ai

ERROR at line 2:
ORA-02299: cannot validate (ICME.UK_PROJECT_SCORE) – duplicate keys found

利用rman 可以方便的把datafile,tablespace,database在本地文件系统和ASM之间转换

[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

启用物化视图的重写有两个条件QUERY_REWRITE_ENABLED=true and materialized view enable query rewrite.
在CBO对查询sql 重写后估算cast后直接查询mv

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查看

数据库在运行一段时间后crash,遭遇ORA-00600: internal error code, arguments: [SKGMFAIL], [2], [4], [4], [1]，重启后又可以正常运行。

sys_op_descend – Returns value as it would be used in a descending index. This is essentially
reverse() function with output in hex.

RLWRAP_HOME:
directory in which the history and completion files are kept.

Oracle为Linux推出了坚不可摧的企业级内核Unbreakable Enterprise Kernel， UEK是一个高速的、新式的、可靠的Linux内核，它们自己的Exadata Database Machine就是基于该内核，也是为oracle自己的软、硬个件优化过的内核