EMC PowerPath 安裝 License
2013-08-16 01:53
1. 安裝 License
emcpreg -install
2. 確認是否有生效
powermt display dev=all
3. 使其強制生效
powermt set policy=co
4.再次確認是否有生效
powermt display...
歷史文章列表
記錄每一個 user 所下過的指令
2013-08-13 11:32
1. 在 /etc/profile、/etc/bashrc 中加入
PROMPT_COMMAND='history -a >(tee -a ~/.bash_history | logger -t "$USER[$$] $SSH_CONNECTION")'
2. 在 /etc/syslog.conf 加入
# Log all kernel messages to the console.
# Logging much else clutters up the screen.
#kern.*...
iscsiadm 註冊和刪除不要的 lun 方法
2013-08-07 17:46
[root@voipdb1 ~]# iscsiadm -m node -p 192.168.101.2 -l
Logging in to [iface: default, target: iqn.1992-04.com.emc:cx.ckm00114501380.b4, portal: 192.168.101.2,3260] (multiple)
Login to [iface: default, target: iqn.1992-04.com.emc:cx.ckm00114501380.b4, portal:...
新增 LOGO 的方式
2013-08-06 15:25
./hosticon_admin add 'LOGO - HP' /usr/local/nagios/share/images/hp.png
./hosticon_admin add 'LOGO - Storage' /usr/local/nagios/share/images/storage.png
./hosticon_admin add 'LOGO - Storage' /usr/local/nagios/share/images/storage.png
./hosticon_admin add 'LOGO -...
查 CONSTRAINT
2013-08-06 15:10
SQL> set pages 5000
SQL> col owner for a10
SQL> select owner,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME from dba_constraints where OWNER='VOIP' order by 3,4,1
OWNER CONSTRAINT_NAME C...
Oracle Tablespace 空間查詢
2013-07-31 16:01
SQL> select a.TABLESPACE_NAME, to_char(a.BYTES/(1024*1024),'999,999') "Size(MB)", to_char(round((a.BYTES-b.BYTES)/(1024*1024),0),'999,999') "Used(MB)", to_char(b.BYTES/(1024*1024),'999,999') "Avail(MB)" from (select TABLESPACE_NAME, sum(BYTES) "BYTES" from...
查 redo log Group 和 Member
2013-07-31 15:55
SQL> desc v$log
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# ...
匯出 / 匯入 特定使用者的 schema
2013-07-30 00:22
匯出 voip 的 schema
exp \'/ as sysdba\' owner=VOIP file=VOIP.dmp rows=n statistics=none log=exp_VOIP.log
匯入 voip 的 schema
imp \'/ as sysdba\' fromuser=VOIP touser=VOIP file=VOIP.dmp ignore=y log=Imp_VOIP.log
刪除過期的 archive log 和 backup
2013-07-30 00:05
1. 進入 rman
2. connect target /
3. crosscheck archivelog all;
4. delete expired archivelog all;
5. report obsolete;
6. delete obsolete;
1. 進入 rman
2. connect target /
3. crosscheck backup;
4. delete expired backup;
5. report obsolete;
6. delete...
執行 awr report
2013-07-29 23:44
[oracle@SIPDB admin]$ cd /opt/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin
[oracle@SIPDB admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 29 23:40:28 2013
Copyright (c) 1982, 2009, Oracle. All rights...
項目: 101 - 110 之 152