Fightinnnng

生活的方向

2007-06-02T20:37:00.000+08:00

现在的状态很好，知道自己擅长什么，要学什么，爱做什么。给自己定下了几个目标，虽然有些难，但是通过努力都是可以达到的。现在这种状态真好。哈哈，张磊加油！！

10G B14211-01

2007-05-29T21:07:00.000+08:00

今天起开始阅读Oracle® Database Performance Tuning Guide 10g Release 2 (10.2)这篇主要讲述10G性能调整的方方面面，虽然有关性能的话题总是牵连广泛，比如底层硬件，CPU，内存，网络，存储，firmware版本，RAID，OS，内核版本，内核参数....但是这里主要关注如何在其他因素确定的情况下，调整Oracle的性能。

记录一个批处理文件的写法

2007-05-17T19:56:00.000+08:00

do.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

X86_64笔记本上安装Red hat AS4u4 + Oracle 10g R2 + ASM

2007-05-14T16:07:00.001+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

CLOB,LONG,NCLOB在SQL*PLUS的显示长度

2007-05-07T22:18:00.000+08:00

SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','BLANK') FROM DUAL;DBMS_METADATA.GET_DDL('TABLE','BLANK')-------------------------------------------------------------------------------- CREATE TABLE "TEST"."BLANK" ( "A" VARCHAR2(100) ) PCTFREE 10 PCTUSED 4SQL> SET LONG 2000SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','BLANK') FROM DUAL;DBMS_METADATA.GET_DDL(

Physical Standby Database Creation and Simple Management

2007-05-06T21:37:00.000+08:00

Compared with RAC environment, standby database is much less complicated to set up.A process of standby database creation generally contains these steps: 1. Force logging on primary database 2. Enable primary archive log mode 3. Generate pfile and shutdown primary database 4. Transport data files to standby node 5.&

TNS-12541

2007-05-03T21:07:00.000+08:00

OS:Windows XP proOracle: 10.2.0.1 64bitlistener中LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) )

浅谈Linux与Oracle的锁（未完成）

2007-05-03T08:00:00.000+08:00

作者:feelfall出处:feelfall.blogspot.com转载时请保留作者和出处。还是由于人懒，这篇文章没有写完。有兴趣再回头研究的时候，我会把这篇文章写完的。信号量是一种描述共享资源的方法。信号量分两种，一种是binary semaphore，一种counting semaphore。在操作系统中，它是一种进程间通信（IPC）的重要手段。锁是一种序列化机制，实现并发控制的一种手段，它强制那些使用资源的实体（如线程、进程）遵守某些规范（authorized or not. etc）。锁从强制性分，有两种，一种是advisory lock（也称协作锁），一种是mandatory lock（强制锁）。使用协作锁，控制权交由程序员来控制，进程或线程之间需要默契配合。这种锁不会防止程序员破坏自己的数据，使数据不一致。说白了，

手动创建数据库

2007-05-02T19:30:00.000+08:00

DBCA是好，但是作为DBA，必须要了解数据库创建的过程。mkdir F:\oracle\product\10.2.0\flash_recovery_areamkdir F:\oracle\product\10.2.0\oradata\replicamkdir F:\oracle\product\10.2.0\admin\replica\bdumpmkdir F:\oracle\product\10.2.0\admin\replica\cdumpmkdir F:\oracle\product\10.2.0\admin\replica\udumpmkdir F:\oracle\product\10.2.0\admin\replica\scripts#################init.ora#######################

Explain plan 和 Statspack

2007-04-28T19:33:00.000+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>

数据库不完全恢复

2007-04-28T17:43:00.001+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下。

系统挂起

2007-04-26T08:58:00.000+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 1

备份脚本

2007-04-24T13:44:00.000+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 < file > pipe_fileimp username/password file=pipe_filegzip < [name-of-pipe]

10g OCP考试通过

2007-04-21T20:24:00.001+08:00

热烈庆祝，嘿嘿。（正在等证书）不过，过了OCP还要继续学习。接下来，可以继续前不久开始的总结工作了。

性能变差了

2007-04-05T08:55:00.000+08:00

昨天把数据库服务器上的RAID重新做了一下，结果发现性能明显下降了。今天测试一下，晚上再重新做一下。

小记

2007-04-01T08:45:00.000+08:00

Fedora 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也可能是其它原因造成的，比如内存碎片。

总结进度

2007-03-26T08:40:00.000+08:00

前不久准备写的总结进度如下：1.Linux的锁和Oracle的锁状态：已开始进度：60%2.Linux的内存结构状态：未开始3.Oracle的内存结构状态：未开始4.文件系统状态：未开始5.Oracle的数据块状态：未开始6.磁盘状态：未开始7.SQL语句的解析过程状态：未开始进度原因，最近有个生产系统要上线，大部分时间用来输入一些初始数据和系统测试。还有就是准备参加10g的OCP考试，花了不少时间看042和043。

Oracle的thin与oci连接方式

2007-03-26T07:52:00.000+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)))昨天把

notes about SQLPLUS & database migration

2007-03-24T11:47:00.000+08:00

Start 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

关QQ

2007-03-19T19:51:00.000+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的远程桌面就可以啦，哈哈哈哈。

今天买笔记本啦啦啦

2007-03-18T22:05:00.000+08:00

看了好几天笔记本，最后选中了HP nx6330 708。昨天上午到了卖电脑的地方，价格谈好了，8590￥。结果在付钱的时候忘记了工资卡的密码。-_-!在刷卡机上试了三次，在ATM机上试了一次，在银行柜台试了两次。把一天里可以试的次数用完了。下午回到宿舍，等待第二天再试。今天8点起床（睡不着啊）。试了一次，通过。原来是初始密码，由于好久没有取过钱了，给忘记了。就这样，笔记本买回来了。从今天中午到现在一直在配置机器上的软件。整体感觉还不错，就是屏幕亮度觉得还差一些，硬盘偶尔还有拉肚子的声音。太晚了，睡觉。

三件事

2007-03-16T15:21:00.000+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

回首我的2006

2007-01-01T08:43:00.000+08:00

2006年是彷徨，是不安，是忙碌。我都在这一年中做了什么呢？2006年中有两个关键时刻——毕业与MES项目。毕业之前，我天天打游戏。成天忙着怎么给自己的虚拟游戏角色配置装备，和同学去某某奇妙的地方杀怪捡游戏物品。可以说，这段时间过的最没有意义了，没有任何积累。毕业之后。我到了宁波立立公司。唉，自己不争气啊，所以每天都努力改变现状。MES项目。软件，是我上学时候花时间最多的东西，现在又有机会体现我能做好什么了。于是我天天看oracle文档，资料。现在觉得心里踏实多了。展望2007年。练内功是硬道理啊。2007年我或许能写书比较辉煌的个人历史哦，此时偷笑几个小时，哈哈。

翻译[2006.9.21][Obituary]Oriana Fallaci

2006-09-27T07:11:00.001+08:00

Obituary讣文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

翻译[2006.09.21]A meaty question

2006-09-24T01:10:00.000+08:00

A meaty question食用肉问题Sep 21st 2006From The Economist print editionBiotechnology: Meat grown in vats, rather than in the form of animals, could soon be on the menu. It might even be healthier and better for you生物工程：不是动物肉，而是长在桶里的肉不久后就会出现在人们的菜单上。对于您，这可能会更健康，更好。IF YOU have ever longed for a meat substitute that smelt and tasted like the real thing, but did not involve killing an animal, then your

翻译[2006.9.07][Book & Art]For him the bell tolled

2006-09-23T08:35:00.000+08:00

引用：---No man is an island,entire of itself;every man is a piece of the continent,a part of the main.If a clod be washed away by the sea,Europe is the less,as well as if a promontory were,as well as if a manor of thy friend's or of thine own were:any man's death diminishes me,because I am involved in mankind,and, therefore,never send to know for whom the bells tolls;it tolls for thee.没有人能自全，没有人是孤岛

It a little bit long

2006-09-17T20:41:00.000+08:00

I haven't written for a little bit long. There is so much too say, but so few words that i can choose.There is uncertainty and unexpectation, but interesting and made me feeling warm.Love is an eternal topic that never fade with time passes by.I wish the ones i love so much could live happily.You know whom i am talking about, it's you!

Lightly frustrated

2006-09-13T18:45:00.000+08:00

How it comes about that the trivials confused me? If one never go through difficulties, he never achieves. Yet the trivials are not questions after all. In fact, the problems of all this is that the frustration is not real but fictitious.Blue days. Destined period.

More actions, Less decisions

2006-09-11T18:28:00.000+08:00

Achievement needs actions more than decisions.Remind myself what is the goal.Encourage myself everyday.

翻译 [2006.09.07]Letters

2006-09-10T11:44:00.000+08:00

LettersOn newspapers, Europe and Israel, MI6, Ethiopia and Somalia, corruption scores, Turkey, China, think-tanks有关，报纸公司，欧洲和以色列，军情6处，埃塞阿比亚与索马里，腐败排行，土耳其，中国，智囊团Sep 7th 2006From Economist.comRead all about it读新闻SIR ? The sensationalist headline to your leader on the newspaper industry was more suited to a tabloid than the reasoned pages of The Economist (“Who killed the newspaper?”, August 26th). To

Rainy Day

2006-09-09T18:57:00.000+08:00

Its' toooo late, and i am so tired.Tomorrow i will have my post posted.Have a sweet dream budy!

Draft of self-introduction

2006-09-08T22:14:00.000+08:00

I decided to attend the english corner this evening at Xiaoshan park. But an unexpected barbecue pushed me to the DaRunFa shopping mart to buy food for the barbecue dated on tomorrow. This is my draft which i wanted to utter at the park.Alas...I'm glad to be here with you today. This is my first time to speak English here. A little bit nervous indeed. The topic in hand is how to make friends,

Views on relationship

2006-09-07T21:37:00.000+08:00

Here is the hyper-link of the posts.http://www.newbeilun.com/read.php?tid-466283-page-2-fpage-1.htmlMine is below:Jane, definitely!I have never fallen in love. But careful observations from the relationship of my prarents, my grandparents and of other marriages around me, make me be able to taste what you typed above deeply. Your post probably started from your view of a special everylasting

My Generation

2006-09-07T21:12:00.000+08:00

How many that were studying together of us are happy now?Rare! We are gregarious animal! But now, each of us is solitary single.Recently, the responses from my friends showed that there was an atmosphere of sadness. Lack of laughters, lack of collective activities, lack of free talking, lack of whispers from the inner hearts......If everyone of us had the chance to start over, what were you going

Few & Many changes in daily life.

2006-09-06T19:23:00.000+08:00

Go through the same road, greet people with the same words, dine at the same place. Every minute in the same row flies in the same order these days. Rare changes happened. I do the same after work. Every cell, however, in the same tissue feels much differently recently. It's fresh everyday.Mizzles told me the time is changed. You should take up your umbrella or raincoat.I talked with Yuki on QQ

Jane in my eyes

2006-09-05T18:47:00.000+08:00

A mother of a smart boy, a wife of a husband, a busy employee of this city, a heart of devotion, a custom of perserve, a smile of delight, and A valuable life of herself.Smiling as this is one combination of her ID "SmilingJane", notes that she is an optimistic person, who i envy so much.All these were in my mind whenever i read her post on the forum of newBeiLun. In fact, i have neither got her

A phone call

2006-09-04T19:58:00.000+08:00

I got a phone call with my aunt yesterday evening.If there were something doubtful in my heart, then, after that, i certainly knew one that i should do undoubtedly."There are something you can obtain after all, say knowledge, scholar degree and so forth, but there are others that you can try only once, say people's impression, good relations with your colleagues, supervisors and others... ..."

汉译英

2006-09-03T00:03:00.000+08:00

（1）、至2002年7月起由新矸镇牡丹小区发起并提供日常经费支持的小山公园英语角旨在为社区居民提供一个轻松良好的英语学习、交友平台；Brief introduction: XiaoShan English Corner, a comfortable language learning and social-networking platform for local inhabitants, came to existance in july 2002 with a running expense support from peony community, Beilun, Ningbo.（2）、位置：明州路南侧，新老板娘大酒店南面，新世纪花园东面，英语角位于公园西面，即从西门进，右侧经走廓，临池最大一间即是（墙壁有英语角标志及相关活动照片）；Location: XiaoShan Park

Smiling Yuki

2006-09-02T09:44:00.000+08:00

Yuki is a funny girl. Believe it or take a step into her blog, then you will finally find i am not cheating you.Essays as there are are full of anecdotes in her normal life.And tasting with a violin concerto "Por Una Cabeza", my feeling just like the fluent notes blowing with the rhythm, then found it's elegant there with no lack of humor.It is much better than a former short cut, promotional

The day for the term begining

2006-09-01T21:51:00.000+08:00

TODAY is for students to jump in their classroom after a lovely summer vacation. Dozens of TODAYs in my life had been passed carelessly. When the moment i realised how i love them, they had already gone without a farewell.I have been a student for such a long time that even now i see myself a new boy in a school. The fresh air there, the atmosphere of free discussion, even the dorm's light and

How to lead a valuable life

2006-08-31T21:13:00.000+08:00

For uncountable nights in my life, i have thought much about how to lead a valuable life in my rest decades.Minutes ago, i got a message from a former schoolmate. She was a smart, hard working, communicative and very considerate girl who owned all these elements that undoubtedly in my eyes i should offer my love to. I asked myself thousands of times if i could give her a happy life. With the

翻译 [2006.08.24]More media, less news

2006-08-30T23:16:00.000+08:00

Special ReportThe newspaper industryMore media, less news媒体多了，新闻少了Aug 24th 2006From The Economist print editionNewspapers are making progress with the internet, but most are still too timid, defensive or high-minded报纸公司在互联网上取得了进步，不过还是太畏缩，还是太谨慎，还是太高傲。THE first thing to greet a visitor to the Oslo headquarters of Schibsted, a Norwegian newspaper firm, is its original, hand-operated printing press

"News" in today

2006-08-29T20:59:00.000+08:00

Here is a long SPECIAL REPORT in hand. Something about the "News industry". And it costs my whole night in dormitory today. It has 6 paragraghes left which i decided to finish their translation tomorrow. If i could finish in time with proofreading, then you will see it tomorrow. But now, i am sleepy, i gonna to wake up early next morning as i usually do in these day for doing something about

翻译 [2006.08.17]Obituary

2006-08-28T21:58:00.000+08:00

Obituary讣告Alfredo StroessnerAug 24th 2006From The Economist print editionGeneral Alfredo Stroessner Matiauda, dictator of Paraguay, died on August 16th, aged 93乌拉圭的独裁者，Alfredo Stroessner Matiauda将军于 8月16日逝世，享年93岁NOT only Africa has a heart of darkness. South America has one too, squeezed in the tight embrace of Argentina, Bolivia and Brazil. Two great rivers, the Paraguay and the Paraná, flow

A common day

2006-08-27T20:41:00.000+08:00

When i opened my eyes at 7:30 or so this morning, it seems gonna to be a common sunday without doubt that filled in my previous life.I am doing some translations these days, articles from the Economist. And there is an obituary today which is a totally new type i have ever had in hand. It's about the death of a former dictator of Paraguay who was a real terrible mammal. The obituary or it's '

翻译 QL Electronics

2006-08-26T17:56:00.000+08:00

宁波立立电子股份有限公司作为我国半导体硅材料行业的龙头企业，产品已进入包括ST、ON-SEMI等著名半导体企业在内的国际主流市场。公司是国家863计划成果产业化基地、国家级高新技术企业，国家高技术产业化示范工程实施单位，建有企业博士后流动站。QL Electronics Co. Ltd, a leading company in Chinese semi-conductor material industry, has brought out various types of products that have already hitted into the popular international markets with such sounding customers like ST and On-Semi . Further more, QL is the

翻译 [2006.08.17]Letters

2006-08-25T22:48:00.000+08:00

On support for Israel, Georgia, Britain and the Suez crisis, Canada, English以色列，格鲁吉亚，英国和苏伊士危机，加拿大，英语Aug 17th 2006From The Economist print editionThe Economist, 25 St James's Street, London SW1A 1HGFAX: 020 7839 2968 E-MAIL: letters@economist.comIsrael and its neighbours以色列和它的邻居们SIR - It seems odd that Jewish migration following the Holocaust was not cited by you as one of the more “obvious”

翻译

2006-08-24T20:57:00.000+08:00

New fiction新小说Window on the world世界之窗Aug 17th 2006From The Economist print editionClaire Messud's new novel will make her name克莱儿梅苏德的新小说会让她出名CLAIRE MESSUD has always been one for surprises. Whereas many novelists start out writing semi-veiled autobiographies dressed up as coming-of-age stories, Ms Messud, at the age of 28, brought out a novel called “When the World was Steady”, about two

<< Economist >>[2006.08.17]Click to download

2006-08-20T08:41:00.000+08:00

Amazon.comClick to download点击下载Aug 17th 2006From The Economist print editionHaving taught the world how to shop online, Amazon.com now finds the world shopping elsewhere on the internet. It is time to become a pioneer again教会了徒弟，饿死了师父。是时候再次成为开创者了。IN HIS most recent annual report, Jeff Bezos, the founder and chief executive of Amazon.com, reprints his letter to shareholders of 1997. “It's all