- 博客(18)
- 资源 (2)
- 收藏
- 关注
原创 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 2203
原创 查看RAC CLUSTER NAME方法
1.su - gridocrdumpgrep clustername OCRDUMPFILE2.su -gridwhich cemutlocemutlo -wcemutlo -n
2012-09-29 15:45:57 2116
原创 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 918
原创 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 9343
转载 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 3897
原创 MySQL Tuner- Author Major Hayden
#!/usr/bin/perl -w# mysqltuner.pl - Version 1.2.0# High Performance MySQL Tuning Script# Copyright (C) 2006-2011 - - major@mhtx.net## For the latest updates, please visit http://mysqltuner.com/#
2012-09-24 08:18:39 1435
原创 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 1404
原创 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 5760
原创 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 1232
转载 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 1075
原创 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 967
原创 Oracle查询动、静态参数
SQL> desc v$parameter; Name Null? Type ----------------------------------------- -------- ---------------------------- NUM NUMBER NAME VARCHAR2(80) TYPE NUMBE
2012-09-11 10:53:32 902
原创 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 634
转载 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 1084
原创 Shell-xtrabackup script
#!/bin/bash################################################################################### purpose:xtrabackup script # version:v1.5# date :2012-08-22# author :kin zhang####################
2012-09-10 14:45:49 904
原创 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 9969 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 779
转载 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 714
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人