• Raspberry Pi

    Enhancing A Moving Art Project to Beginning Robotics with Raspberry Pi

    Back on August 7th, the RMOUG’s Quarterly Education Workshop, I walked everyone through using a Pibrella board to create an art or flyer project that was powered with a python script and a motor. Today, we’re going to take that same code and reuse it with a simple robotics kit to control power and rotation speeds/time to the Insectoid.  This kit, puchased from the Go! store in Flat Irons Crossing mall, was $16 and can be built in less than an hour, even for a small child. If you’re interested, you can also purchase the kit online at Amazon, but…

  • Raspberry Pi

    Python Pass the Pigs

    So I don’t doubt that many parents are bleeding out money for kid’s school fees, supplies, clothing and other demands this time of year.  How many of you are in their local Target, Walmart or other store and after filling the cart with the necessary, the kids eye up the toy aisle and start to ask for something? Even teens are not immune and may be asking for games.  If you could turn around and say to them, “If you want the game, then why don’t you build it instead of buying it?” Now as many of you have figured…

  • Oracle - Raspberry Pi

    The Evolution of a Programmer and the Pythonic Way of Thinking

    There’s an old joke about the evolution of a programmer. It starts with the programmer in their infancy and typing: Print “Hello World” and so the output returns: The programmer continues to evolve. His coding knowledge increases and his code in the end of his evolution becomes a script of 5000 to 10,000 lines. What does the output return? You guessed it: I often joked that I’d make a terrible developer. I over think everything, but the truth is, I may have just evolved too much and need to devolve to improve. There used to be a sign up on…

  • Oracle - Raspberry Pi

    Emulating a Raspberry Pi on Virtualbox

    So I’m working on a lot of posts for Enterprise Manager, but I can’t post them just yet, so here’s some more Raspberry Pi love to keep you busy until then… 🙂 Why VBox Raspberry Pi? Many times I just want to write and test some code, but I want to do it while I’m taking a break from my day to day work-  waiting for a download, in a meeting, a script is running in another window, etc., so it’s convenient to have a Virtualbox image to run Python scripts with all the libraries and modules installed. I can’t…

  • Raspberry Pi

    Scripts from Today’s Family Coding and Hands on Lab Fix

    RMOUG’s Quarterly education workshop was a great event today and I appreciate everyone who came out and those who spent time with their family and their user community doing fun geeky stuff. Raspberry Pi Family Coding Morning There were a few things I promised folks, including access to my family coding slides so anyone can do this at home. Even though I’ve included the GPIO with breadboard configuration and code in the slides, please, PLEASE consider getting the Pibrella board and code with it instead.  The chance of wiring the board wrong is high for those just starting out and…

  • DBA Life - Enterprise Manager - Oracle - Raspberry Pi

    Upcoming Raspberry Pi Family Coding Day Project

    I’ve had a lot of people email and message me asking me what I’m doing with the Raspberry Pi and I wanted to share before the actual RMOUG Quarterly Education Workshop, (QEW) this Friday at Elitches. So a little history-  When I was a kid, I was a real handful.  My mother used to come into my room and I’d have created “webs” out of yarn strung from every piece of furniture and twisted into patterns.  I used to take apart radios and use the parts to create new toys, figuring out how the electronics worked.  Dolls suddenly became cyborgs…

  • DBA Life

    Community and Regional Oracle User Groups

    Back in 2002, as a Junior DBA, I was informed by the senior DBAs I worked with that I MUST become part of my regional user group, (RMOUG).  This was considered a requirement for any educated Database Administrator or Developer of the time and as those who I respected instructed, I became a member and attended my first Rocky Mountain Oracle User Group Training Days in February, 2003.   I was impressed with the level of technical content of the sessions, the opportunity to network with others in my local Oracle community and that I was able to take the new…

  • Enterprise Manager

    Consolidation Planning

    More and more companies are consolidating environments.  Server sprawl has a high cost to any business and finding ways to consolidate to more powerful servers or to the cloud is a productive undertaking for any company. The Consolidation planner in Enterprise Manager has been around for quite some time, but many still don’t utilize this great feature. Creating a Consolidation Project You can access the Consolidation Planner from the main Enterprise menu from Cloud Control in EM12c. There are two consolidation types currently available  physical to physical, (P2P) or physical to virtual, (P2V) consolidation.  For our example, we’ll perform a…

  • Social Media

    The Queen of Social Media Mean

    Unlike other forms of communication, social media can be a real gray area for rules on what dictates freedom of speech and how you have to endure with those that may not be pleasant to interact with.  I’m often told what etiquette some feel it necessary and that I should just disengage from some people online. The truth is, not everyone gets social media and many just don’t understand boundaries or how to communicate productively when online.  You, as a member of the online community, have the right to choose who you communicate with and when it’s time to NOT…

  • Enterprise Manager - Oracle

    Ten Things in Enterprise Manager to Improve a DBA’s Sleep at Night

    Happy Birthday to me!  So for my birthday, I give a present to you…  As I want all DBAs to sleep better at night, here are the top ten features you can use in Enterprise Manager Cloud Control to offer a good night’s rest instead of during the day at your desk… 🙂 1.  Disable the Default Rule Sets Shipped with Cloud Control. Yes, you heard me.  I believe you should use them as a starting point or an example, but don’t put them into production.  These were examples set by development to see all that you could be notified…

  • Enterprise Manager - Oracle

    Zero Data Loss Recovery Appliance with EM12c, (ZDLRA)

    I had a chance to take a closer look at the Zero Data Loss Recovery Appliance, (ZDLRA) via Cloud Control today and really liked the dashboard that’s included in the plugin for the product.  This post isn’t going to cover the installation of the plugin or configuration-  I was just intrigued by the dashboard and wanted to go over the great features that are part of it. Accessing the ZDLRA As with any Targets, the ZDLRA is going to show up in the All Targets menu and also has a target type filtered drop down in the Targets menu. All…

  • Cloud - Enterprise Manager

    A First Technical Look At Hybrid Cloning in EM12c Release 5

    The sales, support and technical teams were brought into the Denver Tech Center office to do some advanced training in Hybrid Cloud.  There were many take-aways from the days we spent in the office, (which is saying a lot-  most of you likely know how much I hate working anywhere but from home… :)) and I thought I would share a bit of this information with those that are aching for more details on this new and impressive offering from release 5. If you’re new to Hybrid Cloud and want to know the high level info, please see my blog…

  • DBA Life

    Upcoming Conference Sessions

    I’m glad to be home after a couple weeks in Europe, speaking at both the Harmony 15 conference in beautiful Tallinn, Estonia and then as a keynote speaker at AOUG in lovely Vienna, Austria the week after.  I get to pretty much stay close to home for the next two months, traveling only a bit, but I want to go over the upcoming conferences that I’ll be speaking at the next couple months. July 23rd, 2015, Georgia Oracle User Group’s Quarterly Tech Symposium I’ll be speaking, along with my peer, Loc Nhan at the event.  I’m looking forward to seeing…

  • Cloud - Enterprise Manager

    12.1.0.5 Hybrid Cloud Cloning

    Last week’s release of 12.1.0.5 was a pleasant surprise for everyone out in the Oracle world.  This release hit the bulls-eye for another cloud target of Oracle’s, announcing the introduction of Enterprise Manager 12c’s offering a single pane of glass management of the hybrid cloud.  The EM12c team has been been trained and testing out the new features of this release with great enthusiasm and I have to admit, pretty cool stuff, folks! Why is the Hybrid Cloud Important? Many companies are still a bit hesitant to embrace the cloud or due to sensitive data and security requirements, aren’t able to…

  • ASH and AWR - EM12c Performance - Oracle

    SQL ID Specific Performance Information

    When you need to have information about one SQL_ID and don’t need everything and the kitchen sink, there are a few different ways to collect this via Oracle.  I’m surprised how rarely this is covered in performance tuning/optimization, (whatever the current “acceptable” term is for fixing a database when there are performance issues arise… J)  classes, manuals and documentation.  I’d like to cover two of my favorite here and know, there are other options that I won’t be digging into, (SQLd360, SQLTXPLAIN, tracing, etc…) The Workload Repository SQL Report I also refer to this as the “SQL ID Specific AWR…

  • Raspberry Pi

    Raspberry Pi 2 Shopping List

    I recently upgraded from the first edition Raspberry Pi to the new and improved Raspberry Pi 2 in a bundle Cana kit.  The Raspberry Pi 2 has a 900MHZ quad-core Arm Cortex A7, (ARMv7 processor instruction set) with 1Gb of memory, GPU is a 250MHZ Broadcom VideoCore IV, 1080p 30 h.264/MPEG-4 AVC high profile decoder and encoder on the graphics and includes four USB ports, a micro SD, HDMI, micro USB power supply and a 15-pin MIPI camera interface.  I like that the kid included a number of accessories, including an 8GB Micro USB card, the USB Wifi, 3.5 mm…

  • AWR Warehouse - Database - Oracle

    Re-Adding a Database to the AWR Warehouse Without Losing Historical Snapshots

    There may be a reason that one needs to re-add a database to the AWR Warehouse.  This is a new opportunity for me to learn and offer assistance, but I’m working off the grid to figure out a solution.  Luckily, it’s just a matter of creating a new process from pre-existing code and processes. The process requires both the AWR Warehouse UI and a SQLPlus connection. 1.  Disable the snapshots 2.  Extract the AWR for the Database 3.  Drop the database from the AWR Warehouse 4.  Add the database back into the AWR Warehouse with the retention time or any…

  • ASH and AWR - AWR Warehouse - Oracle

    ASH Data and How Sizing an AWR Warehouse Can be Mitigated

    When sizing the AWR Warehouse, one of my requirements is to have certain reports for a sampling of databases that will source the AWR Warehouse. This report provides me the right information to create the correct sizing requirements vs. any assumptions done with other choices. The report is the General AWR Information report and can be found in the $ORACLE_HOME/rdbms/admin directory.  It provides the following information: Time of Report AWR Retention and interval settings, including if non-default setting. Schema percentage of space used in the SYSAUX tablespace. Objects and space consumption in the SYSAUX tablespace, including breakdown of the AWR space…