ITPub博客

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

oracle92安装 如果是一台干净的机器，一般是一路顺利，最后通过dbca配置等。如果以前安装过oracle10client等，导致环境变量对oracle92有影响后， dbca等工具就会配置失败。 这样的话默认的sid没有创建[@more@]oracle92安装 如果是一台干净的机器，一般是一路顺利，最后通过dbca配置等。如果以前安装过oracle10client等，导致环境变量对oracle92有影响后， dbca等工具就会配置失败。 这样的话默认的sid没有创建成功， connect / as sysdba时就会弹出：ORA-12560修改的方法有： （1） 修改环境变量使dbca能够启动创建默认数据库， 启动对应s

手工创建oracle数据库-数据库专家作者：佚名 文章来源：不详 [@more@]系统环境： 1、操作系统：Windows 2000 Server2、数据库：　Oracle 8i R2 (8.1.6) for NT 企业版/Oracle 9i for NT 企业版3、安装路径：D:ORACLE步骤：1、手工创建相关目录2、手工创建初始化参数文件3、通过oradim创建一个ORACLE服务4、创建数据库5、创建数据库数据文件，执行脚本6、创建数据字典，运行手工创建数据库完整步骤系统环境操作系统：Windows 2000 Server 数据库：Oracle 9i安装路径：C:Oracle1、手工创建相关目录C：OracleadminwebC：OracleadminwebbdumpC

#!/bin/sh# Solaris system_monitor #. /.profileday=`date +%m%d%Y`file="/var/log/system/sysinfo$day"if [ -f $file ]; thenecho "ok">/dev/null[@more@]#!/bin/sh# Solaris system_monitor #. /.profileday=`date +%m%d%Y`file="/var/log/system/sysinfo$day"if [ -f $file ]; thenecho "ok">/dev/nullelseecho " date cpu mem swap load average oracle sessions">>$fileecho " user system idle free free 1 5 15">>$fileecho "">>

#!/bin/sh# Linxs ck_tablespaces.shsqlplus $1/$2@$3 <<EOFset feed offset lines 160set pagesize 999[@more@]#!/bin/sh# Linxs ck_tablespaces.shsqlplus $1/$2@$3 <<EOFset feed offset lines 160set pagesize 999col tablespace_name format a10col DBfile_name format a50col b.file_id format a10spool $4.txtselect b.file_id,b.FILE_NAME DBfile_name,b.tablespace_name,b.bytes,b.maxbytes maxbytes,( b.bytes-sum(nvl(a.bytes,0))) USED,sum(nvl(a.bytes,0)) SHENGYU,sum(nvl(a.bytes,0))/(b.bytes)*100 SHENYUpre