ZhongWeicheng-优快云博客

原创 MySQL Workbench Performance Tools

MySQL Workbench 是专为数据库架构师、开发人员和 DBA 打造的一个统一的可视化工具。MySQL Workbench 提供了数据建模工具、SQL 开发工具和全面的管理工具（包括服务器配置、用户管理、备份等）。

2014-08-27 22:34:20 1261

原创 DB2 V9.7 Installation on RHEL5

DB2安装前需要修改配置内核参数,修改/etc/sysctl.confshmall默认是8G，建议将此参数设置为DB2服务器物理内存的90%，如果内存是16G，就是(16*0.9*1024*1024)/4=3774873,当前环境的物理内存是2G，也就是(2*0.9*1024*1024)/4=471859shmmax建议和系统物理内存相等，在64位系统上必须至少设置为1G，即107

2014-07-08 19:15:18 1259

DB2 V9.7 Installation on RHEL5

2014-07-08 19:08:05 293

DB2 V9.7 Installation on RHEL5

2014-07-08 19:04:34 196

原创 Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 4

Target Side SetupInstall OGG on Target SideCreates required directories for OGG[oracle@vzwc1 ggs]$ ./ggsci Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.23 1870940

2014-06-16 15:04:54 2209

原创 Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 3

DDL Setup StepsSQL> grant execute on utl_file to ggs;Grant succeeded. Create GLOBALS file[oracle@zwc ~]$ cd /ggs/[oracle@zwc ggs]$ cat GLOBALS GGSCHEMA GGS run marker_s

2014-06-16 15:03:24 2697

原创 Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 2

Prepare 10g Database for OGGCreate GGS and GGS_MON Database UsersSQL> create tablespace ggs_tbs datafile '/u01/app/oracle/oradata/zwc/gg_tbs01.dbf' size 100M;Tablespace created.SQL> cr

2014-06-16 15:02:11 1752

原创 Zero Downtime Upgrade of Oracle 10g to Oracle 11g Using GoldenGate — 1

Source DatabaseDB Name: zwcSchemas: HR,OE,PMVersion: 10.2.0.4RAC: NoOS Version: Red Hat Enterprise Linux Server release 5.9 x86_64OGG

2014-06-16 15:01:03 1927

原创 Oracle GoldenGate 12c 配置Oracle Database 12c Multitenant database

2014-04-08 16:16:30 5299

原创 Oracle GoldenGate 12c 新特性 Credential Store and USERIDALIAS

--生成credentialstore文件[oracle@db12c ggs]$ ggsci Oracle GoldenGate Command Interpreter for OracleVersion 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBOLinux, x64, 64bit (op

2014-04-08 13:33:18 2577

原创 Oracle 12c RAC Flex Cluster & Flex ASM安装配置截图

配置dhcp和dns服务器过程省略--root.sh[root@vzwc1 ~]# /u01/app/12.1.0/grid/roo

2014-03-31 23:27:51 4761

转载 MOS：Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructur

Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid InfrastructureRAC Best Practice and Starter Kit InformationThe goal of the Oracle Real Application Clusters (RA

2014-03-21 17:17:56 3705

原创 Oracle Logminer使用

2014-03-12 23:10:59 1215

原创 Oracle10g Logical DataGuard 详细搭建过程

logical standby是在physical standby基础上搭建Oracle10g Physical DataGuard 详细搭建过程--停止standby上的日志应用SQL> alter database recover managed standby database cancel;Database altered.--

2014-03-03 13:19:53 1900

原创 DataGuard相关参数

DB_UNIQUE_NAME定义数据库唯一名称，因为DB_NAME参数对于物理数据库是必须相同，对于逻辑数据库必须不同，所以在Oracle 10g中引入DB_UNIQUE_NAME参数来确定DataGuard配置中的每个数据库，如果未定义该参数，默认使用DB_NAME参数值。LOG_ARCHIVE_CONFIG定义DataGuard配置的有效DB_UNIQUE_NAME参数列表

2014-03-02 15:02:23 2019

原创 Oracle SQL hints

--Oracle 8iSQL> select NAME,CLASS,SQL_FEATURE from v$sql_hint where VERSION LIKE '8%';NAME CLASS SQL_FEATURE---------

2014-02-25 19:07:19 2152

转载 Data Guard Switchover Unix shell script

The following Unix shell scripts can be used to automate the Data Guard Switchover process of a physical standby database.It is very important that the scripts are run in the correct order and on

2014-02-24 21:23:14 1137

原创 OEM12c 安装配置MySQL Plug-in用来监控MySQL

2014-02-20 15:23:56 2682

原创 OEM12C EMCLI安装

访问https://OMS:PORT/em/console/emcli/download 获取emclikit.jar安装配置jdk./jdk-6u45-linux-x64.bincp -rp jdk1.6.0_45 /usr/share/--在/etc/profile最后添加export JAVA_HOME=/usr/share/jdk1.6.0_45ex

2014-02-20 13:00:35 2300

原创 OEM 12cR3使用agentDeploy方式安装agent

--在OMS服务器使用SYSMAN登录emcli，同步emcli[oracle@omsdb agent]$ $OMS_HOME/bin/emcli login -username=sysman -password=oracleLogin successful[oracle@omsdb agent]$ $OMS_HOME/bin/emcli syncSynchronized succ

2014-02-19 20:20:49 3902

原创 Oracle Enterprise Manager 12c添加被监控数据库

这里添加的是和OMS所在同一台主机的OMRDB左上角Target(目标) -> Database(数据库) Search List(搜索列表) -> add(添加)点击continue(继续)配置连接信息添加之后就可以看见数据库了

2014-02-19 19:21:12 2501

原创在Oracle Linux 5.9上安装Oracle Enterprise Manager Cloud Control 12cR3

OMS,OMR安装在一台服务器OS: Oracle Linux 5.9 x86_64RAM: 6GBOEM: 12.1.0.3REPDB: 11.2.0.4HOSTNAME: omsdb.localdomainOMS12cR3认证平台--安装软件包[root@omsdb ~]# yum -y install oracle-val

2014-02-19 15:28:18 2169

原创 Oracle Physical DataGuard使用RMAN增量备份修复GAP

当Physical DataGuard主库归档日志丢失，使用RMAN或者OS命令删除了归档日志，并且归档日志未传输到Standby端，这样Standby端会产生GAP，可以将Primary端的归档拷贝到Standby端然后使用register命令注册，例如ALTER DATABASE REGISTER LOGFILE '/arch/ARC0000000068_0839199018.0001'，

2014-02-17 01:04:57 2928

原创 GoldenGate将Oracle数据同步到GreenPlum

源端Oracle 11.2.0.4 RAC 2-NodesOracle Linux 5.8 x86_64目标端Greenplum Database 4.2.6.1 4-NodesCentOS 5.7 x86_64======================================================源端配置--本例是将OGG安

2014-02-16 00:45:35 6797 2

原创 Oracle10g Physical DataGuard 详细搭建过程

primary 环境DB version:oracle10.2.0.4IP:192.168.1.7hostname:vzwcdb_name:dbserverdb_unique_name:dbserverservice_name:dbserverinstance_name:ORCLstandby 环境DB version:oracle10.2.0.4IP:

2014-02-14 00:02:25 6114

原创 Oracle10g RMAN Windows 2003 Server R2 x64备份迁移到Linux x64

记录源端windows上oracle的dbidSQL> select dbid from v$database; DBID---------- 66428446使用RMAN备份RMAN> RUN{2> ALLOCATE CHANNEL C1 TYPE DISK;3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';4> BACKU

2014-02-10 23:25:31 2804

原创 Percona Server 安装

安装配置参数[root@monser Percona-Server-5.5.34-rel32.0]# cmake . -DCMAKE_INSTALL_PREFIX=/service/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/service/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWI

2014-02-09 00:16:23 5287

原创 MySQL使用profile分析SQL执行状态

打开profilemysql> select @@have_profiling;+------------------+| @@have_profiling |+------------------+| YES |+------------------+1 row in set (0.00 sec)mysql> select @@profiling;

2014-02-05 23:26:26 4832

原创 MySQL5.5配置安装半同步复制

确认master和slave上是否开启have_dynamic_loadingmasterMASTER@root@(none) 10:54:58>show variables like 'have_dynamic_loading';+----------------------+-------+| Variable_name | Value |+------------

2014-02-03 23:10:47 2362

原创统计MySQL binlog中的DML语句

MASTER@root@test 07:44:52>create table tab02(id int(10) primary key,name varchar(20));Query OK, 0 rows affected (0.10 sec)MASTER@root@test 08:34:54>MASTER@root@test 08:34:54>MASTER@root@test 08:3

2014-01-31 20:38:15 1500

原创 MySQL复制环境中使用slave_exec_mod参数

先看下slave_exec_mod官方描述Command-Line Format--slave-exec-mode=modeOption-File Formatslave_exec_modeSystem Variable Nameslave_exec_modeVariable S

2014-01-31 19:23:40 2945

原创 MySQL禁用binlog中的语句

MySQL复制是异步的，也就是说是非同步的过程，它不会校验数据库中数据的一致性，只要SQL语法正确并且没有错误就能成功执行MASTER@root@test 12:20:40>create table tab01 -> (id int(10) primary key , -> name varchar(20));Query OK, 0 rows affected (0.03 s

2014-01-30 12:29:29 3418

原创 MySQL配置Master-Slave

master库打开log-bin参数，保证master和slave的server-id参数不同在master上创建允许slave访问的rep用户MASTER@root@(none) 12:34:34>grant replication slave on *.* to 'rep'@'192.168.1.12' identified by 'rep';Query OK, 0 rows aff

2014-01-30 00:54:52 1088

原创 Oracle system系统表空间和数据表空间的insert性能测试

SQL> show user USER is "ZHONGWC"SQL> SQL> select * from v$version;BANNER----------------------------------------------------------

2014-01-23 16:53:17 1322

转载 Master Note for Automatic Storage Management (ASM) (Doc ID 1187723.1)

Automatic Storage Management (ASM) Alerts: Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 (Doc ID 1145365.1) Automatic Storage Management (ASM) Concep

2014-01-19 18:36:08 2815

原创 Extracting Datafile Blocks From ASM

2014-01-16 13:57:35 171

原创 RHEL5使用multipath配置ASMdisk

fdisk查看磁盘[root@db11g ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.9 (Tikanga)[root@db11g ~]# [root@db11g ~]# [root@db11g ~]# fdisk -lDisk /dev/sda: 32.2 GB, 3221225472

2014-01-15 13:17:30 3538

原创 Solaris11配置静态IP

Oracle Solaris11安装好默认是DHCP的，禁用DHCP。netadm enable -p ncp DefaultFixed设置net0(公网)、net1(私网)和网关ipadm create-ip net0ipadm create-addr -T static -a 192.168.1.61/24 net0/v4staticroute -p add default

2014-01-13 16:57:52 4576