<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[renfengjun]]></title><description><![CDATA[本心，知行合一。]]></description><link>https://blog.csdn.net/renfengjun</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; renfengjun]]></copyright><item><title><![CDATA[介绍一下当前使用的Oracle数据库自动化运维方式]]></title><link>https://blog.csdn.net/renfengjun/article/details/108223722</link><guid>https://blog.csdn.net/renfengjun/article/details/108223722</guid><author>renfengjun</author><pubDate>Tue, 25 Aug 2020 16:19:47 +0800</pubDate><description><![CDATA[介绍一下当前使用的Oracle数据库自动化运维方式整体结构12C API system
整体结构
不管12C还是11G集群使用的都是svn+httpd+RPM+运维脚本的方式。
SVN：运维脚本管理
httpd：RPM repo
RPM：包含运维脚本
大体工作流程：
client:每台数据库服务器都有自动更新RPM的crontab。当有新脚本发布时，client会自动查询是否有新版本的rpm然后执行自动更新操作。
svn server端：
当有新运维脚本code 提交时，会自动调用svn 服务器的post-]]></description><category></category></item><item><title><![CDATA[12c的两个监控session脚本]]></title><link>https://blog.csdn.net/renfengjun/article/details/103058238</link><guid>https://blog.csdn.net/renfengjun/article/details/103058238</guid><author>renfengjun</author><pubDate>Wed, 13 Nov 2019 21:55:14 +0800</pubDate><description><![CDATA[集群
这里注意QWERTY是密码需要自己填写
SCANADDR需要自己根据自己集群的scan命名规则填写，或者直接填写定植
root@cube:/scripts# cat 12cRACsession.sh
#!/usr/bin/bash
OLDPATH=PATHexportPATH=PATH
export PATH=PATHexportPATH=PATH:/usr/local/bin
SCRIPT...]]></description><category></category></item><item><title><![CDATA[分享几个11G用于监控的脚本]]></title><link>https://blog.csdn.net/renfengjun/article/details/103057826</link><guid>https://blog.csdn.net/renfengjun/article/details/103057826</guid><author>renfengjun</author><pubDate>Wed, 13 Nov 2019 21:32:29 +0800</pubDate><description><![CDATA[./blocks.sh
USERNAME
DEXTER
Select one schema from the list above or( Press enter to see all blocks in the database):
BLK_MODULE   BLOCKER    TY BLK_SESS    CLIENT_INFO                    BLOCKED_OBJE...]]></description><category></category></item><item><title><![CDATA[希望大家关注我的微信公众号以及个人网站]]></title><link>https://blog.csdn.net/renfengjun/article/details/102720247</link><guid>https://blog.csdn.net/renfengjun/article/details/102720247</guid><author>renfengjun</author><pubDate>Thu, 24 Oct 2019 11:48:45 +0800</pubDate><description><![CDATA[欢迎大家关注我的公众账号：
从oracle到mysql

以及个人网站：
http://www.10xdba.com

]]></description><category></category></item><item><title><![CDATA[分享一个前两天写的自动监控blocking 的脚本（基于12C）]]></title><link>https://blog.csdn.net/renfengjun/article/details/97893439</link><guid>https://blog.csdn.net/renfengjun/article/details/97893439</guid><author>renfengjun</author><pubDate>Wed, 31 Jul 2019 10:44:19 +0800</pubDate><description><![CDATA[闲话不说直接上脚本。
用于再rac环境下监控本机所有非standby db的blocking 情况。11g应该也适用。
blocking2.sql
set serveroutput on 
set lines 300
declare
v_msg varchar2(20000);
v_title varchar2(20000);
v_find_obj_sql varchar2(20000);
v_f...]]></description><category></category></item><item><title><![CDATA[数据库自动化运维3-Restful API Postgres DB helpper]]></title><link>https://blog.csdn.net/renfengjun/article/details/93358960</link><guid>https://blog.csdn.net/renfengjun/article/details/93358960</guid><author>renfengjun</author><pubDate>Sat, 22 Jun 2019 20:12:43 +0800</pubDate><description><![CDATA[今天来添加对postgres的支持
Codes:
jwttoken.py 加入如下代码
from pgtest import util as pgutil
from pgtest import mypg

app.config['PGPWD'] = 'oracle123'
app.config['PGUSR'] = 'postgres'
app.config['PGHOST'] = '192.16...]]></description><category></category></item><item><title><![CDATA[数据库自动化运维2-Restful API JWT and Redis authorization]]></title><link>https://blog.csdn.net/renfengjun/article/details/93135507</link><guid>https://blog.csdn.net/renfengjun/article/details/93135507</guid><author>renfengjun</author><pubDate>Thu, 20 Jun 2019 21:13:25 +0800</pubDate><description><![CDATA[上一篇文章提供了一个简单的Restful API的Demo，今天来完善一下它的验证机制。
这里使用redis存放关于用户的密码以及roles等信息，并且根据roles以及客户端请求的endpoint来完成权限验证。
redis里面存放的信息：
[root@adirfj ~]# redis-cli
127.0.0.1:6379&gt; AUTH "password"
OK
127.0.0.1:637...]]></description><category></category></item><item><title><![CDATA[数据库自动化运维1-Restful API一个小DEMO]]></title><link>https://blog.csdn.net/renfengjun/article/details/92847119</link><guid>https://blog.csdn.net/renfengjun/article/details/92847119</guid><author>renfengjun</author><pubDate>Wed, 19 Jun 2019 21:23:01 +0800</pubDate><description><![CDATA[很久没有更新博客了，今天和大家分享一下最近学到的一些关于API方面的东西。]]></description><category></category></item><item><title><![CDATA[ORA-00600 [kpdbLoadCbk-bad-obj#] ORA-65106 手动修复PDB container$信息]]></title><link>https://blog.csdn.net/renfengjun/article/details/87793972</link><guid>https://blog.csdn.net/renfengjun/article/details/87793972</guid><author>renfengjun</author><pubDate>Wed, 20 Feb 2019 14:07:00 +0800</pubDate><description><![CDATA[环境：
Oracle Linux7 x64
./opatch lspatches 
27335416;OCW JAN 2018 RELEASE UPDATE 12.2.0.1.180116 (27335416) 
27105253;Database Release Update : 12.2.0.1.180116 (27105253) 

OPatch succeeded.
问题描述：
在我们创建...]]></description><category></category></item><item><title><![CDATA[Django FileField 上传中文文件乱码的问题解决]]></title><link>https://blog.csdn.net/renfengjun/article/details/79999679</link><guid>https://blog.csdn.net/renfengjun/article/details/79999679</guid><author>renfengjun</author><pubDate>Thu, 19 Apr 2018 09:04:18 +0800</pubDate><description><![CDATA[自己写了个自动化运维的小程序，使用docker+django发布项目，base image为centos7，python版本为2.7，django 1.11.5由于项目中有上传附件的功能，发现上传包含中文的文件的时候，会出现乱码的问题。寻遍网络，各种解决方案，包括修改setting.py，修改相应的views.py加入import sysreload(sys)sys.setdefaultencod...]]></description><category></category></item><item><title><![CDATA[Oracle database 18c 发布时间确定 （20180124最新消息）]]></title><link>https://blog.csdn.net/renfengjun/article/details/79228468</link><guid>https://blog.csdn.net/renfengjun/article/details/79228468</guid><author>renfengjun</author><pubDate>Thu, 01 Feb 2018 14:49:44 +0800</pubDate><description><![CDATA[今日Oracle support更新了文档：英文版Release Schedule of Current Database Releases (文档 ID 742060.1)中文版当前数据库版本的发行时间表 (文档 ID 1626244.1)确定了Oracle Database 18c的发布时间：看来Oracle的一体机才是亲儿子，在今年第一季度就会发布。但是各大操作系统上的18C数据库只有等到2]]></description><category></category></item><item><title><![CDATA[docker 发布 django项目]]></title><link>https://blog.csdn.net/renfengjun/article/details/79173427</link><guid>https://blog.csdn.net/renfengjun/article/details/79173427</guid><author>renfengjun</author><pubDate>Fri, 26 Jan 2018 15:57:49 +0800</pubDate><description><![CDATA[打包django项目 先生成需要的python模块列表pip freeze >req.txt然后打包程序tar cvf django1.tar ./django1 scp到docker服务器的/python目录下解压 确定基础镜像版本首先选择基础镜像，这里选择的是centos，我们的原项目是运行在centos7.3中的。  先到hub.docker.com中查询image的名称 https://h]]></description><category></category></item><item><title><![CDATA[Linux kernel可设置参数说明(sysctl.conf)]]></title><link>https://blog.csdn.net/renfengjun/article/details/78902291</link><guid>https://blog.csdn.net/renfengjun/article/details/78902291</guid><author>renfengjun</author><pubDate>Tue, 26 Dec 2017 14:56:07 +0800</pubDate><description><![CDATA[直接使用ctrl+f查找即可。]]></description><category></category></item><item><title><![CDATA[Exadata Cell 节点 griddisk容量计算小节]]></title><link>https://blog.csdn.net/renfengjun/article/details/78662966</link><guid>https://blog.csdn.net/renfengjun/article/details/78662966</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 11:02:18 +0800</pubDate><description><![CDATA[Exadata Cell 节点 griddisk容量计算小节]]></description><category></category></item><item><title><![CDATA[windows 静默模式部署Oracle数据库]]></title><link>https://blog.csdn.net/renfengjun/article/details/78662808</link><guid>https://blog.csdn.net/renfengjun/article/details/78662808</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 10:55:41 +0800</pubDate><description><![CDATA[windows 利用telnet远程静默模式部署Oracle数据库]]></description><category></category></item><item><title><![CDATA[SuperCluster 在IO domain上配置数据库]]></title><link>https://blog.csdn.net/renfengjun/article/details/78662504</link><guid>https://blog.csdn.net/renfengjun/article/details/78662504</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 10:36:24 +0800</pubDate><description><![CDATA[SuperCluster 在IO domain上配置数据库 的过程]]></description><category></category></item><item><title><![CDATA[AIX下创建ASM磁盘组]]></title><link>https://blog.csdn.net/renfengjun/article/details/78661860</link><guid>https://blog.csdn.net/renfengjun/article/details/78661860</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 09:53:43 +0800</pubDate><description><![CDATA[AIX下创建ASM磁盘组]]></description><category></category></item><item><title><![CDATA[SCAN 原理小节]]></title><link>https://blog.csdn.net/renfengjun/article/details/78661765</link><guid>https://blog.csdn.net/renfengjun/article/details/78661765</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 09:49:07 +0800</pubDate><description><![CDATA[窥一斑而知全豹]]></description><category></category></item><item><title><![CDATA[Oracle数据库静默模式小节(LINUX 11G)]]></title><link>https://blog.csdn.net/renfengjun/article/details/78661408</link><guid>https://blog.csdn.net/renfengjun/article/details/78661408</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 09:16:13 +0800</pubDate><description><![CDATA[Linux 安装oracle 11.2软件p13390677_112040_SOLARIS64_1of7.zipp13390677_112040_SOLARIS64_2of7.zip示例文件在解压目录response目录下db_install.rsp笔者只要修改以下几项：oracle.install.option=INSTALL_DB_SWONLY#ORACLE_HOSTNAME=UNIX_GRO...]]></description><category></category></item><item><title><![CDATA[PLSQL 发送邮件]]></title><link>https://blog.csdn.net/renfengjun/article/details/78661370</link><guid>https://blog.csdn.net/renfengjun/article/details/78661370</guid><author>renfengjun</author><pubDate>Wed, 29 Nov 2017 09:06:04 +0800</pubDate><description><![CDATA[使用PLSQL发送邮件。]]></description><category></category></item></channel></rss>