<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cimi087706的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cimi087706</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cimi087706]]></copyright><item><title><![CDATA[分区表索引的使用]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286911</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286911</guid><author>cimi087706</author><pubDate>Mon, 05 Jan 2015 16:10:11 +0800</pubDate><description><![CDATA[平时工作中，我们可能经常会遇到分区表的使用，用到分区表，当然会用到分区表索引。
 普通索引：create index DBOBJS_IDX on dbobjs(created);
 分区索引：create i...]]></description><category></category></item><item><title><![CDATA[ORACLE_BASE和ORACLE_HOME的区别]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286909</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286909</guid><author>cimi087706</author><pubDate>Thu, 23 Oct 2014 15:16:05 +0800</pubDate><description><![CDATA[OFA（Optimal Flexible Architecture)
OFA 中有几个关键目录需要知道，包括：
oracle inventory 目录：
oracle Base 目录 （ORACLE_BASE);...]]></description><category></category></item><item><title><![CDATA[SCAN 的配置和检查]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286907</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286907</guid><author>cimi087706</author><pubDate>Tue, 21 Oct 2014 16:56:19 +0800</pubDate><description><![CDATA[1、查看SCAN VIP配置
 srvctl config scan  ---集群名及3个SCAN VIP的配置。
2、查看SCAN　VIP 状态
 srvctl status scan
3、查看SCAN ...]]></description><category></category></item><item><title><![CDATA[grid 的卸载（RAC 11.2.0.3）]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286904</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286904</guid><author>cimi087706</author><pubDate>Mon, 20 Oct 2014 11:31:30 +0800</pubDate><description><![CDATA[Oracle 没有提供一个图形化的卸载工具，要想干净地卸载，我们不能简单地把Oracle目录删除了事。在GRID安装目录下有个deinstall目录，这里的deinstall脚本用于卸载grid。
1、关闭数据库和...]]></description><category></category></item><item><title><![CDATA[ora- 12514 tns 监听程序当前无法识别连接描述符中请求连接]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286906</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286906</guid><author>cimi087706</author><pubDate>Thu, 25 Sep 2014 15:18:44 +0800</pubDate><description><![CDATA[今天在连接数据时，一直报ora-12514:
修改了下面的监听文件，后来连接正常。
SID_LIST_LISTENER1 =
 (SID_LIST =
  (SID_DESC =
  (SID_NAME =...]]></description><category></category></item><item><title><![CDATA[安装PostgreSQL 时报错]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286910</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286910</guid><author>cimi087706</author><pubDate>Thu, 04 Sep 2014 10:05:25 +0800</pubDate><description><![CDATA[最近工作相对来说比较轻松，部门领导也希望有所创新，于是我选择了学习PostgreSQL。
     于是，在网上查看了一些关于PostgreSQL的资料，从官网下载了windows 64位安装包，...]]></description><category></category></item><item><title><![CDATA[Oracle自动断开数据库连接的解决办法]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286902</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286902</guid><author>cimi087706</author><pubDate>Wed, 30 Jul 2014 10:31:30 +0800</pubDate><description><![CDATA[上午刚上班，一同事跑过来说，昨天夜里将数据割接到RAC数据库，上午应用跑一会儿就自动断开，以前单实例跑很正常。

通过查找学习，找到如下两种解决方法：
方法一、直接修改资源配置文件
分三个步骤在sqlplus环境下完成。...]]></description><category></category></item><item><title><![CDATA[查看mysql数据库空间使用情况]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286908</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286908</guid><author>cimi087706</author><pubDate>Tue, 29 Jul 2014 10:43:50 +0800</pubDate><description><![CDATA[如果想知道mysql 数据库中的每个表占用的空间、表记录的行数的话，可以打开mysql的information_schema数据库。在该库中有一个tables表，这个表主要字段分别是：
table_schema:数据库名
t...]]></description><category></category></item><item><title><![CDATA[Granules of pga_aggregate_target 494 cannot be more than memory_target (497)]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286905</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286905</guid><author>cimi087706</author><pubDate>Thu, 24 Jul 2014 09:36:09 +0800</pubDate><description><![CDATA[今天对数据库进行日常检查时，在数据库日志里发现以下报错信息：
WARNING: Granules of pga_aggregate_target 494 cannot be more than memory_target (4...]]></description><category></category></item><item><title><![CDATA[oracle 数据库从10.2.0.4升级到11.2.0.3]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286899</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286899</guid><author>cimi087706</author><pubDate>Tue, 22 Jul 2014 14:45:22 +0800</pubDate><description><![CDATA[环境：linux 5.4 红帽双机（RHCS）
 数据库: 10.2.0.4
 前期准备：在两台机器的相同目录下安装11.2.0.3的数据库软件，别安装在以前的10G目录下...]]></description><category></category></item><item><title><![CDATA[parted 分区]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286903</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286903</guid><author>cimi087706</author><pubDate>Thu, 17 Jul 2014 14:29:38 +0800</pubDate><description><![CDATA[由于河南客户平台的存储有8.5T，用fdisk分区最大只能2T，所以我尝试使用parted分区。
环境： centos 6.0
介绍2种分区表：
MBR分区表：（MBR含义：主引导记录）
所支持的最...]]></description><category></category></item><item><title><![CDATA[TNS-12541： TNS： 无监听程序]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286901</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286901</guid><author>cimi087706</author><pubDate>Wed, 09 Jul 2014 11:32:46 +0800</pubDate><description><![CDATA[问题：监听程序无故停止，重建监听后，问题依旧。
解决方法：
1、在 sqlnet.ora文件中 增加如下行:
DIAG_ADR_ENABLED = OFF
2、在listener.ora文件中增加如下行:
DIAG_A...]]></description><category></category></item><item><title><![CDATA[ORA-1031权限不足  TNS-12571包写入程序失败]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286900</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286900</guid><author>cimi087706</author><pubDate>Wed, 09 Jul 2014 10:56:28 +0800</pubDate><description><![CDATA[在windown 操作系统的数据库服务器上，使用“sqlplus / as sysdba" 登录11.2.0.1数据库，显示ora-01031：
   在数据库所在服务器上登录的操作，使用的是操作系统认证...]]></description><category></category></item><item><title><![CDATA[ORA-20000:index is in unusable]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286897</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286897</guid><author>cimi087706</author><pubDate>Tue, 08 Jul 2014 10:31:01 +0800</pubDate><description><![CDATA[上午在进行例行数据库检查时，发现如下报错信息：
Mon Jul 07 22:00:56 2014
GATHER_STATS_JOB encountered errors. Check the trace file.
Er...]]></description><category></category></item><item><title><![CDATA[CRS-2409问题的处理]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286898</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286898</guid><author>cimi087706</author><pubDate>Mon, 07 Jul 2014 14:24:38 +0800</pubDate><description><![CDATA[今天在例行数据库检查时，发现 日志里有关于时间同步问题的日志信息。
   报错日志如下:
2014-07-04 13:40:33.301
[ctssd(15137)]CRS-2409:The clock on hos...]]></description><category></category></item><item><title><![CDATA[oracle 存储过程学习]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286894</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286894</guid><author>cimi087706</author><pubDate>Wed, 02 Jul 2014 15:47:42 +0800</pubDate><description><![CDATA[几个注意点：
1、在oracle中，数据表别名不能加as.
2、在存储过程中，select某一字段时，后面必须紧跟into,如果select整个记录，利用游标的话就另当别论了。
3、在利用select ....into.....]]></description><category></category></item><item><title><![CDATA[2014年6月17日女儿第一次在小银星艺术团上拉丁舞课]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286896</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286896</guid><author>cimi087706</author><pubDate>Wed, 18 Jun 2014 15:37:38 +0800</pubDate><description><![CDATA[女儿第一次在小银星上拉丁舞课
   快暑假了，于是想给女儿报点兴趣班上上。本来想给她报中国舞的，但由于年龄、身体等各方...]]></description><category></category></item><item><title><![CDATA[oracle 安装时先决条件检查失败的解决方案]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286893</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286893</guid><author>cimi087706</author><pubDate>Wed, 18 Jun 2014 15:15:14 +0800</pubDate><description><![CDATA[Oracle安装时先决条件检查失败的解决方案

	　　今天同事在安装oracle 11G客户端时，老是报磁盘空间不足，但实际磁盘还有很大的空间。


	　　安装环境：Win2008-64bit专业版，内存4G，硬盘空间...]]></description><category></category></item><item><title><![CDATA[关于序列同步的问题]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286895</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286895</guid><author>cimi087706</author><pubDate>Tue, 10 Jun 2014 22:28:52 +0800</pubDate><description><![CDATA[在使用oracle数据库时，当给一个表设置自增字段时，我们经常会使用到序列+触发器来完成。但当你需要对数据库进行导入导出时，序列很容易出问题。
 当你将数据库导出后，导入到另一个数据时，你会发现另一个数据库里的序...]]></description><category></category></item><item><title><![CDATA[11g R2新特征：oracle cluster health moniter (CHM) 简介]]></title><link>https://blog.youkuaiyun.com/cimi087706/article/details/100286892</link><guid>https://blog.youkuaiyun.com/cimi087706/article/details/100286892</guid><author>cimi087706</author><pubDate>Wed, 28 May 2014 15:47:51 +0800</pubDate><description><![CDATA[用top进行服务器检查时，发现一个进程消耗CPU比较多，于是查找资料学习了下。
13934 root   RT  0 760m 94m 55m S 8.8 0.1 12973:32 osysmond.bin...]]></description><category></category></item></channel></rss>