Use with your own risk, but this is works

Detail:
-Metadevice : d56
-Disk: emcpower6a(A2=c3t500601623021B12Ed2s2) + emcpower8a(A2=c3t500601623021B12Ed8s2)

Cek MountPoint
# df -h |grep d56
/dev/md/dsk/d56 391G 64M 390G 1% /archive1

Cek Metadevice
# metastat d56
d56: Soft Partition
Device: c3t500601623021B12Ed2s2
State: Okay
Size: 832421888 blocks (396 GB)
Device Start Block Dbase Reloc
c3t500601623021B12Ed2s2 16384 No Yes

Clear the Metadevice
# metaclear d56
d56: Soft Partition is cleared

Now, Concate 2 Disk
# metainit d56 2 1 emcpower6a 1 emcpower8a
d56: Concat/Stripe is setup

Let Start the "Grows"
# mount /dev/md/dsk/d56 /archive1
# growfs -M /archive1 /dev/md/rdsk/d56
# df -h|grep d56
/dev/md/dsk/d56 788G 64M 787G 1% /archive1

# metastat d56
d56: Concat/Stripe
Size: 1677639680 blocks (799 GB)
Stripe 0:
Device Start Block Dbase Reloc
emcpower6a 0 No No
Stripe 1:
Device Start Block Dbase Reloc
emcpower8a 16384 No No

Device Relocation Information:
Device Reloc Device ID
emcpower6a No -
emcpower8a No -

Mataku mulai ngantuk, badan dah mulai panas, kayanya perlu pulang dulu kerumah untuk sekedar rebahan di kamar dan kasur tercinta, meski ta lupa kubawa kerjaan pending ku kerumah, yeah…workhard, workaholic..

vpn aja ah dari rumah besok..he3
ZzzZzzZzz

Yesterday i get error on my database

Errors in file /rdbms/oracle/admin/udump/prod_ora_685.trc: ORA-01114: IO error writing block to file 10004 (block # 503489) ORA-27072: skgfdisp: I/O error HP-UX Error: 28: No space left on device Additional information: 503489

Karena semua query di tampung di temporary tablespace,
so i go to that mount point, and you now what, the mount point was full
# bdf

Filesystem kbytes used avail %used Mounted on
/dev/vg12/lvol5 112656384 112656384 0 100% /rdbms/oracle/temp

so i extend the new datafile on temp tablespace to that mount point, the extend proses was to quickly than before,

so i use

# lvdisplay /dev/vg12/lvol5 and
# fstyp -v /dev/vg12/lvol5
to check the size and compare with bdf/sam command.

Think fast, I used another mount point to moving and recreate the temp tablespace..detail click here.

And blast..
the error was gone, the mount point was suspect corrupt, Use umount, lvremove, lvcreate and than newfs, mount and yes new mount point was added again.

Busy..Busy..
Sebenernya males juga ke bali, kalo diujung2nya malah tambah dikasih kerjaan lebih berat lagi..hahahah, but Liburan gratis kapan lagi, you now what, disana aja masih di telponin suruh remote ke kantor, hue..hue, dengan alasan ga bawa laptop and ga dapet sinyal 3G akhirnya Bos nyerah juga and kita bisa bebas liburan, kuta/hard rock/legian/paddys/tanah lot/jimbaran…yeah..i like it..

Capture from bali you cant see at http://photo.choosen.net

Im in Goddess Island on 22-24 Nov 2007
take care your self

I.M.U.L
Song & Lyrics by laut

I got your message
An : A )
It’s a sign of little smile to me
From you, tonight..

I made a reply
A semicolon A capital P
It’s a wink of teasing eye from me
To you, goodnight…

It’s already late tonight, i cannot go to sleep
I tried counting sheep & lambs, didn’t work
I miss you dear too much

I want to send you another message
“I.M.U.L”
For the words I Miss You Love
Sleep tight, sweet dreams, my love…

It’s getting to hard to sleep, the feeling’s
Just not right
My mind is so full of you, got to see you
& show you how i feel

I miss you love
Can’t believe it, it’s only been one day
But i miss you love

This is for you Babe..

This is my milad day.
Twenty-something..
Hope can reach all my dreams and goals.

Jobs at this Night:

• Pacthing Kernel SunOs 5.10 from 118833-17 to 118833-36
• Update Veritas Cluster Server from 5.0 to 5.0 mp1
• Tunning Log_Buffer

Most Wanted to Download..but wait for a while, cos not been started to play, hiks..
3×05 The Beach start at 2007-10-19
3×06 The Avatar and the Fire Lord start at 2007-10-26
3×07 The Runaway start at 2007-11-02
3×08 The Puppetmaster start at 2007-11-09

Here’s the subtitle Previously
3×01 The Awakening
3×02 The Headband
3×03 The Painted Lady
3×04 Sokka’s Master

Download the Previously (torrent) here’s
Link Lokal di sini

Update: kayanya gue salah nulis deh harusnya “season” bukan “session”,
tapi bikin blog ini nomer satu dalam search The Avatar Session 3, wakakak,,

Yups..semua orang pasti pernah ngerasai ‘enak’ nya lebaran dikantor, entah loyalitas, terpaksa, lemburan yang berlimpah, ato banyak alasan lah.
kali ini setelah menunaikan sholat ied, dan bersimpuh (terlalu berlebihan kayanya deh) di hadapan ortu, gue langsung cabut ke kantor.

Here’s the problem summary
First we have issue about Undo_Retention (undo_retention before = 129600),
yes the Undo retention was set improper, this keep the query for a long-long time, this fix with alter system set undo_retention=14000, and then alter system set query_rewrite_enabled=false scope=both sid='*',

Second we get error-code message from the client who’s connect to the databases (ORA-03113 end-of-file on communication channel), this cause the connection to server was break see problem next(third),

Third the database was slow response and you know what, like on schedule, the slow response was start at 6 am to 10 am, probably issue I/O contention and delay commit on database and the application.

After discuss with team application and running the statpack, known was we have very-very high traffic (probably lebaran days), solve for while was stop the backup script, rename and truncate the table (the table was B*tree index, hu..uh),
for a while response to from application to database was come back normally and the database was back in good performance, this solve..not quite.

Today i have the same problem, confuse, of course..
i think maybe the memory was limit, cause (again) high traffic but handle only one node (first design RAC), so i change (again) the pga parameter cause the ratio pga was 54% , for the optimum ratio i change to 1.5G (backup first –create pfile ='/app/oracle/product/9.2.0/dbs/init_141007.ora' from spfile–), alter system set pga_aggregate_target=1500M scope=both sid='*' and then restart.
was not impact, hu..uh..

I see the log buffer parameter, and then I see the log_checkpoint_interval was set improper (1410065407) , this impact to delay checkpoint, so for the faster checkpoint with no delay,
I change to default “0″ with alter system set log_checkpoint_interval=0 scope=both id='*'
and you know what, the response queue from application to database was back to normal.

Know i must to distribute/split the busy datafile to other mountpoint and change from raid 5 to raid 1+0…Puih

who’s design this project..hu..uh.

Sesuci kalimat syahadat
Sedalam makna sholawat
Setulus hati berucap
Taqobalallahu minna waminkum
Minal aidin wal faidzin
MOon Maap Lahir Batin

Sat Oct 13 08:13:14 2007
Completed checkpoint up to RBA [0x698a.2.10], SCN: 0x079d.d2dc15e8