it’s simply a matter of a time…

Oracle

Problem, logging, tips and tricks with Oracle

ORA-08104

In Oracle on 1 January 2009 tagged Oracle Error Code with 3 comments

Beberapa waktu lalu, saya mendapatkan error “ORA-08104” di database warehouse di kantor, dikarenakan di “kill” nya proses “rebuild index online” nya, sehingga menyebabkan index tersebut menjadi tidak valid.
Dan berdasarkan referensi dari metalink note.375856.1, disitu dinyatakan bahwa error tersebut terdapat relasi dengan BUG 3805539, yang nyatanya issue tersebut harusnya sudah fix di Oracle Ver. 10.2.0.1, [...]

OraSnap on the fly

In Info, Oracle on 14 July 2008 tagged Oracle Tips with no comments

OraSnap (Oracle Snapshot) contains all the SQL scripts that most of us already have in our arsenal. The “twist” is the way the information is presented. All of the statistics are generated with HTML tags – which can then be viewed with a web browser. Each report has the source code used for the information [...]

Oh..Archive Log

In HP-UX, Oracle, Poetry on 19 May 2008 tagged Oracle Tips with no comments

Damn…
when project upgrade veritas netbackup from 5.0 to 6.0 never shown their progress.
and the database archive log was grown rapidly, so for the quickly action, I build this script.
works on HP-UX environments

#!/usr/bin/sh
# moving archive log
#####################################
bdf -l /oracle/archivelog | grep -iv Filesystem |awk ‘{print $6" "$5}’ | while
read LINE; do
ASS=`echo $LINE | cut -d"%" -f1 | [...]

No locks available

In HP-UX, Oracle on 19 February 2008 tagged Oracle Error Code, Oracle Tips with no comments

Hari ini gue mendapatkan banyak error di mesin yang menurut gue paling canggih, paling banyak CPU (20), paling banyak Memory (143GB), boros disk (30 TB), pokoknya
serba paling.
tapi di hari ini dia juga mengumpulkan daftar error paling banyak, berikut error list hari ini.

List Error Hari ini
“lckpwdf: Lockf deadlock detection Cannot obtain lock for /etc/.pwd.lock”
“WARNING: Failed to [...]

Moving & Recreate Temp Tablespace

In Oracle on 13 December 2007 tagged Oracle Error Code, Oracle Tips with no comments

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 [...]

‘Lebaran’ at d office

In Curhat, Oracle on 15 October 2007 with no comments

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 [...]