<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cpda53349199的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cpda53349199</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cpda53349199]]></copyright><item><title><![CDATA[crsctl start/stop crs and crsctl start/stop cluster 区别]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426743</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426743</guid><author>cpda53349199</author><pubDate>Wed, 18 Apr 2018 09:39:29 +0800</pubDate><description><![CDATA[官网解释：
crsctl start/stop crs- Manage start/stop theentireOracleClusterware stack on a node, including the OHASD pr...]]></description><category></category></item><item><title><![CDATA[expdp出dmp文件到NFS NAS报错ora-39001 ora-39000 ora-31641 ora-27054]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426805</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426805</guid><author>cpda53349199</author><pubDate>Wed, 07 Feb 2018 13:20:35 +0800</pubDate><description><![CDATA[通过查询metalink id :387700.1

文档上说可能的问题有以下几种：
a) The mount table (eg; /etc/mnttab) can be read to check the mount...]]></description><category></category></item><item><title><![CDATA[impdp/expdp 示例]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426750</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426750</guid><author>cpda53349199</author><pubDate>Wed, 07 Feb 2018 09:06:02 +0800</pubDate><description><![CDATA[create tablespace C_MAIN DATAFILE 
'D:\oracle\product\10.2.0\oradata\orcl\main.dbf' SIZE 
1024M

一.exp/imp备...]]></description><category></category></item><item><title><![CDATA[RHEL 7 安装oracle rac 11.2.0.4执行root.sh报错ohasd failed to start]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426748</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426748</guid><author>cpda53349199</author><pubDate>Mon, 05 Feb 2018 14:15:03 +0800</pubDate><description><![CDATA[报错信息：


	[root@rac1 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions 
of /u01/app/oraInvento...]]></description><category></category></item><item><title><![CDATA[Oracle OCM作业运行报错ORA-29280]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426747</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426747</guid><author>cpda53349199</author><pubDate>Wed, 20 Dec 2017 22:02:01 +0800</pubDate><description><![CDATA[1、Oracle OCM作业运行报错ORA-29280


	一个同事系统中出现小故障，笔者协助帮助查看。由于系统总体负载很低，也没有明显的功能影响点，笔者也没有直观的思路。一般而言，从alert log中我们可以按...]]></description><category></category></item><item><title><![CDATA[ORA-20011 KUP-11024 外部表引起的错误]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426877</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426877</guid><author>cpda53349199</author><pubDate>Fri, 20 Oct 2017 09:03:15 +0800</pubDate><description><![CDATA[查看alert日志，看到了没有见过的错误。
字面大致意思是：GATHER_STATS_JOB收集统计信息时发生错误。
错误发生在执行调出ODCIEXTTABLEOPEN时；外部表只能通过数据泵调用。

Sat Jun 1...]]></description><category></category></item><item><title><![CDATA[修改ASM磁盘冗余度（由normal改为external）]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426910</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426910</guid><author>cpda53349199</author><pubDate>Wed, 18 Oct 2017 14:53:04 +0800</pubDate><description><![CDATA[有个朋友问起ASM磁盘创建后能否直接修改冗余度？
印象中是不能，需要重建ASM磁盘。

回去翻了一下官方文档：
Automatic Storage Management Administrator's Guide -〉...]]></description><category></category></item><item><title><![CDATA[Oracle ASM 的redundancy与failgroup]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426875</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426875</guid><author>cpda53349199</author><pubDate>Wed, 18 Oct 2017 11:56:17 +0800</pubDate><description><![CDATA[redundancy与failgroup


	


	1．关于redundancy 与fail group官方说明


	


	http://docs.oracle.com/cd/E1188...]]></description><category></category></item><item><title><![CDATA[如何诊断RAC系统中的'gc cr multi block request'?]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426874</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426874</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 17:09:24 +0800</pubDate><description><![CDATA[如何诊断RAC系统中的'gc cr multi block request'?


	
		By:Jane Zhang|Senior Support Manager
	
	
		 'gc cr ...]]></description><category></category></item><item><title><![CDATA[如何升级Oracle Grid Infrastructure和RAC从11.2.0.3到11.2.0.4？]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426876</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426876</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 17:08:36 +0800</pubDate><description><![CDATA[如何升级Oracle Grid Infrastructure和RAC从11.2.0.3到11.2.0.4？


	
		
	
	
		把GI 和 RAC从 11.2.0.3升级到11.2.0.4的主要步骤：...]]></description><category></category></item><item><title><![CDATA[RAC性能分析 - gc buffer busy acquire 等待事件]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426911</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426911</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 17:01:57 +0800</pubDate><description><![CDATA[RAC性能分析 - gc buffer busy acquire 等待事件


	
		
	
	
		
			
				
					
						
							
								
						...]]></description><category></category></item><item><title><![CDATA[Data Guard - Snapshot Standby Database配置]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426906</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426906</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 16:32:36 +0800</pubDate><description><![CDATA[Data Guard - Snapshot Standby Database配置


	
		
	
	
		概述
	
	
		--------
	
	
		一般情况下，物理standby数据库处于...]]></description><category></category></item><item><title><![CDATA[Oracle诊断工具 - ORA-4030 Troubleshooting Tool]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426904</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426904</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 16:21:44 +0800</pubDate><description><![CDATA[Oracle诊断工具 - ORA-4030 Troubleshooting Tool


	
		
	
	
		
			
				ORA-4030 说明Oracle服务器进程(server process...]]></description><category></category></item><item><title><![CDATA[ASM管理 - 如何重命名diskgroup]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426741</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426741</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 16:20:07 +0800</pubDate><description><![CDATA[ASM管理 - 如何重命名diskgroup


	
		ASM 11.2.0.1 版本开始增加了diskgroup重命名的新功能，通过renamedg命令重命名已经创建的diskgroup，重命名前需要先dism...]]></description><category></category></item><item><title><![CDATA[pga_aggregate_target和_pga_max_size都不能绝对限制实际PGA的使用--ora04030]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426738</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426738</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 16:10:53 +0800</pubDate><description><![CDATA[和sga_target不同，pga_aggregate_target并不能限制PGA的大小。 另一个差别是，SGA是数据库启动时按照sga_max_size预先分配的，而PGA则是“按需分配”的。


	
...]]></description><category></category></item><item><title><![CDATA[诊断某些表统计信息不能自动收集原因]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426740</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426740</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 15:53:40 +0800</pubDate><description><![CDATA[客户反映一个schema数据导入之后一直没有自动收集统计信息，而之前导入的另外一个schema


	
		却是正常的，手动收集却没有问题。因为oracle收集统计信息有前提条件是数据变化量是否超过
10%，否则...]]></description><category></category></item><item><title><![CDATA[一个奇怪的ora-4030错误的诊断过程]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426735</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426735</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 15:51:41 +0800</pubDate><description><![CDATA[一个奇怪的ora-4030错误的诊断过程


	
前些天我收到一个客户报出的相当奇怪的ora-4030的问题，特和大家分享一下。

根据客户的描述，他是在Solaris 10 Sparc上尝试将一个Oracle...]]></description><category></category></item><item><title><![CDATA[系统内存耗尽的案例分析]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426736</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426736</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 15:41:20 +0800</pubDate><description><![CDATA[近日遇到一个RAC节点hang导致节点被重启的问题，最后经过分析，发现在系统运行一段时间后，系统内存就会耗尽，原本256G的内存，最后只剩几百M。


	
		1. 问题时间段的TOP输出可以看到，内存只剩7G，而...]]></description><category></category></item><item><title><![CDATA[sqlplus 登录时快时慢问题诊断]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426739</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426739</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 15:38:18 +0800</pubDate><description><![CDATA[客户反映前端系统反映很慢，自己通过sqlplus登录发现时而正常时而卡顿，登录之后有没有明显症状，需要诊断原因。


	
		因为客户反映登录之后并没有异常，所以先不怀疑是db端出现了性能问题，必须先从客户端程序下...]]></description><category></category></item><item><title><![CDATA[DG--standby 磁盘IO性能较差，影响Primary性能]]></title><link>https://blog.youkuaiyun.com/cpda53349199/article/details/100426732</link><guid>https://blog.youkuaiyun.com/cpda53349199/article/details/100426732</guid><author>cpda53349199</author><pubDate>Mon, 10 Jul 2017 15:33:48 +0800</pubDate><description><![CDATA[近日处理一个由于standby 磁盘IO性能较差，导致Primary的性能受到影响。


	
		主库主要是等待"log file switch completion"，通过ASH dump分析，最终发现实际等待事...]]></description><category></category></item></channel></rss>