Saturday, December 28, 2013

During my talk at UK OUG tech 2013 earlier this month; running "Oracle Database on LDOMS" I promised I would put some figures on what performance hit to expect when doing virtual IO in the guest domain.

So far I did following tests :


  • orion testing
  • SLOB testing
  • fio 

I am still busy to review the results.
I'll put the results there shortly


here is the link to the presentation :

Friday, December 27, 2013

replicate controlfile or restore controlfile

something i noticed today

I remember that once i used following in rman


 replicate controlfile from '/export/home/oracle/control_ACP1.cont';


I thought it would also update the spfile however that seemed not the case.

how ever what automatically updates the spfile is the following

RMAN> restore controlfile from '/export/home/oracle/control_ACP1.cont';

Starting restore at 27-DEC-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=110 instance=EUACP11 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATADG1/euacp1/controlfile/current.4907.835270147
output file name=+ARCHDG1/euacp1/controlfile/current.16585.835270147

Finished restore at 27-DEC-13



lots of audit files generated in ASM home dir on 12cR1

Last week I had an issue on a freshly installed dev system with 12c and Oracle Restart.
In about 3 months time there were 7,5 million audit files generated in the GI home.

This caused the zfs filesystem to fill up completely ( zfs doesn't like this ;-) we didn't finish monitoring yet on this system so we noticed it when damage was done ....



cleaning up the zfs filesystem was one thing, first we had to make some space otherwise we got ...

rm: cannot remove : No space left on device



First since is was a dev system and holidays anyways I stop ASM and the databases ...
After cleaning up some space we could to following ...


cd $GRID_HOME/rdbms/audit
find . > /tmp/rm_audit

remove the first line of that file ...


cat rm_audit | xargs -l 100 rm



and then slowly the space was given back...

now time to change the check interval to something more reasonable since it was checking each second .... and thus generating an audit file each second or 86400 each day

to view all the parameters 

crsctl stat res -p 

for example on the ASM instance following parameters are set.


NAME=ora.asm
TYPE=ora.asm.type
ACL=owner:grid:rwx,pgrp:asmdba:r-x,other::r--
ACTIONS=
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTION_TIMEOUT=60
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALERT_TEMPLATE=
ALIAS_NAME=
ASM_DISKSTRING=/dev/oracle/*
AUTO_START=restore
CHECK_INTERVAL=1
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=asm) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%)
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Oracle ASM resource
ENABLED=1
GEN_USR_ORA_INST_NAME=+ASM
INSTANCE_FAILOVER=1

but databases are impacted as well.

so we changed it to every minute a check

-bash-4.1$ crsctl modify resource ora.dba12c.db -attr "CHECK_INTERVAL=60"
-bash-4.1$ crsctl modify resource ora.asm -attr "CHECK_INTERVAL=60"


ofcourse a cron job to delete the audit files on a regular basis installed ...


Saturday, December 7, 2013

post UKOUG impressions

I had a blast at UKOUG, I  met plenty of friends, finally could place a face on an avatar and had my first talk ever, in short lots of emotions and the quality of the sessions was very very high. I helped with RAC attack and was glad to see that plenty of people have now RAC running on their laptop.


I enjoyed  my good friend Iloon's session about the APEX listener. Joel Goodman on the picture here under chaired the session.








My talk it self went fine, had a good interaction with the audience and got some good questions, Solaris and LDOMs are certainly not dead, i think it just started for them as Bjoern Rost's session about a customer moving from Linux to Solaris showed, which was a great session BTW he really is a gifted speaker.



It was not only my first time but also Jan Karremans' first conference talk, he really did a good job he was up at 8:30 wednesday. I really enjoyed his session



Finally I got to meet Osama Mustaffa and Uwe Hesse face to face, two great guys, I feel like I have two friends, you guys rock






Thank you Iloon , Joel , Oyvind Isene, Sally-Ann, Peter Raganitsch,  Uwe, Bjoern, Osama,Gert Poel, Jan, Frits Hoogland (without you I was still at the train station ;) you made UKOUG something not to forget soon !!!







Apart from UKOUG and running in parallel there was also Oak Table World, with great speakers, I went to two presentations over there :

Apex for Dba's
Hadoop for Dba's

both very interesting





The jumping Rac Attack Guys ( + plenty of others that came later) 




I now have to keep my promise to the attendees of my session to put a blog article online about the performance of different SPARC processor and the impact of virtual I/O


Also a big thank you to Kevin Closson father of  SLOB, thank you for this great tool, it helped me a lot and is standard in my tool.

Sunday, December 1, 2013

arrived in Manchester

I arrived in Manchester today, looking forward to it.

this is my agenda for today

NAS & SAN Storage with the Oracle ZFS Storage Appliance  by Mr Darren Moffat

Oracle Transaction Locks and Analysis by Mr Kyle Hailey

and of course Iloons session

How to Avoid to Struggle with the APEX Listener


looking really forward to it.

Tomorrow D-day ;-)

Sunday, October 27, 2013

presenting at ukoug 2013

This long overdue post to announce that I will be speaking at UK OUG 2013.

I will be talking about the implementation of LDOM  aka Oracle VM for Sparc at a customer and how the made an M9000 redundant by doing so...

See you at Tech 13 in Manchester !!

here is the link to my presentation :



Saturday, April 20, 2013

Ougn 2013

Today was the last day of a the ougnvarseminar2013,  this was my 2 nd seminar , my first being oracle openworld last year. I had a marvellous time in Oslo and on the boat between Olso and Kiel, there are at least 12 reasons for that :

  1. perfect organisation
  2. fantastic speakers : Thomas Kyte, Cary Millsap, Joel Goodman , Bryn Llewellyn , Martin Bach(@MartinDBA), Martin Nash (@mpnsh), Bjoern Rost(@brost),  Frits Hoogland (@fritshoogland), Iloon Ellen (@iloonellen), Roel Hartman, Kuassi Mensah ()  and many many others
  3. great sessions
  4. friendly Norwegians
  5. nice classy setting
  6. good food
  7. new friends
  8. down to earth conversations
  9. technical sessions no marketing bullsh*t 
  10. nice weather
  11. justin bieper
  12. presentations about new upcoming version n.m R1 ;-) 

I had a lot of eye-openers and have lots of inspiration for new things really i can highly recommend you this seminar, the sessions were on par with the speakers. 
Thank you oyvind isene (@OyvindIsene for the twitterati) for the hospitality and letting me know about this great conference.
Thank you ougn board for all the work you've put in this, for me it was worth it
Thank you @johnnyq72 aka Mr. DbVisit or Jan for the friends, for the insights you gave me in the various DbVisit products and the great time we spend together.
Thank you Iloon Ellen for the great talks we had
Thank you Joel Goodman for the lessons in Oracle you taught and more importantly the lessons in life you taught me, never thought this would be possible in such a short timespan.



here some impressions which fall completely into nothing with the real thing

























Friday, January 25, 2013

kapstok

I will be publish several articles here that serve the purpose of "kapstok" (hat stand) for things i keep on forgetting just ...