2012年09月_jxzkin

原创 Oracle RAC EM工具日常管理

rac em工具日常管理检查em集群配置:emca -displayConfig dbcontrol -cluster[oracle@racdb1 ~]$ emca -displayConfig dbcontrol -clusterSTARTED EMCA at Sep 29, 2012 8:12:56 AMEM Configuration Assistant, Ve

2012-09-29 16:00:49 2195

原创查看RAC CLUSTER NAME方法

1.su - gridocrdumpgrep clustername OCRDUMPFILE2.su -gridwhich cemutlocemutlo -wcemutlo -n

2012-09-29 15:45:57 2102

原创 Required Support Diagnostics for Hanging Databases [ID 452358.1]

Required Support Diagnostics for Hanging Databases [ID 452358.1] In this Document Goal Solution ReferencesApplies to:Oracle Server - Enterprise Edition - Version: 9.0.1.0 to 1

2012-09-29 12:44:38 911

原创 Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 )

Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) [ID 1084186.1]In this DocumentGoalFixReferencesApplies to:Oracle Server - Enterpri

2012-09-28 12:33:47 9331

转载 RAC-ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contact

http://space.itpub.net/22664653/viewspace-706623【RAC】ORA-15055: unable to connect to ASM instanceORA-12547: TNS:lost contactrac 安装完成，关闭之后重启数据库遇到如下错误：oracle@rac1:/tmp>sqlplus "/as sysdba"

2012-09-26 11:16:04 3877

原创 MySQL Tuner- Author Major Hayden

2012-09-24 08:18:39 1420

原创 Oracle dbms_backup_restore恢复数据库

Oracle Version:Oracle 10.2.0.5 64bitOS:RHEL5.4 64bit1.fullbackup[oracle@Kin ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Mon Sep 17 17:00:14 2012Copyrigh

2012-09-21 23:43:36 1393

原创 Oracle修改dblink连接数

alter system set open_links=10 scope=spfile;alter system set open_links_per_instance=10 scope=spfile;OPEN_LINKSPropertyDescriptionParameter typeIntegerDefaul

2012-09-21 09:26:26 5743

原创 Flash Recovery Area空间使用查询

col name format a32 heading 'file name'col spc_lmt_mb format 9999.99 heading 'space|limit|(mb)'col spc_usd_mb format 9999.99 heading 'space|used|(mb)'col spc_rcl_mb fo

2012-09-20 13:54:22 1218

转载 SQL递归查询

http://space.itpub.net/118838/viewspace-735995connect by是结构化查询中用到的，其基本语法是：select ... from tablename start by cond1connect by cond2where cond3;简单说来是将一个树状结构存储在一张表里，比如一个表中存在两个字段:id,parentid

2012-09-14 13:49:41 1071

原创 mysqlsla安装使用

Installwget http://hackmysql.com/scripts/mysqlsla-2.03.tar.gztar zvxf mysqlsla-2.03.tar.gz cd mysqlsla-2.03 perl Makefile.PL make make install Usage:mysqlsla -lt slow slow_sta

2012-09-11 15:33:12 961

原创 Oracle查询动、静态参数

SQL> desc v$parameter; Name Null? Type ----------------------------------------- -------- ---------------------------- NUM NUMBER NAME VARCHAR2(80) TYPE NUMBE

2012-09-11 10:53:32 891

原创 MySQL开启慢查询

long_query_time = 1log-slow-queries = /usr/local/mysql/data/slow.loglog-queries-not-using-indexesmysqldumpslow –h主要介绍两个参数-s和-t-s 这个是排序参数，可选的有：al: 平均锁定时间ar: 平均返回记录数at: 平均查

2012-09-11 09:23:33 630

转载 Linux scp无需输入密码验证

以下是在机器Client的root和机器Server的root之间建立安全信任关系的步骤： 1. 在机器Client上root用户执行ssh-keygen命令，生成建立安全信任关系的证书。 [root@Client root]# ssh-keygen -b 1024 -t rsa Generating public/private rsa key pai

2012-09-10 16:50:49 1075

原创 Shell-xtrabackup script

#!/bin/bash################################################################################### purpose:xtrabackup script # version:v1.5# date :2012-08-22# author :kin zhang####################

2012-09-10 14:45:49 897

原创 Oracle 行转列(pivot、wm_concat、decode)使用总结

1.创建测试数据CREATE TABLE CC (Student NVARCHAR2(2),Course NVARCHAR2(2),Score INT );INSERT into CC select N'张三',N'语文',78 from dual union allselect N'张三',N'数学',87 from dual union allselect N'张

2012-09-06 10:32:13 9954 4

原创 install sqlplus command-line help

1. install sqlplus command-line helplog into as system user@?/sqlplus/admin/help/hlpbld.sql helpus.sql2. remove sqlplus command-line help@?/sqlplus/admin/help/helpdrop.sql

2012-09-03 16:56:34 777

转载 MySQL监控脚本

#/bin/bash# * * * * * sh /tmp/check_kpi_local.sh > /dev/null 2>&1LOGFILE=/tmp/KPI_$(date +%F).logCURRENT=$(date "+%T %F")HOST=`/sbin/ifconfig | grep "inet addr" | awk -F: '{print $2}' | awk {'pr

2012-09-03 14:02:27 712

KIN ORACLE