<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuanchi1413的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuanchi1413</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuanchi1413]]></copyright><item><title><![CDATA[201611巡检SQL]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387337</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387337</guid><author>cuanchi1413</author><pubDate>Tue, 22 Nov 2016 15:49:12 +0800</pubDate><description><![CDATA[select * from v$option a where a.PARAMETER='Real Application Clusters'; --rac


select * from v$instanc...]]></description><category></category></item><item><title><![CDATA[oracle 解锁 lock]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387332</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387332</guid><author>cuanchi1413</author><pubDate>Tue, 21 Jun 2016 16:04:48 +0800</pubDate><description><![CDATA[解决方案： RAC1 RAC2 多个节点执行

通过触发器。

create or replace trigger on_logon_trigger
after logon on database
begin...]]></description><category></category></item><item><title><![CDATA[ORA-4063 SYS.DBMS_DATAPUMP]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387333</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387333</guid><author>cuanchi1413</author><pubDate>Fri, 26 Dec 2014 15:26:00 +0800</pubDate><description><![CDATA[ORA-4063 SYS.DBMS_DATAPUMP


客户升级到11.2.0.3后EXPDP EXP都不好用报错，数据库失效对象1000个。

处理：
startup upgrade
@CATUPGRD.sql...]]></description><category></category></item><item><title><![CDATA[ORA-4063 SYS.DBMS_CUBE_EXP]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387331</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387331</guid><author>cuanchi1413</author><pubDate>Fri, 26 Dec 2014 15:21:57 +0800</pubDate><description><![CDATA[ORA-4063 SYS.DBMS_CUBE_EXP 


CAUSE

OLAP objects remain existing in data dictionary while OLAP is not ...]]></description><category></category></item><item><title><![CDATA[被锁的对象+KILL]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387388</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387388</guid><author>cuanchi1413</author><pubDate>Fri, 26 Dec 2014 15:19:38 +0800</pubDate><description><![CDATA[1.如果update 某个表，没有报错，等待很久都没结束，那很有可能是表被锁了。

2.查看被锁的对象

select sid,serial#,username,SCHEMANAME,osuser,MACHINE,t...]]></description><category></category></item><item><title><![CDATA[2014 go on!]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387328</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387328</guid><author>cuanchi1413</author><pubDate>Wed, 12 Feb 2014 14:55:24 +0800</pubDate><description><![CDATA[2014 go on!
                                                            
                    
                    ...]]></description><category></category></item><item><title><![CDATA[oracle创建数据文件大小]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387325</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387325</guid><author>cuanchi1413</author><pubDate>Mon, 15 Apr 2013 13:22:36 +0800</pubDate><description><![CDATA[linux最大支持oracle的数据文件1、默认创建表空间时BLOCKSIZE是8k，文件最大是32G2、可以把BLOCKSIZE设置为16k，SQL〉altersystemsetdb_16k_cache_size=...]]></description><category></category></item><item><title><![CDATA[心理成熟的12个标志]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387327</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387327</guid><author>cuanchi1413</author><pubDate>Mon, 31 Dec 2012 21:22:33 +0800</pubDate><description><![CDATA[1.孝顺父母，知恩反哺；2.学着尊重每个人；3.合理安排时间；4.懂得锻炼、养生；5.开始关注国家大事；6.不再盲目跟风；7.遇到问题能冷静思考；8.重视身边的朋友；9.想找一个符合自己口味的另一半；10.在得失方面变得大度；1...]]></description><category></category></item><item><title><![CDATA[Oracle 11.2.0.3  下载 没MOS的有福了（转）验证]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387326</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387326</guid><author>cuanchi1413</author><pubDate>Mon, 31 Dec 2012 16:14:41 +0800</pubDate><description><![CDATA[Oracle 11.2.0.3http://hi.baidu.com/yanzi52351/item/c821c6fcf645e10cc6dc45c5这是完整版本，可以直接安装(验证)。使用迅雷直...]]></description><category></category></item><item><title><![CDATA[P2V LINUX]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387324</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387324</guid><author>cuanchi1413</author><pubDate>Tue, 30 Oct 2012 09:30:23 +0800</pubDate><description><![CDATA[如何P2V Linux到VMware ESX Server

现在有不少工具可以帮你实现P2V Windows系统。如VMware Converter可以轻松的帮你实现该转换，该免费的VMware工具可以在这里下载。但是如何...]]></description><category></category></item><item><title><![CDATA[R720 ESXI5.0 安装]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387371</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387371</guid><author>cuanchi1413</author><pubDate>Tue, 30 Oct 2012 09:27:34 +0800</pubDate><description><![CDATA[Dell Poweredge R720 安装VMware ESXi 5.0 Update 1 网卡认不到问题最近一个项目到了一批r720，拿dell的pac去vmware注册了下载个5.0u1准备装的试试看的，结果麻烦了头一次碰...]]></description><category></category></item><item><title><![CDATA[Oracle10gR2 ORA-3136]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387271</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387271</guid><author>cuanchi1413</author><pubDate>Tue, 21 Aug 2012 14:57:10 +0800</pubDate><description><![CDATA[http://hi.baidu.com/james_yulei/blog/item/ad39730a90f4f5800b7b8227.htmlOracle10gR2 ORA-3136 错误解决
			
			
			
	...]]></description><category></category></item><item><title><![CDATA[ORA-19527与ORA-00312和db_recovery_file_dest_size of 2048 MB is 0.00% used]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387274</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387274</guid><author>cuanchi1413</author><pubDate>Tue, 21 Aug 2012 14:42:19 +0800</pubDate><description><![CDATA[Tue Aug 21 13:41:52 2012Errors in file d:\oracle\product\10.2.0\admin\billing\bdump\billing_mrp0_2216.trc:OR...]]></description><category></category></item><item><title><![CDATA[OUI-11108:  Packages information not specified.]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387270</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387270</guid><author>cuanchi1413</author><pubDate>Fri, 03 Aug 2012 14:10:37 +0800</pubDate><description><![CDATA[http://www.tinyme.org/index.php/archives/67
			
			hecking operating system package requirements …Check complete...]]></description><category></category></item><item><title><![CDATA[IIS网站迁移的必备工具和脚本]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387267</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387267</guid><author>cuanchi1413</author><pubDate>Thu, 14 Jun 2012 12:23:51 +0800</pubDate><description><![CDATA[http://www.cnblogs.com/fcu3dx/archive/2011/12/09/2281481.html这2周一直在给客户做网站迁移项目，搜罗了几个强大的迁移工具和脚本，特别感谢搞存储的吴SIR提供的FASTC...]]></description><category></category></item><item><title><![CDATA[数据泵版本问题]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387263</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387263</guid><author>cuanchi1413</author><pubDate>Wed, 02 May 2012 15:59:42 +0800</pubDate><description><![CDATA[http://space.itpub.net/4227/viewspace-722483
数据泵在10g刚推出的时候，跨版本的问题并不明显，而等到11.2推出之后，数据泵同样存在处理跨版本的问题。
Oracle原始的E...]]></description><category></category></item><item><title><![CDATA[RAID 1+0和RAID 0+1的区别]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387261</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387261</guid><author>cuanchi1413</author><pubDate>Sun, 04 Mar 2012 10:25:46 +0800</pubDate><description><![CDATA[RAID 1+0和RAID 0+1的区别RAID 1的概念传统的RAID 1就是简单的磁盘镜像，两块盘以上就可以完成，但是一定要偶数盘 在两快盘组成的RAID1中，写入数据的话，会同时写在两块磁盘上，然后返回写...]]></description><category></category></item><item><title><![CDATA[Vmware P2V 清除被隱藏網卡佔用的的IP]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387264</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387264</guid><author>cuanchi1413</author><pubDate>Tue, 11 Oct 2011 13:24:11 +0800</pubDate><description><![CDATA[方法一，在運行中輸入輸入 regedit，打開註冊表編輯器，找到“能被hKey本地機器 \系統 \ ControlSet001 \ coontrol \會話管理\環境，在其下新建”DWORD的“，命名為”Devmgr_Show_...]]></description><category></category></item><item><title><![CDATA[VMWARE VIEW 4.6搭建]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387323</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387323</guid><author>cuanchi1413</author><pubDate>Sat, 24 Sep 2011 16:11:44 +0800</pubDate><description><![CDATA[VIEW 4.6ESX4.1
VCENTER 4.1
View Connection Server4.6
View Composer 2.6
全部 W...]]></description><category></category></item><item><title><![CDATA[office 2003 安全模式]]></title><link>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387257</link><guid>https://blog.youkuaiyun.com/cuanchi1413/article/details/100387257</guid><author>cuanchi1413</author><pubDate>Sun, 04 Sep 2011 23:23:26 +0800</pubDate><description><![CDATA[今天给一同事整理电脑时，发现他的OFFICE2003只能以安全模式启动，随即就想到了那个经典的问题，就是默认模板问题，上网一搜，果然发现问题就是在这里，将默认模板删除。就可以了。office 2003 重新安装无用，呵呵。今天，...]]></description><category></category></item></channel></rss>