RMAN-06900&RMAN-06901 RMAN-00600 [3045] ORA-19921 when rman connect target
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-00600: internal error, arguments [3045] [] [] [] []
ORACLE 9i-23ai
数据库oracle
Performance Tuning DML hang wait event ‘cursor: pin S wait on X’
年前一套数据库出现了性能问题，一周出现了两次，很多session 等待“cursor: pin S wait on X” 事件，这是一套11.2.0.4 RAC on RHEL6 的环境，下面记录一下该案例的优化方案。
Troubleshooting RMAN-00600: internal error, arguments [13205] [] [] [] []
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/11/2011 10:03:29
RMAN-00600: internal error, arguments [13205] [] [] [] []
Troubleshooting the crsd.bin and listener process terminal after eanble TCP.VALIDNODE_CHECKING in sqlnet.ora
Recently, we met several times Oracle Listener terminal case, here I will be sharing again due to configuration Listener whitelist caused, For to system hardening, we are eanble listener whitelist (TCP.VALIDNODE_CHECKING = yes) on some RAC Environment, But no more after prolonged listening terminated unexpectedly after enable VALIDNODE_CHECKING . [oracle@anbob2:/home/oracle]# ps -ef|grep lsnr oracle 5111994 … Read more
诊断一起存储链路引起的数据库性能问题案例 ORA-32701 and krsv_proc_kill: Killing 1 processes (Process by index) in alert
前几日一套库出现在性能问题，虽然最终问题不在数据库， 但是记录一下希望遇到同样问题时可以节约你的时间 ，这是11.2.0.3 RAC 2nodes on hpux (EMC存储), 问题是从16：40左右起中间件偶尔有瞬间的业务积压， 积压时数据库大多数会话都是简单的insert同一表数据
Invalid segment BIN$xxx and dba_recyclebin was empty (回收站空，释放无效的BIN$xx空间)
近来有套库空间紧张，发现有很大BIN$开头的TABLE partition,index partition 类型的段，查询确认是2个月前删除的对象，手动清空过dba_recyclebin使用purge，但都过去几天了，后来dba_recyclebin一直为空，发现对象BIN$XX还存在
Performance tuning ‘gc cr¤t grant 2-way’ event (当主机扩容cpu后)
gc cr¤t grant 2-way 是一种 grant message package 的传递，当取cr 或current block 时向block master instance 请求x或s的权限 ，当请求的block在从任何实例上的buffer cache中都没有发现, lms进程会通知FG进程从disk 读取block到local buffer cache中
Fixed OSWatcher v7.3.3 some problems on HPUX ia 11-31 platform
The OSW is a great OS monitor tool, The latest version of osw(7.3.3) there are some problems in the HP platform(ia 11-31).
1, the private network to collect information to monitor only once at startup
2, Did not get the information TOP
ORA-31693&ORA-31640&ORA-19505 and ORA-39126&ORA-01555&ORA-22924 when impdp 11g rac using parallel
ORA-31693: Table data object “CTCARD”.”RES_IMSI1104IMPORTANT” failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file “/home/oracle/datapump/UIM04.DUMP” for read
ORA-19505: failed to identify file “/home/oracle/datapump/UIM04.DUMP”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-04063: package body “SYS.DBMS_SQLTUNE_INTERNAL” and compile body raise ORA-00904: “XMLAGG”
ORA-04063: package body “SYS.DBMS_SQLTUNE_INTERNAL” 有错误
ORA-06508: PL/SQL: 无法找到正在调用 : “SYS.DBMS_SQLTUNE_INTERNAL” 的程序单元
ORA-06512: 在 “SYS.DBMS_SQLTUNE”, line 5664
ORA-06512: 在 line 55
Warning ! RAC Listener offline& VIP failover when dynamically adding disks using udev after executing
增加新存储到现有ASM，使用udev配置绑定的存储，当增加了udev rule 配置文件中新增的lun， 执行了start_udev后，执行该命令RAC当前节点资源 的VIP fail 到另一个实例，并且listener offline
After remote_listener change to null, frequently getting message ‘* service_update * ‘ in listener.log, pmon spin
一套10.2.0.5 RAC ON HPUX, 前做时间Disable LB 参数调整时把remote_listener=”， 随后几天发现listener.log 空间增速异常的快，当时看了下里面多是service_update的信息， 查看top进程，也发现了pmon 进程一直是top 1,使用 cpu 100%，
Troubleshooting ora-600 [17114] Trace file show current SQL selecting v$session
二个月前一套CRM 的10.2.0.5 rac on hpux 的alert 中发现了ora-600 17114 , 从trace file 中发现是查询v$session, 随后在MOS中找到了bug 导致， call stack 一致，简单记录一下。
How to force a hint without touch sql text? 手动SQL Profile固定执行计划
很久以前遇到的一个问题简单记录一下，之前一个数据库出现了很高的I/O 负载，影响了全省的业务， 因为SQL 使用了错误的执行计划，当前修改app 重上线已来不及， 此时可以使用像sql profile,outline, sql baseline来指定个执行计划…
troubleshooting ORA-600[6302] & ORA-600 [6200] corrupted index block
今天同事的一套数据库遇到了alert 日志 一堆的ora-600，这是一套10.2.0.5 db 2nodes RAC on AIX , 找我帮着看看， 最终确认为一个索引出现了block corrupted 勘误块导致， 重新创建的了索引后解决…
Performance tuning library cache lock & single-task message
My colleague suddenly encountered a problem today,a Database becomes very slow , and the a lot of session wait library cache lock event, Let me help him to look. DB env is 10.2.0.4 rac.
ORA-08104 when online index rebuild
Last night ,The Developers ask me they have creating an index do not use parallel,Unacceptably slow. then kill the session to cancel, but now to face ORA-08104 during trying to online index rebuild . that is a busy product database(7×24). DB version 10205 2nodes rac on hpux.
Troubleshooting ORA-07445 [skgxpdmpmem()+22096]
ORA-07445: exception encountered: core dump [skgxpdmpmem()+22096] [SIGSEGV] [Address not mapped to object] [0x0002D0B8C] [] []
Sun Dec 21 20:55:43 EAT 2014
Trace dumping is performing id=[cdmp_20141221205543]
Sun Dec 21 20:55:45 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/bdump/anbob1_pmon_13442.trc:
ORA-00484: LMS* process terminated with error
Troubleshooting ORA-00600 internal error [6704], [2], [1405099], [953234]
刚接手一套数据库，数据库执行SQL时提示 ORA-00600: internal error code, arguments: [6704], [2], [1405099], [953234], [], [], [], [], [], [], [], []]，下面简单记录一下。
Shell: extract more from listener.log (分析oracle监听日志连接频率)
最近遇到了两起数据库连接数不足的问题， 通常都会预留一些会话增加的情况， 但在一些特殊情况下如连接风暴(logon storm)， 如果在监听中没有做rate限流，对数据库来说
巨大的冲击可能会导致数据库Hang 或 ora-20 或ora-18 错误。