- 博客(382)
- 收藏
- 关注
转载 [Linux7] HA Package Yum源配置
今天本来想在RHEL7.3上装pcs,pacemaker 高可用的package的时候,发现原来的配置的yum原不能使用。后来发现HA的package放在 addon...
2018-02-21 23:36:09
304
转载 [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
650
转载 [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
2026
转载 [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
103
转载 [Linux] 查看环境变量
查看环境变量env #显示全局变量,export的变量. 取消unset.set #能将env的结果都显示出来,并将user的显示出来* # *前面的字符是0个或多个字符 . # ...
2017-12-31 11:50:21
217
转载 [HPUX] HP Unix server vg自动激活
HP Unix server vg自动激活AUTO_VG_ACTIVATE=0 #表示不激活custom_vg_activation() #里面表示自动启动{ /sb...
2017-12-31 11:49:18
380
转载 [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
588
转载 [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
291
转载 [HPUX] vgremove 不成功措施(vgexport)
vgremove 不成功措施(vgexport).[xxxx]# vgremove vgoravgremove: Couldn't delete physical volume:No such device or a...
2017-12-31 11:41:04
419
转载 [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
1057
转载 [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
995
转载 [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
73
转载 [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&...
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
701
转载 [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
61
转载 [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
47
转载 [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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人