tag:blogger.com,1999:blog-33027557Tue, 22 Sep 2009 05:45:11 +0000Focus on Linux & Database technology ,sometimes translate articles.http://feelfall.blogspot.com/noreply@blogger.com (feelfall)Blogger51125tag:blogger.com,1999:blog-33027557.post-5745910552323659992Sat, 02 Jun 2007 12:37:00 +00002007-06-02T20:39:51.010+08:00现在的状态很好，知道自己擅长什么，要学什么，爱做什么。给自己定下了几个目标，虽然有些难，但是通过努力都是可以达到的。现在这种状态真好。哈哈，张磊加油！！http://feelfall.blogspot.com/2007/06/blog-post.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-252664419419769902Tue, 29 May 2007 13:07:00 +00002007-05-29T21:13:35.938+08:00今天起开始阅读Oracle® Database Performance Tuning Guide 10g Release 2 (10.2)这篇主要讲述10G性能调整的方方面面，虽然有关性能的话题总是牵连广泛，比如底层硬件，CPU，内存，网络，存储，firmware版本，RAID，OS，内核版本，内核参数....但是这里主要关注如何在其他因素确定的情况下，调整Oracle的性能。http://feelfall.blogspot.com/2007/05/10g-b14211-01.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-2247354187221720120Wed, 23 May 2007 12:15:00 +00002007-05-23T20:26:56.249+08:00最近我在看10g RMAN的文档，如何利用rman进行高级复制，重建数据库。还有就是对照OCM的考试大纲一个一个的练习和做实验。准备今年内参加OCM的考试。英语啊英语，我的口语怎么练习呢？很想背一背，但是找不到好的材料。http://feelfall.blogspot.com/2007/05/blog-post_23.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-1847445929134890935Thu, 17 May 2007 11:56:00 +00002007-05-17T20:07:35.935+08:00do.bat@echo Straing load COC data from ADE tab flat file@for /f %%A in ('"dir /a:d /b "') do @dir %%A /s /b >> temp.tmp@rem 这里首先取到当前目录下面的所有子目录中的文件（只有一层），保存在temp.tmp里面@find "TEX" temp.tmp > temp.names@rem 过滤temp.tmp的内容，之保留带有TEX结尾的文件。@for /f "skip=2" %%A in ('"type temp.names "') do @call extract %%A@rem 用extract脚本收取每个文件当中的内容@REM *********************@for /f %%A in ('"dir /a:d /b "') do @rd %%A /q http://feelfall.blogspot.com/2007/05/blog-post_17.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-7130198834619230042Mon, 14 May 2007 08:07:00 +00002007-05-14T16:31:16.777+08:00这篇文章主要向你介绍，如何在只有一块物理硬盘的linux环境下，安装带ASM的Oracle 10g。首先用grub引导机器，进入grub的命令行。kernel (hd0,10)/as4/vmlinuzInitrd (hd0,10)/as4/initrd.imgboot然后从硬盘选择iso镜像，安装Red hat AS4u4。Oracle 10g的安装选择silent模式。1. 省略前期的内核配置，用户权限配置，用户环境变量配置。2. 录制安装脚本$./runInstaller –record –destinationFile /tmp/install_scripts.rsp进入安装界面后，按照需求选择，最后一步的时候cancel掉。(注意选择software only)3. 使用录制脚本安装$./runInstaller –silent –force –ignoreSysprereqs http://feelfall.blogspot.com/2007/05/x8664red-hat-as4u4-oracle-10g-r2-asm.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-1725127964626072089Mon, 07 May 2007 14:18:00 +00002007-05-07T22:24:08.367+08:00SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','BLANK') FROM DUAL;DBMS_METADATA.GET_DDL('TABLE','BLANK')--------------------------------------------------------------------------------&nbsp&nbspCREATE TABLE "TEST"."BLANK"&nbsp&nbsp (&nbsp&nbsp&nbsp&nbsp"A" VARCHAR2(100)&nbsp&nbsp ) PCTFREE 10 PCTUSED 4SQL> SET LONG 2000SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','BLANK') FROM DUAL;DBMS_METADATA.GET_DDL(http://feelfall.blogspot.com/2007/05/cloblongnclobsqlplus.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-5561919119977028819Sun, 06 May 2007 13:37:00 +00002007-05-07T00:05:13.319+08:00Compared with RAC environment, standby database is much less complicated to set up.A process of standby database creation generally contains these steps:&nbsp&nbsp1.&nbsp&nbspForce logging on primary database&nbsp&nbsp2.&nbsp&nbspEnable primary archive log mode&nbsp&nbsp3.&nbsp&nbspGenerate pfile and shutdown primary database&nbsp&nbsp4.&nbsp&nbspTransport data files to standby node&nbsp&nbsp5.&http://feelfall.blogspot.com/2007/05/physical-standby-database-creation-and.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-1230112800070296892Thu, 03 May 2007 13:07:00 +00002007-05-03T21:13:16.785+08:00OS:Windows&nbspXP&nbspproOracle:&nbsp10.2.0.1&nbsp64bitlistener中LISTENER&nbsp=&nbsp&nbsp(DESCRIPTION_LIST&nbsp=&nbsp&nbsp&nbsp&nbsp(DESCRIPTION&nbsp=&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp(ADDRESS&nbsp=&nbsp(PROTOCOL&nbsp=&nbspTCP)(HOST&nbsp=&nbsp127.0.0.1)(PORT&nbsp=&nbsp1521))&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp(ADDRESS&nbsp=&nbsp(PROTOCOL&nbsp=&nbspIPC)(KEY&nbsp=&nbspEXTPROC1))&nbsp&nbsp&nbsp&nbsp)&nbsp&nbsphttp://feelfall.blogspot.com/2007/05/tns-12541.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-1312694680726657162Thu, 03 May 2007 00:00:00 +00002007-05-02T23:18:13.637+08:00作者:feelfall出处:feelfall.blogspot.com转载时请保留作者和出处。还是由于人懒，这篇文章没有写完。有兴趣再回头研究的时候，我会把这篇文章写完的。信号量是一种描述共享资源的方法。信号量分两种，一种是binary&nbspsemaphore，一种counting&nbspsemaphore。在操作系统中，它是一种进程间通信（IPC）的重要手段。锁是一种序列化机制，实现并发控制的一种手段，它强制那些使用资源的实体（如线程、进程）遵守某些规范（authorized&nbspor&nbspnot.&nbspetc）。锁从强制性分，有两种，一种是advisory&nbsplock（也称协作锁），一种是mandatory&nbsplock（强制锁）。使用协作锁，控制权交由程序员来控制，进程或线程之间需要默契配合。这种锁不会防止程序员破坏自己的数据，使数据不一致。说白了，http://feelfall.blogspot.com/2007/05/linuxoracle.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-3733284403259401300Wed, 02 May 2007 11:30:00 +00002007-05-02T19:40:01.978+08:00DBCA是好，但是作为DBA，必须要了解数据库创建的过程。mkdir&nbspF:\oracle\product\10.2.0\flash_recovery_areamkdir&nbspF:\oracle\product\10.2.0\oradata\replicamkdir&nbspF:\oracle\product\10.2.0\admin\replica\bdumpmkdir&nbspF:\oracle\product\10.2.0\admin\replica\cdumpmkdir&nbspF:\oracle\product\10.2.0\admin\replica\udumpmkdir&nbspF:\oracle\product\10.2.0\admin\replica\scripts#################init.ora#######################http://feelfall.blogspot.com/2007/05/blog-post.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-1836169060734593764Sat, 28 Apr 2007 11:33:00 +00002007-04-28T19:35:04.148+08:00查看查询计划，安装Statspack。都是最常用的东西。记录一下，方便自己以后查找。[oracle@database ~]$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Sat Apr 28 11:02:37 2007Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - ProductionSQL> http://feelfall.blogspot.com/2007/04/explain-plan-statspack.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-8287878222581995784Sat, 28 Apr 2007 09:43:00 +00002007-04-28T19:18:31.389+08:00今天report突然出现这个错误EXT-fs Error (device cciss/c0d0p2) in start-transaction ; Journal has aborted.消息给的很明显，是文件系统的日志被异常终止了。重启后mkrootdev: label / not foundmount:error 2 mounting ext3mount:error 2 mounting noneswitchroot: mount failed 22umount initrd/dev failed : 2Kernel panic - not syncing : Attempted to kill init !这个错误搞不定了，决定重装。由于oracle的数据文件存放在cciss/c0d0p3上，所以恢复起来没有什么问题。OS安装好后，将参数文件和密码文件复制到dbs下。http://feelfall.blogspot.com/2007/04/blog-post_28.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-8861664159192450978Thu, 26 Apr 2007 00:58:00 +00002007-04-26T09:15:57.638+08:00今天系统使用人员反映系统登录很慢。查看了一下v$session，发现有很多session。系统基本不能使用DML。检查一下alert，发现下面的内容：Wed Apr 25 09:05:43 2007Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Completed: ALTER DATABASE OPENWed Apr 25 23:16:37 2007ORACLE Instance mycim - Can not allocate log, archival requiredWed Apr 25 23:16:37 2007ARCH: Connecting to console port...Thread 1http://feelfall.blogspot.com/2007/04/blog-post_26.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-6177967030464858319Tue, 24 Apr 2007 05:44:00 +00002007-04-26T09:22:21.384+08:00备份脚本backupif [ "x$1" != "x" ]; thenecho $1mknod $1"`date +%G%m`.pipe" pgzip < $1"`date +%G%m`.pipe" > $1"`date +%G%m%d-%H%M`.dmp.gz" &exp userid=$1/$1@mycim owner=$1 INDEXES=y \grants=y \rows=y \constraints=y \compress=N \file=$1"`date +%G%m`.pipe"else echo "no schema enterred"firm $1"`date +%G%m`.pipe" -f导入gunzip <&nbspfile&nbsp> pipe_fileimp username/password file=pipe_filegzip < [name-of-pipe]http://feelfall.blogspot.com/2007/04/backup-if-x1-x-then-echo-1-mknod-1date.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-4917754212128134494Sat, 21 Apr 2007 12:24:00 +00002007-04-21T20:26:06.498+08:00热烈庆祝，嘿嘿。（正在等证书）不过，过了OCP还要继续学习。接下来，可以继续前不久开始的总结工作了。http://feelfall.blogspot.com/2007/04/10g-ocp_21.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-2281760448187886936Thu, 05 Apr 2007 00:55:00 +00002007-04-05T09:18:33.628+08:00昨天把数据库服务器上的RAID重新做了一下，结果发现性能明显下降了。今天测试一下，晚上再重新做一下。http://feelfall.blogspot.com/2007/04/blog-post_05.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-5299968273064088542Sun, 01 Apr 2007 00:45:00 +00002007-04-01T10:41:38.757+08:00Fedora Core 6 硬盘安装Reiserfs 文件系统，需要给kernel传入一个额外的参数。先用grub引导，然后进入command。grub> kernel (hd0,10)/fc6/vmlinuz reiserfsgrub> initrd (hd0,10)/fc6/initrd.imggrub> boot这样引导起来的安装过程是可以使用reiserfs文件系统的。但是我装完之后不能登录，奇怪，换回ext3就一切正常了。不知道是Redhat故意的还是笔记本硬件方面的问题。今天在安装10g的时候报错ORA-04031。说明安装过程中shared pool没有分配足够大的连续内存区域。把SGA调大了140MB，安装中就没有报错了。看来内存还是小了点儿。数据库正常运行的情况下ORA-04031也可能是其它原因造成的，比如内存碎片。http://feelfall.blogspot.com/2007/04/blog-post.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-2675098864811495473Mon, 26 Mar 2007 00:40:00 +00002007-03-26T08:53:06.693+08:00前不久准备写的总结进度如下：1.Linux的锁和Oracle的锁状态：已开始进度：60%2.Linux的内存结构状态：未开始3.Oracle的内存结构状态：未开始4.文件系统状态：未开始5.Oracle的数据块状态：未开始6.磁盘状态：未开始7.SQL语句的解析过程状态：未开始进度原因，最近有个生产系统要上线，大部分时间用来输入一些初始数据和系统测试。还有就是准备参加10g的OCP考试，花了不少时间看042和043。http://feelfall.blogspot.com/2007/03/blog-post_26.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-8602332642392371522Sun, 25 Mar 2007 23:52:00 +00002007-03-26T08:29:40.718+08:00应用与oracle的连接分为thin和oci两种模式，前者不需要oracle客户端的支持，后者需要。jdbc:oracle:thin:@youroraclehost:1521:yoursidjdbc:oracle:thin:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))jdbc:oracle:oci:@youroracle-tns-namejdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))昨天把http://feelfall.blogspot.com/2007/03/oraclethinoci.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-83438069173282917Sat, 24 Mar 2007 03:47:00 +00002007-03-24T16:29:27.043+08:00Start Oracle using SQLPLUS on Windiws NT platform:As we all know, post-oracle-9i-installation on Windows NT needs some manual operations to startup the database from SQLPLUS.Here are the steps to notice me long after.1.Set the ORACLE_SID enviroment.2.Make sure key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\ORACLE_SID in register table has correct value.3.Services OracleService and http://feelfall.blogspot.com/2007/03/notes-about-sqlplus-database-migration.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-5343057423440831276Mon, 19 Mar 2007 11:51:00 +00002007-03-19T20:12:24.468+08:00每天在公司都把QQ开着，今天回来的时候忘记关了，导致每次登录都会被公司里的那个给顶下去。怎么办？使绝招，IP映射！出于安全考虑，首先SSH到公司的IP，登录到一台Linux。然后再从那台Linux机器Telnet到路由器。 Username:Password:Lili_router>enPassword:Lili_router#config terminalEnter configuration commands, one per line. End with CNTL/Z.Lili_router(config)#ip nat inside source static tcp 192.168.1.32 3389 公司固定IP 3389 extendable接下来通过windows的远程桌面就可以啦，哈哈哈哈。http://feelfall.blogspot.com/2007/03/qq.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-679409385858848358Sun, 18 Mar 2007 14:05:00 +00002007-03-19T19:51:05.319+08:00看了好几天笔记本，最后选中了HP nx6330 708。昨天上午到了卖电脑的地方，价格谈好了，8590￥。结果在付钱的时候忘记了工资卡的密码。-_-!在刷卡机上试了三次，在ATM机上试了一次，在银行柜台试了两次。把一天里可以试的次数用完了。 下午回到宿舍，等待第二天再试。今天8点起床（睡不着啊）。试了一次，通过。原来是初始密码，由于好久没有取过钱了，给忘记了。就这样，笔记本买回来了。从今天中午到现在一直在配置机器上的软件。整体感觉还不错，就是屏幕亮度觉得还差一些，硬盘偶尔还有拉肚子的声音。太晚了，睡觉。http://feelfall.blogspot.com/2007/03/blog-post.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-7891925731817783163Fri, 16 Mar 2007 07:21:00 +00002007-03-20T11:30:56.533+08:00一、前天晚上登录mycim正式环境突然没有了反应。用vmstat查看jboss服务器的状态，发现PROC的b为1，CPU的id和wa栏位出现异常，两个属性各占50%，说明有进程在等待IO。ps -aux后发现是和数据库链接的进程在等待IO。那么问题定位在了ORACLE数据库。# ssh oracle@192.168.1.2ssh: connect to host 192.168.1.2 port 22: No route to host# ping 192.168.1.2PING 192.168.1.2 (192.168.1.2) 56(84) bytes of data.From 192.168.1.32 icmp_seq=0 Destination Host UnreachableFrom 192.168.1.32 icmp_seq=1 Destination Host http://feelfall.blogspot.com/2007/03/mycim-vmstatjbossprocb1cpuidwa50io-ps.htmlnoreply@blogger.com (feelfall)0tag:blogger.com,1999:blog-33027557.post-8828260454848890441Mon, 01 Jan 2007 00:43:00 +00002007-01-01T08:54:22.013+08:002006年是彷徨，是不安，是忙碌。我都在这一年中做了什么呢？2006年中有两个关键时刻——毕业与MES项目。毕业之前，我天天打游戏。成天忙着怎么给自己的虚拟游戏角色配置装备，和同学去某某奇妙的地方杀怪捡游戏物品。可以说，这段时间过的最没有意义了，没有任何积累。毕业之后。我到了宁波立立公司。唉，自己不争气啊，所以每天都努力改变现状。MES项目。软件，是我上学时候花时间最多的东西，现在又有机会体现我能做好什么了。于是我天天看oracle文档，资料。现在觉得心里踏实多了。展望2007年。练内功是硬道理啊。2007年我或许能写书比较辉煌的个人历史哦，此时偷笑几个小时，哈哈。http://feelfall.blogspot.com/2007/01/2006.htmlnoreply@blogger.com (feelfall)1tag:blogger.com,1999:blog-33027557.post-115931269054082639Tue, 26 Sep 2006 23:11:00 +00002006-09-27T07:29:15.546+08:00Obituary讣文Oriana FallaciSep 21st 2006From The Economist print editionOriana Fallaci, journalist and fighter, died on September 15th, aged 77Oriana Fallaci，一位记者，一名斗士，于9月15日安详往生，享年77岁FAINTHEARTS may prefer not to say that the West is at war with terror. But Oriana Fallaci, Italy's fiercest and most famous journalist, had no doubt at all. She felt it “at nine o'clock on the dot” on the morning of http://feelfall.blogspot.com/2006/09/2006921obituaryoriana-fallaci_27.htmlnoreply@blogger.com (feelfall)0