<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[tl_19的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/tl_19</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; tl_19]]></copyright><item><title><![CDATA[ORA-07445: 出现异常错误: 核心转储 [evaopn3()+252]]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9447249</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9447249</guid><author>tl_19</author><pubDate>Wed, 24 Jul 2013 13:35:10 +0800</pubDate><description><![CDATA[一： 环境介绍
操作系统版本:SOLARIS 10
数据库版本:11.2.0.1
架构组成：2节点RAC
二 ：问题
第一次出现：
---alert.log
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x10481C59C, evaopn3()+252] [flags: 0x0, co]]></description><category></category></item><item><title><![CDATA[Fatal NI connect error 12170]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9366829</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9366829</guid><author>tl_19</author><pubDate>Thu, 18 Jul 2013 14:23:33 +0800</pubDate><description><![CDATA[Fatal NI connect error 12170.
  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.1.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.1.0 - Production
  Time]]></description><category></category></item><item><title><![CDATA[AIX之LVM]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9145847</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9145847</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 15:25:07 +0800</pubDate><description><![CDATA[1.基本概念：
PV 物理卷：普通的直接访问的存储设备，有固定的和可移动的之分，代表性的就是硬盘。
vg 卷组：AIX中最大的存储单位，一个卷组由一组物理硬盘组成，也就是由一个或多个物理卷组成。
pp 物理分区：是把物理卷划分成连续的大小相等的存储单位，一个卷组中的物理分区大小都相等。
lp 逻辑分区：适映射物理分区的逻辑单位，一个逻辑分区可以对应一个也可以对应多个物理分区。
lv 逻辑]]></description><category></category></item><item><title><![CDATA[IPTABLES]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9145149</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9145149</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 14:23:10 +0800</pubDate><description><![CDATA[IPTABLES简单应用说明:
iptables -A INPUT -p tcp -s 10.1.2.187 -j ACCEPT
将10.1.2.187加入允许范围
iptables -t nat -A POSTROUTING -j SNAT --to-source 10.1.2.1
参数——
-A: 添加 (跟链)
-I: 插入
-p: 跟协议
-s: 源IP
-d: 目标IP]]></description><category></category></item><item><title><![CDATA[单机上创建物理DG（ORACLE 10G单实例）]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144915</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144915</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 14:15:36 +0800</pubDate><description><![CDATA[一 配置规划

 




名 称
     IP
     监听
   端 口
SID
db_name
db_unique_name
service name
 


主机

127.0.0.1


Listener1

1521
test1
test1
test1
test1
 


备机

127.0.0.1


L]]></description><category></category></item><item><title><![CDATA[mysql-cluster-gpl-7.1.17 安装配置脚本]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144851</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144851</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 14:01:47 +0800</pubDate><description><![CDATA[#!/bin/sh
# install mysql-cluster
#usage:sh inscluster |ndb_mgmd |ndbd |mysqld $2  eg:sh inscluster.sh ndbd 116.211.12.171
#$1 type   $2:ndb-mgmd-ip
group=`cat /etc/group|grep -i "mysql"|awk -F':']]></description><category></category></item><item><title><![CDATA[MYSQL5.5.19源码安装脚本]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144819</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144819</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:59:14 +0800</pubDate><description><![CDATA[#!/bin/sh
#install mysql5.5.19
echo "nameserver 8.8.8.8">>/etc/resolv.conf
yum install -y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt*  cmake
#wget http://mir]]></description><category></category></item><item><title><![CDATA[mysql5.5.19主从脚本（master-innodb,slave-myisam）]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144809</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144809</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:57:45 +0800</pubDate><description><![CDATA[#!/bin/sh
#multi-instance
#usage sh tl55.sh $1 $2
#取备份
lastip=`echo $1|awk -F '.' '{print $3$4}'`
echo $lastip
mkdir -p /app/dbbackup/${lastip}



 
 
#解压取POS值
cd /app/dbbackup/${lastip}]]></description><category></category></item><item><title><![CDATA[mysql5.1多实例+主从配置脚本--基于MYISAM]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144775</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144775</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:53:20 +0800</pubDate><description><![CDATA[mysql5.1多实例+主从配置脚本--基于MYISAM

#!/bin/sh
#multi-instance
#usage sh tl2.sh $1 $2
hostip=`/sbin/ifconfig eth0|grep -i "inet addr"|awk  '{print $2}'|awk -F"." '{print $3$4}'`
echo $hostip
cnf=/etc/]]></description><category></category></item><item><title><![CDATA[mysql主从复制中的几个DB]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144761</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144761</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:51:50 +0800</pubDate><description><![CDATA[1 主机中默认DB
● Binlog_Do_DB：设定哪些数据库（Schema）需要记录Binlog；
● Binlog_Ignore_DB：设定哪些数据库（Schema）不要记录Binlog；
好处：
可以减少主机中记录不需要的日志
可以减少从机中的I/O读取量,sql执行量
减少网络流量。
坏处：复制某个EVENT时需要判断2中的DB和1中DB是否一致，一致时主机I/O线程才将该]]></description><category></category></item><item><title><![CDATA[mysql5.1.52主从脚本（master-myisam,slave-myisam）]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144753</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144753</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:50:37 +0800</pubDate><description><![CDATA[#!/bin/sh
#multi-instance
#usage sh ws.sh $1 $2
#取备份
lastip=`echo $1|awk -F '.' '{print $3$4}'`
echo $lastip
mkdir -p /app/dbbackup/${lastip}
#ftp -i -in 
#open 1.82.3.74
#user gt 13
#lcd /a]]></description><category></category></item><item><title><![CDATA[mysql简单监控脚本]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144735</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144735</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:48:54 +0800</pubDate><description><![CDATA[mysql简单监控脚本

以MONITOR用户登录时就出此监控菜单（在MONITOR的用户环境里加个自动执行此脚本的语句子 sh ./monitor.sh）
具体脚本如下：
#!/bin/sh
while [ -e /home/monitor ]
do
echo "]]></description><category></category></item><item><title><![CDATA[Installing Oracle11g R2 RAC on RedHat Linux AS 5.8]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144697</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144697</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:44:58 +0800</pubDate><description><![CDATA[Installing Oracle11g R2 RAC on RedHat Linux AS 5.8
目录
1 系统运行环境
2 安装前准备
3 安装oracle grid
4 创建ASM磁盘
5 安装ORACLE软件
6 创建ORACLE数据库
7 验证
1 系统运行环境
1.1 硬件环境




产品名称


产品描述


数量]]></description><category></category></item><item><title><![CDATA[Upgrade Oracle RAC to 11.2.0.3 from 11.2.0.1 on Linux]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144677</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144677</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:42:15 +0800</pubDate><description><![CDATA[Upgrade Oracle RAC to 11.2.0.3 from 11.2.0.1 on Linux
目录
1 系统升级环境
2 升级前准备
3 安装OPATCH工具和PSU
4 升级GI/CRS到11.2.0.3
5 升级RDBMS到 11.2.0.3
6 升级DB
7 验证
1 系统升级环境
1.1 硬件环境




产品名称


产品描述]]></description><category></category></item><item><title><![CDATA[Deleting Oracle RAC 11g from Nodes on Linux]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144659</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144659</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:40:56 +0800</pubDate><description><![CDATA[Deleting Oracle RAC 11g from Nodes on Linux
目录
1 系统环境
2 从集群数据库中删除实例
3 移除ASM实例
4 移除ORACLE RAC
5 从集群中删除节点
6 验证
1 系统环境
1.1 硬件环境




产品名称


产品描述


数量




 
服务器节点


Cpu: Intel(]]></description><category></category></item><item><title><![CDATA[﻿﻿﻿﻿Adding Oracle RAC 11g from Nodes on Linux]]></title><link>https://blog.youkuaiyun.com/tl_19/article/details/9144639</link><guid>https://blog.youkuaiyun.com/tl_19/article/details/9144639</guid><author>tl_19</author><pubDate>Fri, 21 Jun 2013 13:37:57 +0800</pubDate><description><![CDATA[Adding Oracle RAC 11g from Nodes on Linux
目录
1 系统环境
2 添加节点前准备
3 添加GI/CRS软件
4 添加ORACLE RDBMS软件
5 添加新实例
6 验证
1 系统环境
1.1 硬件环境




产品名称


产品描述


数量




 
服务器节点


Cpu: Intel(R)]]></description><category></category></item></channel></rss>