<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/congpu1904</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; congpu1904]]></copyright><item><title><![CDATA[rac死活只有一个节点能启动]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312862</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312862</guid><author>congpu1904</author><pubDate>Wed, 18 Sep 2013 14:43:59 +0800</pubDate><description><![CDATA[今天同事报他们大区的RAC死活只能启动一个节点，第一反应就是是不是心跳或者网络什么问题。问他们要了远程登陆密码连接上查看日志错误信息：[ CSSD]2013-09-18 13:45:11.587 [2...]]></description><category></category></item><item><title><![CDATA[ora-27054]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312860</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312860</guid><author>congpu1904</author><pubDate>Mon, 25 Feb 2013 15:33:52 +0800</pubDate><description><![CDATA[南京同事在安装数据库的时候，因为没有图形界面，故而让他将之前安装的一个新数据库整个拷贝到新服务器上面，后面连接上去修改相关参数，在启动数据库到mount状态的时候报错，查看日志显示
。。。
ORA-27054: NFS fi...]]></description><category></category></item><item><title><![CDATA[Ora-27300, Ora-27300, Ora-27302]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312865</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312865</guid><author>congpu1904</author><pubDate>Mon, 17 Dec 2012 11:41:52 +0800</pubDate><description><![CDATA[Ora-27300, Ora-27300, Ora-27302
Dbca删除库过后，重新建库，出现下面错误。
Ora-27154:post/wait create failed
Ora-27300 os system ...]]></description><category></category></item><item><title><![CDATA[找出未收集统计信息和统计信息过期的表]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312858</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312858</guid><author>congpu1904</author><pubDate>Fri, 10 Aug 2012 10:48:27 +0800</pubDate><description><![CDATA[下面这个查询可以找到从未收集过统计信息或者统计信息过期的表。
EXEC DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
SELECT OWNER,TABLE_NAME,OBJECT_TY...]]></description><category></category></item><item><title><![CDATA[CRS can not Start After Node Reboot]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312857</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312857</guid><author>congpu1904</author><pubDate>Fri, 18 May 2012 23:04:01 +0800</pubDate><description><![CDATA[同事在切割的时候，发现数据库节点1启动不起来，重启服务器等操作均无法启动节点1,通过vpn登录到数据库查看日志文件，ocssd.log如下一直重复内容，与节点2通信失败。
。。。。。[ CSSD]2012-05-18 1...]]></description><category></category></item><item><title><![CDATA[ora-6502]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312855</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312855</guid><author>congpu1904</author><pubDate>Thu, 10 May 2012 16:52:19 +0800</pubDate><description><![CDATA[朋友在运行awrrpt.sql的时候，，报告中有undo错误信息
errorencounteredinundosegmentsummarywhileexecutingsqlstatement:Len

...]]></description><category></category></item><item><title><![CDATA[11gR2 RAC安装时遇到的一些错误]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312861</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312861</guid><author>congpu1904</author><pubDate>Sat, 21 Apr 2012 17:32:17 +0800</pubDate><description><![CDATA[第一次安装11gR2遇到很多问题，排查错误也用了好些时间。现将有关问题记录如下：
一、安装grid执行root.sh的时候不成功，如下错误

Errors in file :
ORA-27091: una...]]></description><category></category></item><item><title><![CDATA[ORA-32004&ORA-27125]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312853</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312853</guid><author>congpu1904</author><pubDate>Wed, 21 Mar 2012 16:18:26 +0800</pubDate><description><![CDATA[一个朋友数据库在启动的时候提示下面错误SQL&gt; startupORA-32004: obsolete and/or deprecated parameter(s) specifiedORA-27125: unable to...]]></description><category></category></item><item><title><![CDATA[delete ,truncate]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312851</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312851</guid><author>congpu1904</author><pubDate>Tue, 20 Mar 2012 09:27:11 +0800</pubDate><description><![CDATA[此处仅为自己的一些简单测试SQL&gt; select segment_name,extents,bytes/1024/1024 mb from user_segments;
SEGMENT_NAME...]]></description><category></category></item><item><title><![CDATA[用orabm进行CPU压力测试]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312848</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312848</guid><author>congpu1904</author><pubDate>Tue, 20 Mar 2012 09:21:47 +0800</pubDate><description><![CDATA[用orabm测试oracle服务器的tps值1、orabm介绍 orabm是一个开源的oracle性能测试工具，包含了一套sql脚本和几个命令行程序 下载地址：http://www.linxcel.co.uk/orabm...]]></description><category></category></item><item><title><![CDATA[substr,instr使用]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312849</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312849</guid><author>congpu1904</author><pubDate>Thu, 01 Mar 2012 15:30:50 +0800</pubDate><description><![CDATA[今天开发问到一个关于字符截取的问题，当时一时没想起来如何做，忘记了函数了。大概表的字段如下1111#abac1134#defha134#xxxe....要获得#前面的数字，然后排序。
测试如下：SQL&gt; create t...]]></description><category></category></item><item><title><![CDATA[ORA-12526, TNS:listener: all appropriate instances are in restricted mode]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312846</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312846</guid><author>congpu1904</author><pubDate>Thu, 01 Mar 2012 10:47:21 +0800</pubDate><description><![CDATA[在启动应用程序的时候提示ora-12526错误

2012-02-29 04:37:25,366 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Listen...]]></description><category></category></item><item><title><![CDATA[数据文件恢复一例]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312859</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312859</guid><author>congpu1904</author><pubDate>Tue, 21 Feb 2012 15:03:54 +0800</pubDate><description><![CDATA[今天青海同事说应用不能录入数据：查看alert日志出现大量的下面信息ORA-00603: ORACLE server session terminated by fatal errorORA-00372: file 3 cann...]]></description><category></category></item><item><title><![CDATA[网关不通导致vip漂移]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312845</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312845</guid><author>congpu1904</author><pubDate>Thu, 16 Feb 2012 15:41:36 +0800</pubDate><description><![CDATA[同事安装rac的时候，发现节点2的vip漂到节点1上面，远程连接上去处理过程如下：
rac1:~ # cd /oracle/crs/bin/rac1:/oracle/crs/bin # ./crs_stat -tName...]]></description><category></category></item><item><title><![CDATA[rac一节点crs启动不起来]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312856</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312856</guid><author>congpu1904</author><pubDate>Wed, 08 Feb 2012 15:34:41 +0800</pubDate><description><![CDATA[rac一节点crs启动不起来
系统环境：suse 10 sp2数据库版本：10.2.0.4.0存储：raw+asm故障：节点一crs无法启动，节点二正常RAC1:/oracle_crs/product/10.2/crs/b...]]></description><category></category></item><item><title><![CDATA[library cache lock解决方法]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312852</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312852</guid><author>congpu1904</author><pubDate>Fri, 03 Feb 2012 14:29:16 +0800</pubDate><description><![CDATA[今天上午，运维告知在创建一个表的时候hang住。出现问题前操作是，在通过dblink来迁移表的时候，由于时间等待太长，所以ctl+c终止掉该操作。后续在进行创建该表的时候就一直hang在那里。

SQL&gt...]]></description><category></category></item><item><title><![CDATA[diagcollection.pl脚本使用]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312881</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312881</guid><author>congpu1904</author><pubDate>Thu, 02 Feb 2012 09:54:04 +0800</pubDate><description><![CDATA[diagcollection.pl来收集crs相关的日志
RAC2:/oracle_crs/product/10.2/crs/bin # ./diagcollection.pl --helpProduction Cop...]]></description><category></category></item><item><title><![CDATA[DB BUFFER CACHE 命中率介绍【转】]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312843</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312843</guid><author>congpu1904</author><pubDate>Fri, 02 Sep 2011 09:49:13 +0800</pubDate><description><![CDATA[1.
 
  块缓存即数据高速缓冲区。它是SGA区的一个主要部分。用于存放从数据文件读入的数据块。它的大小有INITsid.ORA文件的DB_BLOCK_BUFFERS参数来设置(Oracle9i参数名称为DB_CAC...]]></description><category></category></item><item><title><![CDATA[oracle下载]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312840</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312840</guid><author>congpu1904</author><pubDate>Tue, 30 Aug 2011 09:58:28 +0800</pubDate><description><![CDATA[Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition  for Microsoft Windows (32-bit)  http://dow...]]></description><category></category></item><item><title><![CDATA[java.sql.SQLException: End of TNS data channel]]></title><link>https://blog.youkuaiyun.com/congpu1904/article/details/100312842</link><guid>https://blog.youkuaiyun.com/congpu1904/article/details/100312842</guid><author>congpu1904</author><pubDate>Tue, 09 Aug 2011 14:17:08 +0800</pubDate><description><![CDATA[在启动应用程序的时候出现这个错误2011-08-08 16:43:50][WARN] Could not obtain connection metadatajava.sql.SQLException: End of TNS d...]]></description><category></category></item></channel></rss>