ITPub博客

Tue Feb 28 15:30:06 2017Errors in file /u01/app/oracle/diag/rdbms/cwgkavpd/cwgkavpd1/trace/cwgkavpd1_ora_165303.trc:ORA-00604: error occurred at recursive SQL level 1ORA-01438: value larger than specified precision allowed for this columnORA-06512: at line 2参见MOS文档：1275094.1由于登...

一、以空格为分隔符awk ‘{print $1" "$2}’二、以逗号为分隔符awk ‘{print $1","$2}’

卸载原有mysql版本rpm -qa | grep -i mysql | xargs rpm -ev --nodeps去官网下载最新的社区版mysql5.6版本官网地址：www.mysql.com这个tar包里含有许多与MYSQL相关的安装包，需要哪个安装哪个,解压之后的包安装mysql的服务器端和客户端rpm -ivh mysql-server-5.6.35-1.el6.x86-64.rpmrpm -ivh mysql-...

vi /etc/sysconfig/oracleasmoracleasm_scanorder="emc"或oracleasm_scanorder="sdllm"ps -ef | grep LOCAL=NO|grep -v grep|awk '{print $2}'|xargs kill -9srvctl stop instance -d CWGKVPD -i CWGKVPD2srvctl stop instance -d SGHRDB -i SGHRDB2crsctl stop crs /etc/init.d/oracleasm startv...

#!/bin/bashoracleasm listdisks > /tmp/1.txtvar2=`oracleasm listdisks |wc -l`> /tmp/2.txt> /tmp/3.txtfor ((i=1;i<=var2;i++))do var1=`cat /tmp/1.txt|sed -n ${i}p` oracleasm querydisk -p $var1 |grep emc|cut -d ':' -f 1|cut -b 6-|sed 's/1//g' >>/tmp/3.txt oracleasm querydisk -p $...

获取asm_lib所用磁盘所属的emc聚合磁盘名和emc磁盘名，并获取二者的差异#!/bin/bashvar1="oracleasm querydisk -p "var2="| grep emc|cut -d ':' -f 1|cut -b 6- >>/tmp/2.txt"#oracleasm listdisks >/tmp/1.txtoracleasm listdisks |awk '{print "oracleasm querydisk -p "$0"| grep emc|cut -d '\'':'\'' -f 1|cut -...

1、查看网卡是否处于运行状态mii-tool 网卡名称

1、查看存储#cd /opt/DynamicLinkManager/bin/#./dlnkmgr view -lu

1、emc常用查看磁盘命令powermt display dev=all

A、B列，A列值逐一比对B列的全部值，看是否A列值存在于B列值中，公式如下：=ISNUMBER(MATCH(A1,B:B,))，返回值为true为存在

先关掉NetworkManager服务，然后在重启网卡service NetworkManager stopservice network restartservice NetworkManager startservice NetworkManager start

ASM接触了很长时间，从磁盘组中删除磁盘的操作还是第一次。  没想到这么简单的操作，由于不熟悉还碰到了两个小问题。[oracle@dbserver1 ~]$ sqlplus / as sysdbaSQL*Plus: Release ...

参见官方文档Performance Tuning Guide搜索block关键字

下文简单介绍一个方法,实现不重新启动linux而可以识别到新增的磁盘.环境描述:OS: Redhat linux 5.4 x86(主机为vmware 虚拟主机)增加一个50G的lun一. 手工增加磁盘的命令# echo "scsi add-single-device w x y z" > /proc/scsi/scsi为使该命令正常运行，必须指定正确的参数值 w、x、y 和 z，如下所示： ...

错误如下：[grid@ora1 ~]$ srvctl start database -d testPRCR-1079 : Failed to start resource ora.test.dbCRS-5017: The resource action "ora.test.db start" encountered the following error: ORA-00119: invalid specification for system parameter REMOTE_LISTENERORA-00132: syntax error or unresolve...

今天有个10g库检修，由于关闭crs速度太慢，杀掉了cssd进程，导致一个节点重启，重启后发现crs未自启动，之后查看OCR报如下错误OCR initialization failed accessing OCR device: PROC-26: Error while accessing the physical storage 由于是AIX系统，后经分析是hacmp未启动所致，启动hacmpsmit hacmp启...