<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[heavenmouse的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/heavenmouse</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; heavenmouse]]></copyright><item><title><![CDATA[使用function 限制ORACLE用户密码长度]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/44079483</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/44079483</guid><author>heavenmouse</author><pubDate>Thu, 05 Mar 2015 10:48:12 +0800</pubDate><description><![CDATA[1.SYS 用户建立funcation
 
CREATE OR REPLACE FUNCTION verify_function
(username varchar2,
  password varchar2,
  old_password varchar2)
  RETURN boolean IS
   n boolean;
   m integer;
   differ in]]></description><category></category></item><item><title><![CDATA[使用sqlprofile固定与迁移执行计划]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/42147701</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/42147701</guid><author>heavenmouse</author><pubDate>Thu, 25 Dec 2014 16:23:39 +0800</pubDate><description><![CDATA[我们在数据迁移的过程中，经常会发现数据库升级或迁移后，执行计划改变的情况，我们可以通过profile的方法固定执行计划。
以下为一个10G-11G的模拟实验：
1.创建实验环境
[oracle@new10g ~]$ sqlplus mouse/mouse
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Dec 25 14:57:40 201]]></description><category></category></item><item><title><![CDATA[ora-16433的处理思路]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/42062373</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/42062373</guid><author>heavenmouse</author><pubDate>Sun, 21 Dec 2014 18:57:39 +0800</pubDate><description><![CDATA[在给一个生产库做灾难恢复的过程中，recover database报错
SQL> recover database;
 ORA-00283: recovery session canceled due to errors
 ORA-16433: The database must be opened in read/write mode.
 
该库无备份无归档，意外掉电，所以走到这步必须]]></description><category></category></item><item><title><![CDATA[关闭DRM触发的cr request retry与gc cr block lost]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/42044967</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/42044967</guid><author>heavenmouse</author><pubDate>Sat, 20 Dec 2014 19:57:23 +0800</pubDate><description><![CDATA[某用户割接现场保障，全部数据进库后，8点全网上线前最后一轮压测，截取AWR中发现如下等待
 
  Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ----]]></description><category></category></item><item><title><![CDATA[_minimum_giga_scn恢复数据库一例]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41913453</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41913453</guid><author>heavenmouse</author><pubDate>Sat, 13 Dec 2014 20:37:27 +0800</pubDate><description><![CDATA[某行今天报告一个3T的库，恢复后无法OPEN，要求我方介入。
到现场之前想当然的觉得无非不就是resetlog走起，结果到了以后用户说已经resetlog过了，从磁带恢复要两天，心凉半截。
接手系统，recover database需要归档日志。询问用户得知备份已不存在。好吧，不管了。
增加隐藏参数_allow_resetlogs_corruption=true
起手alter datab]]></description><category></category></item><item><title><![CDATA[使用v$wait_chains分析当前数据库hang]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41825917</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41825917</guid><author>heavenmouse</author><pubDate>Tue, 09 Dec 2014 16:50:18 +0800</pubDate><description><![CDATA[11G以后，hanganalyze的输出想必大家都看见了，这尼玛的太难看了。
为了解决吴同学的这个问题。ORACLE在11G以后给大家提供了一个伟大的视图，v$wait_chains.
11.1开始，DIA0后台进程自动收集hanganalyze信息至指定内存区域（LOCAL 3秒，GLOBAL 10秒），这些数据对于分析当前数据库hang是极有价值的。
以下两个脚本供大家使用：
1.查找]]></description><category></category></item><item><title><![CDATA[expdp排除特定用户的特定表]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41822853</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41822853</guid><author>heavenmouse</author><pubDate>Tue, 09 Dec 2014 13:35:38 +0800</pubDate><description><![CDATA[用户今天问了一个expdp的问题，导出8个用户下的所有表，排除A用户下的某张表，但是在其它用户下也有相同的表名，用户使用了expdp 的exclude参数，
directory=dumpdir 
dumpfile=expdp_schema_others_20141208.dmp
schemas=sync,settlement,risk,fbtransfer,fbtransferhistory]]></description><category></category></item><item><title><![CDATA[使用ASM存储EXPDP转储文件]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41787029</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41787029</guid><author>heavenmouse</author><pubDate>Sun, 07 Dec 2014 13:41:25 +0800</pubDate><description><![CDATA[某证券用户电话，本地空间已不够存储EXPDP的导出，询问是否可以存放在ASM空间内。
于是做了个小实验。
 
1.建立磁盘组中的Directory：


SQL> create or replace directory dmp as '+TESTDG/dmp';

SQL>grant read,write on directory dmp to system;



2.手]]></description><category></category></item><item><title><![CDATA[低版本使用dblink连接11G版本时报错ora-02063/ora-01017]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41728557</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41728557</guid><author>heavenmouse</author><pubDate>Thu, 04 Dec 2014 19:03:30 +0800</pubDate><description><![CDATA[一回家，某运营商电话至，创建dblink报错ora-02063/ora-01017 
关于这个BUG，遇到不是一次了，ORACLE对于该BUG 描述如下
Bug 6738104: ORA-01017 ORA-02063 WHILE CONNECTING FROM10G TO 11G VIA PUBLIC DBLINK
 
Cause
The following Bug 6738104 w]]></description><category></category></item><item><title><![CDATA[关于RAC节点重启的一点胡言乱语]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41706095</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41706095</guid><author>heavenmouse</author><pubDate>Wed, 03 Dec 2014 22:24:09 +0800</pubDate><description><![CDATA[关于RAC的io fence,一直想写点什么作为总结，毕竟干了这么多年，遇见的大大小小的节点重启也很多次了，今天，月黑风高，LOL被人骂成翔，还是静下心来写写技术文档吧
RAC的io fence,中文名IO隔离，当RAC节点间无法正常联系彼此的时候，为了保证数据完整性，ORACLE会对故障节点发起驱逐命令，驱逐命令在原理上就是通过voting disk发出killblock，使节点重启或蓝屏，避]]></description><category></category></item><item><title><![CDATA[TNS-12518: TNS:listener could not hand off client connection &  Broken pipe]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41597527</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41597527</guid><author>heavenmouse</author><pubDate>Sat, 29 Nov 2014 17:41:25 +0800</pubDate><description><![CDATA[一个很有意思的CASE，早上接报某用户的核心生产部分业务中断，无法连接。该用户为4节点RAC，后现场工程师修改WAS指向除第一节点意外其他节点，业务恢复正常。

到了现场后常规流程，做AWR的时候发现出了BUG，enq-wf contention,无法获取AWR报告，检查等待事件，节点1一切正常。ALERT日志无错误。

VMSTAT显示节点压力较大。用户DBA表示昨晚OGG有过部分进程僵]]></description><category></category></item><item><title><![CDATA[ORA-27301: OS failure message: Not enough space]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41578123</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41578123</guid><author>heavenmouse</author><pubDate>Fri, 28 Nov 2014 20:06:37 +0800</pubDate><description><![CDATA[火车上收到邮件，某证券用户CRM库异常崩溃，检查相关日志
故障时点
Thu Nov 27 11:51:54 2014
Errors in file /oracle/admin/crmii/bdump/crmii_psp0_5308592.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
OR]]></description><category></category></item><item><title><![CDATA[RAC环境下NTP导致的VKTM detected a time drift]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41552895</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41552895</guid><author>heavenmouse</author><pubDate>Thu, 27 Nov 2014 20:23:45 +0800</pubDate><description><![CDATA[今天巡检某行生产库，一套RAC的2节点ALERT日志中报错
 
Thu Nov 22 06:30:28 2014
Time drift detected. Please check VKTM trace file for more details.
Thu Nov 22 07:30:30 2014
Time drift detected. Please check VKTM trace ]]></description><category></category></item><item><title><![CDATA[ORA 7445 [V_vsnprintf()]]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41446497</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41446497</guid><author>heavenmouse</author><pubDate>Mon, 24 Nov 2014 16:04:28 +0800</pubDate><description><![CDATA[今天巡检某高校的库时在LOG中发现07445 
 
Ensure that the RMAN process is not killed during backup.]]></description><category></category></item><item><title><![CDATA[ogg-01172]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41441129</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41441129</guid><author>heavenmouse</author><pubDate>Mon, 24 Nov 2014 10:30:49 +0800</pubDate><description><![CDATA[ogg-01172,rep进程abended.]]></description><category></category></item><item><title><![CDATA[SOLARIS 10 安装ORACLE 10g rac 注意事项及准备工作]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41247861</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41247861</guid><author>heavenmouse</author><pubDate>Tue, 18 Nov 2014 15:38:47 +0800</pubDate><description><![CDATA[1.创建用户与属主

mkdir /oracle
chmod -R 777 /oracle
groupadd -g 100 oinstall
groupadd -g 101 dba
useradd -u 200 -g oinstall -G dba -s /usr/bin/bash -d /oracle -m oracle
passwd oracle
chown -R oracle]]></description><category></category></item><item><title><![CDATA[有意思的ora_rowscn]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41116475</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41116475</guid><author>heavenmouse</author><pubDate>Fri, 14 Nov 2014 11:53:42 +0800</pubDate><description><![CDATA[今天某用户电话问了一个有意思的问题。]]></description><category></category></item><item><title><![CDATA[WINDOWS X64平台超出32核CPU 安装11.2.0.3 GI 蓝屏]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41115105</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41115105</guid><author>heavenmouse</author><pubDate>Fri, 14 Nov 2014 10:55:13 +0800</pubDate><description><![CDATA[昨天同事安装11G RAC遇到蓝屏，查询METALINK，]]></description><category></category></item><item><title><![CDATA[kkjcre1p: unable to spawn jobq slave process的排查思路]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41085077</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41085077</guid><author>heavenmouse</author><pubDate>Thu, 13 Nov 2014 19:27:31 +0800</pubDate><description><![CDATA[才下火车，接到电话说某用户的一套核心RAC一个节点重启，心急火燎的赶回家收LOG。]]></description><category></category></item><item><title><![CDATA[expdp使用NFS遭遇ORA-27054]]></title><link>https://blog.youkuaiyun.com/heavenmouse/article/details/41047963</link><guid>https://blog.youkuaiyun.com/heavenmouse/article/details/41047963</guid><author>heavenmouse</author><pubDate>Wed, 12 Nov 2014 18:26:43 +0800</pubDate><description><![CDATA[Disallow MOUNT POINT checks with event:
"10298 trace name context forever, level 32"

Event 10298 disables the NFS checks in the 10.2 code]]></description><category></category></item></channel></rss>