<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[DolphinHat的专栏]]></title><description><![CDATA[——除了事实之外，没有其它的权威！]]></description><link>https://blog.youkuaiyun.com/orcldb</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; orcldb]]></copyright><item><title><![CDATA[oracle 11g未找到文件WFMLRSVCApp.ear文件]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/17509797</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/17509797</guid><author>orcldb</author><pubDate>Mon, 23 Dec 2013 18:50:32 +0800</pubDate><description><![CDATA[安装oracle 11.2.4时，报错：
未找到文件...WFMLRSVCApp.ear文件

解决方法如下：
oracle 11.2.4有两个压缩包，将压缩包解压至同一目录再安装即可解决此类问题。]]></description><category></category></item><item><title><![CDATA[listener之一二]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/12784273</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/12784273</guid><author>orcldb</author><pubDate>Wed, 16 Oct 2013 18:01:51 +0800</pubDate><description><![CDATA[一、注册
    注册就是将数据库作为一个服务注册到监听程序。客户端不需要知道数据库名和实例名，只需要
知道该数据库对外提供的服务名就可以申请连接到数据库。这个服务名可以与实例名一致，也可以不
一致，且可以注册多个服务。
    注册可以分为静态注册与动态注册，下面分别介绍静态注册和动态注册。
二、静态注册
    静态注册就是预先配置好listener.ora文件，配置信息如下：]]></description><category></category></item><item><title><![CDATA[vmware server 1.0搭建共享存储]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/12705633</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/12705633</guid><author>orcldb</author><pubDate>Mon, 14 Oct 2013 10:48:06 +0800</pubDate><description><![CDATA[vmware server 1.0搭建共享存储
两台虚拟机，分别为L01,L02
1.首先使用vmware-vdiskmanager.exe命令创建磁盘(该命令位于vmware server的安装目录下)
vmware-vdiskmanager.exe -c -s 8GB -a lsilogic -t 2 E:\Disk\db01.vmdk
2.将磁盘db01.vmdk分别添加到两台虚拟机]]></description><category></category></item><item><title><![CDATA[临时表空间]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/12064467</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/12064467</guid><author>orcldb</author><pubDate>Thu, 26 Sep 2013 18:15:58 +0800</pubDate><description><![CDATA[临时表空间
11g之前(不包括11g)临时表空间不会自动释放其内容，除非重启数据库；但11g之后可通过shrink方法来搜索临时表空间。
临时表空间消耗的主要操作有：
1.order by
2.group by
3.distinct
4.union [all]
5.create[|rebuild] index
6.analyze
1.查询数据库默认临时表空间
select * ]]></description><category></category></item><item><title><![CDATA[利用rman进行异机还原(目录不同)]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/11896727</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/11896727</guid><author>orcldb</author><pubDate>Sun, 22 Sep 2013 14:26:06 +0800</pubDate><description><![CDATA[--注：备份操作省略，详见利用rman进行异机还原(目录相同)。下列操作均在目标服务器上进行。
--rman
[oracle@db02 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Sun Sep 22 08:19:14 2013
Copyright (c) 1982, 2005, Oracle]]></description><category></category></item><item><title><![CDATA[利用rman进行异机还原(目录相同)]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/11803071</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/11803071</guid><author>orcldb</author><pubDate>Wed, 18 Sep 2013 13:19:17 +0800</pubDate><description><![CDATA[利用rman进行异机还原(目录相同)
源始库：192.168.201.2
目标库：192.168.201.3
--192.168.201.2
--rman
[oracle@db01 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Sep 18 08:52:25 2013
Copyri]]></description><category></category></item><item><title><![CDATA[Checking Network Configuration requirements  Failed]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/11776141</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/11776141</guid><author>orcldb</author><pubDate>Tue, 17 Sep 2013 16:15:07 +0800</pubDate><description><![CDATA[安装oracle执行检查，出现
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Failed 
Problem: The install has detected that the primary IP address of the sys]]></description><category></category></item><item><title><![CDATA[PCTFREE与PCTUSED概述]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/11082183</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/11082183</guid><author>orcldb</author><pubDate>Wed, 04 Sep 2013 17:32:30 +0800</pubDate><description><![CDATA[PCTFREE：表示一个block保留的空闲百分比。PCT_FREE的默认值为10，表示block可用空间剩余10%时，该block则不再接受数据insert，只能update；其引入的目的
是为了减少行链接的发生。


PCTUSED：表示一个block保留的可用百分比。当tablespace的管理方式为manual时，可设置该参数值（auto时不能设置）；表示block已用空间大于n%]]></description><category></category></item><item><title><![CDATA[rowid结构浅析]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/10990061</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/10990061</guid><author>orcldb</author><pubDate>Tue, 03 Sep 2013 15:36:38 +0800</pubDate><description><![CDATA[select rowid from dual
AAAAB0AABAAAAOhAAA
rowid结构如下：
对象号    文件号   块号   行号
XXXXXX    XXX     XXXXXX XXX
因此，
AAAAB0 对象号
AAB    文件号
AAAAOh 块号
AAA    行号
如何得知这些编号对应的十进制编码值呢(rowid是基于64位编码的18个字符显示的]]></description><category></category></item><item><title><![CDATA[更改standby库的数据文件路径]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/10329897</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/10329897</guid><author>orcldb</author><pubDate>Mon, 26 Aug 2013 11:07:16 +0800</pubDate><description><![CDATA[更改standby库的数据文件路径
[oracle@bldc02 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 26 10:44:57 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
SQL> conn /as sysdba]]></description><category></category></item><item><title><![CDATA[DB_WRITER_PROCESSES与LOG_ARCHIVE_MAX_PROCESSES]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/10183555</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/10183555</guid><author>orcldb</author><pubDate>Thu, 22 Aug 2013 15:14:50 +0800</pubDate><description><![CDATA[DB_WRITER_PROCESSES
Property  Description
Parameter type  Integer
Default value  1 or CPU_COUNT / 8, whichever is greater 默认值为1或CPU个数的1/8
Modifiable  No      
Range of values  1 to 20      取值范围为1]]></description><category></category></item><item><title><![CDATA[强制日志归档]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9988397</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9988397</guid><author>orcldb</author><pubDate>Thu, 15 Aug 2013 18:51:53 +0800</pubDate><description><![CDATA[在Data Guard环境中，如果oracle数据库归档频率过低导致出现故障时丢失数据，我们可通过

archive_lag_target参数来强制进行日志切换并归档。]]></description><category></category></item><item><title><![CDATA[RMAN常用命令(未完待续)]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9970141</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9970141</guid><author>orcldb</author><pubDate>Wed, 14 Aug 2013 19:28:33 +0800</pubDate><description><![CDATA[1、SHOW命令：
   1.1、RMAN> show all;      显示rman参数配置 
2、REPORT命令：
   2.1、RMAN> report schema                          报告目标数据库的物理结构
   2.2、RMAN>report need backup days=n;              报告最近n天没有被备份的数据文件]]></description><category></category></item><item><title><![CDATA[ORACLE常用监控语句(未完待续)]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9950847</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9950847</guid><author>orcldb</author><pubDate>Tue, 13 Aug 2013 16:49:51 +0800</pubDate><description><![CDATA[--查询日志的切换频率
select  t1.RECID as srecid
       ,t2.RECID as erecid
       ,t1.FIRST_TIME as stime
       ,t2.FIRST_TIME as etime
       ,round((t2.FIRST_TIME-t1.FIRST_TIME)*1440,2) as minutes
fro]]></description><category></category></item><item><title><![CDATA[LGWR: Failed to archive log X thread 1 sequence 151016 (16086)]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9949209</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9949209</guid><author>orcldb</author><pubDate>Tue, 13 Aug 2013 15:39:18 +0800</pubDate><description><![CDATA[更改主库redo大小，出现16086的错误，错误信息如下：
LGWR: Failed to archive log 4 thread 1 sequence 151016 (16086)
当主库redo大小发生变更，那么备库的standby日志也需要做相应调整
备注：调整redo log大小的几个步骤
1.添加日志组(按所需的redo log大小添加，具体大小和组的个数视log switch]]></description><category></category></item><item><title><![CDATA[redo log的管理]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9949165</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9949165</guid><author>orcldb</author><pubDate>Tue, 13 Aug 2013 15:31:03 +0800</pubDate><description><![CDATA[1.添加日志组
alter database add logfile group 1 ('/u02/oradata/bolan/redo01.log') size 100m;
2.添加日志组成员
alter database add logfile member '/u02/oradata/bolan/redo01.log' to group 1;
3.删除日志组
alter datab]]></description><category></category></item><item><title><![CDATA[统计没有使用绑定变量的sql语句]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/9041139</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/9041139</guid><author>orcldb</author><pubDate>Thu, 06 Jun 2013 17:51:36 +0800</pubDate><description><![CDATA[摘要：
select to_char(FORCE_MATCHING_SIGNATURE) as FORCE_MATCHING_SIGNATURE, count(1) as counts
from v$sql
where FORCE_MATCHING_SIGNATURE>0 and FORCE_MATCHING_SIGNATURE 
group by FORCE_MATCHING_SIGNA]]></description><category></category></item><item><title><![CDATA[关于oracle的where条件有特殊符号的处理]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/8904327</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/8904327</guid><author>orcldb</author><pubDate>Thu, 09 May 2013 10:52:31 +0800</pubDate><description><![CDATA[有这样的一些数据：
select 'fie_a' as col from dual
union all
select 'fie_b' as col from dual
union all
select 'fi_a' as col from dual
union all
select 'fi_b' as col from dual;
我需要从这些数据中查找fi_开头的数据，一般写法是]]></description><category></category></item><item><title><![CDATA[关于oracle的&字符的处理]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/8904272</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/8904272</guid><author>orcldb</author><pubDate>Thu, 09 May 2013 10:45:40 +0800</pubDate><description><![CDATA[&符号是oracle的替代字符，只要出现该字符oracle就会提示输入替代值。解决该问题有以下三种方式：
1.设置会话，将&符号作为普通字符
SQL> set define off;
SQL> select 'a&b' from dual;
2.拆分字符
SQL> select 'a'||chr(38)||'b' from dual;
SQL> select 'a'||'&'||'b']]></description><category></category></item><item><title><![CDATA[oracle如何显示毫秒？]]></title><link>https://blog.youkuaiyun.com/orcldb/article/details/8851037</link><guid>https://blog.youkuaiyun.com/orcldb/article/details/8851037</guid><author>orcldb</author><pubDate>Thu, 25 Apr 2013 17:50:29 +0800</pubDate><description><![CDATA[date类型只能精确到秒，要想精确到毫秒，需要使用timestamp类型。
应用举例：
举例1：
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff') from dual;
举例2：
select to_char(to_timestamp('20130425 080000','yyyy-mm-dd hh24:mi:ss.ff'),]]></description><category></category></item></channel></rss>