Sunday, July 19, 2015

E4 2015 it is a wrap

Long overdue but I had a very busy month of june and july sofar.

 This year I was invited at E4 as a speaker. This was my second time in the USA and
 I really enjoyed every bit of it, a great conference , great people nice interactions unsurpassed hospitality. Andy Colvin and his wife Kate came to pick me up at the airport, the belt where I had to get my luggage was very appropriate.





Once the luggage was there it was the turn of Martin Bach to get picked up at the airport he landed at about the same time at another terminal.
Andy together with the amazing Veronica arranged a great Mexican Restaurant for us that night it was delicious and we finished the evening in a great beer pub in Southlake .


The great thing about E4 is that it is completely focussed on engineered systems and how they work, the other great thing is that there is one track which makes you attend plenty of interesting session you might miss otherwise.

 I really enjoyed it and learned a lots of engineered systems I didn't even know before such as the VCA, Virtual Compute Appliance, James Anthony really nailed this presentation it was very interesting and well presented.


 Other highlights for me were :


  •  Tanel Poder & Kerry Osborne's keynote about the hybrid world, Conventional RDBMS and the NOSQL movement will continue to coexist together and are complimentary 



  • Tyler Muth about Super Cluster and in-memory very interesting since I didn't have not a lot of exposure of ORACLE 12c so far 



  •  Roger MacNicol What’s new in Exadata Smart Scan 12.1.0.1 and 12.1.0.2 which was the version we just upgraded to, so this was a great refresher



  •  Sue Lee "Tips and Tricks for Successful Consolidation on Exadata" I had a lot of eye openers there and got really good info about resource manager and IORM. Some interesting new things in Storage Cell version 12.1.2.1 such as Flash Cache Min and Flash Cache Limit are available now. 



  •  Martin Bach's talk about HCC Compression, I saw this one already a couple of times and it is really a presentation like wine, it gets better and and better, I you are able to attend this talk at some other conference please do so it is really very world while and Martin knows his stuff and has very good presentation skills.



  •  Frits Hoogland, in Frits' own style he did a superb presentation about memory SGA the differences in allocation between AMM and ASMM and manual, PGA how it allocated, etc very interesting but have to go through the presentation again to grasp everything 



  • Kodi's Umamageswaran session he pointed out what is in store on the technology level: Networking 40Gbps Ethernet, 100Gbps infiniband Persistent memory etc. 



  •  Mauro Pagano's session about health checks was really incredible what a horror story very entertaining, if ever a book should be written about worst practices this use case is a good candidate.


 My talk was about the Sparc Super Cluster "Super Cluster: the SWISS army knife of the Engineered Systems", I had the first slot on Tuesday and had about 100 people in my session,

I was bit nervous since a lot of my hero's were in the room and also the product manager of Super Cluster Michael Palmeter and Tyler Muth Super Cluster affiando.

The talk went ok and I did get good feedback and enjoyed it a lot.

 The conference is one thing but being able to talk offline with people like Karl Arao, Tanel P├Áder, Kerry Osborne, Mauro Pagana, Cary Millsap, Carlos Sierra, Andy Colvin, Tyler Muth, Michael Palmeter, Frits Hoogland, Martin Bach, Tarmo Alasoo, Radu Parvu, Jason Arneil, Hank   and all the passionate attendees just feels great and that is what attending this conference

I really enjoyed this conference a lot and got to know some nice people, thank you Veronica , Chanea and all the others of the organisation, you really made us speakers feel like kings.

A big thank you to Andy and Kate,  thanks for you warm welcome and even warmer hospitality really appreciated.

Next year there will be a European E4 as well in April, just a couple hours of flight for most of the Europeans, so you have no excuse to not attend this great engineered systems conference. check enkitecs website for more info


and yes it is true everything is bigger in Texas :-)



adding storage cells : appliance mode

Due to capacity issues 2 extra storage cells had to be added to the already 3 licensed high performance X3 cells on the Super Cluster T4. Some details about the installation Cellsrv 12.1.2.1.0 GI 12.1.0.2.4 DB 11.2.0.4 The process was quite straight forwards and is documented here in summary : create cell disks create grid disks on them exactly the same as on the existing cells with the same offsets for each disk group here an example of the first disk group on our cells
cellcli -e  "LIST GRIDDISK WHERE NAME LIKE 'DATA_DG.*' ATTRIBUTES NAME, SIZE ,STATUS, ASMMODESTATUS, ASMDEACTIVATIONOUTCOME,OFFSET"
         DATA_DG_CD_00_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_01_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_02_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_03_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_04_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_05_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_06_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_07_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_08_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_09_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_10_celadm01   423G    active  ONLINE  Yes     32M
         DATA_DG_CD_11_celadm01   423G    active  ONLINE  Yes     32M
ok we did that that way the configuration was exactly the same on the cells. on the database node we added the ip's of the newly added cells. I was a bit confused by the fact that nothing needed to be added on the storage cells because I recalled that there was a functionality introduced in one of the more recent storage cell versions that made them "talk" to each other on rebalance operations. But adding the ip's in cellip.ora on the db node was enough and then we were ready to rebalance the disk group
ALTER DISKGROUP DATA_DG ADD 
DISK 'o/192.168.15.104/DATA_DG*' 
DISK 'o/192.168.25.105/DATA_DG*' 
rebalance power 32 
; 
and kaboum
ERROR at line 1: 
ORA-00600: internal error code, arguments: [kfgpCreate_60], [12], [0], [65535], 
[65535], [65535], [65535], [], [], [], [], []
luckily asm was still running but being already pretty late after a day of migrations this was not funny at all. after chatting with support they suggested to disable appliance.mode on the disk group
 ALTER DISKGROUP DATA_DG SET ATTRIBUTE 'appliance.mode'='FALSE';
after we did that the addition of the disks worked
ALTER DISKGROUP DATA_DG ADD 
DISK 'o/192.168.15.104/DATA_DG*' 
DISK 'o/192.168.25.105/DATA_DG*' 
rebalance power 32 
; 

Diskgroup altered. 
When the rebalance was finished we put appliance.mode again to TRUE
ALTER DISKGROUP DATA_DG SET ATTRIBUTE 'appliance.mode'='TRUE';
more info can be found in note EXADATA : What Is Oracle ASM appliance.mode Attribute (Doc ID 1664261.1) So it looks like the appliance.mode is an optimisation I wonder if it is the fact that cells can communicate directly instead of using the host for rebalance operations, however that is not literally stated in the metalink note. hope this helps if you encounter this