<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cuandou3689的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuandou3689</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuandou3689]]></copyright><item><title><![CDATA[ORA-39213: Metadata processing is not available]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387684</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387684</guid><author>cuandou3689</author><pubDate>Tue, 04 Dec 2012 16:48:16 +0800</pubDate><description><![CDATA[expdp 出现异常


$expdp system/oracle directory=dumpdir dumpfile=ora10.dmp full=y


Copyright (c) 1982, 2011,...]]></description><category></category></item><item><title><![CDATA[RAC oracle 权限更改导致 实力启动失败]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387689</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387689</guid><author>cuandou3689</author><pubDate>Tue, 27 Nov 2012 16:31:07 +0800</pubDate><description><![CDATA[ORA-27303: additional information: startup egid = 501 (oinstall), current egid =
500 (dba)


Sql&gt;st...]]></description><category></category></item><item><title><![CDATA[ORA-08102: 未找到索引关键字]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387687</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387687</guid><author>cuandou3689</author><pubDate>Thu, 25 Oct 2012 13:39:47 +0800</pubDate><description><![CDATA[在执行一个procedure的时候出现如下log
ORA-08102: 未找到索引關鍵字，obj# 52235，dba 293728808 (2)
SQL&gt; select * from dba_objects w...]]></description><category></category></item><item><title><![CDATA[CBO的运行模式first_rows,all_rows]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387682</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387682</guid><author>cuandou3689</author><pubDate>Fri, 19 Oct 2012 10:10:11 +0800</pubDate><description><![CDATA[CBO的运行模式可以分为2中
first_rows(n)
all_rows
当设置优化器模式为first_rows(n)时，意味着oracle在执行SQL时，优先将结果集中的前n条记录以最快的速度反馈给用户，而其他的结果集...]]></description><category></category></item><item><title><![CDATA[ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387722</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387722</guid><author>cuandou3689</author><pubDate>Wed, 17 Oct 2012 13:08:10 +0800</pubDate><description><![CDATA[在导出的时候
expdp system/ets directory=dumpdir dumpfile=chimei_expdp schemas=chimei logfile=exp_kanekoh.log
oracle...]]></description><category></category></item><item><title><![CDATA[SP2-0611: Error enabling STATISTICS report]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387685</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387685</guid><author>cuandou3689</author><pubDate>Thu, 11 Oct 2012 16:23:47 +0800</pubDate><description><![CDATA[SQL&gt; set autot onSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error...]]></description><category></category></item><item><title><![CDATA[11gr2 RAC注册database，listener 到CRS]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387733</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387733</guid><author>cuandou3689</author><pubDate>Sat, 29 Sep 2012 11:37:28 +0800</pubDate><description><![CDATA[在安装好了11gr2 RAC（db已建立OK）之后，
卸载grid 重新安装
$/orahome/grid/deinstall/deinstall


将database的信息注册到CRS里
[oracle@...]]></description><category></category></item><item><title><![CDATA[tns listner 监听连接很慢]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387677</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387677</guid><author>cuandou3689</author><pubDate>Fri, 28 Sep 2012 09:46:02 +0800</pubDate><description><![CDATA[数据库11.2.0.1

数据库在本地连接速度正常
但是在服务器上利用tnsname连接速度很慢
sqlplus system/oracle@test 连接需要10s左右
tnsping tnsname 也达到了84...]]></description><category></category></item><item><title><![CDATA[ORA-06512: at "PERFSTAT.STATSPACK", line 2134]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387683</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387683</guid><author>cuandou3689</author><pubDate>Thu, 27 Sep 2012 15:10:38 +0800</pubDate><description><![CDATA[安装statspcak

SQL&gt; create tablespace STATSPACK datafile '/oracle9idata/MGSSFCS/statspack01.dbf' size 500M;
T...]]></description><category></category></item><item><title><![CDATA[ORA-12528: TNS:listener: all appropriate instances are blocking new connection]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387678</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387678</guid><author>cuandou3689</author><pubDate>Tue, 25 Sep 2012 09:55:26 +0800</pubDate><description><![CDATA[利用rman做auxiliary恢复的时候出现了ORA-12528: TNS:listener: all appropriate instances are blocking new connection

$lsnrct...]]></description><category></category></item><item><title><![CDATA[asm工具asmcmd]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387675</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387675</guid><author>cuandou3689</author><pubDate>Mon, 24 Sep 2012 15:53:26 +0800</pubDate><description><![CDATA[现在对ASM磁盘管理还不是很熟悉
先了解下ASMCMD工具吧
利用该工具可以将ASM 文件复制到本地文件上，当然也可以讲本地文件复制到ASM磁盘上
[oracle@tyan147 backup]$ export ORACL...]]></description><category></category></item><item><title><![CDATA[RMAN备份出现ORA-7217错误]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387673</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387673</guid><author>cuandou3689</author><pubDate>Mon, 24 Sep 2012 15:43:18 +0800</pubDate><description><![CDATA[[oracle@tyan147 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 24 15:45:44 2012
...]]></description><category></category></item><item><title><![CDATA[在LINUX上配置oracle ASMLib的多路径磁盘]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387721</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387721</guid><author>cuandou3689</author><pubDate>Wed, 19 Sep 2012 13:54:59 +0800</pubDate><description><![CDATA[在LINUX上配置oracleASMLib的多路径磁盘
在LINUX上配置oracleASMLib的多路径磁盘
适用于：
OracleServer-EnterpriseEdition-Version:10...]]></description><category></category></item><item><title><![CDATA[RAC 找不到asm 磁盘]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387674</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387674</guid><author>cuandou3689</author><pubDate>Wed, 12 Sep 2012 11:00:12 +0800</pubDate><description><![CDATA[这几次存储都出现异常，一节点突然找不到存储，又一次原因是光纤口松动了

接好之后
该节点可以认到存储
利用#service oracleasm scandisks
#service oracleasm listdis...]]></description><category></category></item><item><title><![CDATA[ORA-07445    [SIGSEGV] [Address not mapped to object]]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387732</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387732</guid><author>cuandou3689</author><pubDate>Wed, 12 Sep 2012 10:15:11 +0800</pubDate><description><![CDATA[今天log中出现ORA-07445: exception encountered: core dump [00000001007B3808] [SIGSEGV] [Address not mapped to object]...]]></description><category></category></item><item><title><![CDATA[EXP-00056: ORACLE error 29275 encountered]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387668</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387668</guid><author>cuandou3689</author><pubDate>Wed, 29 Aug 2012 15:52:55 +0800</pubDate><description><![CDATA[exp test/test file=test.dmp wner=test log=exp.log
出错
EXP-00056: ORACLE error 29275 encounteredORA-29275: partial...]]></description><category></category></item><item><title><![CDATA[oracle 加密]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387670</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387670</guid><author>cuandou3689</author><pubDate>Tue, 28 Aug 2012 11:03:01 +0800</pubDate><description><![CDATA[利用oracle wrap 可以对函数和procedure等源码进行加密
如sql:test1.sql
create or replace procedure lerry.my_procasi number;beginfor...]]></description><category></category></item><item><title><![CDATA[ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387702</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387702</guid><author>cuandou3689</author><pubDate>Thu, 23 Aug 2012 09:01:25 +0800</pubDate><description><![CDATA[ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []
Undo 手动清除回滚段方法

检查alertlog 发现一...]]></description><category></category></item><item><title><![CDATA[ORA-12545：Connect failed because target host or object  does not exist]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387671</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387671</guid><author>cuandou3689</author><pubDate>Tue, 07 Aug 2012 13:37:30 +0800</pubDate><description><![CDATA[11gr2 RAC中客户端利用scan-ip连接server，之前都是利用vip 连接数据库，现在客户端只需要知道scan-ip即可连接，scan-ip的作用使得节点的个数对客户端是透明的
Scan-ip----àsan-li...]]></description><category></category></item><item><title><![CDATA[sqlldr 基本使用]]></title><link>https://blog.youkuaiyun.com/cuandou3689/article/details/100387665</link><guid>https://blog.youkuaiyun.com/cuandou3689/article/details/100387665</guid><author>cuandou3689</author><pubDate>Thu, 19 Jul 2012 16:35:28 +0800</pubDate><description><![CDATA[$sqlldr lerry/lerry control=loader.ctl
$cat loader.ctl
load datainfile '/orahome/mydata.csv'into table testfield...]]></description><category></category></item></channel></rss>