<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuiganglan0701的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuiganglan0701</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuiganglan0701]]></copyright><item><title><![CDATA[ORA-24315 ORA-01595 ora-00607 ora-00600错误的处理过程]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481139</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481139</guid><author>cuiganglan0701</author><pubDate>Thu, 02 Mar 2017 16:22:08 +0800</pubDate><description><![CDATA[平台：WIN 7


	ORACLE version：10203 for vista


	


	28日收到企业报警：保存数据出现ora-03114 通讯通道终止的错误，并且之前总出现没有监听程序的提...]]></description><category></category></item><item><title><![CDATA[某石化企业控制文件不一致的处理过程]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481095</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481095</guid><author>cuiganglan0701</author><pubDate>Thu, 08 Jan 2015 11:39:10 +0800</pubDate><description><![CDATA[平台WIN7，ORACLE版本10.2.03。


	某日用户启动应用的时候报错，连接上去后发现监听有问题。配置完监听后，启动数据库出现错误，提示控制文件不一致：


	C:\Users\lenovo&g...]]></description><category></category></item><item><title><![CDATA[ORA-00600 [kkqcbydrv 1] 错误的解决方法]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481094</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481094</guid><author>cuiganglan0701</author><pubDate>Mon, 01 Sep 2014 16:38:15 +0800</pubDate><description><![CDATA[ORACLE 10.2.0.3.0


	平台windows 2003


	 运行某应用时候出现如下错误：


	
		插入数据表[ ]时出现 ORA-00600：内部错误代码，参...]]></description><category></category></item><item><title><![CDATA[某企业控制文件损坏 回滚数据文件损坏实例二恢复过程]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481093</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481093</guid><author>cuiganglan0701</author><pubDate>Tue, 19 Aug 2014 16:37:33 +0800</pubDate><description><![CDATA[平台：windows xp  


	Oracle 817 


	非归档模式


	时间:8月6日 周三下午3点后,至 7日
周四一天


	 


	 实例2 错误和实例1类似，但...]]></description><category></category></item><item><title><![CDATA[某企业控制文件损坏 回滚 临时表空间数据文件损坏实例一恢复过程]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481110</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481110</guid><author>cuiganglan0701</author><pubDate>Tue, 19 Aug 2014 10:00:50 +0800</pubDate><description><![CDATA[平台：windows xp  


	Oracle 817 


	非归档模式


	时间:8月6日 周三下午3点后,至 7日
周四一天


	 


	实例1:ORCL的恢复：

...]]></description><category></category></item><item><title><![CDATA[应用ORACLE 10G以上细粒度审计功能实现操作审计]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481122</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481122</guid><author>cuiganglan0701</author><pubDate>Fri, 16 May 2014 17:07:11 +0800</pubDate><description><![CDATA[最近因某企业莫名出现3次某重要数据采集表记录全部被修改为某个值的事情，通过LOGMINER工具分析出的日志结果，每个UPDATE都带有具体的ROWID，并且绑定变量也都替换了成了具体的数值，不大好和源程序中的语句进行...]]></description><category></category></item><item><title><![CDATA[在ORACLE8i. 9i版本建立审计触发器]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481092</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481092</guid><author>cuiganglan0701</author><pubDate>Thu, 15 May 2014 16:37:56 +0800</pubDate><description><![CDATA[在网上查询了些资料，10G之前的版本，系统自带的审计功能和细粒度审计，结果都不如意，只能查询到发生了什么操作，但无法获得谁执行了操作，前值后值等详细信息。尽管不愿意，但是建立触发器来监控相关的操作还是唯一可行的办法。...]]></description><category></category></item><item><title><![CDATA[投资系统错误ORA-06502 的解决]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481111</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481111</guid><author>cuiganglan0701</author><pubDate>Thu, 15 May 2014 11:45:00 +0800</pubDate><description><![CDATA[有企业在历史数据装入的时候遇到错误ORA-06502，之前遇到这类情况，都需要把历史数据分成多个阶段进行下载，正确的解决方法如下：





	将DATABASE目录下该存储过程开始第二行的循环变量长度...]]></description><category></category></item><item><title><![CDATA[某数据库再次发生所有记录置为3的问题,再用Logminer分析日志文件]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481121</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481121</guid><author>cuiganglan0701</author><pubDate>Mon, 14 Apr 2014 16:10:32 +0800</pubDate><description><![CDATA[前两天有个数据库的生产表在上午11点半左右又一次所有记录均被置为3，据说4年前曾发生过一次同样的事情，程序人员和上层都不相信是程序的事情，相关人员信誓旦旦说自己的应用不会有问题，希望察看下相应的操作。可惜的是，事情发生之...]]></description><category></category></item><item><title><![CDATA[在9i中手动建库过程]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481119</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481119</guid><author>cuiganglan0701</author><pubDate>Wed, 18 Sep 2013 14:27:50 +0800</pubDate><description><![CDATA[在9i中手动建库 按照此贴操作成功,其中因空间关系,改变了DUMP的目录,相应地在参数文件中也做了更改,最后创建TEST用户后,连接提示用SYSTEM用户执行PUPBLD.SQL,此文件在$ORACLE_HOME/sqlplus...]]></description><category></category></item><item><title><![CDATA[转贴 (数据库字符集）]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481165</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481165</guid><author>cuiganglan0701</author><pubDate>Mon, 09 Sep 2013 09:21:56 +0800</pubDate><description><![CDATA[转贴 (数据库字符集）链接:http://space.itpub.net/8475224/viewspace-692675
                                                    ...]]></description><category></category></item><item><title><![CDATA[临时表是否需要收集统计信息]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481089</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481089</guid><author>cuiganglan0701</author><pubDate>Wed, 04 Sep 2013 10:48:07 +0800</pubDate><description><![CDATA[讨论贴,讨论临时表是否需要收集统计信息,我们的应用也使用了大量的临时表,我也有此疑惑好久了,很好的帖子,收藏!链接:http://www.itpub.net/thread-1109247-4-1.html
           ...]]></description><category></category></item><item><title><![CDATA[视图取数还会有事,你相信吗]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481104</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481104</guid><author>cuiganglan0701</author><pubDate>Thu, 29 Aug 2013 10:00:28 +0800</pubDate><description><![CDATA[前一阵去一小范围的培训,遇到一个极其坑爹的问题,记录以下:



 一个用了N年的应用,一条简单得不能再简单的语句,从视图中取得相应的数据,更新到汇总的数据表中。从8.1.6 开始,有企...]]></description><category></category></item><item><title><![CDATA[10G 打补丁的时候出现ORA-12801  ORA-00018]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100510557</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100510557</guid><author>cuiganglan0701</author><pubDate>Thu, 29 Aug 2013 09:39:26 +0800</pubDate><description><![CDATA[WINDOWS 2008 r2 64 位操作系统,ORACLE原来为10204 ,打10205 的patch 64位的。打补丁的时候,2台机器使用upgrade assistant ...]]></description><category></category></item><item><title><![CDATA[生产系统中重组表数据应注意的问题]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481102</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481102</guid><author>cuiganglan0701</author><pubDate>Thu, 25 Oct 2012 09:23:40 +0800</pubDate><description><![CDATA[有时候，在生产系统中发现某个表影响性能时，譬如说数据占用的数据块过多，过于无序，行迁移过多，主键建立的不够合理等，就需要对其数据进行重组。 
重组的过程如下： 

1、先用EXP 或者数据泵将该表的数据导出一份
Exp ...]]></description><category></category></item><item><title><![CDATA[ORACLE SQL 编写原则]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481100</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481100</guid><author>cuiganglan0701</author><pubDate>Tue, 23 Oct 2012 10:50:08 +0800</pubDate><description><![CDATA[Oracle_Database_10g_tuning原则.rar
                                                            
                    ...]]></description><category></category></item><item><title><![CDATA[使用wm_cancat解决串连接的顺序问题]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481151</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481151</guid><author>cuiganglan0701</author><pubDate>Thu, 18 Oct 2012 16:49:34 +0800</pubDate><description><![CDATA[同事想将公式表中的竖着存储的几条公式全部连接到一个串中，使用wm_cancat 函数一条语句就能实现，响应速度也很快。但是随后的问题来了，虽然可以把一个指标的公式都连接到一个串中，但是公式的顺序不能保证正确。
select z...]]></description><category></category></item><item><title><![CDATA[WINXP ORACLE817双实例ora-1191无法启动的处理]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481086</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481086</guid><author>cuiganglan0701</author><pubDate>Wed, 08 Aug 2012 15:53:33 +0800</pubDate><description><![CDATA[企业告知重装的服务器，两个实例无法自动启动，需要进入管理平台手工干预下，方可启动，服务里面相关实例的状态都是正常的“已启动”状态。

登陆上去查看了下，发现一个实例的ALERT文件中以下信息：

alter da...]]></description><category></category></item><item><title><![CDATA[ORA-00119 ORA-00132错误处理实录]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481099</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481099</guid><author>cuiganglan0701</author><pubDate>Thu, 05 Jul 2012 10:02:41 +0800</pubDate><description><![CDATA[环境：WIN7 32位，oracle11R2


今天启动数据库,发现：
SQL&gt; startup
ORA-00119: invalid specification for system paramete...]]></description><category></category></item><item><title><![CDATA[EXPDP exclue  query参数使用实例]]></title><link>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481045</link><guid>https://blog.youkuaiyun.com/cuiganglan0701/article/details/100481045</guid><author>cuiganglan0701</author><pubDate>Wed, 04 Jul 2012 15:17:55 +0800</pubDate><description><![CDATA[下面为使用11gr2数据泵两个参数的实际例子：
EXPDP test/test directory=dumpdir dumpfile=1.dp logfile=expdp_1.log exclude=TABLE:"IN(...]]></description><category></category></item></channel></rss>