Having been thrust into the role of reluctant DBA, I recently migrated a database. It all went pretty smoothly until I needed to enable dead connection detection to act as a keepalive.
All you need do is add SQLNET.EXPIRE_TIME = x (in minutes) to you sqlnet.ora
Despite everything I read to the contrary, this did not work for me until I bounced both the database and the listener. Just posting this here in the hope I may save someone else some annoyance.
Wednesday, May 2, 2012
Wednesday, December 14, 2011
My experiences with Server Pronto
Now, that I am no longer a Server Pronto customer, I feel that I can write on my experience.
Firstly, it wasn't all bad, I'd been a customer for 5 years and at the time they were offering a very competitive product. I had only one hardware problem at the time and it was dealt with sufficiently.
The price did keep creeping up, but I was somewhat consoled that the specs on my package were creeping up too, or so I thought.
Then checking my credit card statement one day, I noticed a charge that was about 18x my usual charge.
It seemed that I had gone over my usage limit. I cannot to this day see how that happened, but support could offer me no logs to add veracity to their claims. Regardless of whether or not I had actually used that much bandwidth, it was less than the current advertised limit for the plan I was a subscriber to. However because I hadn't asked to "switch" to the same plan, with the same name and same price as I was paying I was stuck my my original bandwidth limit. After a plea to the CEO (or whoever reads the CEO's mail), I was given a credit. Since I wasn't in the mood for more of a fight, I accepted that. My credit has now just expired and here I am writing this blog entry.
I was irate at the time, but 16 months has mellowed me somewhat.
There's a number of things that SP could do better.
Firstly, it wasn't all bad, I'd been a customer for 5 years and at the time they were offering a very competitive product. I had only one hardware problem at the time and it was dealt with sufficiently.
The price did keep creeping up, but I was somewhat consoled that the specs on my package were creeping up too, or so I thought.
Then checking my credit card statement one day, I noticed a charge that was about 18x my usual charge.
It seemed that I had gone over my usage limit. I cannot to this day see how that happened, but support could offer me no logs to add veracity to their claims. Regardless of whether or not I had actually used that much bandwidth, it was less than the current advertised limit for the plan I was a subscriber to. However because I hadn't asked to "switch" to the same plan, with the same name and same price as I was paying I was stuck my my original bandwidth limit. After a plea to the CEO (or whoever reads the CEO's mail), I was given a credit. Since I wasn't in the mood for more of a fight, I accepted that. My credit has now just expired and here I am writing this blog entry.
I was irate at the time, but 16 months has mellowed me somewhat.
There's a number of things that SP could do better.
- Automatically move customers to the new plans, had they done this, they would still have my custom.
- Provide a sanctioned usage meter. Support suggest installing your own, but of course they will always use their own.
- Make your customers aware that you use 95th percentile billing. I suspect this is what tripped me up.
- Inform your customers about outages on a service status page. When my server and your infrastructure is down, I like to know what is going on.
- Make your cancellation process simpler. I don't want to have to send a fax or an email to cancel. Complex cancellation processes actually put customers off.
The best thing about this whole experience is that I discovered linode.com of whom I am a very happy customer.
Thursday, October 20, 2011
Ninject lesson of the day.
Bind(typeof(IBlob<>)).ToProvider(typeof(IBlobP
Does not work how you would expect.
Firstly you end up with a weird error message about a double binding.
I ended up using a crufty workaround with .ToMethod
Does not work how you would expect.
Firstly you end up with a weird error message about a double binding.
I ended up using a crufty workaround with .ToMethod
Friday, September 30, 2011
Day Camp 2011 Day 5
Well, this is the end of, the end of my story, story...
Day 5 seemed to fly past. Wally and Captain Sook finished their quest finally!
We then took a trip to the gunyahs to clean up the area and dismantle them. Our tyres had been pilfered, but I was very much unsurprised by that. My kids finally got some swing joy courtesy of a vine swing that lasted about 2 minutes before it fell down.
Back to the main camp and the teams embarked on a treasure hunt. Each team went through a series of bible verse clues to find a particular item around the camp. Upon completion of each clue a puzzle piece was obtained. At the end of the quest, your puzzle solution was used to obtain the treasure.. I wonder what it could be?
We retrieved the much vaunted treasure boxes from the craft area and returned to assembly to find out what the treasure might be. The kids were not convinced when I suggested it could be chocolates, or possibly even bricks! In a surprising development, the treasure turned out to be a bible for each of the children. It was great to see that one of my team members started reading it at assembly!
Lunch was then served - hot dogs were provided and I believe some children managed to get up to fourths!
After lunch, the concert was held with the parent in attendance and while most teams recalled a song, there were a few more creative teams - My team did an old standard camp skit with a treasure theme craftily wrapped around it.
There were some awards given to the leaders and support staff and then all the parents took their little darlings home!
We took the bus back to Kingaroy and then started our own journey home to the Gold Coast.
I have had an excellent time at Day Camp and I hope that my team members had a good time too. I have every intention of returning next year!
... Everything is honky, dory, dory....
Thursday, September 29, 2011
Day Camp 2011 Day 4
The word for day for was rain. Rain and lots of it in the morning accompanied by its close friend bitter coldness. This meant that the much awaited water fight was off the menu, much to the disappointment of the campers. BUT, it was still Stewsday and as soon as everyone arrived we split off into teams to prepare the stew. There was not enough camp ovens for each team to be allocated one, so my team joined with another to create some awesome stew.
The rain really had thrown a spanner in the works as few leaders were prepared with rain activities. After "team time" and practicing for our concert piece, there was not much left to do except craft. Craft had never been so popular! Hats off to the craft ladies, who did an outstanding effort!
Hats off also to the "firemen", who normally sit around the fire drinking tea and putting the occasional damper in and out of the fire. Today however, they needed to call upon their best fire skills as they fought the rain to ensure that all stews were cooked. Well done chaps!
After lunch there was a big void to fill and despite the rain stopping, gunyahs were still out of bounds so the kids were allowed in the the dorm rooms. Unfortunately, the only activity on offer in the dorm rooms was mucking around and some shenanigans ensued.
The camp director finally had pity on the leaders inability to properly entertain rain-bound children and called the buses in an hour early.
The buses had an hour layover in Kingaroy and the kids watched a veggietales video in the church. Unfortunately, I was called to the leaders meeting, so I missed out on watching it (I think I'd already seen the dvd in question).
Which brings us to tomorrow's conclusion - gunyah site cleansing,
The rain really had thrown a spanner in the works as few leaders were prepared with rain activities. After "team time" and practicing for our concert piece, there was not much left to do except craft. Craft had never been so popular! Hats off to the craft ladies, who did an outstanding effort!
Hats off also to the "firemen", who normally sit around the fire drinking tea and putting the occasional damper in and out of the fire. Today however, they needed to call upon their best fire skills as they fought the rain to ensure that all stews were cooked. Well done chaps!
After lunch there was a big void to fill and despite the rain stopping, gunyahs were still out of bounds so the kids were allowed in the the dorm rooms. Unfortunately, the only activity on offer in the dorm rooms was mucking around and some shenanigans ensued.
The camp director finally had pity on the leaders inability to properly entertain rain-bound children and called the buses in an hour early.
The buses had an hour layover in Kingaroy and the kids watched a veggietales video in the church. Unfortunately, I was called to the leaders meeting, so I missed out on watching it (I think I'd already seen the dvd in question).
Which brings us to tomorrow's conclusion - gunyah site cleansing,
Wednesday, September 28, 2011
Day Camp 2011 Day 3
This brings us to day 3 - which I was trying to promote as "Hump Day", except none of the Gen Ys actually understood that concept...
Again we were guests on the much more peaceful Murgon/Wondai bus and arrived to the same morning routine with "lovely" singing followed by Captain Sook and Walter. We were then briefed on the morning entertainment - "Pieces of Eight".
It was a team-based collecting game, where items of different colours needed to be collected from around the campsite. Of course no game is complete without antagonists and this was provided in spades by the gophers who as pirates were wounding and pillaging. The kids all seemed to enjoy themselves, and apart from a few leaders who were disproportionately targeted by the pirates, a good time was had by all.
After the game my team had the best "team time" of the week so far and dare I say some there was even some bonding occurring! We shall see if that holds over to tomorrow.
Now lunch was a sight to behold. The bring your own food day has turned into something of an arms race. There was nachos, hot chips, a lot of pizzas and most of them were cooked in the oven! I'm going to go out on a limb here and say that if it's not cooked in the fire, it isn't day camp. What's next? A catering van showing up and dishing out food to the kids? I challenge all leaders out there to remember the core principles of day camp and let the kids enjoy burnt food!
After lunch, I finally acceded to my teams tyre-lust and went out on a tyre-hike. We captured three fine specimens from the Australian bush and hauled them back to our gunyah for a ceremonial display. I'm pretty sure that they will have all been stolen by the time we get back to our gunyah tomorrow!
Quite amazingly for children who displayed little interest in art, they spent nearly an hour decorating their treasure boxes. This was a welcome respite from chasing them around.
Tomorrow is stewsday, water-fight day and finally-start-practising-for-the-concert day!
See you then!
Again we were guests on the much more peaceful Murgon/Wondai bus and arrived to the same morning routine with "lovely" singing followed by Captain Sook and Walter. We were then briefed on the morning entertainment - "Pieces of Eight".
It was a team-based collecting game, where items of different colours needed to be collected from around the campsite. Of course no game is complete without antagonists and this was provided in spades by the gophers who as pirates were wounding and pillaging. The kids all seemed to enjoy themselves, and apart from a few leaders who were disproportionately targeted by the pirates, a good time was had by all.
After the game my team had the best "team time" of the week so far and dare I say some there was even some bonding occurring! We shall see if that holds over to tomorrow.
Now lunch was a sight to behold. The bring your own food day has turned into something of an arms race. There was nachos, hot chips, a lot of pizzas and most of them were cooked in the oven! I'm going to go out on a limb here and say that if it's not cooked in the fire, it isn't day camp. What's next? A catering van showing up and dishing out food to the kids? I challenge all leaders out there to remember the core principles of day camp and let the kids enjoy burnt food!
After lunch, I finally acceded to my teams tyre-lust and went out on a tyre-hike. We captured three fine specimens from the Australian bush and hauled them back to our gunyah for a ceremonial display. I'm pretty sure that they will have all been stolen by the time we get back to our gunyah tomorrow!
Quite amazingly for children who displayed little interest in art, they spent nearly an hour decorating their treasure boxes. This was a welcome respite from chasing them around.
Tomorrow is stewsday, water-fight day and finally-start-practising-for-the-concert day!
See you then!
Tuesday, September 27, 2011
Day Camp 2011 Day 2
Day 2 began with the usual very loud bus trip consisting of music that only God can love!
Upon arriving at camp, the usual morning routine with Captain Sook and Wally unfolded, and after that the team headed to the increasingly more distant and fairly functionless gunyah. It seems that it is just a place that the kids want to temporarily store their bags, keep tyres (more about that later) and see what kind others have made.
We participated in "team time", which I hope the kids are deriving some value from and headed of to construct the now legendary treasure boxes.
The treasure boxes are quite a tricky thing to construct, and even with the cutting out and scoring pre-done by the wonderful craft ladies, it still takes some time. Still my team I think got a good result. To their delight/chagrin tomorrow, we'll spend some time decorating them.
After the treasure boxes, we returned to the gunyah to get our lunch and joined the very long queue for sausage cooking facilities. After waiting for too long, we decided to make our damper, which today had added m&ms. It was quite the opposite of mondays, with little charcoal on the outside, but a little bit of gooiness in the middle. It was still yummy though.
Eventually, we cooked and ate our sausages, although we did not set any records for consumption.
We skipped the billy tea today, and no-one seemed to care (myself included).
After lunch and another trip back to the gunyah and back, we went for a hike with some other teams.
All was going normal until a huge cache of tyres were discovered. Now embedded in South Burnett Day Camp lore is the tyre. It is an object of desire, the ultimate status symbol with which to adorn your gunyah. It is the target of theivery and requires great protection. Naturally, the children were overjoyed at discovering such a large stash of unguarded tyres. And they rolled them along with them on the hike and I discovered that stopping a rolling tyre that is coming towards you is better left unattempted. I hadn't had a day camp injury from a tyre before today. A few of the younger girls wanted a tyre, but didn't have the strength or patience to get it back to camp. Therefore I ended up carrying two tyres back to camp like a challenge on some tv show.
The hike pretty much brought us up to the end of the day, where after the normal afternoon routine, we boarded the bus. BUT not the normal Kingaroy bus, we were the guests on the Wondai/Murgon bus. Let me say that they are a much more civilised bunch with a lot less singing which I appreciated after a long day.
Tomorrow is the "Pieces of Eight" game day and pizza pockets, let's see how that turns out.
Upon arriving at camp, the usual morning routine with Captain Sook and Wally unfolded, and after that the team headed to the increasingly more distant and fairly functionless gunyah. It seems that it is just a place that the kids want to temporarily store their bags, keep tyres (more about that later) and see what kind others have made.
We participated in "team time", which I hope the kids are deriving some value from and headed of to construct the now legendary treasure boxes.
The treasure boxes are quite a tricky thing to construct, and even with the cutting out and scoring pre-done by the wonderful craft ladies, it still takes some time. Still my team I think got a good result. To their delight/chagrin tomorrow, we'll spend some time decorating them.
After the treasure boxes, we returned to the gunyah to get our lunch and joined the very long queue for sausage cooking facilities. After waiting for too long, we decided to make our damper, which today had added m&ms. It was quite the opposite of mondays, with little charcoal on the outside, but a little bit of gooiness in the middle. It was still yummy though.
Eventually, we cooked and ate our sausages, although we did not set any records for consumption.
We skipped the billy tea today, and no-one seemed to care (myself included).
After lunch and another trip back to the gunyah and back, we went for a hike with some other teams.
All was going normal until a huge cache of tyres were discovered. Now embedded in South Burnett Day Camp lore is the tyre. It is an object of desire, the ultimate status symbol with which to adorn your gunyah. It is the target of theivery and requires great protection. Naturally, the children were overjoyed at discovering such a large stash of unguarded tyres. And they rolled them along with them on the hike and I discovered that stopping a rolling tyre that is coming towards you is better left unattempted. I hadn't had a day camp injury from a tyre before today. A few of the younger girls wanted a tyre, but didn't have the strength or patience to get it back to camp. Therefore I ended up carrying two tyres back to camp like a challenge on some tv show.
The hike pretty much brought us up to the end of the day, where after the normal afternoon routine, we boarded the bus. BUT not the normal Kingaroy bus, we were the guests on the Wondai/Murgon bus. Let me say that they are a much more civilised bunch with a lot less singing which I appreciated after a long day.
Tomorrow is the "Pieces of Eight" game day and pizza pockets, let's see how that turns out.
Subscribe to:
Comments (Atom)