ITPub博客

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

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

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

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

　　1、说一说Oracle的Optimizer及其相关的一些知识。　　　　2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。　　　　3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。[@more@]　　本文的目的：　　　　1、说一说Oracle的Optimizer及其相关的一些知识。　　　　2、回答一下为什么有时一个表的某个字段明明有索引,当观察一些SQL的执行计划时,发现确不走索引的问题。　　　　3、如果你对 FIRST_ROWS、 ALL_ROWS这两种模式有疑惑时也可以看一下这篇文章。　

Linux下Tomcat的安装１．下载Tomcat在下面的地址下载Tomcat的二进制版[@more@]Linux下Tomcat的安装１．下载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．３．设置设置路经在/etc/profile文件中加入如下两行

# 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

＃截取字符串-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那就有两种情况了，一种要留分界符的，一种不要

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

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;/

<?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 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 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

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)

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

*.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','/

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