Few months ago, my company decides and proceeds to upgrade our factory MES system, we create a new database for the new MES system, using Oracle 11gR2 instead of previous Oracle 9i, and we also create a new user and its schema meswip45 instead of previous mesprd on the new 11g database.

Every program which link to the MES system was upgrade side by side, one after another according to the project plan, it is barely smoothly according to the plan. Now, we will make MES system go live to the production in 2012/1/2 and it's the best time point as it is most idle time in a year and just following by Christmas and Chinese Spring Festival.

But during last two weeks UAT, one of our user found the Travel Card (just the Crystal Reporting business alternative name, you can read it as a specially report) cannot output via printer, after check the one of the slowest Crystal Reporting, we can easily conclude that there is no program logic bug to block the Crystal Travel Card printing. It is just the reporting execution time is unreasonable long (more than 2 minutes to output the actual content).

A lot of company windows domain system administrator will disable user to access Windows Update in Microsoft Site and push the patch to your desktop via a internal site, but for the developer who using tools like Visual Studio or SQL Server, the domain system administrator won't help you.

In Oct 28 2011, while I was working to recover a production reporting oracle database sync SQL facility provide by MES vendor Camstar, I meet the ORA-02049 error, Such error is never observed, but after kill session relative with sync SQL in production transaction database, the whole sync SQL facility return to normal.

So except the reason suggested by the Burleson Consulting, the root cause in my case can be the reporting server suddenly down and in it’s 2 phase commit, there is exist a lock in transaction database but rebooted reporting server’s oracle now can not known it. so after kill that pending session, the ORA-02049 error disappeared.

Suddenly UNIX server reboot/memory dump is still possible, so I record here and hoping its useful for you.

I perfer use the official Firefox (Not the China Zhimei .CN version) and here is the Add-on I install:

A couple of days ago, I just re-install Windows 7 on IBM X60 based on the flash drive, now the new bought Sandisk Ultra USB flash drive is no use now, so during the National Holiday, I just install a Live-CD type Linux on it so I can play something different with MS stuff latter.

I choose Knoppix largely because of it's size: Knoppix has the largest size among other Linux distribution like puppy/Slax as well as it's popularity, you can Get Knoppix via a BT client like µTorrent. After you get the 3.68GB DVD ISO downloaded, the step to custom Knoppix to fit your needs will be quite simple (yes simple, but it must be consider in the Linux standard):

Many people know when drag the small black square in the lower right-hand corner of the cell in Excel, Excel will auto fill the value, fewer people know drag the small black square in right mouse-key will pop-up the context menu and let you select Copy Cells, Fill Series, or other options like below picture:

It should be weird that a Shanghaiese say he is on trip in Shanghai, but it is true. In the recent years, the city area extend so much I believe Shanghai as a geography concept should be refer as a providence rather than a city now. Shanghai is already one of four direct lead city in China since the 1949, quite a long time ago but in the first 50 years it remain relative small. The aggressive extension is happen in the decade together with the subways construction. This phenomenon largely result low profit industry moving to suburb and center area property price boost at the same time and finally lead the people leaves traditional shanghai center because the job or financial reason.

Now it is no much people live in the center area, most of them are now in the suburb, but they need to trival huge distance every day and spend 3~4 hours on the road, Goverment call that modernization but I would rather call that timing suicide.

IBM X60 is very legacy PC, very light and have active hard-drive protection so X60 is quite reliable. but due to its hard drive AHCI mode and no CD-ROM, it is really a nightmare when you plan to re-install the windows.

But fortunately, you can use the USB disk to install the Windows 7 very easily and fast (no driver problem in windows 7 for X60), so the key problem for install the Windows 7 on X60 become how to build a bootable Windows 7 installation media on USB disk and how to successfully boot it in the X60 when startup.