cizhiyou2391-CSDN博客

转载 [Linux7] HA Package Yum源配置

今天本来想在RHEL7.3上装pcs,pacemaker 高可用的package的时候，发现原来的配置的yum原不能使用。后来发现HA的package放在 addon...

2018-02-21 23:36:09 305

转载 [ASM] ORA-15032 ORA-15260

SQL> conn / as sysdbaConnected.SQL> select group_number,disk_number,name,path from v$asm_disk where grou...

2018-02-19 16:29:46 681

转载 [RAC] Oracle11g RAC禁止DB自动启动

RAC里面有时候需要禁止DB自动启动。禁止自动启动DB命令crsctl modify resource ora.clusdb.db -attr "AUTO_START...

2018-01-30 23:46:30 653

转载 [Oracle] Device Checks for ASM - This is a pre-check........

Oracle11g RAC安装grid的时候。条件检查的时候出现了如下警告，Device Checks for ASM - This is a pre-check to verify if the specified d...

2018-01-30 21:14:46 2030

转载 [Linux7] Centos7 multipath 盘权限绑定.

Centos7 multipath 盘权限绑定.[root@centos7 ~]$ more /etc/udev/rules.d/99-oracle.rules KERNEL=="dm-0",OWNER="oragrid...

2018-01-29 15:32:35 277

转载 [Linux7] zabbix 3.2.11安装

zabbix 3.2.11关闭selinux[root@vm4 ~]$ vi /etc/selinux/config SELINUX=disabled1.安装lamp[root@vm4 ~]$ yum...

2018-01-28 20:02:55 129

转载 [Oracle] Error in invoking target 'agent nmhs' of makefile

Centos7安装oracle11g时报Error in invoking target 'agent nmhs' of makefile解决方法 vi $ORACLE_HOME/sysman/lib/in...

2018-01-28 19:49:17 104

转载 [Linux] 查看环境变量

查看环境变量env #显示全局变量,export的变量. 取消unset.set #能将env的结果都显示出来，并将user的显示出来* # *前面的字符是0个或多个字符 . # ...

2017-12-31 11:50:21 218

转载 [HPUX] HP Unix server vg自动激活

HP Unix server vg自动激活AUTO_VG_ACTIVATE=0 #表示不激活custom_vg_activation() #里面表示自动启动{ /sb...

2017-12-31 11:49:18 381

转载 [HPUX] UX:vxfs mount: ERROR: V-3-21264

UX:vxfs mount: ERROR: V-3-21264: /dev/vgora/oragrid is already mounted, /oragrid is busy, allowable number of mo...

2017-12-31 11:48:39 589

转载 [RAC] HP Unix Install Oracle11g(RAC)

1.Hardware check. (1)machinfo | grep -i memory # memory>2G (2)swapinfo -a (3)bdf...

2017-12-31 11:45:53 296

转载 [HPUX] vgremove 不成功措施(vgexport)

vgremove 不成功措施(vgexport).[xxxx]# vgremove vgoravgremove: Couldn't delete physical volume:No such device or a...

2017-12-31 11:41:04 420

转载 [RHEL7] ssh免密码登录

##linux7设置ssh面密码登录(密码变更后一样可以登录)[root@rhel7 ~]$ ssh-keygen #生产密钥文件Gen...

2017-12-13 21:14:21 202

转载 [MYSQL] mysql source code install(5.7.15)

1.mysql source code install(5.7.15)mysql版本相关知识mysql的命名机制使用3个数字和一个后最组成的版本号mysql-...

2017-11-22 21:42:05 123

转载 [SANSwitch] SANSwitch 一点理解

最常用的两个命令switchshowcfgshow 1.先建立config文件后，在建立zone2.fcmsutil /dev/fcd2 后...

2017-11-17 16:19:39 1058

转载 [RHEL7] redhat7 ssh 打开慢

[root@rhel7 ~]# cd /etc/ssh[root@rhel7 ssh]# more sshd_config #如下两项需要设置为noGSSAPIAuthentication noUseDNS...

2017-11-12 21:48:20 191

转载 [Install] HP Unix Install Oracle11g(Single Instance)

HP Unix Install Oracle11g(Single Instance)1.Hardware check. (1)machinfo | grep -i memory # memory>2G...

2017-11-11 15:07:33 131

转载 [HPUX] HP Unix pv,vg,lv操作

[root@testdb:/#] pvcreate /dev/rdsk/c2t1d4 #使用的字符设备Physical volume "/dev/rdsk/c2t1d4" has been ...

2017-11-11 09:25:27 996

转载 [HPUX] HP Unix 修改hostname

方法1，set_parms hostname #这个需要重启,这个要在/etc/hosts中配置一下方法2,vi /etc/rc.config.d/netconf HOSTNAME="xxxxx...

2017-11-11 09:05:24 541

转载 [Oracle] 脚本创建DB

C:\Users\Admin>set ORACLE_HOME=E:\oracle11g\product\11.2.0\dbhome_1C:\Users\Admin>set ORACLE_SID=bruce...

2017-11-11 09:02:05 89

转载 [RHEL7] Change root password

===============================change root password=====================================================恢复root密码...

2017-11-01 10:11:33 57

转载 [ASM] ASM Diskgroup Header BACKUP

ASM Header BACKUP[root@#] more /oracle/ASM/asm_dg_meta_backup.sh. ~oracle/.bash_profileexport ORACLE_SID...

2017-10-29 09:14:13 75

转载 [Upgrade] Oracle 10.2.0.5 PSU upgrade

before we start to PSU upgrade,we should backup database(cold or hot backup) and the oracle home directory. C:...

2017-10-29 09:03:37 93

转载 [Upgrade] Oracle 10.2.0.5 opatch utility upgrade

Oracle 10.2.0.5 opatch utility upgrade.E:\oracle\product\10.2.0\db_1\OPatch>set ORACLE_HOME=E:\oracle\product...

2017-10-15 08:40:35 84

转载 [Upgrade] Oracle 10.2.0.1 --> 10.2.0.5 patchset Upgrade.

从oracle官网上下载相关patchset:https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=qdu85yeys_9&amp...

2017-10-15 08:36:07 87

转载 [Oracle] Oracle收集统计信息的采样比例

Oracle收集统计信息的采样比例:SELECT owner, segment_name, ROUND (SUM (bytes) / 1024 / 1024) size_mb, case when ...

2017-10-15 08:28:43 702

转载 [Oracle Script] Top sql

Top sql: select rownum as rank, a.*from (select PARSING_SCHEMA_NAME RUN_USER, --执行用户SQL_FULLTEXT, --SQL文本,全，...

2017-10-15 08:27:38 42

转载 [Oracle Script] ASM Disks Performance metric

ASM Disks Performance metric:SELECT a.name disk_group_name, b.path disk_path, ...

2017-10-15 08:26:39 47

转载 [Oracle Script] ASM Disk Groups Used

select name,sector_size,block_size,allocation_unit_size,state,type,total_mb,free_mb,(total_mb-free_mb) "used_mb"...

2017-10-04 14:33:42 63

转载 [Oracle Script] Lock

col spid format a10col inst_id format a7col owner format a15col object_name format a20col machine format...

2017-10-04 14:33:12 36

转载 [Oracle Script] Undo Usage Per session

select s.SID,s.SERIAL#,t.USED_UBLK,t.USED_UREC from v$transaction t,v$session s where t.ADDR=s.TADDR order b...

2017-10-04 14:32:39 51

转载 [Oracle Script] Undo Usage Per status

select tablespace_name,sum(decode(status,'EXPIRED',bytes,0)) "EXPIRED", round(sum(decode(status,'EXPIRED',bytes,...

2017-10-04 14:32:04 55

转载 [Oracle Script] Log switch status

select inst_id,to_char(first_time,'yyyy/mm/dd') "Date",sum(decode(to_char(first_time,'HH24'),'00',1,0)) H00,sum(...

2017-10-04 14:31:33 53

转载 [Oracle Script] Library Cche Hit Ratio

SELECT TO_CHAR(SYSDATE, 'yyyy/mm/dd hh24:mi:ss') TIME, SUM(reloads) reloads, round(sum(reloads)/sum(pins),...

2017-08-20 10:20:56 103

转载 [Oracle Script] Buffer Cache Hit Ratio

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') currenttime,round(1-(physical_read-physical_reads_direct)/(db_bloc...

2017-08-20 10:19:50 178

转载 [Oracle Script] Rollback Segment Usage

SELECT s.sid, s.serial# serial, s.module, s.program, s.status session_status, t.status txn_status, t.start_time st...

2017-08-20 10:19:15 37

转载 [Oracle Script] Temporary Sort Usage

SELECT s.sid sid, s.serial# serial, s.module module, s.program program, s.event, SUM(su.blocks) temp_blocks,...

2017-08-20 10:18:41 48

转载 [Oracle Script] latch holder

select PID , SID , LADDR , NAME , GETS from GV$LATCHHOLDER where inst_id = USERENV('Instance') ...

2017-08-20 10:18:06 91

转载 [Oracle Script] check latch

select l.latch# latch,l.name, nvl(c.latches, 0) children, l.gets, l.misses, l.gets-l.misses "Simple Gets",...

2017-08-06 15:19:53 41

转载 [Oracle Script] check Literal SQL

SELECT (SELECT parsing_schema_name FROM v$sqlarea WHERE sql_id = a.max_sql_id) SCHEMA, (SELECT MODULE FROM...

2017-08-06 15:16:47 46

空空如也

空空如也