2011/08/24

Find oracle program version

Sometimes you'll need to find out which version of your Oracle program is.
Maybe for patching purpose or bug issue.
Try this

strings | grep Header
adident Header


I personally like adident, much easier. =P


Reference

2011/05/08

2011/04/01

Oracle TRM Resource

Most of the eTRM didn't get the detail information of the tables
In my opinion, I can get those information from the db myself why do I need a paid eTRM?

I found this useful link including the traditional TRM with PDF format.
http://download.oracle.com/docs/cd/A88418_01/html/trmdoc.html

Share with you

2011/03/20

3 steps to install/upgrade OpenOffice.org on your ubuntu


Applied on 9.10 and up


  • sudo add-apt-repository ppa:openoffice-pkgs/ppa
  • sudo apt-get update
  • sudo apt-get install openoffice.org

2011/01/04

Grub Rescue

The following text is reference from this blog article.
The original text is Chinese. I translate it into English
http://tw.myblog.yahoo.com/jw!39j4lB.fEQ9h3IciAIk-/article?mid=421
I originally got a SATA II Hard Drive and installed a Ubuntu 10.10 on it.
And for some unknown reason. It won't show the grub menu.
Then I choose install another Ubuntu on another disk and the 2nd Ubuntu is smart and can let me get my 1st Ubuntu
But after that I found there are too many software need to be re-install & configure
I decide to go the hard way.
The error message is

No such a device


I have no idea what should I do then.
After googled from that blog article.
I follow his instruction and unattach my 2nd hard disk and do the following:


grub rescue>set
prefix=(hd0,msdos1)/boot/grub
root=hd0,msdos1






This seems correct, then I do


grub rescue>ls
(hd0), (hd0,1)



I got only one partition, so I can startup via the 1st partition

grub rescue>set root=(hd0,1)
grub rescue>set prefix=(hd0,1)/boot/grub
grub rescue>insmod normal
rescue:grub>normal



Then I can see my grub menu(Long time no see)
Then I got a normal startup (No more extra hard disk)

After in the GUI of Ubuntu, now need to modify the 
/boot/grub/grub.cfg

run update-grub to update the grub menu
sudo update-grub


now reinstall the grub

sudo grub-install /dev/sda

restart again. my 1st Ubuntu is back :)