Live on Januar V. Simarmata

FIND usage

2010-02-27T11:13:00.003+04:00

I always forget how to use find command when it is combined with -exec clause :(. So, here are kind comprehensive list I got after googling from here.

sudo find / -type f -name *.jpg -exec cp {} . \;

find . -type f -size +10000 -exec ls -al {} \;
find . -atime +1 -type f -exec mv {} TMP \; # mv files older then 1 day to dir TMP
find . -name "-F" -exec rm {} \; # a script error created a file called -F
find . -exec grep -i "vds admin" {} \;
find . \! -name "*.Z" -exec compress -f {} \;
find . -type f \! -name "*.Z" \! -name ".comment" -print | tee -a /tmp/list
find . -name *.ini
find . -exec chmod 775 {} \;
find . -user xuser1 -exec chown -R user2 {} \;
find . -name ebtcom*
find . -name mkbook
find . -exec grep PW0 {} \;
find . -exec grep -i "pw0" {} \;
find . -atime +6
find . -atime +6 -exec ll | more
find . -atime +6 -exec ll | more \;
find . -atime +6 -exec ll \;
find . -atime +6 -exec ls \;
find . -atime +30 -exec ls \;
find . -atime +30 -exec ls \; | wc -l
find . -name auth*
find . -exec grep -i plotme10 {};
find . -exec grep -i plotme10 {} \;
find . -ls -exec grep 'PLOT_FORMAT 22' {} \;
find . -print -exec grep 'PLOT_FORMAT 22' {} \;
find . -print -exec grep 'PLOT_FORMAT' {} \;
find . -print -exec grep 'PLOT_FORMAT' {} \;
find ./machbook -exec chown 184 {} \;
find . \! -name '*.Z' -exec compress {} \;
find . \! -name "*.Z" -exec compress -f {} \;
find /raid/03c/ecn -xdev -type f -print
find /raid/03c/ecn -xdev -path -type f -print
find / -name .ssh* -print | tee -a ssh-stuff
find . -name "*font*"
find . -name hpmcad*
find . -name *fnt*
find . -name hp_mcad* -print
find . -grep Pld {} \;
find . -exec grep Pld {} \;
find . -exec grep Pld {} \;
find . -exec grep PENWIDTH {} \; | more
find . -name config.pro
find . -name config.pro
find /raid -type d ".local_sd_customize" -print
find /raid -type d -name ".local_sd_customize" -print
find /raid -type d -name ".local_sd_customize" -ok cp /raid/04d/MCAD-apps/I_Custom/SD_custom/site_sd_customize/user_filer_project_dirs {} \;
find /raid -type d -name ".local_sd_customize" -exec cp /raid/04d/MCAD-apps/I_Custom/SD_custom/site_sd_customize/user_filer_project_dirs {} \;
find . -name xeroxrelease
find . -exec grep xeroxrelease {} \;
find . -name xeroxrelease
find . -name xeroxrelease* -print 2>/dev/null
find . -name "*release*" 2>/dev/null
find / -name "*xerox*" 2>/dev/null
find . -exec grep -i xeroxrelease {} \;
find . -print -exec grep -i xeroxrelease {} \;
find . -print -exec grep -i xeroxrelease {} \; > xeroxrel.lis
find . -exec grep -i xeroxrel {} \;
find . -print -exec grep -i xeroxrel {} \;
find . -print -exec grep -i xeroxrel {} \; | more
find /raid/03c/inwork -xdev -type f -print >> /raid/04d/user_scripts/prt_list.tmp
find . -exec grep '31.53' {} \;
find . -ls -exec grep "31/.53" {} \; > this.lis
find . -print -exec grep "31/.53" {} \; > this.lis
find . -print -exec grep 31.53 {} \; > this.lis
find . -exec grep -i pen {} /;
find . -exec grep -i pen {} \;
find . -print -exec grep -i pen {} \; | more
find . -exec grep -i pen {} \;
find . -atime +6 -exec ll | more \;
find . -atime +6 -exec ll \;
find . -atime +6 -exec ls \;
find . -atime +30 -exec ls \;
find . -atime +30 -exec ls \; | wc -l
find . \! -name '*.Z' -exec compress -f {} \;
find . -name 'cache*' -depth -exec rm {} \;
find . -name 'cache*' -depth -print | tee -a /tmp/cachefiles
find . -name 'cache[0-9][0-9]*' -depth -print | tee -a /tmp/cachefiles
find . -name 'hp_catfile' 'hp_catlock' -depth -print | tee -a /tmp/hp.cats
find . -name 'hp_catfile' -name 'hp_catlock' -depth -print | tee -a /tmp/hp.cats
find . -name 'hp_cat*' -depth -print | tee -a /tmp/hp.cats
find . -name 'hp_cat[fl]*' -depth -print | tee -a /tmp/hp.cats
find /raid -name 'hp_cat[fl]*' -depth -print
find . \! -name '*.Z' -exec compress -f {} \;
find . -name '*' -exec compress -f {} \;
find . -xdev -name "wshp1*" -print
find . -xdev -name "wagoneer*" -print
find . -name "xcmd" -depth -print
find /usr/contrib/src -name "xcmd" -depth -print
find /raid -type d -name ".local_sd_customize" -exec ls {} \;
find /raid -type d -name ".local_sd_customize" \
-exec cp /raid/04d/MCAD-apps/I_Custom/SD_custom/site_sd_customize/user_filer_project_dirs {} \;

QS Top Universities: ITB in rank #90

2008-10-19T10:13:00.003+04:00

BANDUNG Institute of Technology Indonesia (ITB) in ranking #90.

MIT is the top most.

QS Top Universities: University rankings in Technology

Complete list is following:

Subject Rank	School Name	Country	Subject Score
Source: QS Quacquarelli Symonds (www.topuniversities.com) Copyright © 2004-2008 QS Quacquarelli Symonds Ltd. Click here for copyright and limitations on use.
1	MASSACHUSETTS Institute of Technology (M...	United States	100.0
2	University of California, BERKELEY	United States	93.9
3	STANFORD University	United States	85.3
4	CALIFORNIA Institute of Technology (Calt...	United States	81.6
5	University of CAMBRIDGE	United Kingdom	76.2
6	CARNEGIE MELLON University	United States	71.6
7	IMPERIAL College London	United Kingdom	70.9
8	GEORGIA Institute of Technology	United States	68.9
9	University of TOKYO	Japan	67.4
10	University of TORONTO	Canada	66.0
11	National University of SINGAPORE(NUS)	Singapore	64.5
12	TSINGHUA University	China	63.4
13	ETH Zurich (Swiss Federal Institute of T...	Switzerland	63.1
14	University of OXFORD	United Kingdom	61.6
15	PRINCETON University	United States	61.5
16	University of CALIFORNIA, Los Angeles (U...	United States	61.4
17	DELFT University of Technology	Netherlands	60.4
18	MCGILL University	Canada	60.1
19	HARVARD University	United States	59.6
20	University of ILLINOIS	United States	58.4
21	TOKYO Institute of Technology	Japan	57.0
22=	KYOTO University	Japan	56.8
22=	University of BRITISH COLUMBIA	Canada	56.8
24=	CORNELL University	United States	56.4
24=	HONG KONG University of Science & Techno...	Hong Kong	56.4
26	NANYANG Technological University	Singapore	55.2
27	University of NEW SOUTH WALES	Australia	54.7
28	The University of MELBOURNE	Australia	54.4
29	TECHNION - Israel Institute of Technolog...	Israel	54.1
30	University of WATERLOO	Canada	53.9
31	ÉCOLE POLYTECHNIQUE	France	52.6
32	University of TEXAS at Austin	United States	52.0
33	PURDUE University	United States	50.9
34	KAIST - Korea Advanced Institute of Scie...	Korea, South	50.5
35	University of CALIFORNIA, San Diego	United States	50.3
36=	Indian Institute of Technology Bombay (I...	India	49.9
36=	AUSTRALIAN National University	Australia	49.9
38=	University of MICHIGAN	United States	49.2
38=	PEKING University	China	49.2
40	Technische Universität MÜNCHEN	Germany	48.7
41	The University of SYDNEY	Australia	48.0
42	Indian Institute of Technology Delhi (II...	India	47.7
43	SEOUL National University	Korea, South	46.0
44	Ecole Polytechnique Fédérale de LAUSANNE...	Switzerland	45.2
45	University of MANCHESTER	United Kingdom	44.8
46	University of ALBERTA	Canada	44.6
47	MONASH University	Australia	44.3
48	SHANGHAI JIAO TONG University	China	43.8
49=	University of Science and Technology of ...	China	42.3
49=	National TAIWAN University	Taiwan	42.3
49=	EINDHOVEN University of Technology	Netherlands	42.3
49=	OSAKA University	Japan	42.3
53	TEXAS A&M University	United States	41.8
54	KTH, ROYAL Institute of Technology	Sweden	41.5
55	CHALMERS University of Technology	Sweden	41.3
56=	The University of AUCKLAND	New Zealand	40.8
56=	Katholieke Universiteit LEUVEN	Belgium	40.8
58	YALE University	United States	40.7
59	Virginia Polytechnic Institute (VIRGINIA...	United States	40.4
60	University of EDINBURGH	United Kingdom	40.2
61	University of QUEENSLAND	Australia	40.0
62	University of CALIFORNIA, Santa Barbara	United States	39.8
63=	Politecnico di MILANO	Italy	39.5
63=	COLUMBIA University	United States	39.5
65	Technische Universität BERLIN	Germany	39.3
66	RENSSELAER Polytechnic Institute	United States	38.7
67	JOHNS HOPKINS University	United States	38.5
68	Universität STUTTGART	Germany	38.0
69	University of HONG KONG	Hong Kong	37.3
70=	Indian Institute of Technology Kanpur (I...	India	37.1
70=	Rheinisch-Westfälische Technische Hochsc...	Germany	37.1
72	Universität KARLSRUHE	Germany	37.0
73	University of WISCONSIN-Madison	United States	36.9
74=	Indian Institute of Technology Madras (I...	India	36.0
74=	The CHINESE University of Hong Kong	Hong Kong	36.0
76	VIENNA University of Technology	Austria	35.9
77	Technical University of DENMARK	Denmark	35.8
78	University of PENNSYLVANIA	United States	35.0
79=	MCMASTER University	Canada	34.9
79=	PENNSYLVANIA STATE University	United States	34.9
81=	University of MARYLAND	United States	34.6
81=	NORTHWESTERN University	United States	34.6
83=	University of CHICAGO	United States	34.5
83=	Indian Institute of Technology Kharagpur...	India	34.5
85	University of WASHINGTON	United States	34.3
86	CHULALONGKORN University	Thailand	34.0
87=	University of SOUTHERN CALIFORNIA	United States	33.9
87=	Université de Montréal	Canada	33.9
89	CITY University of Hong Kong	Hong Kong	33.7
90=	BANDUNG Institute of Technology	Indonesia	33.5
90=	University of CALGARY	Canada	33.5
92	FUDAN University	China	33.2
93	BROWN University	United States	33.1
94=	RMIT University	Australia	33.0
94=	HELSINKI University of Technology TKK	Finland	33.0
96=	UCL (University College London)	United Kingdom	32.8
96=	University of SOUTHAMPTON	United Kingdom	32.8
98=	TOHOKU University	Japan	32.7
98=	University of BIRMINGHAM	United Kingdom	32.7
100	École Normale Supérieure, PARIS	France	32.4

---
ITB : Institut Teknologi Bandung (www.itb.ac.id)

Disable sendmail on Solaris 9

2008-10-09T16:22:00.001+04:00

I got problem in one of our server that there are thousands of sendmail process running and calling another process mail.local which blocked any access to this server.

root@server1 # ps -ef |grep mail.local | wc -l
6503

Killing those processes has recovered access to the server:
pkill -9 sendmail
pkill -9 mail.local

But, in order to prevent same problem, disabling sendmail is required.

The more detail of sendmail is following....

sendmail is a service started at boot time through the rc mechanism. Have a look at the /etc/rc*.d directories for startup scripts.

mv /etc/rc2.d/S88sendmail /etc/rc2.d/s88sendmail

Only scripts that start with an upper case S are started at boot time.

kidung.com

2008-10-09T14:21:00.000+04:00

kidung.com - Lirik Lagu Rohani & Chord Lagu Pujian & Penyembahan

If you want to know Christian song, including lyrics, chord, then check this out! Besides Indonesian, there is English song too.

Google Diaspora

2008-10-09T08:48:00.000+04:00

Print The Google Diaspora:

"In that garage, Sergey Brin and Larry Page built their empire on the basis of a simple and powerful idea that now seems obvious: Create a better search engine by taking into account not just a page's content but also its connectedness. The most popular pages would show up ahead of the lonelier pages in search results. This idea was so central to the Google experiment that its demo-stage name was 'BackRub,' as in, 'You rub my site's back, I'll rub yours.' It's this same basic idea that drives interest in the Google diaspora. Not only are Xooglers bright, entrepreneurial, and wealthy, but their links to one another and to Google endow them with a real-world ranking bonus--VC doors open wider; the press is more intrigued."

The guys are working today on a one-page mission statement that they intend to send out to all their investors. They show the draft to me, ask for my comments. One of the key lines reads:

"Within the software/Internet sector, we are focused on early-stage investment opportunities supported by one or more of our three major investment themes: algorithm-intensive solutions, multisided aggregation platforms, and next-generation productivity solutions."

I point out that the word solutions is used twice and offer that, in general, the term "next-generation" is used so often, it's basically useless. They change the line, replacing the first solutions with services, and writing "Web-centric" in place of "next-generation."

Missed dialed number for internet access via GPRS/ 3G

2008-10-04T14:15:00.005+04:00

In the past 3 days, I really need wireless internet access. Not via WIFI as it is not widely available, but via GPRS / 3G.

I have been tried it on may laptop in peered with with my E90 and K800i. Both were working perfectly.

I missed the dialed code, so this post should force me to remember the detail and would never forget it again.

The dialed code format is *99***cid#, where cid is the GPRS/3G connection id.

In my case cid is 3, so full dialed code is *99***3#. Note that it is three consecutive stars. I have tried with two stars and didn't work.

This is my current favorite Python editor

2008-09-27T18:13:00.001+04:00

I meant "current" as it may change later on.

http://pype.sourceforge.net/index.shtml

PyPE (Python Programmers' Editor) is an editor written in Python with the wxPython GUI toolkit. Releases occur when sufficient (or extraordinary) bugs are fixed, features are added, etc.

Back to Dubai (from holiday)

2008-09-24T15:33:00.004+04:00

I was idle for almost 2 months already, and now trying to post something.

I come back to Dubai around 3 weeks ago, after spending 3 weeks holiday in Indonesia (Jakarta/Depok, Sumatera Utara - Medan, Pulo Raja, Siantar, Parapat / Samosir Island / Toba Lake, Sidikalang, Brastagi), also 3 days in Kuala Lumpur - Malaysia.

It was a long trip we spent with whole family. Quite tired but happy for what GOD has given.

(We stands on Samosir Island and Toba Lake)

Back to Dubai, we have to spend few days to clean the house. Hmm... letting the AC down, let lots of microbes grows at clothes, carpet.

Also quite busy with preparing my two lovely kids for their new school.

Also preparing visa stamping for their residence, including getting medical test. I finally decided to bring my wife to get medical test in Al Baraha Hospital. It is a government hospital which result must be accepted by DNR Dubai. There is another option:

Al Maktoum Hospital (it is quite bad, although cheapest AED 270).
Iranian Hospital (I heard some news that it will be accepted, but as I don't want to take any risk then I go to Al-Baraha.
Municipality Clinic (there was new in Gulfnews.com that it was rejected for some reason).

That's about it for now... I will try to post again later.

Thanks,
~JVS

sman1mdn-91 · Alumni SMAN 1 Medan - 1991

2008-07-28T00:10:00.000+04:00

Today, I am looking at my yahoo account and found already lost of emails coming from my older friends. Arggh... 17 years ago. It is always nice to met old friends, talking about fun memories.

Thanks to Hasbi for organizing the milist.
Thanks to Aulia "Unung" Arif for adding me to the list.
Thanks to Togap for managing the gathering in CITOS, Jakarta.

Teringat Abner "Tungir"... Hehehee... Kawan-kawan pramuka banyak juga. Banyak juga yang ketemu di Bandung... Banyak yang kuliah di ITB, Unpad (Padjajaran), STT Telkom. Hehehe....

Tungir bersaudara: Susila Shane + Emila Zola & Bastian... para pendekar Telkom :)

Unung sama Lia... kita udah beberapa kali jumpa di Dubai. Yang lain... ayo... pindah ke Dubai???!

Is DNA test that expensive!

2008-07-25T15:31:00.001+04:00

detikNews : situs warta era digital | Bripda Janes Napitupulu Ingkar Janji, Tidak Mau Tes DNA

It was said that the cheapest DNA test costs Rp 60,000,000 (USD 6500). It has to be done in Medan or Jakarta. Too expensive!

Don't know what is the cost in Singapore or Malaysia.

Is DNA test really that expensive??!!

Your steadfast love

2008-07-18T20:58:00.003+04:00

14 years ago, on 1994 I was servicing PMK (Christian Fellorship) gathering as Song Leader, and this beautiful song is one of them.

Your Steadfast Love

Your steadfast love extends to the heavens
Your faithfulness reaches to the clouds
Your righteousness is like majestic mountains
And your wisdom like the depths of the sea
And you come to me

Filling my heat with your loving kindness
I find my peace in the shadow of your wings
I eat my fill from the abundance of your household
And I drink from the streams of rejoicing

You are my king
You are my king
You are my king
You are my king

Diary of a Failed Startup: Postmortem

2008-07-01T21:41:00.000+04:00

Diary of a Failed Startup: Postmortem: "Solve a problem, not a class of problems. Only after you've thoroughly solved that problem can you work on expanding it. Really, it's okay to not have your product do everything, as long as it does something well."

Solve a problem, one problem first. Then expand it.

Be yourself. Do the what matters most now.

Veritas 4.1 is not Jumpstart compliant

2008-05-07T16:01:00.001+04:00

Look at:

http://seer.entsupport.symantec.com/docs/286878.htm

Veritas 5.0 will be complaint.

KeePassX - multi platform port of KeePass Password Safe

2008-04-17T14:52:00.002+04:00

I am a user of KeePass since 2004 for managing hosts and its related information. It has help me for such long time to manage Production / Testbed server in Excelcom, Hutchison, and now du. I don't have to remember all password. I don't have to type-in password each time want to login to server.

Lately, I found that its porting to Linux has reach satisfying look and feel as the original Windows one. It is KeePassX. I use it in my Ubuntu machine (virtual one, as I use VMWare on top my Windows XP).

It is nice to have same tool on multi platform environment like I have.

Building Erlang on Ubuntu

2008-04-08T08:29:00.004+04:00

Here is my experience in building Erlang from source on Ubuntu 6.

The step is following:

From your home directory, get the Erlang source: wget http://www.erlang.org/download/otp_src_R11B-5.tar.gz
Unpack it: tar -xzf otp_src_R11B-5.tar.gz
Get a working gcc: sudo apt-get install build-essential
Get the ncurses development libraries: sudo apt-get install libncurses5-dev
Get m4: sudo apt-get install m4
Optionally, get the ssl libraries: sudo apt-get install libssl-dev
Go into the erlang source directory: cd otp_src_R11B-5
Run the configuration script: ./configure
Compile it all: make
Install it: sudo make install

First I tried for R11-5 source and it is working fine. I can execute 'erl' binary and get the shell.

januarvs@kubuntuku:~/otp_src_R11B-5/bin$ ./erl

Eshell V5.5.5 (abort with ^G)
1>

Then to get the latest version, I tried for R12-1 and I got problem. The error after ‘make’ is below:

januarvs@kubuntuku:~/otp_src_R12B-1$ make
cd erts/emulator && ERL_TOP=/home/januarvs/otp_src_R12B-1 make generate depend
make[1]: Entering directory `/home/januarvs/otp_src_R12B-1/erts/emulator’
make -f i686-pc-linux-gnu/Makefile generate
make[2]: Entering directory `/home/januarvs/otp_src_R12B-1/erts/emulator’
gcc -g -O3 -I/home/januarvs/otp_src_R12B-1/erts/i686-pc-linux-gnu -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_GNU_SOURCE -DHAVE_CONFIG_H -Wall -Wstrict-prototypes -Wmissing-prototypes -Wdeclaration-after-statement -DUSE_THREADS -D_THREAD_SAFE -D_REENTRANT -D_POSIX_THREAD_SAFE_FUNCTIONS -Ibeam -Isys/unix -Isys/common -Ii686-pc-linux-gnu/opt/plain -Ii686-pc-linux-gnu -Izlib -Ihipe -I../include/internal -I../include/internal/i686-pc-linux-gnu -c hipe/hipe_mkliterals.c -o obj/i686-pc-linux-gnu/opt/plain/hipe_mkliterals.o
hipe/hipe_mkliterals.c:388: error: \u2018X86_LEAF_WORDS\u2019 undeclared here (not in a function)
hipe/hipe_mkliterals.c:389: error: \u2018X86_NR_ARG_REGS\u2019 undeclared here (not in a function)
make[2]: *** [obj/i686-pc-linux-gnu/opt/plain/hipe_mkliterals.o] Error 1
make[2]: Leaving directory `/home/januarvs/otp_src_R12B-1/erts/emulator’
make[1]: *** [generate] Error 2
make[1]: Leaving directory `/home/januarvs/otp_src_R12B-1/erts/emulator’
make: *** [depend] Error 2
januarvs@kubuntuku:~/otp_src_R12B-1$

I tried to build without hipe, by submitting ‘configure –disable-hipe’ but still not lucky.

Erlang for Ubuntu

2008-04-07T17:14:00.000+04:00

Installing Erlang on Ubuntu Linux can be done in 2 ways:

1. Apt-get

For example, if you have gutsy (aka Ubuntu 7.10), then you can see all packages from http://packages.ubuntu.com/gutsy/interpreters/erlang.

To get them, follow below instruction.

First, ensure that the universe repository for gutsy is in your
/etc/apt/sources.list.

If is not already there, add this:

deb http://archive.ubuntu.com/ubuntu gutsy universe

then run (as a root, from the terminal), apt-get update

Secondly, you can get erlang, simply typing (again, as a root, from the terminal)

apt-get install erlang

But, Ubuntu built the packages based on old source R11B-1 at this time.

januarvs@kubuntuku:~$ erl
Erlang (BEAM) emulator version 5.5.1 [source] [async-threads:0] [kernel-poll:false]

Eshell V5.5.1 (abort with ^G)
1>

The current version is R12B-1 (5.6.1).

2. Build from source code

The source code can be get from Erlang web site (http://www.erlang.org/download.html).

This is the way to get latest version of Erlang on your Ubuntu Linux.

Erlide - the Erlang IDE powered by Eclipse

2008-04-01T12:43:00.001+04:00

Yesterday, I started using Erlide, the Erlang IDE which powered by Eclipse. Eclipse is sophisticated open source editor initially for Java programming, but now has been extended to cover another language like C/C++, and now Erlang.

Erlide is an extension on top of Eclipse for Erlang programming language. It gives project management, syntax highlight, more integrated environment with Erlang, and later will be integrated debugger. There are many more features that I can't mentioned due I don't remember right now :).

It give console, but for me it doesn't work as expected. I can't run specific function on that console. I have also problem is executing Mnesia database.

Overall, it is good to have Erlide especially in future, and it will still take time to be useful for daily work.

Fire in National Cement Factory - Al Quoz Industrial 1

2008-03-26T10:47:00.001+04:00

There is a bad fire since morning in National Cement Factory in Al Quoz Industrial 1 area which is very close to Sheikh Zayed Road.

First picture was taken from Sheikh Zayed Road

This picture was taken from 313 Road (next to Al Quoz area).

When I drive from Al-Qusais, the sky is so dark just like ready for rain. Just after passing the Al-Quoz Industrial area, it is sunny again.

Note:
Pictures were taken while driving using Nokia Communicator E90 with 0.3 MB size which suitable for MMS.

Factorial function

2008-03-24T06:46:00.000+04:00

Here is one of the very basic thing implemented in Erlang: Factorial function.

-module(fac). -export([fac/1]). fac(0) -> 1; fac(N) -> N*fac(N-1).

In Pascal there are several construction to do looping e.g. repeat ... until, while ... do, for ... to ... do .... In Erlang those construction is not available. It is typical of not only Erlang but functional programming in general. If you see how the factorial function implemented above, you will realize that it has no difference with mathematical notation. That is the beauty of functional programming.

Below is how to compile and execute the function in Windows.

c:\MyWorks>erl Eshell V5.6.1 (abort with ^G) 1> c(fac). {ok,fac} 2> fac:fac(16). 20922789888000 3>

Chowking in Dubai Outlet Mall

2008-03-15T19:54:00.002+04:00

While I was in Excelcom, I used to go to Chowking in Ambassador Mall. Now, here in Dubai I continue the habit. I used to go there with my family.

We can find other Chowking outlet in Dubai Airport, Karama, Al-Ghurair. Unfortunately, we can't find one in Deira City Center, Mall of The Emirates, or Ibn Batuta Mall.

Erlang Programming for concurrent world

2008-03-15T09:08:00.003+04:00

It has been 1 year since I started to learn Erlang programming seriously during my off-time. While there are no "night" call for du project, I used to wake up at 5AM and spend around 2-3 hours to practice this language.

Erlang uses functional paradigm rather than procedural which is the most common language nowadays.

Erlang is not my first functional language. I had learned LISP several years ago. For me, functional paradigm is very interesting and promising.

Virtualization software

2008-03-13T15:53:00.000+04:00

First time, I was using VMWare Server to run Windows XP and Linux. Later, I use VMWare Workstation which has much better responsiveness while typing or moving mouse.

While running Linux on VMWare, I have to compile internal tool provided by VMWare in order to get smooth switching back and forward to VMWare.

There are lots of nice feature of VMWare Workstation, eg: ability to access host’s filesystem.

So far, I am successfully running Windows XP, Linux Ubuntu on my VMWare. I was trying to setup OS X, but can't find or create the image. Also, I have no chance yet to get Solaris running. Maybe I will try Solaris 10 for X86. I have got the DVD source and ready to install it on my VMWare.

Cisco firmware upgrade

2008-03-12T04:18:00.001+04:00

I have just arrived at home after finishing 2nd night Cisco upgrade intervention. This night was done for Cisco Catalyst switch and Cisco ITP. There is no special thing happen during our activity as all things run smoothly as planned.

All firmware was upgraded as proposed by Cisco itself as the current one was very old and didn't supported anymore. So, it is mandatory to upgrade the firmware. For the case of Cisco Catalyst, the reason we upgrade urgently was also because the current one contain serious bug so it is not listed anymore in Cisco web site.

It is good to have latest version of software running in system platform which is in my responsibility.

Detail steps for cloning database using RMAN/Networker

2008-03-10T07:29:00.001+04:00

Here are the details of cloning database using RMAN and Networker.

I will create a new Oracle instance called 'DUP'. The original instance called 'E2BE'.

1. Create password file for the duplicate instance

orapwd file=/u01/app/oracle/product/9.2/dbs/orapwDUP password=password entries=10

2. Add entries to tnsnames.ora and listener.ora

tnsnames.ora and listener.ora reside on $ORACLE_HOME/network/admin directory. The new entry is definition for the new instance.

tnsnames.ora
# Added to the tnsnames.ora
DUP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = du-t-ube)(PORT = 1521))
)
(CONNECT_DATA =
(ORACLE_SID = DUP)
)
)

listener.ora
# Added to the listener.ora
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/9.2)
(SID_NAME = DUP)
)

Don't forget to reload the listener

lsnrctl reload

3. Create an init.ora file for the duplicate database

Since we are duplicating the database onto the same server as the original we must convert the file names so there is no conflict.

I created $ORACLE_BASE/admin/DUP directory for the new instance. Under this directory I created 4 directories: bdump, cdump, udump, and pfile.

The new init.ora is put under $ORACLE_BASE/admin/DUP/pfile. (Just copy the init.ora from original Oracle instance and make adjustment)

The adjustment is below:

DB_NAME=DUP
CONTROL_FILES=(/oracle/data1/DUP/control01.ctl,
/oracle/data1/DUP/control02.ctl,
/oracle/data1/DUP/control03.ctl)

# Convert file names to allow for different directory structure.
DB_FILE_NAME_CONVERT=(/oracle/data1/E2BE, /oracle/data1/DUP)
LOG_FILE_NAME_CONVERT=(/oracle/log1/E2BE, /oracle/data1/DUP)

# make sure block_size and compatible parameters
# match if you are not using the default.
DB_BLOCK_SIZE=8192
COMPATIBLE=9.2.0.0.0

4. Create SPFILE base on the new init.ora

First you have to change the ORACLE_SID env variable so it will take into account the new instance. To do this you need to be oracle user.

# su - oracle
$ ORACLE_SID=DUP; export ORACLE_SID
$ sqlplus /nolog
$ conn / as sysdba

Now, create the SPFILE

SQL> CREATE SPFILE FROM PFILE='/u01/app/oracle/admin/DUP/pfile/initDUP.ora';

File created.

5. Start the database in NOMOUNT mode

SQL> startup force nomount;
ORACLE instance started.

Total System Global Area 320308936 bytes
Fixed Size 730824 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes
SQL>

Note that the System Global Area (SGA) value depends on parameters you specified in init.ora / spfile.

6. It is RMAN job now....

With the duplicate database started we can now connect to it from RMAN. For the duplication to work we must connect to the original database (TARGET), the recovery catalog (CATALOG) and our duplicate database (AUXILIARY):

Keep login as oracle user

# su - oracle
$ ORACLE_SID=DUP; export ORACLE_SID
$ rman TARGET sys/system@E2BE CATALOG catjvs/catjvs@CATJVS AUXILIARY /

We can then duplicate the database using one of the following commands:

RUN
{
ALLOCATE AUXILIARY CHANNEL dupdb DEVICE TYPE SBT
PARMS='ENV=(NSR_SERVER=bstestbed,NSR_DATA_VOLUME_POOL=TESTBEDDATA)';
DUPLICATE TARGET DATABASE TO DUP;
RELEASE CHANNEL dupdb;
}

Note:
- You have to specify AUXILIARY because you are doing duplication.
- NSR_SERVER specify Networker Backup Server. Check /etc/hosts for IP address detail.
- NSR_DATA_VOLUME_POOL specify pool from where you will do restore/duplication from.

The time it takes to complete varies depending on the size of the database and the specification of the server. Once the process is finished RMAN produces a completion message and you have your duplicate instance.

Cloning database using RMAN and Networker Legato

2008-03-07T22:14:00.000+04:00

Cloning database was never planned before but we come to that idea while preparing for restore testing session. We don't want to break the running database and then try to restore some tablespace or datafile.

Note: we can't restore a table in Oracle 9i. In Oracle 10g we can do by doing undo from it's recycle-bin.

I was struggling to make cloning work. Most problem we have are related to un-stable Networker backup platform. It is not the Networker base software which is not stable, but the implementation itself. Eg, the license was not maintained very well hence cause some node can't do more backup due to expiration; another thing is there is only 1 drive which is causing impossible to do restore from some tape while there are backup running on another tape.

I have been success to clone UBE (Billing Engine) and now try to do same thing for USMS (Management Platform).

I will post how I do that with detail explanation about Oracle configuration and RMAN script.

@Home - Dubai