<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuixi0781的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuixi0781</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuixi0781]]></copyright><item><title><![CDATA[VBOX RAC 12C安装一些常见问题记录]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283267</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283267</guid><author>cuixi0781</author><pubDate>Sat, 30 Dec 2017 09:09:04 +0800</pubDate><description><![CDATA[vbox安装出现问题
如果工具安装不成功 一般是 内核缺少 可以查询一下
yum install kernel-devel kernel-headers gcc gcc-c++ make
yum install kerne...]]></description><category></category></item><item><title><![CDATA[Hadoop过程中配置SSH免密码登录]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283271</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283271</guid><author>cuixi0781</author><pubDate>Sat, 30 Dec 2017 09:05:14 +0800</pubDate><description><![CDATA[假设用户名为u：


1）确认已经连接上互联网，然后输入命令：


sudo apt-get install ssh


2）配置为可以免密码登录本机。首先查看在u用户下是否存在.ssh文件夹（注意ssh...]]></description><category></category></item><item><title><![CDATA[oracle_bbed.Datafile.Header_System.数据文件头信息]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283265</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283265</guid><author>cuixi0781</author><pubDate>Fri, 25 Mar 2016 12:00:36 +0800</pubDate><description><![CDATA[BBED&gt; show
FILE#1
BLOCK#1
OFFSET0
DBA...]]></description><category></category></item><item><title><![CDATA[ORACLE 11GR2 新特性CACHE表与以前的区别]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283268</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283268</guid><author>cuixi0781</author><pubDate>Fri, 27 Jun 2014 13:17:04 +0800</pubDate><description><![CDATA[alter system set db_keep_cache_size=80M --设置keep值大小
 alter table TBL_AIRCOMPANY storage(buffer_pool kee...]]></description><category></category></item><item><title><![CDATA[V$SQLAREA 视图TOP_SQL]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283262</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283262</guid><author>cuixi0781</author><pubDate>Fri, 27 Jun 2014 13:07:30 +0800</pubDate><description><![CDATA[V$SQLAREA 
　　本视图持续跟踪所有shared pool中的共享cursor，在shared pool中的每一条SQL语句都对应一列。本视图在分析SQL语句资源使用方面非常重要。 

V$SQLAREA中的信息列...]]></description><category></category></item><item><title><![CDATA[dbms_metadata包中的get_ddl函数详细参数]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283263</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283263</guid><author>cuixi0781</author><pubDate>Mon, 30 Dec 2013 11:05:08 +0800</pubDate><description><![CDATA[当我们想要查看某个表或者是表空间的DDL的时候，可以利用dbms_metadata.get_ddl这个包来查看。


	dbms_metadata包中的get_ddl函数详细参数
GET_DDL函数返回创建对象的...]]></description><category></category></item><item><title><![CDATA[物理DG与逻辑DG的区别与逻辑DG同步异常处理方法]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283258</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283258</guid><author>cuixi0781</author><pubDate>Thu, 12 Dec 2013 09:40:29 +0800</pubDate><description><![CDATA[一、物理DG与逻辑DG的区别
官方文档是这样说明的

The main difference between physical and logical standby databases is the manner
in...]]></description><category></category></item><item><title><![CDATA[PL SQL异常处理.]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283261</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283261</guid><author>cuixi0781</author><pubDate>Tue, 26 Nov 2013 17:37:08 +0800</pubDate><description><![CDATA[PL/SQL程序执行过程中出现的错误，称之为异常。


PL/SQL程序的错误可分为两类：
  一类是PL/SQL语法错误，它由PL/SQL编译器发现并给出错误信息，
  另一类是运行时错误，由PL/SQL运行...]]></description><category></category></item><item><title><![CDATA[ORACLE用户管理与权限设置]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283264</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283264</guid><author>cuixi0781</author><pubDate>Tue, 26 Nov 2013 11:39:47 +0800</pubDate><description><![CDATA[创建用户：
CREATE USER user_name
IDENTIFIED BY password
[DEFAULT TABLESPACE tablespace_name]
[TEMPORARY TABLESPACE...]]></description><category></category></item><item><title><![CDATA[ORACLE物化视图测试]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283256</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283256</guid><author>cuixi0781</author><pubDate>Tue, 26 Nov 2013 11:27:44 +0800</pubDate><description><![CDATA[ORACLE物化视图测试

物化视图是一种特殊的物理表，“物化”(Materialized)视图是相对普通视图而言的。普通视图是虚拟表，应用的局限性大，任何对视图的查询Oracle都实际上转换为视图SQL语句的查询。这样对整...]]></description><category></category></item><item><title><![CDATA[利用RMAN搭建DATAGARD进行主备切换]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283280</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283280</guid><author>cuixi0781</author><pubDate>Thu, 07 Nov 2013 15:34:23 +0800</pubDate><description><![CDATA[使用rman的duplicate来创建备库，过程简洁了不少，无需在手动创建备库控制文件。


	



	主库SPFILE 

*.log_archive_format='%T%S%r.ARC'
*....]]></description><category></category></item><item><title><![CDATA[DG日志不应用，GAP,主备切换解决思路与办法]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283259</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283259</guid><author>cuixi0781</author><pubDate>Wed, 30 Oct 2013 15:01:15 +0800</pubDate><description><![CDATA[环境ORACLE 10G OS WINDOWS对于DG故障解决思路，DG日志切换不进行应用，DG出现GAP解决方法，DG主备库切换，当DG出现故障时，第一时间检测alert日志，服务器OS日志,网络是否通畅。...]]></description><category></category></item><item><title><![CDATA[DG保护模式与备用联机日志文件]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192784</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192784</guid><author>cuixi0781</author><pubDate>Wed, 30 Oct 2013 14:54:02 +0800</pubDate><description><![CDATA[Data Guard在最大保护maximize protection -和最高可用性maximize availability 模式下，Standby数据库必须配置standby redo log，通过下面的实验展示创建的原则和...]]></description><category></category></item><item><title><![CDATA[利用RMAN把ORACLE 10G 64位降级为32位]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100283254</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100283254</guid><author>cuixi0781</author><pubDate>Thu, 10 Oct 2013 14:45:26 +0800</pubDate><description><![CDATA[由于项目需要测试环境，原库为ORACLE 10.2.0.4 64位，环境导致需迁移到32位上机器上去，网上有很多32位升级到64位的文章，其实64位降级为32位大同小异，数据字典的改变而已，可以利用冷备 RMAN等方法...]]></description><category></category></item><item><title><![CDATA[EXP,IMP迁移数据库的时候注释乱码解决方法]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192815</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192815</guid><author>cuixi0781</author><pubDate>Wed, 02 Oct 2013 09:22:37 +0800</pubDate><description><![CDATA[在使用 imp/exp 导入/导出 把8I迁移到10G数据时发现导入的数据注释全部都是乱码.


	


	原因是导出的时候客户端字符集没有设置，或者设置不对。修改成DB的就OK了


	


	查...]]></description><category></category></item><item><title><![CDATA[UNDO表空间损坏，爆满，ORA-600[4194]/[4193]错误解决]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192821</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192821</guid><author>cuixi0781</author><pubDate>Mon, 30 Sep 2013 17:13:01 +0800</pubDate><description><![CDATA[模拟手工删除UNDO表空间 在ORADATA 中把UNDOTBS01.DBF 删除模拟启库SQL&gt; STARUP;*第 1 行出现错误:ORA-01157: 无法标识/锁定数据文件 2 - 请参阅 DBWR 跟踪文件ORA...]]></description><category></category></item><item><title><![CDATA[ORACLE 常用 函数]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192812</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192812</guid><author>cuixi0781</author><pubDate>Fri, 27 Sep 2013 11:30:34 +0800</pubDate><description><![CDATA[一）日期函数[重点掌握前四个日期函数]1,add_months[返回日期加(减)指定月份后(前)的日期]select sysdate S1,add_months(sysdate,10) S2,add_months(sysdate...]]></description><category></category></item><item><title><![CDATA[ORACLE 单引号 双引号]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192818</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192818</guid><author>cuixi0781</author><pubDate>Tue, 10 Sep 2013 16:25:23 +0800</pubDate><description><![CDATA[在ORACLE中，单引号有两个作用，一是字符串是由单引号引用，二是转义。单引号的使用是就近配对，即就近原则。而在单引号充当转义角色时相对不好理解


	


	1、从第二个单引号开始被视为转义符，如果第二个单引...]]></description><category></category></item><item><title><![CDATA[读懂Oracle 10046 SQL TRACE]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192813</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192813</guid><author>cuixi0781</author><pubDate>Mon, 26 Aug 2013 10:50:19 +0800</pubDate><description><![CDATA[为什么我们要使用10046 trace?10046 trace帮助我们解析 一条/多条SQL、PL/SQL语句的运行状态 ，这些状态包括 ：Parse/Fetch/Execute三个阶段中遇到的等待事件、消耗的物理和逻辑读、C...]]></description><category></category></item><item><title><![CDATA[ORACLE 10G 在XP系统DATAGURAD搭建]]></title><link>https://blog.youkuaiyun.com/cuixi0781/article/details/100192819</link><guid>https://blog.youkuaiyun.com/cuixi0781/article/details/100192819</guid><author>cuixi0781</author><pubDate>Thu, 22 Aug 2013 17:53:20 +0800</pubDate><description><![CDATA[由于自己机器配置很低，内存2G,硬盘250G 创建了两个XP系统虚拟机安装了ORACLE 10G 测试DATAGURAD主库 主机名 TEST1  IP 192.168.128.11 ORACLE_SID=ORCL...]]></description><category></category></item></channel></rss>