ITPub博客

windows + VMWARE +oracle 10G rac +asm1.安装vmware: 创建共享磁盘:scsi1:1 rac.vmx中增加 disk.locking="FALSE" scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/

windows + VMWARE +oracle 10G rac +asm1.安装vmware:创建共享磁盘:scsi1:1rac.vmx中增加disk.locking="FALSE"scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/etc/sysc

windows + VMWARE +oracle 10G rac +asm1.安装vmware: 创建共享磁盘:scsi1:1 rac.vmx中增加 disk.locking="FALSE" scsi1:sharedBus="VIRTUAL"设置/etc/udev/rules.d/60-raw.rules增加ACTION=="add",KERNEL=="sdc1",RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add",KERNEL=="sdc2",RUN+="/bin/raw /dev/raw/raw2 %N"ACTION=="add",KERNEL=="raw[1-2]", OWNER="oracle", GROUP="dba", MODE="660"/

lvcreate -L 8G -nLogVol06 VolGroup00lvcreate -L 8G -nLogVol07 VolGroup00lvcreate -L 8G -nLogVol08 VolGroup00lvcreate -L 8G -nLogVol09 VolGroup00lvcreate -L 8G -nLogVol10 VolGroup00lvcreate -L 8G -nLogVol11 VolGroup00lvcreate -L 8G -nLogVol12 VolGroup00lvcreate -L 8G -nLogVol13 VolGroup00/etc/init.d/oracleasm createdisk VOL1 /dev/mapper/VolGroup00-LogVol06/etc/init.d/oracleasm createdisk VOL2 /dev/mapper/VolGroup00-LogVol07/etc/init.d/oracleasm createdisk VOL3 /dev/mapper/VolGroup00-LogVol08/etc/

oracle中增加全局环境变量配置在oracle的.profile或者.bash_profile中增加SQLPATH=$ORACLE_HOMEexport SQLPATH保存退出后编辑$ORACLE_HOME/login.sqlset lines 160set pages 80set timing onset time offset termout onset trimout ONset trimspool Onset serveroutput on size 100000 format wrappedset long 5000-- define gname=idle-- column global_name new_value gname for a40-- SELECT lower(USER) || '@' ||upper(instance_name)||'('||nvl(UTL_INADDR.GET_HOST_ADDRESS, SYS_CONTEXT('userenv', 'ip_address'))||')' GLOBAL_NA

打印指定月文件的字节数ls -ltr | awk '$6=="Oct" {sum += +$5 } END { print sum}'[@more@]

@?/rdbms/admin/utlxplan create public synonym plan_table for plan_table; grant all on plan_table to public; @?/sqlplus/admin/plustrce.sql grant plustrace to public; #测试过程connect /as sysdba;select username,created from dba_users order by 2;connect USERNAME/PASSWORDset autotrace traceonly;如果出现 SQL> set autotrace traceonly;SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS report的提示,执行:connect /as sysdba;grant select any

cat file_name | sed -n '/key world/,$p' 显示关键字到文件末尾的内容[@more@]l

unix为防止终端长时间没有动作挂死，可以在另一个终端向前一个发write 如下:while : ;do printf "`date `nnn" ; printf "`date` nnnnn"|write oracle pts/2 ;sleep 2 ;doneoracle pts/2 是用w命令看到的前一个终端的标识[@more@]

a="$(for pid in $(ps -ef | grep -v grep | grep java | grep weblogic | awk '{print $2}'); do fs="$($(which lsof) -p $pid | wc -l)" ; echo $fs+ ; done)"echo $a[@more@]

# TZ=${TZ}+64 == 3 day ago# TZ=${TZ}+40 == 2 day ago# TZ=${TZ}+16 == 1 day agoyDATE="`TZ=${TZ}+40 date +%b %d`"echo ${yDATE}solaris 中取1，2，3天前的日期[@more@]

#!/bin/shcd ./076/for id in 01016 01017 01015 01014 01010 01007 01012 01005 01009do echo "$id" find ./ -name '*.txt' -type f |xargs awk '$2~/'$id'/ {print $1"t"$2"t"$4"t"$5}' >>../aaaaadone[@more@]

wget http://ftp.unicamp.br/pub/postfix/official/postfix-2.6.3.tar.gztar zxvf postfix-2.6.3.tar.gzcd postfix-2.6.3/make useradd -s /sbin/nologin -d /dev/null postfixgroupadd postdropmake install最后一步选择postdrop =================vi /etc/postfix/main.cfqueue_directory = /var/spool/postfixcommand_directory = /usr/sbindaemon_directory = /usr/libexec/postfixdata_directory = /var/lib/postfixmail_owner = postfixmydomain = domain.commyhostname = mail.$mydomainmyorigin = $mydomainrelay_domains = $mydo

rsync配置认证方式/etc/rsyncd.conf uid = wst40gid = wst40max connections = 50pid file = /var/run/rsyncd.pidlock file = /var/run/rsyncd.locklog file = /var/log/rsyncd.loghosts allow = xxx.xxx.xxx.0/24ignore errors = yesauth users = wst40secrets file = /etc/rsyncd.secretsread only = no[htdocs]path = /usr/local/apache2/htdocscomment = cms3 - gxydread only = no=====================服务器端/etc/rsyncd.secrets 格式username:password username可以不是操作系统名称password不是操作系统用户名chmod 600 /etc

#!/bin/shhosts="10.46.64.49 10.46.64.50"ports="6001 6003 6005 6007"#apps="/ /fmccehalladmin/ /fjheart/ /mzonehr/ /pay/ /service/ /fjzp/ /sitestat2/"apps="/ /fjheart/ /mzonehr/ /pay/ /service/ /fjzp/ /sitestat2/"status="status.jsp"send_mail(){mess="$1"cat /app/apache/bin/mail_list |grep -v '^#'|while read emaildomail -s "fj mobile weblogic alert !!! $(date +%Y年%m月%d日 %H时%M分%S秒)"<$mess $email -- -f master@fj.chinamobile

select user_mobile, count(*) from t_query_log where application ='wap' andquery_time >= to_date(to_char(trunc(sysdate-7),'yyyy-mm-dd')||' 18:00:00','yyyy-mm-dd hh24:mi:ss') and query_time <= to_date(to_char(trunc(sysdate),'yyyy-mm-dd')||' 18:00:00','yyyy-mm-dd hh24:mi:ss')[@more@]

tcpdump -ni eth0 -s0 -tttt -vvvv host (xxx.xxx.xxx.xxx or yyy.yyy.yyy) and dst port 80[@more@]

reference:http://blog.chinaunix.net/u/11765/showart_471903.html===================1.创建表，通过utlxplan脚本 SQL> @?/rdbms/admin/utlxplanTable created. 2. 创建同义词为了多个用户可以共享一个plan_table 并授权给public SQL> create public synonym plan_table for plan_table;Synonym created.SQL> grant all on plan_table to public;Grant succeeded. 3.创建plustrace 角色 SQL> @?/sqlplus/admin/plustrce.sql 执行这个脚本就可以了。SQL> drop role plustrace;drop role plustrace *ERROR at l

linux date 昨天date -d '-2 day' +%Y%m%d-%H%M%S取前一个小时date -d '-1 hour' +%Y%m%d-%H%M%S[@more@]linux date 昨天date -d '-2 day' +%Y%m%d-%H%M%S取前一个小时date -d '-1 hour' +%Y%m%d-%H%M%S

注意:php-5.3.0.tar.gz抛弃的很多的函数,所以不适合安装dotproject2.1.2 只能使用php-5.3.0.tar.gz以前的版本[@more@]注意:php-5.3.0.tar.gz抛弃的很多的函数,所以不适合安装dotproject2.1.2 只能使用php-5.3.0.tar.gz以前的版本tar zxvf zlib-1.2.3.tar.gzcd zlib-1.2.3/./configure --prefix=/home/project/usr/localmake make installtar zxvf libpng-1.2.38.tar.gzcd libpng-1.2.38/./configure --prefix=/home/project/usr/localmake make installtar zxvf jpegsrc.v7.tar.gzcd jpeg-7/./configure --prefix=/home/project/usr/local