general

You are currently browsing articles tagged general.

I’ve passed with success the exam 1Z0-052, with the previous exam 1Z0-007 now I’m an Oracle Certified Associate. Today I’m looking to attend the second exam 1Z0-053 to become Oracle Certified Professional. Good luck to myself

Tags: , , , , ,

Today I’ll start to prepare myself to attend Oracle exam 1Z0-052 – Oracle 11g Administration I .

I’ve already attended the related course in Oracle and now it’s time to take the exam. Any information is needed. I’ve already taken SelfTest software but is not similar to topics covered in my course. Maybe the only way to study is to use Oracle books from course and Oracle official book for this exam. Anything to suggest?

Follow up – 7/8 – I’ve discovered that test center was closed for holidays. Maybe somebody forgot to close online reservation! Damn

Tags: , , , , ,

I’ve always thought that ASM is a sucking unneeded part of oracle. Is really slow, is another abstraction layer between database a disk block, is not mature for production environment and simply sucks. Yesterday I made an error. Altering a diskgroup to add a new lun to ASM in a RAC environment cause an error because LUN was not visible to ASM on both cluster node

ALTER DISKGROUP ORAFRA ADD DISK '/dev/rhdisk14';
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide

Oh my god, LUN rescan was done on both node, what’s the problem? I’ve found a permission problem, On second node LUN was not writable to oinstall group… ok. Changed. And now? Now is interesting.
First, ORAFRA diskgroup was unmounted on second node and as the diskgroup contains on control file second instance was closed in abort!
No panic. I’ve mounted diskgroup and restarted second instance. Curious, what about /dev/rhdisk14 ?
Check in ASM:

SQL> col name format a15
SQL> col path format a20
SQL> set lines 136 pages 400
SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,NAME,PATH from v$asm_disk where PATH like '%rhdisk14';

GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU NAME            PATH
------------ ----------- ------- ------------ --------------- ------------------------------
           0           5 CLOSED  MEMBER                       /dev/rhdisk14

My LUN is MEMBER of nothing! Perhaps an ASM error. As this LUN was added to diskgroup ORAFRA I’ll try to remove it from this diskgroup.

SQL> alter diskgroup ORAFRA drop disk '/dev/rhdisk14' ;
alter diskgroup ORAFRA drop disk '/dev/rhdisk14'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15054: disk "/DEV/RHDISK14" does not exist in diskgroup "ORAFRA"

Damn, what I’ve to do? Metalink note: 399500.1
This problem can occurs when disk is not visible cluster-wide. For particular type of storage (of course storage I’m using) you have to change a value in LUN configuration: reserve_policy = no_reserve
Ok, this needs a reboot, bad. And to solve my problem? Metalink suggest to check and make LUN really visible and useable to both nodes. Then drop and add again the disk. Is this possible? I think not!

Tags: , , , ,

Now building my own wishe’s list for 2009 Christmas and Birthday:

  • NetPC … now sure now if eeePC from Asus, or Samsung
  • Some people want to pay a flight with me as pilot in command
  • A trip in Zanzibar or Maldive or Mexico or another exotic place (first time in my life)
  • A sorround system for my home
  • An HiFi stereo system – Philips MCD716/12
  • CANON EOS 500d kit
  • Salt and Pepper Shakers (designer David Shrigley)
  • Abercrombie&Fitch topwear

Tags:

I’m back

After some days (I think few months) of abscoding I’m back again to write something here in my blog. As far as I remember this a technical blog but during last years technical posts were been strictly reduced maybe due to economy crisis ;-)
Now what’s new? I became a pilot, Private Pilot, with license CH-52405, english radiotelephony and english language proficency check passed. While I’ve no more money in this period, I’m sure I’ll not be able to go on with my study already planned to get ATPL license in 2010.
I’m also moving to a new home nearby Como, in a place called Lomazzo. Hope to post here as soon as possibile home photos.
I’ve been just qualified as Oracle 11g Pre Sales Champion and I hope the upcoming Oracle 11g Administration I certification will arrive quickly. I’ve to study again and pass the relative exam.
My knowledge in BMC Bladelogic is going on. Now I’ve been elected for a Bladelogic installation in a customer environment and this is really great for me.
Other? A special friend of mine let me to be in a train cockpit and now I hope I’ll be able to drive a train for a small trip… I can’t say more as this is not properly legal :D

And now? Simply, as I like to fly, I’m looking for passengers as I can divide with them the cost for a flight. Contact me for more infos…

Tags:

As filed in my subject. I’m looking again for a second work as a consultant. Ten years of experience in systems administration and security. Contact me for any other informations.

Tags: , , , , ,

C’è poco da dire. Ho vinto. Ancora una volta. Nunzio Vobis Magnium Gaudio che i vigili sono 4 teste di minchia. Ora che fare? una interrogazione in consiglio comunale chiedendo il licenziamento in tronco del capo dei vigili urbani di Monza per avere non solo cercato di ‘truffare’ un cittadino predisponendo controlli senza rispettare le leggi a riguardo ma avendo anche reiterato la sua presunzione di superiorità presentando un fumoso ricorso dopo la mia prima vincità davanti al giudice di pace appellandosi a futili cavilli legali stile azzeccagarbugli che gli hanno una seconda batosta. Sarebbe opportuno che delle sue scelte ne rendesse conto davanti al comune e davanti ai cittadini che gli foraggiano lo stipendio, sicuramente non da operaio. Invece, come è doveroso che sia in Italia, continuerà a stare lì, a scaldare la sua sedia di pelle, con la vigilessa segretaria, a fare finta di gestire il comando dei vigili urbani, con un diploma preso per corrispondenza a scuola radio elettra in semaforologia applicata e una laurea al CEPU in malgestione del traffico con specializzazione in dossi e rotatorie. Semplicemente un inetto intrufolato nel sistema grazie a qualche solita raccomandazione. Ci hai provato? Ti ho fregato.

Alea iacta est.

Tags:

This post can be longer indeed, but let’s from scratch. First, identify from v$session_waits if there’re buffer busy waits with this query:

select
   p1 "File ID",
   p2 "Block ID",
   p3 "Reason ID"
from
   v$session_wait
where
   event = 'buffer busy waits';

Now, you can find file id and block id of buffer busy. Using the following statement you can find the object belonging to waits:

select
   owner,
   segment_name,
   segment_type
from
   dba_extents
where
   file_id = &P1
and
  &P2 between block_id and block_id + blocks -1;

Now you have to find which session is using the object incriminated.

Tags:

I’m really interested in this as PS3 has many resources but I’m locked only about RAM. It’s possibile to add more RAM to PS3? 512 mb are really low, growing it can be usefull. I’ve read around some peoples used fast SD cards as swap devices but this solution is not a real alternative to hardware RAM.

Tags:

From few days I’ve an RMAN backup that apparently fails with this error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql command at 03/12/2009 05:32:40
RMAN-06004: ORACLE error from recovery catalog database: ORA-01023: Cursor context not found (Invalid cursor number)

I’m trying to debug it, also looking into Metalink withot success. Metalink refers the problem in document 452946.1 to a wrong use of RMAN command release. Channel release is no more mandatory as it’s done automatically after backup. I’ve commented release command without solving the problem. Looking deeper to solve it. Maybe I’ll change Oracle TDP…

Tags:

« Older entries