ITPub博客

oracle记录[@more@]orassh -P -g -f tomcat@61.242.223.36 -L 8080:61.242.223.36:8080 sleep 7200kill -9 `ps -ef|grep "LOCAL=NO" |grep -v grep |awk '{print $2}'` 删除重复的记录delete from heroinfo a where a.rowid!=(select max(rowid) from heroinfo b where a.fxno=b.fxno and b.fxno=a.fxno ); 后台进程的SPIDSELECT s.SID SID, p.spid threadid, p.program processname, bg.NAME NAME FROM v$process p, v$session s, v$bgprocess bg WHERE p.addr = s.paddr AND p.addr = bg.paddr AND bg.paddr <> '00';

关于ssh端口转发的深入实例ssh的三个强大的端口转发命令：ssh -C -f -N -g -L listen_port:DST_Host:DST_port user@Tunnel_Hostssh -C -f -N -g -R listen_port:DST_Host:DST_port user@Tunnel_Hostssh -C -f -N -g -D listen_port user@Tunnel_Host [@more@]关于ssh端口转发的深入实例ssh的三个强大的端口转发命令：ssh -C -f -N -g -L listen_port:DST_Host:DST_port user@Tunnel_Hostssh -C -f -N -g -R listen_port:DST_Host:DST_port user@Tunnel_Hostssh -C -f -N -g -D listen_port user@Tunnel_Host -f Fork into background afte

while (:); do p=`ps -ef | grep httpd | grep -v grep | wc -l`; echo "p=$p" ;n=`netstat -anlp | grep 'xxx.xxx.xxx.xxx:80' | wc -l`; echo "n=$n";echo "";sleep 2 ;done while : ; do ps -ef H| grep -v grep | grep httpd | wc -l ;sleep 2;echo "" ;donefree | grep buffers | tail +2 | awk '{print $4}'=======================================pnum=0;if [ "$pnum" -eq "0" ]; then echo "ok" ; else echo "no ok ..." ;fi[@more@]

ftpd_banner=Welcome to blah FTP service.pam_service_name=vsftpduserlist_enable=NOlisten=YEStcp_wrappers=YESanonymous_enable=NOlocal_enable=YESlocal_umask=022xferlog_enable=YESxferlog_std_format=YESwrite_enable=YES[@more@]

1. fdisk划分hda5,hda6，并且将这两个分区的标志(键入t改)改为(0x)8e 然后用partprobe通知OS磁盘分区的变化 2. pvcreate /dev/hda5 创建pv hda53. vgcreate VolGroup00 /dev/hda5 将hda5加入逻辑卷组VolGroup00中 4. 激活卷组,为了立即使用卷组而不是重新启动系统，可以使用vgchange来激活卷组 vgchange -a y VolGroup005. 添加新的物理卷到卷组中 vgextend VolGroup00 /dev/hdc56. lvcreate -L5G -nLogVol04 VolGroup00 从VolGroup0中，创建一个5G的逻辑卷LogVol047. 创建文件系统 mke2fs -j /dev/mapper/VolGroup00-LogVol

#!/usr/bin/sh# ding yi huan jing bian liang DATE=`date +%w`DIR="/export/home/ORA_BAK"BAK_CONF="${DIR}/bin"RBAK_HOME="/manager/oracle/ORA_BAK"export DATE DIR BAK_HOME# export oracle dump file dumpdb(){cd $DIR/DATA$ORACLE_HOME/bin/exp $1/$1@$2 file=$1_$DATE.dmp log=$1_$DATE.log compress=n}zip(){cd $DIR/DATAif [ -f ${DIR}/DATA/$1_$DATE.dmp ] ; then echo "$1 dmp is dump ... now compress ..." rm -rf $DIR/DATA/$1_$DATE.dmp.Z compress $1_$DATE.dmp echo &q

#!/bin/sh# DATE=`date +%w`DIR="/export/home/oracle/ORA_BAK"BAK_CONF="${DIR}/bin"RBAK_HOME="/backup/orabackup"export DATE DIR BAK_HOME# export oracle dump file dumpdb(){cd $DIR/DATA$ORACLE_HOME/bin/exp $1/$2@$3 file=$1_$DATE.dmp log=$1_$DATE.log # compress=n}zip(){cd $DIR/DATAif [ -f ${DIR}/DATA/$1_$DATE.dmp ] ; then echo "$1 dmp is dump ... now compress ..." rm -rf $DIR/DATA/$1_$DATE.dmp.Z compress $1_$DATE.dmp echo "database dmp compress OK..

#!/bin/sh#. /.profileday=`date +%m%d%Y`file="/var/log/system/sysinfo$day"if [ -f $file ]; thenecho "ok">/dev/nullelseecho " date cpu mem swap load average sessions">>$fileecho " user system idle free free 1 5 15 httpdT+httpdPjavaT+javaP">>$fileecho "">>$filefitime=`date '+%m%d %H:%M:%S '`load=`uptime |grep load|sed s/,//g|awk '{printf"%10s %6s %6s", $(NF-2),$(NF-1),$NF}'`#cpu=`vmstat |grep -v [cpu][swap]|awk '{print

#!/bin/shsqlplus $1/$2@$3 <<EOFset feed offset lines 130set pagesize 999col TS_name format a13col TS_place format a48spool $4.txtselect b.file_id ID,b.FILE_NAME TS_place,b.tablespace_name TS_name,b.bytes BYTES,b.MAXBYTES,(b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) surplus,sum(nvl(a.bytes,0))/(b.bytes)*100 surplus_prefrom dba_free_space a,dba_data_files bwhere a.file_id=b.file_idgroup by b.tablespace_name,b.file_id,b.bytes,b.FILE_NAME,b.MAXBYTES order by b.file_id;spool offexitEO

startup mount ;select name from v$datafile;select tablespace_name from dba_tablespaces; [@more@]startup mount ;select name from v$datafile;select tablespace_name from dba_tablespaces; alter database datafile '/export/home/oracle/oradata/ECOM/undotbs01.dbf' offline drop; alter tablespace UNDOTBS1 add datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200M;# create undo tablespace undotbs2 datafile '/export/home/oracle/oradata/ECOM/undotbs02.dbf' size 200m;ALTER SYSTEM SET undo_tablesp

<Location /fjzp/*.jsp|/fjzp/*.do>SetHandler weblogic-handler# PathTrim /weblogic/weblogic/myserver/fjzp</Location>[@more@]LoadModule weblogic_module modules/mod_wl_20.so<Location /fjzp/*.jsp|/fjzp/*.do>SetHandler weblogic-handler# PathTrim /weblogic/weblogic/myserver/fjzp</Location># action/CreatedImage<Location /fmccehall/action/CreateImage>SetHandler weblogic-handler</Location><Files *.jsp>SetHandler weblogic-handler</Files><Files *.do>

RMAN简单使用目标机A:create tablespace RMAN datafile '$ORACLE_HOME/oradata/FILENAME.DBF' size 20M;[@more@]RMAN简单使用目标机A:create tablespace RMAN datafile '$ORACLE_HOME/oradata/FILENAME.DBF' size 20M;create username RMAN identified by RMAN default tablespace rman temporary tablespace temp quota unlimited on RMAN;grant recovery_catalog_owner to rman ; rman catalog rman/rmancreate catalog tablespace 'RMAN';Rman主机B:rman target /connect catalog rman/rman@$A_SID注册数据库register database;注销数据

apache编译安装//httpd2.2./configure --prefix=/home/www --enable-rewrite --enable-so --with-mpm=worker --with-threads=yes[@more@]apache编译安装//httpd2.2./configure --prefix=/home/www --enable-rewrite --enable-so --with-mpm=worker --with-threads=yes//lt_LogFormatLogFormat "%h %l %u %{[%Y/%m/%d/%w:%H:%M:%S]}t "%r" %>s %b "%{User-agent}i"" combinedCustomLog "|/usr/local/sbin/cronolog /home/www20/logs/web-%Y%m%d.log" combined//fj_LogFormatLogFormat "%h

while (:) ;do echo "httpd ->` ps -ef | grep -v grep | grep httpd | wc -l`";sleep 1 ;donepnum=0;if [ "$pnum" -eq "0" ]; then echo "ok" ; else echo "no ok ..." ;fi[@more@]#!/bin/sh# ping shellecho '219.238.182.1'>./.ipecho '219.238.182.10'>>./.ipecho '219.238.182.62'>>./.ipecho '#!/bin/sh'>./pecho '#pshell'>>./pecho 'while read LINE'>>./pecho 'do'>>./pecho 'echo "${LINE} `ping -c1 ${LINE}|tail +2 | grep '

make clean./configure --prefix=/home/www/apache22w1 --enable-so --with-mpm=worker --with-threads=yesmake ;make install查看使用什么mpm$apache/bin/httpd -l[@more@]make clean./configure --prefix=/home/www/apache22w1 --enable-so --with-mpm=worker --with-threads=yesmake ;make installmake clean./configure --prefix=/home/www/apache22w2 --enable-so --with-mpm=workermake ;make installmake clean./configure --prefix=/home/www/apache22p1 --enable-so --with-mpm=prefork --with-threads=yesmake ;make installmak

下面介绍一下怎样打开apache的mod_rewrite功能。#tar -zxvf httpd-2.0.59.tar.gz#cd httpd-2.0.59#./configure --prefix=/opt/apache2 --enable-modules=so --enable-module=rewrite --enable-shared=rewrite --enable-shared=max#make#make install[@more@]下面介绍一下怎样打开apache的mod_rewrite功能。#tar -zxvf httpd-2.0.59.tar.gz#cd httpd-2.0.59#./configure --prefix=/opt/apache2 --enable-modules=so --enable-module=rewrite --enable-shared=rewrite --enable-shared=max#make#make installapache安装完毕，下面来加载编译

首先来重新编译安装apache-2.0.59#tar -zxvf httpd-2.0.59.tar.gz#cd httpd-2.0.59#./configure --prefix=/opt/apache2 --enable-so --enable-module=rewrite --enable-shared=rewrite --enable-shared=max#make#make install[@more@]下面介绍一下怎样打开apache的mod_rewrite功能。zhy1899 圣骑士会员UID：131228注册时间：2004-2-7 09:54最后登录：2007-5-17 10:13帖子总数： 125 精华帖子： 0积分：91在线状态：...离线...首先来重新编译安装apache-2.0.59#tar -zxvf httpd-2.0.59.tar.gz#cd httpd-2.0.59#./configure --prefix=/opt/

并行cpu查询分区表测试 12月01日(星期四) 这篇文章是回应玉面飞龙所提出的均匀分布数据的情况而实验测试均匀数据分布的并行查询与非并行查询，结果是均匀数据分布的并行查询要优于非并行查询测试环境: OS: HP9000 DB:9201(数据文件分布在裸设备上)[@more@]并行cpu查询分区表测试 12月01日(星期四) 这篇文章是回应玉面飞龙所提出的均匀分布数据的情况而实验测试均匀数据分布的并行查询与非并行查询，结果是均匀数据分布的并行查询要优于非并行查询测试环境: OS: HP9000 DB:9201(数据文件分布在裸设备上)1.创建一个200M的data1逻辑卷，在系统

1.用sys用户运行脚本ultxplan.sql建立这个表的脚本是：（UNIX:$ORACLE_HOME/rdbms/admin, Windows:%ORACLE_HOME%rdbmsadmin）ultxplan.sql。SQL> connect sys/sys@colm2 as sysdba;SQL> @C:oracleora92rdbmsadminutlxplan.sql;SQL> create public synonym plan_table for plan_table; --建立同义词SQL> grant all on plan_table to public;--授权所有用户[@more@]1.用sys用户运行脚本ultxplan.sql建立这个表的脚本是：（UNIX:$ORACLE_HOME/rdbms/admin, Windows:%ORACLE_HOME%rdbmsadmin）ultxplan.sql。SQL> connect sys/

.bash_profile#export LD_ASSUME_KERNEL=2.4.20export ORACLE_BASE=/export/home/oracleexport ORACLE_HOME=$ORACLE_BASE/9iexport ORACLE_SID=ECOMexport ORACLE_TERM=xtermexport ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/libexport LD_LIBRARY_PATHexport PATH=$PATH:$ORACLE_HOME/binexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport