Mike Ault's Blog

Mike Ault's thoughts on various topics, Oracle related and not. Note: I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this blog are provided “as is” with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.

Sunday, April 26, 2015

Heading Home

Well, this is my last day away from home. I've been on the road to SNIA-DSI conference, Oracle Collaborate Conference and vacation. It will be good to get back home. I really enjoyed fishing with my father and brother even if we didn't catch our limit. I am also seriously looking into the gasifier I got a chance to see in action for the Wherehouse in Murphy, both to offset energy costs and to sell.

Stopped by the kids place in Kingston Georgia, work is progressing nicely and they should be able to move in soon. We will take Susan's Mom  out for lunch today then head on up to home.

I plan on concentrating on getting the 12c cluster up and running next week. Of course Open World, EDGE and another SNIA event are coming up as well as trips to the Midwest and New York as well as California. Of well, travel so fast old age can't catch ya I guess!

Thursday, April 09, 2015

This Week

Just finished attending SNIA-DSI conference in Santa Clara, California. Next week it is off to IOUG Collaborate 2015 in Las Vegas. So a busy time. I was able to attend several presentations about flash, testing and futures. I also was able to visit Calypso who makes a great testing platform for SSDs and flash, if you have SSDs or flash to test, I suggest you look them up(https://calypsotesters.com/).

I presented to day on implementing IDC testing guidelines using VDBench. Unfortunately since I was in the last time slot on the last day I only had a few attendees but they asked many questions and seemed to enjoy the presentation.

Tomorrow evening I am attending an open house at All Power Labs (http://www.allpowerlabs.com/) who knows, if I like what I see I may contact a unit for my retirement home. They manufacture a 20 KW biomass fueled gasifier that power a generator. I looked at a 15-20KW solar option but it is very pricey at $80k (with batteries).

Well, that is about all for now.

Tuesday, March 24, 2015

Progress...Sort of!


Well it has been a while since my last post, I have been working with the components of my RAC setup and got the passwords for the servers, and the HP SanSwitch, plugged in the SFPs/GBICs and have been battling with the switch ever since. Indications are that the switch is malfunctioning. When I run a minicycle command it tells me the switch is faulted but I can’t find the component that is causing the fault indication. It appears the actual port controller may be bad. Anyway, for $90 bucks I will toss it and get a new 4gb IBM switch for $140 with a 8 port license. Hopefully I will get the switch Monday and then I will finally get to see if the 5TB MediaVault storage system is working.

Once I get everything working I will look into going over to Oracle Linux on the servers and then load up Oracle12C. I will continue to report on my progress.

I attended IBM Interconnect and a writing conference since my last post. I have also finished the first draft of my next fiction book “The Suppressors” and contributed 2 chapters to a new Oracle trouble shooting book. Of course I have also been traveling with the job and staying busy at Sunset Cove. I helped my oldest daughter put in some raised beds for growing plants (well, we started anyway!).

I also am very happy to say my fifth grandchild, Evelyn Joy Bojczuk, was born 3/21/2015 at 1:25 in the morning. 6 pounds and 13 ounces and 19.5 inches long. Mother and baby are perfect.

Getting ready to head over to Raleigh to do some webcast recordings and week after next off to SNIA in Santa Clara and then EDGE in Las Vegas. After that it is a week fishing with my Father and Brother. Meanwhile my property manager will be cleaning up the storm and snow damage at Sunset Cove and will be preparing the upper and lower gardens for planting. The Asian pears, apple and pear trees are all blossoming and spring is finally here!

Monday, September 08, 2014

Status of Home Lab


Well, all the equipment is stacked onto a heavy duty plastic storage shelf. I will probably retrieve my wire rack from Atlanta next time I am through there. Of course if anyone wants to donate a computer rack (even a half-rack would do) I would be willing to consider it…J

When I unpacked the FC switch I realized they hadn’t included GBICs so I had to order some off Ebay. In addition the FC optical cables I had were the wrong type so I had to order more. Looking at the small SAN I purchased I discovered it is using a serial connection rather than a Ethernet so I ordered the appropriate adapter…from Hong Kong. Unfortunately it came with a 230 v power adapter (not even dual voltage) so I had to order a new power supply. The serial-to-Ethernet adapter also had a male plug as does the SAN, so back to Ebay for a female-to-female adapter. Hopefully by tomorrow all these various cables, adapters and power supplies will have arrived and I can finally start configuring the system.

At least all the KVA cables worked (Keyboard-Video Adapter interface) and I can talk to both servers from the same touchpad/ keyboard and Monitor. The servers come with a minimal install of Windows Server 8, unfortunately it seems someone has set a password. Luckily I am blowing the whole OS setup away on both servers and installing Oracle Linux, so the lack of a Windows password really doesn’t bother me that much.

Once everything is up I get to set up the network (2-1GB Enet switches, one for general networking between the operator, servers, FC switch and SAN and the interconnect, set of the 4GB SAN switch for proper zoning, format and configure the SAN and then configure the OS on the servers and install Oracle.

I’ll keep you posted.

I am also doing an All-Flash-Array (AFA) testing setup at work for the IDC based testing. We are looking at setting up VDBench through Windows to test the IBM FlashSystem 840 in accordance with the IDC guidelines and then having the setup and generated setup documentation available so any client can use the guidelines for testing to satisfy them we aren’t using smoke and mirrors in our claims for performance of the FS840. I will post any lessons learned for that as I experience them.

This weekend I split and stacked about a cord of wood here at Sunset Cove for the basement woodstove in case the projections that this will be another record snow year for Tennessee, North Carolina and points North comes true. Luckily I have a hydraulic splitter that made quick work of the actual splitting, but the loading, unloading and stacking still had to be done by hand.  Also had to adjust the brakes and clutch on the tractor and buy a new battery for it. The clutch still needs a tweak as the Power-Takeoff (PTO) isn’t disengaging properly when the clutch is fully depressed.

Looks like next weekend I get to pick more pears. Since the apple crop this year was a bit disappointing I guess instead of hard cider I will make what they call Peary which is Pear Cider. I made five gallons of hard apple cider last year but it only lasted until half-way through the winter, so to make enough for it to last until the next crop comes in I guess I will have to do 10-15 gallons which will be around three bushels of pears. If I can get it setup next weekend then it can ferment for the three weeks I am going to be gone to OOW, Edge and vacation. Then I will have just enough time to filter it and bottle it before the relatives show up for the Punkin Chunkin in late October. If you have never seen a Punkin Chunkin, check it out online, there is probably one near you. Essentially you build the best punkin throwing device you can envision then compete for distance, last year 900 yards was the winning distance.

The gardens need to be tilled under as we are getting the last of the tomatoes and cucumbers now. Luckily I have a yard service that will do that for me. I’ll have them weed wack the gardens to grade then till the plants under and then place some of that weed-block fabric over the top to kill off any weeds that want to try a comeback. In a few weeks we’ll plant the winter garden items.

The hydroponics setups are still languishing in the greenhouse, afraid I haven’t had a chance to get the lower well re-lined and I need a good supply of water to do them properly and about 6 weeks of non-travel so I can monitor the ammonia and nitrate levels daily to get the biologics established on the growth media, then you put in the Tilapia and get the nitrate cycle going and then start growing some leafy vegetables like Lettice, Kale, Boc choy or even good old spinach. Maybe later I will look at vertical gardening techniques to do something more dense.

Of course deer season is just around the corner and I have that new platform stand to put together down overlooking the Orchard. I spent several weeks trying to figure out where the deer where last year only to realize they were busy raiding the orchard for low-hanging and windfall fruit. Since it is near the road I will need to use archery only. That reminds me, have to tune the new compound bow and adjust the draw length to allow for my d-loop and trigger as well as sight in the black powder and deer rifles and check that the crossbow is still sighted in as well.

Then there is also the ongoing work with my half ownership in the Wherehouse of Murphy, an art gallery and hand-made item, antique and general merchandise store. We also do free concerts, Yoga and art classes. Luckily I am mostly a silent partner and Joy Stein handles most of that for us.

Did I mention I am also writing the third book in the Rex Franklin series? Yep, Rex is installing a Tsunami warning system in the Turks and Caicos when he gets roped into helping out his least favorite ex-boss fetch a fortune in emeralds from a Spanish wreck….

Also toying with writing a book on Oracle AWR Analysis, in my spare time.

Add into that the travel and full-time work load of IBM and it rounds out my schedule nicely.

No rest for the wicked I guess. And people wonder why I laugh when they ask “But Mike if you retired what would you do with yourself?”

Friday, August 29, 2014

A Friday at Bradley International


Well, sitting here in Poughkeepsie waiting on my flight back to Atlanta. Asfar as the proof of concept I was here for, let me give you one take-away, when Oracle says put the RAT clients on a different server, they mean it! Of course it didn't help that the client was testing 24 databases simultaneously on the same Power8 box...
Anyway, John with the IBM lab and I convinced them to move RAT to its own server and things are now going great. 
I decided I better put down on paper what I need to do for the home lab:
Action Plan for Lab Set up
 
  1. Convert files to disk images on DVD
  2. Cable up systems
    1. Interconnet
                                                               i.      2-1 GB Ethernet cables and switch

    1. Network
                                                               i.      2-1 GB ethernet cables for servers

                                                             ii.      1 cable for SAN

                                                            iii.      1 Cable for Storage Switch

                                                           iv.      1 GB Ethernet switch

                                                             v.      1 wifi switch for remote access (2nd floor office to basement lab)

    1. SAN
                                                               i.      Install 4-4 GB HBAs (2 per server installed)

                                                             ii.      Install 6-4 GB FC optical cables between components and Switch

1.       2 for SAN

2.       2 for each server

                                                            iii.      4 GB switch setup

1.       Zone SAN and servers

    1. Install OS
                                                               i.      Install Oracle enterprise Linux on each server

                                                             ii.      Locate and install any needed drivers for HBA, monitor, etc.

                                                            iii.      Implement multipathing to SAN

    1. Install Oracle12c
                                                               i.      Install grid software

                                                             ii.      Install RAC software

                                                            iii.      Create database

    1. Download SLOB and/or Swingbench and install
    2. Create and load databases
Trying to keep it simple to allow for some flexibility.

Wednesday, August 27, 2014

New Lab status


Well, I have all the equipment, power cords and Ethernet cords. I am waiting on some Fibre channel cables that should arrive by Tuesday at the latest. I purchased a WiFi Ethernet switch so I can connect to the system form my loft office without having to go all the way downstars. I salvaged my KVM switch and cables along with the power cords, Ethernet switches and touchpad keyboard and monitor from my old lab. Should get the system mostly wired and cables on Friday night and be able to start loading the OS on Monday with any luck, then begins the joy of loading Oracle12c! I have a line on a couple of FusionIO 190 gb cards I made an offer on them, we will see if they will give them up. I offered $175 apiece for them since I have no idea how many PE cycles they have on them. I figure to use the FusionIO cards as flash cache for the RAC instances since it won’t be shared storage.
I am at the Atlantsa airport waiting on a flight to Poughkeepsie where I will be helping on a proof of concept tomorrow, it is about boarding time so I will keep this entry short.

Thursday, August 21, 2014

Upgrading the Lab


I am afraid I have been a bit negligent in my blog posts of late. I will endeavor to make them more frequently and of course try to make them interesting and enlightening! I am embarking on a new project, I am rebuilding my computer lab with newer, better equipment. To that end I just completed the purchase of the following gear:

  1. 2 – Dell PowerEdge 2950 III servers
    1. 2x2.83 GHz E5440 Quad core
    2. 16 GB memory
    3. 4x500 GB internal drives
    4. PERC6i 2PS
  2. 4 – Dell Qlogic QLE2460 single port 4 GB FC PCIe HBAs
  3. 1 – A7394a HP Storageworks SAN 4 GB/s Switch with 32 active ports
  4. 1- CIPRIO MediaVault RX 4 GB dual FC Storage 5 TB array (capable of RAID0, RAID1 or RAID3)

Now, you should realize I have access to a full IBM Power8 server with an IBM FlashSystem 840 attached via remote access to the STG lab, but when I am testing and learning I prefer a system where if I crash it or trash it, it will effect only my work. Once I learn what not to do I will take advantage of the advanced equipment that IBM has made available.

It is interesting to note that when I started writing Oracle books I purchased a new server (back in the late 1990’s) at that time I got a hyper-threaded, dual core system with 2 GB of memory for about $5K. When RAC was released I needed to upgrade so I purchased 2 – single core hyper-threaded servers with 4 GB or memory, a 1 GB switch and 2 disk arrays at a total cost of around $3K. For all of the equipment listed above I paid $1.6K on Ebay. It just goes to show the incredible decrease in costs and increase in capabilities that have occurred over the last 20 years.

Next I will be acquiring Oracle OEL for the operating system and Oracle12c for testing and learning on. I will post my lessons learned as I go along. I hope to test many of the new features of 12c such as container databases, in-memory database options, use of Flash Cache in container, regular and RAC 12c databases and of course use of the in-memory option with a 12c RAC database.

Next I have to decide whether to install the equipment in the house or out in the shed, if I do it in the shed I have to build a computer room out there and put in a small AC unit. I an existing AC unit that will work, just have to cut the needed ports in the side of the building and install the intake/outlet lines for the air handler section. Of course instead of building a room it may be more cost effective to buy a small 8x10 foot shed and place it in the larger 30x50 foot equipment shed. I’ll post pictures along with the blog entries as I go along.