linux 配置虚拟网络(Dunmy Network
linux 配置虚拟网络(Dunmy Networkmodprobe dummy numdummies=n //n要虚拟网卡的数量ifconfig dummy0 10.0.0.1 netmask 255.255.255.0 upifconfig dummy1 10.1.0.1 netmask 255.255.255.0 upcat /proc/net/dev[@more@]linux 配置虚拟网络(Dunmy Networkmodprobe dummy numdummies=n //n要虚拟网卡的数量ifconfig dummy0 10.0.0.1 netmask 255.255.255.0 upifconfig dummy1 10.1.0.1 netmask 255.255.255.0 upcat /proc/net/dev=================================================/etc/sysconfig/network-scripts/ifcfg-dummy0DEVICE=dummy
linux serial console_grub.conf
IntroductionHave you ever needed to connect a dumb terminal (like a Wyse 50) to a Linux host? Do you need to login to a Linux server from a laptop to perform administrative functions, because there is no monitor or keyboard [@more@]IntroductionHave you ever needed to connect a dumb terminal (like a Wyse 50) to a Linux host? Do you need to login to a Linux server from a laptop to perform administrative functions, because there is no monitor or keyboard attached to the server? If you are accustome
oracle9i 运行runInstaller 报错symbol __libc_wait, version GLIBC_2.0
Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference[@more@]Unable to load native library: /tmp/OraInstall2003-10-25_03-14-57PM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference必须打patch,安装patch 3006854,然后可以启动runInstaller;//跟踪$ORACLE_HOME/9i/install/make.log文件报错:/export/home/orac
Oracle数据库关于SQL的执行计划
1、说一说Oracle的Optimizer及其相关的一些知识。 2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。 3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。[@more@] 本文的目的: 1、说一说Oracle的Optimizer及其相关的一些知识。 2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。 3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。
Linux下Tomcat的安装
Linux下Tomcat的安装1.下载Tomcat在下面的地址下载Tomcat的二进制版[@more@]Linux下Tomcat的安装1.下载Tomcat在下面的地址下载Tomcat的二进制版 http://mirrors.ccs.neu.edu/Apache/dist/jakarta/tomcat-4/binaries/即下载文件 tomcat-4.1.18.tar.gz2. 安装首先解压缩 gunzip tomcat-4.1.18.tar.gz tar -zxvf tomcat-4.1.18.tar得到Tomcat的所有文件.然后把它拷贝到你要安装的位置,如 /opt/tomcat-4.1.18/然后为了方便,你可以把目录名tomcat-4.1.18改为tomcat.3.设置设置路经在/etc/profile文件中加入如下两行
apache +tomcat 桥接
# apache./configure --prefix=/home/www --enable-so#生成mod_jk.so文件./configure --with-apxs=/home/www/bin/apxs --enable-EAPI[@more@]# apache./configure --prefix=/home/www --enable-so#生成mod_jk.so文件./configure --with-apxs=/home/www/bin/apxs --enable-EAPI# httpd.confLoadModule jk_module modules/mod_jk.so#AddModule mod_jk.c## Mod_jk settings#JkWorkersFile "conf/workers.properties"JkLogFile "logs/mod_jk.log"JkLogLevel errorJkMount /*.jsp defaultJkMount /*.do default#logsLogFor
linux下的shell编程之--截取字符串
#截取字符串-1aa="`ifconfig eth0 | grep 'inet addr' | awk '{print $2}'`"echo $aa | grep -o '[0-9]+.[0-9]+.[0-9]+.[0-9]+'[@more@]#截取字符串-1aa="`ifconfig eth0 | grep 'inet addr' | awk '{print $2}'`"echo $aa | grep -o '[0-9]+.[0-9]+.[0-9]+.[0-9]+'#截取字符串-2ifconfig eth0 | grep 'inet addr' | awk '{print $2}' | cut -c6-20#截取字符串-3aa="`ifconfig eth0 | grep 'inet addr' | awk '{print $2}'`"echo ${aa:6:20}#截取字符串-4那就有两种情况了,一种要留分界符的,一种不要
opracle 共享内存 /etc/sysctl.conf
Modify /etc/sysctl.conf, add the following content:[@more@]Modify /etc/sysctl.conf, add the following content:kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.shmall = 2097152 kernel.sem = 250 32000 100 128 fs.file-max = 65536 net.ipv4.ip_local_port_range = 1024 65000If you have more then 2G ram, you can set kernel.shmmax = 2147483648
oracle 匿名存储过程插入大量测试数据
declare i integer; begin i:=1; loop insert into T(ID, dt, VALUE) values(SEQ.nextval, to_date('2005-10-10', 'YYYY-MM-DD'),i);i:=i+1; exit when i>10; end loop;commit;end;/[@more@]declare i integer; begin i:=1; loop insert into T(ID, dt, VALUE) values(SEQ.nextval, to_date('2005-10-10', 'YYYY-MM-DD'),i);i:=i+1; exit when i>10; end loop;commit;end;/
oracle 9i 建库模板
<?xml version = '1.0'?><DatabaseTemplate name="scripts" description="" version="9.0.1"><CommonAttributes><option name="Oracle Ultra Search" value="true"/><option name="Oracle Label Security" value="false"/><option name="Oracle JVM" value="true"/><option name="Oracle Spatial" value="true"/><option name="Oracle Intermedia" value="
oracle 817 ,9i /etc/oratab,/etc/oraInst.loc
============oracle 816 /etc/oratab=============ANET:/export/home/oracle/8.1.6:N =============oracle 9i /etc/oratab==============ECOM:/export/home/oracle/9.0.1:N =============oracle 817 /etc/oraInst.loc=============inventory_loc=/export/home/oracle/oraInventoryinst_group=dba =============oracle 9i /etc/oraInst.loc==============inventory_loc=/export/home/oracle/ora9i/oraInventoryinst_group=dba [@more@]============oracle 816 /etc/oratab=============ANET:/export/home/oracle/8.1.6:N =============orac
oracle .bash_profile
=================oracle 817===============. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.shexport LD_ASSUME_KERNEL=2.2.5export LDEMULATION=elf_i386_glibc21[@more@]=================oracle 817===============. /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.shexport LD_ASSUME_KERNEL=2.2.5export LDEMULATION=elf_i386_glibc21export GCC_EXEC_PREFIX=/usr/i386-glibc21-linux/lib/gcc-lib/export ORACLE_BASE=/export/home/oracleexport ORACLE_HOME=$ORACLE_BASE/817export PATH=$PATH:$ORACLE_HOME/binexpo
oracle 9i init.ora
db_name=DEFAULTdb_files = 80 # SMALL[@more@]db_name=ECOMdb_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL # db_block_buffers = 100 # SMALL --oracle 9i已经废除 shared_pool_size = 3500000 # SMALLlog_checkpoint_interval = 10000processes = 50 # SMALL parallel_max_servers = 5 # SMALLlog_buffer = 32768 # SMALLmax_dump_file_size = 10240 # limit trace file size to 5 Meg eachglobal_names = TRUEcontrol_files = (ora_control1, ora_control2)
oracle 816 init.ora
db_name=""db_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL db_block_buffers = 100 # SMALL [@more@]db_name=""db_files = 80 # SMALL db_file_multiblock_read_count = 8 # SMALL db_block_buffers = 100 # SMALL shared_pool_size = 3500000 # SMALLlog_checkpoint_interval = 10000processes = 50 # SMALL parallel_max_servers = 5 # SMALLlog_buffer = 32768 # SMALLmax_dump_file_size = 10240 # limit trace file size to 5 Meg eachglobal_names = TRUEcontrol_files = (ora_control1, or
oracle 9i pfileECOM.ora
*.aq_tm_processes=1*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'*.compatible='9.2.0.0.0'*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'[@more@]*.aq_tm_processes=1*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'*.compatible='9.2.0.0.0'*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/
oracle 816_init$SID.ora
db_name = "ANET"instance_name = ANETservice_names = ANETcontrol_files = ("/export/home/oracle/oradata/ANET/control01.ctl", "/export/home/oracle/oradata/ANET/control02.ctl",[@more@]db_name = "ANET"instance_name = ANETservice_names = ANETcontrol_files = ("/export/home/oracle/oradata/ANET/control01.ctl", "/export/home/oracle/oradata/ANET/control02.ctl", "/export/home/oracle/oradata/ANET/control03.ctl")open_cursors = 100max_enable
oracle 816 手工创库
cat ANETrun1.sh#!/bin/shORACLE_SID=ANETexport ORACLE_SID[@more@]cat ANETrun1.sh#!/bin/shORACLE_SID=ANETexport ORACLE_SID/export/home/oracle/8.1.6/bin/svrmgrl << EOFspool /export/home/oracle/admin/ANET/create/crdb1.logconnect internalstartup nomount pfile = "/export/home/oracle/admin/ANET/pfile/initANET.ora"CREATE DATABASE "ANET"maxdatafiles 254maxinstances 8maxlogfiles 32character set ZHS16GBKnational character set ZHS16GBKDATAFILE '/export/home/oracle/oradata/ANET/syst