http://sundog315.itpub.net sundog315 Thu,09 02 2012 17:26:07 http://sundog315.itpub.net/post/308/526049 在10G之前，甚至在10G的Oracle环境中，有很多数据量不大，重要性不太高的系统依然采用EXP/IMP逻辑导出备份方式，或者，作为辅助备份方式。通常情况下，我们都是这样操作的：1.exp导出2.gzip压缩3.gzip解压4.imp导入这样操作有如下两个不好的地方：1.占用大量磁盘空间，磁盘剩余空间必须大于导出的，未压缩的文件大小加上压缩后的文件大小。如果设置计划任务，每日定时导出的话，很有可能因为磁盘空间不足导致备份失败。由于这种备份方式磁盘使用率的剧烈抖动，即使有监控工具，也不能很好的提供趋势分析2.系统资源浪费，在导出时，大部分都... Oracle Thu,19 01 2012 10:33:03 sundog315 http://sundog315.itpub.net/post/308/525811 Unable To Connect To ASM Due To SQL*Plus Shows “Connected To An Idle Instance. [ID 1179825.1] -------------------------------------------------------------------------------- 修改时间 30-SEP-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution--------------------------------------------------------------------------------Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applies to any platform.... Oracle Thu,29 12 2011 11:35:26 sundog315 http://sundog315.itpub.net/post/308/525798 Oracle 10.2.0.1 HP-UX 11.31 ia64alert.log:Mon Dec 26 14:11:16 2011Shutting down instance (abort)License high water mark = 486Instance terminated by USER, pid = 1675syslog:Dec 26 14:10:14 wandadb1 cmnetd[29338]: lan0 is down at the data link layer.Dec 26 14:10:14 wandadb1 cmnetd[29338]: lan0 failed.Dec 26 14:10:14 wandadb1 cmnetd[29338]: Subnet 10.0.4.0 downDec 26 14:10:36 wandadb1 cmnetd[29338]: lan0 is up at the data link layer.Dec 26 14:10:36 wandadb1 cmnetd[29338]: lan0 recovered.Dec 26 14:10... Oracle Tue,27 12 2011 07:53:13 sundog315 http://sundog315.itpub.net/post/308/525709 源库10.2.0.1，目标库11.2.0.3impdp system/"xxxx" network_link=wdyx_prod schemas=wd_web,wanda parallel=4 TABLE_EXISTS_ACTION=REPLACE directory=dumpdir logfile=wdyx_trans.log VERSION=10.2Import: Release 11.2.0.3.0 - Production on Tue Dec 20 23:13:02 2011Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning optionORA-39006: internal errorORA-39113: Unable to determine... Oracle Tue,20 12 2011 16:25:51 sundog315 http://sundog315.itpub.net/post/308/525708 11.2.0.3 VIP/SCAN VIP is Not Pingable After Failover Leads to Connection Issue (Doc ID 1379498.1) Oracle Tue,20 12 2011 16:24:09 sundog315 http://sundog315.itpub.net/post/308/525638 一台Linux 11GR2public vip scan 均在10.199.88.0网段，服务器启动后，从服务器本身或者10.199.88.0网段的其他服务器看，均正常。在10.199.88.0网段外看这个RAC坏境，public ip是通的，但是，vip scan都不通。在这两台RAC服务器上使用/sbin/arping -s vip gateway后，所有的网段看到RAC的状态都正常了。原因待查 Oracle Thu,15 12 2011 06:21:18 sundog315 http://sundog315.itpub.net/post/308/525631 记录一下，以防忘记1.创建/etc/sysconfig/network-scripts/ifcfg-bond0DEVICE=bond0BOOTPROTO=noneONBOOT=yesTYPE=EthernetNETMASK=255.255.255.0IPADDR=10.199.88.13GATEWAY=10.199.88.1USERCTL=noIPV6INIT=no2.修改ifcfg-eth0 ifcfg-eth1DEVICE=eth0BOOTPROTO=noneONBOOT=yesTYPE=EthernetMASTER=bond0USERCTL=noIPV6INIT=noDEVICE=eth1 BOOTPROTO=none ONBOOT=yes TYPE=Ethernet MASTER=bond0 USERCTL=no IPV6INIT=no3.修改/etc/modprobe.conf，添加alias bond0 bondingoptions bond0 miimon=100 mode=0mode=0 负载均衡mode=1 HA... Linux Wed,14 12 2011 18:09:27 sundog315 http://sundog315.itpub.net/post/308/525630 HP-UX 11.31Oracle 10.2.0.1 RAC其中一个session的等待事件一直为kksfbc child completion，查询了一下，有可能是个BUGBug 6795880，相关的doc id为：6795880.8A session may go into an infinite spin just after a wait for 'kksfbc child completion'. The spin occurs with a stack including kksSearchChildList -> kkshgnc where kksSearchChildList loops forever.This problem can also lead to internal error such as any ofORA-600 [kksSearchChildList1], ORA-600 [kksSearchChildList2]ORA-600 [kksSearchChildList3],... Oracle Wed,14 12 2011 18:06:55 sundog315 http://sundog315.itpub.net/post/308/525049 一个多灾多难的系统：）HP-UX 11.31 IA64 Oracle 10.2.0.1 两节点RAC数据库集群自动重启，检查alert文件，报ORA-00600错误Mon Nov 14 15:43:53 2011Errors in file /u01/app/oracle/admin/ufsa8/udump/ufsa81_ora_4531.trc:ORA-00600: internal error code, arguments: [KGHALO4], [0xC0000000BD0CD060], [], [], [], [], [], []Mon Nov 14 15:43:58 2011Trace dumping is performing id=[cdmp_20111114154358]Mon Nov 14 15:43:58 2011Errors in file /u01/app/oracle/admin/ufsa8/udump/ufsa81_ora_4531.trc:ORA-00600: internal error ... Oracle Mon,14 11 2011 16:29:43 sundog315 http://sundog315.itpub.net/post/308/525039 Load averages可以很好的表示系统的负载情况，它统计的是CPU运行及等待队列的长度，而与CPU使用率无关。当CPU队列长度长期超过CPU数量时，表明系统CPU已超载，需调整应用或增加硬件。对于Load averages，wikipedia有一些描述http://en.wikipedia.org/wiki/Load_averages在文章里，Load averages/CPU_NUM，如果这个值超过1，则代表处理器已无法及时的处理所有的请求。但是，在HP-UX 11.31 IA64下，观察的结果却不一致。在一个16核的小机，Load averages为1.5，按照标准的计算模式，1.5/16，此服务器负载不高，处理器绰绰有余。但是，查看CP... 杂谈 Mon,14 11 2011 10:00:32 sundog315