<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cuican4982</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cuican4982]]></copyright><item><title><![CDATA[Aix 7一次补丁安装失败问题处理]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331554</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331554</guid><author>cuican4982</author><pubDate>Mon, 15 Jul 2019 16:18:21 +0800</pubDate><description><![CDATA[安装失败后，查看日志提示以下错误：



Stopping CRS...


Stopped CRS successfully





patch /oracle/soft/28813878...]]></description><category></category></item><item><title><![CDATA[X7一体机数据库迁移问题处理]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331551</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331551</guid><author>cuican4982</author><pubDate>Mon, 15 Jul 2019 16:17:16 +0800</pubDate><description><![CDATA[数据库版本：Oracle 12.1.2


相同版本迁移。




X4


操作系统为RHEL 5.10。




X7


操作系统为RHEL 7.4。





...]]></description><category></category></item><item><title><![CDATA[一次诡异的Oracle用户无法su问题]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331548</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331548</guid><author>cuican4982</author><pubDate>Fri, 18 Jan 2019 15:02:41 +0800</pubDate><description><![CDATA[环境：



  Oracle exadata x4-2 计算节点只有一个节点可以通过su切换到Oracle用户，其他节点oracle用户多次修改密码依旧无法登陆，无法切换到oracle用户,无法通过ssh使用o...]]></description><category></category></item><item><title><![CDATA[em13cc如何添加不在支持序列系统的agent监控]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331553</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331553</guid><author>cuican4982</author><pubDate>Fri, 18 Jan 2019 14:35:38 +0800</pubDate><description><![CDATA[EM13CC


的oms和agent支持操作系统包括以下六类SLES 12,SLES 11,Red Hat Enterprise Linux 7,Red Hat Enterprise Linu...]]></description><category></category></item><item><title><![CDATA[Sector size导致ORA-27061: waiting for async I/Os failed  with root.sh]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331629</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331629</guid><author>cuican4982</author><pubDate>Mon, 07 Jan 2019 21:13:13 +0800</pubDate><description><![CDATA[测试环境：


数据库节点系统：rhel 6.8 x86_64


数据库版本：Oracle 11.2.0.4 RAC





背景：


对比分布式存储和IBM传统存储性能对比。


...]]></description><category></category></item><item><title><![CDATA[Solaris集群节点重启]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331543</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331543</guid><author>cuican4982</author><pubDate>Sat, 29 Dec 2018 18:38:33 +0800</pubDate><description><![CDATA[适用于Solaris 11，

SPARC平台，版本在

Solaris


11.3.14.6.0之后。






查看系统详细版本：








$


...]]></description><category></category></item><item><title><![CDATA[Oracle 18c rpm 安装及解析安装过程]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331567</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331567</guid><author>cuican4982</author><pubDate>Thu, 01 Nov 2018 17:56:36 +0800</pubDate><description><![CDATA[环境：


OEL 6.8


DB：18.3





安装过程中包括两个RPM包


oracle-database-ee-18c-1.0-1.x86_64.rpm


o...]]></description><category></category></item><item><title><![CDATA[Sublime text 3 集成python 3 环境配置]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331585</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331585</guid><author>cuican4982</author><pubDate>Tue, 09 Oct 2018 09:23:14 +0800</pubDate><description><![CDATA[介质版本:

Python 3.6


Sublime Text 3





包括：


sublime字体配置。


常用插件：


Package Control、Sublime...]]></description><category></category></item><item><title><![CDATA[Oracle11g 自动化建库及调整相关参数]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331566</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331566</guid><author>cuican4982</author><pubDate>Wed, 12 Sep 2018 13:26:10 +0800</pubDate><description><![CDATA[该脚本适用于从模板克隆出的数据库，包括建库、调整参数、修改相关配置文件、生产数据库配置文件。该脚本目录在suse 11、suse 12上测试通过。





#!/usr/bin/env bash

...]]></description><category></category></item><item><title><![CDATA[GoldenGate 自动化初始数据]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331622</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331622</guid><author>cuican4982</author><pubDate>Wed, 05 Sep 2018 13:22:13 +0800</pubDate><description><![CDATA[针对于上次《GoldenGate 自动化初始数据》过程中，存在的不适合场景，调整脚本，并对脚本进行优化，源端包括ogg_expdp.sh，目标端包括stop_rep.sh和ogg_impdp.sh


ogg_e...]]></description><category></category></item><item><title><![CDATA[Oracle Database 12.2本机配置ADG]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331546</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331546</guid><author>cuican4982</author><pubDate>Wed, 05 Sep 2018 11:23:38 +0800</pubDate><description><![CDATA[随着Oracle Database 12.2的发布，越来越多的客户已经开始使用Oracle 12c，刚好下载了12.2，测试下12.2的物理备库。本次测试主库和备库在同一台主机上。



1、环境信息

...]]></description><category></category></item><item><title><![CDATA[RHEL 7.2 安装二进制MySQL 5.7.18]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331545</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331545</guid><author>cuican4982</author><pubDate>Wed, 22 Aug 2018 10:49:53 +0800</pubDate><description><![CDATA[环境：


Red Hat Enterprise Linux Server release 7.2 (Maipo)


mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

...]]></description><category></category></item><item><title><![CDATA[GoldenGate 自动化初始数据]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331549</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331549</guid><author>cuican4982</author><pubDate>Mon, 06 Aug 2018 14:39:41 +0800</pubDate><description><![CDATA[源端、目标端环境如下：


SLES 11SP4


Oracle 11.2.0.4


GoldenGate:11.2.1.0.33





涉及用户相关信息中数据表及密码已加密或替换。...]]></description><category></category></item><item><title><![CDATA[Oracle DG运维常用SQL]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331540</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331540</guid><author>cuican4982</author><pubDate>Mon, 06 Aug 2018 14:27:48 +0800</pubDate><description><![CDATA[=====运维SQL


--查看switch状态


select switchover_status from v$database;


--查看数据库状态


set lin 200 pag...]]></description><category></category></item><item><title><![CDATA[一次rman恢复引起的nologging问题模拟]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331541</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331541</guid><author>cuican4982</author><pubDate>Tue, 31 Jul 2018 11:43:21 +0800</pubDate><description><![CDATA[测试环境：


Oracle 11.2.0.4


SLES 11SP4


结论如下：



no force logging,table nologging, dml nologging，出现o...]]></description><category></category></item><item><title><![CDATA[innobackupex 备份MySQL数据库]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331583</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331583</guid><author>cuican4982</author><pubDate>Tue, 17 Apr 2018 14:32:21 +0800</pubDate><description><![CDATA[环境：
rhel 7.2
MySQL：5.6.38

测试innobackupex备份、恢复MySQL过程

--创建测试数据库
[root@rhel72 mysql]# mysql -uroot -pgyc123...]]></description><category></category></item><item><title><![CDATA[RHEL安装Xtrabackup]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100509314</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100509314</guid><author>cuican4982</author><pubDate>Thu, 12 Apr 2018 15:43:53 +0800</pubDate><description><![CDATA[Xtrabackup是由percona提供的mysql数据库备份工具，据官方介绍，这也是世界上唯一一个开源的能够对innodb和xtradb数据库进行物理热备的工具。


Xtrabackup中主要有包含两个工具：
　　...]]></description><category></category></item><item><title><![CDATA[Mysql 5.6 Master和Slave 主备切换]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331563</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331563</guid><author>cuican4982</author><pubDate>Tue, 10 Apr 2018 16:41:54 +0800</pubDate><description><![CDATA[--master/slave切换记录，用于后期查找

环境：
master:
rhel 6.6
mysql 5.6
192.168.15.101


salve:
rhel 7.2
mysql 5.6
1...]]></description><category></category></item><item><title><![CDATA[ansible高级应用ansible-vault]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331559</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331559</guid><author>cuican4982</author><pubDate>Fri, 23 Mar 2018 16:23:10 +0800</pubDate><description><![CDATA[ansible-vault属于ansible高级应用。
在使用过程中ansible 1.9执行加密后的问题，提示错误；在ansible 2.5中可以运行，测试过程如下：

[root@DBA180321R00P ansib...]]></description><category></category></item><item><title><![CDATA[ansible自动化运维数据库]]></title><link>https://blog.youkuaiyun.com/cuican4982/article/details/100331544</link><guid>https://blog.youkuaiyun.com/cuican4982/article/details/100331544</guid><author>cuican4982</author><pubDate>Thu, 22 Mar 2018 10:01:50 +0800</pubDate><description><![CDATA[通过ansible简单对数据库主机检查和数据库表空间的检查，前提数据库主机有统一的用户名和密码.

运维环境：rhel 7.2，ansible 1.9
数据库环境：Oracle 11.2.0.4, Suse ...]]></description><category></category></item></channel></rss>