字符集gb2312转utf8(用spool)
gb2312转到utf8spool出来并用iconv转到utf8#!/bin/bashfor i in `cat table.txt`do/opt/oracle10g/u01/bin/sqlplus -s guomei/xyzmn << EOF set newpage 0set linesize 10000  ...
iptables开启pptp及ftp跟踪
对iptables的nat模块开启pptp及ftp跟踪 modprobe ip_nat_pptp modprobe ip_nat_ftp
Managing the Linux Environment
From:http://www.oracle.com/technology/pub/articles/advanced-linux-commands/part4.html
JVM优化配置
From:http://hi.baidu.com/coofucoo/blog/item/25d361d9555c002811df9bf2.htmlJVM优化配置《一》OOM这个缩写就是Java程序开发过程中让人最头痛的问题:Out of Memory。在很多开发人员的开发过程中,或多或少...
10gR2.0.4数据库压力较大,IO发生短暂停止响应的时候,可能导致数据库实例崩溃
From:NingooOracle10.2.0.4中,如果数据库压力较大,IO发生短暂停止响应的时候,可能导致数据库实例崩溃。在alert中可以找到如下错误:Thu Apr 2 10:55:36 2009Errors in file /bdump/test.trc:ORA-00494: enqueu...
转:ORA-12516错误的处理
解决过程:1、查看当前会话数、processes和sessions值,发现session数和2个参数的值已经非常逼近SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 9 15:50:...
EMC存储最佳实践
From:http://blog.chinaunix.net/u/3380/showart_189722.html
ASM process设置
From:http://blog.itpub.net/battlemanASM process设置Processes = 25 + (10 + [max number of concurrent database file creations, and file extend operations possible])*nn is the number of RDBMS instance (A...
drbd+gfs2配置
两台hp dl360redhat as5.3x64写好两台的host文件10.59.96.65 gfs1.x.com10.59.96.65 gfs110.59.96.100  ...
dd的使用
使用dd清除vote disk和ocr(裸设备)dd if=/dev/zero f=/dev/votedisk_device bs=8192 count=2560dd if=/dev/zero of=/dev/ocr_device bs=8192 count=12800 From:http://www.linuxdiyf.com/bbs/view...
重建控制文件之后,只读表空间的状态变化
What is fractured Block?
From:http://www.geekinterview.com/question_details/62921A block fracture occurs when a block is being read by the backup and bieng written to at the same time by the DBWR. This happens because...
B-type SAN 交换机的划Zone(zoning)方法
From:http://www-01.ibm.com/support/docview.wss?uid=csc114d0cf37a80aa5284825741f001baccfZoning的配置主要途径有两种:Telnet和WEB方式。Zoning的配置可以动态的进行,当使用cfgenable指定某个配置成为...
在多个Brocade SAN Switch上配置Zone
From:http://e-support.hp.com.cn/e-delivery/kdb/UserInterface/DisplayHotDoc.asp?full_docid=38237&ParentCategoryId=274&category_path=0:258:266:274经验共享:在多个Brocade SAN Switch上配置Zone作者...
DML RETURNING INTO Clause
From:http://www.oracle-base.com/articles/misc/dml_returning_into_clause.phpDML RETURNING INTO ClauseThe RETURNING INTO clause allows us to return column values for rows affected ...
cisco与h3c的syslog配置
H3C:[H3C]info-center enable[H3C]info-center loghost 1.1.1.1[H3C]info-center loghost source Vlan-interface 17[H3C]info-center timestamp log date[H3C]info-center switch-on all ...
oracle HA Features
http://www.oracle.com/technology/deploy/availability/index.html
learn AWK from oracle.com
From:http://www.oracle.com/technology/pub/articles/dulaney_awk.htmlLinux SysadminAWK: The Linux Administrators' Wisdom KitBy Emmett DulaneyLearning Linux? This introduction to the ...
Basic Enterprise Manager Troubleshooting
From:http://www.oracle-base.com/articles/misc/BasicEnterpriseManagerTroubleshooting.phpBasic Enterprise Manager TroubleshootingThe web-based Enterprise Manager tool was introduced in Oracle 10...
ASM using ASMLib and Raw Devices
From:http://www.oracle-base.com/articles/10g/ASMUsingASMLibAndRawDevices.phpASM using ASMLib and Raw DevicesIntroductionPartition the DisksASMLib InstallationRaw Device SetupASM CreationDataba...