<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cpc84938的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cpc84938</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cpc84938]]></copyright><item><title><![CDATA[Linux7.4 安装oracle 19C RAC]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234603</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234603</guid><author>cpc84938</author><pubDate>Tue, 20 Aug 2019 16:11:20 +0800</pubDate><description><![CDATA[##安装rpm
yum-yinstallbcgccgcc-c++binutilsmakegdbcmakeglibckshelfutils-libelfelfutils-libelf-devel...]]></description><category></category></item><item><title><![CDATA[AWR TOP SQL实现]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234608</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234608</guid><author>cpc84938</author><pubDate>Mon, 08 Jul 2019 11:25:49 +0800</pubDate><description><![CDATA[1按解析次数排序






selecta.*,
to_char(substr(b.sql_text,1,4000))
from
(selectdhs.sql_id,...]]></description><category></category></item><item><title><![CDATA[OGG删除过期的trail文件，shell实现]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234600</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234600</guid><author>cpc84938</author><pubDate>Mon, 08 Jul 2019 09:41:25 +0800</pubDate><description><![CDATA[脚本主要实现对OGG进程过期trail文件的删除处理。


脚本只实现对已经读取的文件进行删除，如果stop或ABENDED的话也不会出问题，因为只删除已读取的文件，未读取不做操作。
...]]></description><category></category></item><item><title><![CDATA[网卡流量监控脚本，python实现]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234605</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234605</guid><author>cpc84938</author><pubDate>Thu, 04 Jul 2019 16:55:11 +0800</pubDate><description><![CDATA[使用-h获取帮助



在Python2.7版本以上执行





脚本获取：

https://github.com/raysuen/AdapterMonitor






内容:...]]></description><category></category></item><item><title><![CDATA[linux7 静默安装 11GR2 RAC]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234599</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234599</guid><author>cpc84938</author><pubDate>Fri, 14 Jun 2019 18:20:19 +0800</pubDate><description><![CDATA[vi/etc/hosts
#publicip
192.168.56.71ora71
192.168.56.72ora72
#privateip
192.168.221.71ora...]]></description><category></category></item><item><title><![CDATA[Oracle redo日志内容探索(一)]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234598</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234598</guid><author>cpc84938</author><pubDate>Wed, 05 Jun 2019 08:57:05 +0800</pubDate><description><![CDATA[昨天，和群里的小伙伴讨论redo内容是什么，很多人认为redo内就是存放的sql语句，甚至是解析后的sql。




  例如，一条udate对表A修改了20万条记录。redo内相当于形成了20万条...]]></description><category></category></item><item><title><![CDATA[ORA-16038: log 3 sequence# 510 cannot be archived]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234642</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234642</guid><author>cpc84938</author><pubDate>Tue, 21 May 2019 17:59:56 +0800</pubDate><description><![CDATA[#问题描述：启动报错



SQL&gt; startup


ORACLE instance started.


Total System Global Area 1787138048 byt...]]></description><category></category></item><item><title><![CDATA[获取AWR的脚本，可以在crontab里面部署]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234597</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234597</guid><author>cpc84938</author><pubDate>Fri, 17 May 2019 17:54:08 +0800</pubDate><description><![CDATA[使用方法可以在脚本最后查看，或者使用-h参数获取帮助。





版本更新：


1 修改不能在rac环境执行的问题。



修改后获取本节点的awr，不能指定获取其...]]></description><category></category></item><item><title><![CDATA[WRH$_ACTIVE_SESSION_HISTORY未自动清理导致SYSAUX空间过度增长的处理方法]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234602</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234602</guid><author>cpc84938</author><pubDate>Mon, 25 Feb 2019 10:31:51 +0800</pubDate><description><![CDATA[参考MOS文档： 

WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged Based Upon the Retention Policy (文档 ID 387914.1...]]></description><category></category></item><item><title><![CDATA[keepalived配置redis主从切换]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234632</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234632</guid><author>cpc84938</author><pubDate>Tue, 04 Dec 2018 16:40:50 +0800</pubDate><description><![CDATA[IP规划：


主节点：10.0.37.224


备节点：10.0.37.225


VIP：10.0.37.226


一 2个节点安装redis


1安装






...]]></description><category></category></item><item><title><![CDATA[long2varchar 把long转换为varchar2]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234589</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234589</guid><author>cpc84938</author><pubDate>Sun, 11 Nov 2018 22:52:34 +0800</pubDate><description><![CDATA[发文的主要原因是因为前几天一个同事一直说获取分区表的high_value不会，并且一直表示long类型完全不能获取。迫不得已，我今晚查了一下资料，发现oracle本身有对long类型的转换支持。






...]]></description><category></category></item><item><title><![CDATA[linux7 开机自启动oracle]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234675</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234675</guid><author>cpc84938</author><pubDate>Thu, 30 Aug 2018 16:25:17 +0800</pubDate><description><![CDATA[描述：


linux7安装oracle11G后，设置开机自启动



问题：


当服务器重启或使用systemctl start oracle.service以后，会把...]]></description><category></category></item><item><title><![CDATA[oracle11g在linux7的静默安装脚本]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234674</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234674</guid><author>cpc84938</author><pubDate>Mon, 13 Aug 2018 15:25:33 +0800</pubDate><description><![CDATA[1 把11.2.0.4的安装文件放到基础目录，一般我放在/u01下


2 把

compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm和

elfutils-lib...]]></description><category></category></item><item><title><![CDATA[非OMF管理 自动添加数据文件add_datafiles.sh]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234588</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234588</guid><author>cpc84938</author><pubDate>Fri, 10 Aug 2018 09:15:14 +0800</pubDate><description><![CDATA[oracle_ray


.sh脚本在我的博客中有，请自行搜索。






这个脚本需要规范的路径，主要是数据文件的命名，要以数字结尾的.dbf文件开可以实现自动数字自加。


例如：

...]]></description><category></category></item><item><title><![CDATA[insert引起的死锁，起因主键冲突]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234594</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234594</guid><author>cpc84938</author><pubDate>Thu, 02 Aug 2018 10:22:49 +0800</pubDate><description><![CDATA[起因：生产数据库突然产生死锁，查询trace发现是insert语句造成的，经过向大神咨询和论坛发帖询问，获得相关信息。







参考：


http://www.xifenfei.com/2011/0...]]></description><category></category></item><item><title><![CDATA[oracle_ray.sh 常用的oracle sql功能脚本]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234593</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234593</guid><author>cpc84938</author><pubDate>Wed, 18 Jul 2018 16:01:19 +0800</pubDate><description><![CDATA[如果个人有其他需求不会自己添加进脚本，可以给我留言，我再更新脚本。


获取帮助：


oracle_ray.sh help=y



 更新:


  第二版：

...]]></description><category></category></item><item><title><![CDATA[OMF管理自动添加数据文件脚本add_datafile.sh]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234586</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234586</guid><author>cpc84938</author><pubDate>Wed, 18 Jul 2018 15:04:52 +0800</pubDate><description><![CDATA[oracle_ray.sh这个脚本在我的博客内能找到，如需要请自行寻找



修改项：


1 在crontab中执行不读取profile文件就找不到sqlplus。如果是linux请读取bas...]]></description><category></category></item><item><title><![CDATA[python 删除非空目录]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234592</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234592</guid><author>cpc84938</author><pubDate>Mon, 09 Jul 2018 17:05:55 +0800</pubDate><description><![CDATA[点击(此处)折叠或打开
		
	
	
		
			
				#!/usr/bin/env python3

			
			
				# _*_coding:utf-8_*_
		...]]></description><category></category></item><item><title><![CDATA[python 创建密码]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234590</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234590</guid><author>cpc84938</author><pubDate>Sun, 06 May 2018 00:59:55 +0800</pubDate><description><![CDATA[使用：
mkpass -l [password length] [-nu|-nl|-ns]
获取帮助：
  mkpass -h




	
		
			点击(此处)折叠或打开
		
	
	...]]></description><category></category></item><item><title><![CDATA[python使用cx_Oracle连接oracle数据库获取常用信息]]></title><link>https://blog.youkuaiyun.com/cpc84938/article/details/100234587</link><guid>https://blog.youkuaiyun.com/cpc84938/article/details/100234587</guid><author>cpc84938</author><pubDate>Sun, 22 Apr 2018 01:05:37 +0800</pubDate><description><![CDATA[直接使用：
  CheckOracle.py -H [remote_home] -u [oracle_user] -p [oracle_password] -s [oracle_SID] -i [information] ...]]></description><category></category></item></channel></rss>