My little IT blog now Oracle oriented

Have you downloaded Oracle client for AIX, gunzipped and now unable with the usual command to extract using cpio? I know…maybe this is the right solution

oracle@aixsrv:/app/oracle>cpio -idmv < 10gr2_aix5l64_client.cpio

cpio: 0511-903 Out of phase!
cpio attempting to continue...

cpio: 0511-904 skipping 642010 bytes to get back in phase!
One or more files lost and the previous file is possibly corrupt!

Segmentation fault

That’s bad. The solution is to use the option -idcmv

oracle@aixsrv:/app/oracle>cpio -idcmv < 10gr2_aix5l64_client.cpio

This simply because Oracle Corp. had cpioed installer with -c argument that’s, from manpage, “Reads and writes header information in ASCII character form. If a cpio archive was created using the c flag, it must be extracted with c flag.”

Poche parole:

• Servomuto (e non mi interessa che sia FoppaPedretti!)
• Un paio di camicie (chi è interessato mi chieda come..BTW ricorda che vesto solo classico, il colore dell’anno è viola, tessuto modello poplin anche senza righe e magari un monogramma)
• Miscelatore per la cucina
• Contributo riparazione parafango auto
• Contributo tagliando auto
• Macchina fotografica (da vedere quale…)
• Gatto (preferibilmente un certosino)

Solo su alcuni regali, seri, posso ammettere che si cumulino per Natale e compleanno

Just two word to say that from yesterday I’m qualified as Oracle Certified Professional. Nothing more.

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

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

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!

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

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

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…

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.

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.