Troubleshooting Instance crash when modify db_cache_size, ora-600 [kmgs_pre_process_request_6]
ORA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6], [895], [0], [3], [0x459C1F3D8], [], []
Mon Dec 22 22:40:43 2014
MMAN: terminating instance due to error 822
Instance terminated by MMAN, pid = 31205
Troubleshooting ORA-12012&ORA-29283&ORA-06512 issue
ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_2″
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation
ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line 2436
ORA-06512: at line 1
Oracle Database History
In 1977 Larry Ellison saw a IBM Journal of Research and Development, discovered a research paper that described a working prototype for a relational database management system (RDBMS). Showing it to coworkers Bob Miner and Ed Oates at Ampex .
How to release still “killed“ status session in v$session?(释放killed的session)
最近在一套生产库上发现了几个已经killed的会话一直保持在v$session 会话中，会话是user type的连接，而且已经killed了很久，通过SPID 发现操作系统层面已不存在该进程， 下面是我多次尝试后最终释放，
How to find out who caused the database user locked（ora-1017 or ORA-28000）(捕捉登录失败)
昨天有应用反应server日志中有如下错误，提示用户locked，但是重启了下web server又恢复了正常，但是这期间我们也没有人为的给db user unlock, 下面记录一下, 其实事情的经过是这样子的…
