Tim Hall

Subscribe to Tim Hall feed
Oracle related rants (and lots of off-topic stuff)...
Updated: 14 hours 27 min ago

Oracle Midlands : Event #16

Thu, 2016-06-30 06:15

Don’t forget Oracle Midlands Event #15 next week!

om16

It’ll be interesting to see what this new kid on the block Jonathan Lewis has to say for himself!

Please show your support and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…

Oracle Midlands : Event #16 was first posted on June 30, 2016 at 12:15 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

VirtualBox 5.0.24 Released

Wed, 2016-06-29 07:54

Less than two weeks since the last release, yesterday saw the appearance of VirtualBox 5.0.24.

The downloads and changelog are in the usual places.

I’ve only done the installation on Windows at this point, but it seemed to go fine. I’ll probably do the Mac and Linux installs when I get home tonight.

Cheers

Tim…

VirtualBox 5.0.24 Released was first posted on June 29, 2016 at 1:54 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Fedora 24 and Oracle 12c

Mon, 2016-06-27 05:40

fedoraFedora 24 was released a few days ago. As usual I had a play around with it and tried installing Oracle on it.

First comes the warnings, because people keep misunderstand why I do this. Do not install Oracle on Fedora before reading this!

With that out of the way, here’s what I did.

No real drama here. It was pretty much the same as Fedora 23 in that respect.

It’s kind-of hard to get excited about a new version of Fedora since I switched my desktop from Fedora to Mac. One thing that was interesting is the change to the upgrade process. In previous releases I used “fedup” to do it. Now it’s pretty much done using DNF (YUM). If you are interested, you can read about it here.

Cheers

Tim…

Fedora 24 and Oracle 12c was first posted on June 27, 2016 at 11:40 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

EU Referendum : Oh Hell No!

Fri, 2016-06-24 02:45

If you care, you’ve probably heard the UK voted to leave the European Union (EU) yesterday. Suffice to say I’m gutted!

I’ve just deleted most of the content this post because it contained a lot of inflammatory and negative comments. I could question the motives of the leavers, but what good would that do now. IMHO this is a dark day for the UK.

For all my friends around the world, I would just like you to know I wanted to remain part of something bigger than this little island…

Cheers

Tim…

PS. If anyone has got an EU passport going spare it could come in really handy!

PPS. One of my colleagues just described what I’m going through as the 5 stages of grief. I think he is correct.

 

EU Referendum : Oh Hell No! was first posted on June 24, 2016 at 8:45 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

WordPress 4.5.3 Released

Tue, 2016-06-21 15:20

If you have a WordPress blog, by the time you read this you will probably already be running WordPress 4.5.3.

It’s a maintenance release that fixes a bunch of nasty things. If your site hasn’t already auto-updated, you should probably log on and give it a nudge. I’ve got 5 different installations and all auto-updated successfully.

Cheers

Tim…

WordPress 4.5.3 Released was first posted on June 21, 2016 at 9:20 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

VirtualBox 5.0.22 Released

Fri, 2016-06-17 08:02

VirtualBox 5.0.22 has been released.

The downloads and changelog are in the usual places.

Judging by the progress of 5.1, now in beta 3, it won’t be long before we’ve got something new to play with.

KeePass 2.34

Wed, 2016-06-15 05:13

I’m a little late to the party, but I just noticed KeePass 2.34 was released a couple of days ago. You can download it here.

You can read about how I use KeePass and KeePassX2 on my Mac, Windows and Android devices here.

Cheers

Tim…

Update: Ian Murphy just mentioned this exploit, which is a very good reason to upgrade to 2.34.

My Glamorous Life : What’s the point?

Fri, 2016-06-10 04:19

Last night I put out a video of my trip home.

I’ve written about the My Glamorous Life series of videos before (here). A couple of people commented recently that “nothing happens in them” and they are “quite boring”. That’s the point really.

OGh Oracle DBA and SQL Celebration Day 2016

Wed, 2016-06-08 12:01

oghThe OGh Oracle DBA and SQL Celebration Day was the last stop on my trip and it went super-quick! The morning started with a keynote by Dad. He managed to resist the urge to talk about me for 60 minutes, which was good. It gets really embarrassing when he keeps telling everyone I’ve eclipsed his accomplishments in every way possible!

After the keynote is was speaking about efficient PL/SQL calls from SQL. I lost the ability to type, but I think the session went OK. There is a playlist of videos about this stuff here.

Amsterdam to Zeist

Mon, 2016-06-06 16:01

I had a lazy morning, then it was time to start the journey to Zeist. It was a pretty straight forward journey from Amsterdam Central, via Utrecht to Driebergen-Zeist station. I had planned to get a bus from Driebergen-Zeist station to the hotel, but looking on the map it was only a couple of miles so I walked it. It was a little annoying dragging my suitcase, but no big drama. You can check out the journey and the hotel in the video below.

I had a quick walk around part of the town, near the hotel, where I bumped into my new stepmom.

In the evening I got a message from Dad asking if I wanted to go out to a family dinner. It was just as you would expect. Me crying and screaming, “You can’t tell me what to do, you’re not my mother!” and her saying, “I’m not trying to replace your mother. I just want to be friends!” I got back to my hotel room to find some brochures for posh, but secluded boarding schools. I’m not sure what I should be thinking at this point…

Tomorrow I’m speaking at the OGH Oracle DBA and SQL Celebration Day. Dad is doing the keynote and my new stepmom is going to visit some relatives that live near. I have a sneaking suspicion it’s going to be like “The Princess Diaries” and she will find she’s actually next in line to the Dutch Throne. Does that make me a step-prince?

Cheers

Tim…

Amsterdam to Zeist was first posted on June 6, 2016 at 10:01 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Amsterdam : A long weekend that didn’t quite happen.

Sun, 2016-06-05 16:51

My plan was to spend a long weekend in Amsterdam before heading off to the next conference…

I got off the train at Amsterdam Central and felt hot, very tired, sick and had the start of a headache. By the time I got to my hotel room I was feeling about 3/4 Machu Picchu. I took some Lemsip capsules and crashed out. I woke up about 20 minutes later still feeling bad, but knowing I would survive.

The next day came and went. I spent most of the day in bed. I ventured out of my room to film some bits of the hotel and get some food, which I promptly threw up, then went back to bed. If nothing else, I did manage to edit some videos between bouts of sleep. If you want to see where I spent Friday evening and all day Saturday, check out the video below.

Sunday morning was significantly better. After my Machu Picchu incident last year, a couple from the US gave me some electrolyte replacement sachets. I didn’t use them at the time, but found them in my bag and took one as soon as I got up. I decided to go and have a walk around, but it quickly became apparent I had zero energy. I didn’t feel ill, but just couldn’t walk any sort of distance. After about 2 miles I was totally done.

To make sure the day wasn’t a total right-off, I got onto a Sightseeing Boat and did one of the three possible loops (Green). I then picked up some food and headed back to the hotel. No puking this time, which was good. Once I was sure I wouldn’t be seeing lunch again, I headed back out and did another loop in the boat (Blue). You can see the photos and videos from the day here.

It wasn’t exactly what I had in mind for the weekend, but what ya gonna do?

So tomorrow I have to get a train down to Zeist for the OGH Oracle DBA and SQL Celebration Day on the following day.

Cheers

Tim…

PS. The “My Glamorous Life” title for these type of videos was always meant to be a joke, but in this case it is really funny. There was nothing glamorous about this weekend.

AMIS 25 – Beyond the Horizon – Day 2

Sat, 2016-06-04 09:16

amisDay 2 of AMIS 25 – Beyond the Horizon started with me playing catch-up on some blogging, then the conference proper started.

The first session I went to was Jeremy Ashley presenting “General Session – Oracle Applications User Experience: Trends and Strategy”. I wrote loads of notes on this, because I find it really interesting. I’m not going to post them here because I will make some mistakes and look like a fool. I’ve seen a number of sessions by the UX team over the years and each time I do, it seems to click a little more. I’m starting to think SQL*Plus may not be the ultimate in UI or UX, but I’m not 100% sure…

Next up was Björn Rost doing a “Quick Guide to Open Source SQL Tuning Tools (Quickie)”. This was a short session talking about some tools I know and use (rlWrap, SQLcl, MOATS, Snapper, SQL Developer) and something that was new to me TUNAs360.

After that was my session about running Oracle databases in the cloud.

I then took a break do some work, upgrading Tomcat and deploying a new application, before heading off to the OTN Cloud Developer Challenge results.

I would like to say we were robbed, but we really weren’t.

AMIS 25 – Beyond the Horizon – Day 1

Fri, 2016-06-03 02:58

amisWe had already been at the venue the day before for the beginning of the OTN Cloud Developer Challenge, but today was the first day of AMIS 25 – Beyond the Horizon. The day started at about 07:00, with a short minibus trip to the venue.

The first session I attended was “Get your money’s worth out of your Database” by Patrick Barel. He presented a whole bunch of database features that developers need to be using to make the most of their Oracle databases, including a bunch of 12c features. I like these kind of sessions. Much of what we end up doing at conferences is giving people pointers to what we think is interesting.

Next I went to “Smart Offices Are the Future of Work, Powered by the Internet of Things” by Noel Portugal. This started with some talk about designing for mobility, because people are connected all the time. It then moved on to the internet of things, where he discussed how small, cheap electronics can bridge the gap between the physical world and the internet, using examples like Amazon Dash, gesture controls, voice controls like Amazon Echo etc. The UX team are regularly using a lot of this stuff for their own office, kind-of making it the office of the present, not the future.

At this point, our team got together to carry on working on the OTN Cloud Developer Challenge, which took a big chunk of the day…

Later I headed off to see Jonathan Lewis present a session called “Just Don’t Do It”. As the name suggests, this session was focussed on improving performance by avoiding unnecessary work. The session was made up of examples from the OTN forums and consulting jobs where SQL was doing loads of unnecessary work. Often reframing the question allowed the statement to be rewritten to reduce the amount of work necessary to achieve the same goal. Neat!

From there it was back to the OTN Cloud Developer Challenge. All the groups got together to do the pitch for their solutions. With such a short timescale and the complexity of some of the services, most groups had hit some roadblocks, but everyone produced something. Debra actually did the pitch for two groups, but she did an exceptional job for ours. As I mentioned in a previous post, our team didn’t actually include people who do development outside of the database, and the challenge focussed on the non-DB side of things, which left us in a rather awkward position. By substituting comedy for content, Debra managed to make our pitch sound a lot better than it was. She also demoed our mobile app on her phone, and conveniently forgot to mention it was written in APEX. Your can see the home page below.

OTN Cloud Developer Challenge 2016

Thu, 2016-06-02 09:31

cloudThe Oracle ACE Program decided to tag an extra day on to the front of the AMIS 25 Beyond the Horizon conference for the “OTN Cloud Developer Challenge”. The idea was for teams of ACEs to get together and build applications using Oracle Cloud services. It was originally called a cloud hackathon, but got renamed to something that didn’t contain the word “hack”.

Paris to the Netherlands

Thu, 2016-06-02 02:04

airplane-flying-through-clouds-smallGetting to bed at 01:00 and having to wake up at 04:30 is not ideal, but it was worth it.

The alarm went off at 04:30, I had a quick shower, checked out of the hotel and took the shuttle across to terminal 2 in Charles de Gaulle airport. Despite the early hour, there were a lot of people around. I grabbed a coffee and caught up with my blog posts. By the time I had done that, it was time to board the short flight to Amsterdam.

We boarded on time, but unfortunately the flight was delayed by about 50 minutes, so a 50 minute flight became a 100 minute plane ride.

Paris Province Oracle Meetup

Tue, 2016-05-31 23:50

paris-province-oracle-meetupThe reason for me being in Paris was to speak at the Paris Province Oracle Meetup. Breaking my journey to the Netherlands with a quick trip to Paris was a really easy way to connect with more people.

The Paris meetup is very similar to those found in other cities around the world, including Oracle Midlands in my home town. We all gathered at about 19:00 in the AVNET office in Paris and I did two talks with a short break between them. The first talk was about pluggable databases and the second one was about running Oracle databases in the cloud.

I like these local meetups. They feel a lot less formal and more personal than some (but not all) conferences. It just feels more natural to me. I really enjoyed doing the talks and the crowd seemed to respond well to them, which was nice. I’ll definitely be back again, if they will have me. Maybe next time I will get to do some sightseeing in Paris too.

Birmingham to Paris

Tue, 2016-05-31 23:15

airplane-flying-through-clouds-smallThe day started at a rather civilised time of 06:00, which makes a change. I usually book early flights, forgetting I have to get to the airport a couple of hours early, then regret the decision later.

Paris and Netherlands Trip

Mon, 2016-05-30 06:16

Early tomorrow I start a small series of events in Paris and the Netherlands.

Tomorrow I fly to Paris to speak at the Paris Province Oracle Meetup. It will be my first time in Paris, so I’ll try to hit a few of the sites in the city centre if I can. I was originally hoping to fly out the same night as I have an event the following day, but the flights for that didn’t work out. Instead I’m staying in a hotel at the airport. I’ve got an early flight out of Charles de Gualle airport, so I figured I’d take the easy (but boring) approach of staying at the airport.

The next morning I fly to Amsterdam, take a train, then a taxi to the hotel, followed by a taxi to the OTN Cloud Developer Challenge (formerly known as the Hackaton). It started life as an extra day tagged on to an AMIS event by the Oracle ACE Program, like an ACE Briefing, but became a hackathon. I’m not sure if other people are allowed into it, but a few of us have got into teams and we are going to try and develop stuff with Oracle Cloud services. It’s going to be a bit of a magical mystery tour as most of the people in my team are database people and know nothing about the developer and mobile cloud services. If we are able to produce something with them, it will prove they are easy.

4 years and counting…

Mon, 2016-05-30 05:12

prisoner-296515_640It’s 4 years since I started at my current company.

No job is ever perfect. You just have to try and find a place where the pros outweigh the cons. Your judgement about what is a pro and what is a con will vary drastically throughout your life. What suits you today may not tomorrow.

Let’s see if I can make it to 5 years…

Video : Indexing JSON Data in Oracle Database 12c

Sun, 2016-05-22 04:25

Following on from last week’s post, today’s video is about indexing JSON data in Oracle Database 12c.

If videos aren’t your thing, you might want to read these articles, which the videos are based on.

The cameo in this video comes courtesy of Bertrand Drouvot, who was a silent extra in the previous video too. 

Pages