Moving a database to a new ORACLE_HOME

I recently had a request at work to upgrade a 10.2.0.1 database to 10.2.0.4. Now normally this would be a fairly simple request. However, on the server the customers database is running on, the oracle home in question is shared by about 5 different databases. Now I don’t want to upgrade all the databases, just this one customers.

How do I do that? Move that database in question to a new ORACLE_HOME.

This sounds like it would be a difficult task, but its not that hard.
Check out the step after the break.

Read More »

How to elevate in Vista without prompting

by coba
by coba

I was recently researching how to run an application in Vista with higher privileges, without having it prompt me with the “are you sure” message.

The best I could find was this work around that basically involves setting up a scheduled task, which you can set to run with higher privileges, then making a shortcut to run that scheduled task. I thought that sounded a bit fiddley, but it did give me an idea on how to fix my problem.

What I was trying to do was run SpeedFan at login. It doesn’t work properly unless it runs with admin rights so just putting it in the start up group didn’t work and checking ‘run as administartor’ got annoying. 

What I was able to do was create a scheduled task that runs when I logon and set it to run with higher privileges. I also had to add a delay of 1 minute to allow a few other things to start up. Other wise it seemed to be starting OK, but I couldn’t see the temp icon that was meant to be on the task bar.

Trouble syncing iTunes Videos

by Eoghan Uttley
by Eoghan Uttley

One of the main reason I purchased my iPod Touch was to watch videos on the train on the way to work. And this has been work out great for me. One of the small problems I had was there seemed to be certain show that it didn’t want to sync properly.

I have the TV Shows set to sync the “5 least recent unwatched”, and this works OK for most TV shows that I add to iTunes myself. However for one particular show, it seemed to be choosing episode 10 onwards, instead of episode 1 onwards. I couldn’t for the life of me work out why. All the files had the same date, the same time. There was no reason.

Then I found The Complete Guide to Managing iTunes Videos at the iLounge.

In their guide I found that “when dealing with the various ‘recent’ settings, iTunes bases this on the date the episode was added to iTunes, not on the episode number, episode ID, or release date.”

After reading that I removed all the episodes from my library, added them again all at once, and tried sync’ing again.

It works!

Thank you iLounge.