-
编辑 删除
TNS-00510 Internal limit restriction exceeded
TNS-00510 Internal limit restriction exceededCause Too many files or sockets open simultaneously (or some other resource has been depleted).Action For further details, trace the operation for protocol details.TNS-12500 TNS:listener failed to start a dedicated server processCause The process of starting up a dedicated server process failed. The executable could not be found or the environment may be set up incorrectly.Action Turn on tracing at the ADMIN level and re-execute the operation. Verify
-
编辑 删除
RAC遇到GC Buffer Busy的解决方法2
inst_id分区避免rac gc buffer busy 通过ASH报告，我看到刚才系统HANG住的时候，主要的等待事件是buffer busy wait： Avg Active Event Event Class % Activity Sessions ----------------------------------- --------------- ---------- ---------- buffer busy waits Concurrency 72.55 9.31 enq: HW - contention Configuration 14.21 1.82 gc buffer busy Cluster 7.67 0.98 CPU + Wait for CPU CPU 2.13 0.27 ------------------------------------------------------------- 看样子是由于热块冲突导致系统HANG住的，而且高水位推进
-
编辑 删除
RAC遇到GC Buffer Busy的解决方法1
一朋友求助说他的ORACLE RAC服务器负载不是很稳定，时高时低，且没有任何规律。摘取负载高峰时间的一段日志来分析，最大的等待如下：^LTop SQL Statements DB/Inst: BOSSCENT/bosscent1 (May 19 13:17 to 13:32) SQL ID Planhash % Activity Event % Event ------------- ----------- ---------- ------------------------------ ---------- f9rf7a8cg40nt N/A 9.14 gc buffer busy 2.53 insert into test(id,user_id,point_num,time,point
-
编辑 删除
TNS-12520 TNS-12519 连接错误处理
今天巡检客户数据库时，发现有个taf自动offline,手工启动后，再过一段时间又自动offline$ crs_stat -tName Type Target State Host ------------------------------------------------------------ora....B1.lsnr application ONLINE ONLINE db1 ora....db1.gsd application ONLINE ONLINE db1 ora....db1.ons application ONLINE ONLINE db1 ora....db1.vip application ONLINE ONLINE db1 ora....B2.lsnr application ONLINE ONLINE db2
