ITPub博客

n="1048477";while [ : ] ; do if ulimit -Hn $n >/dev/null 2>&1 ; then echo "${n} :`ulimit -Hn`" ; else echo "${n} :ulimit -Hn max ..."; break ; fi; n=`expr $n + 1` ; ulimit -Hn 60000;done[@more@]

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@]