I have been playing with Oracle Management Server at work receenty to try and mke the management of all our Oracle 8i and 9i databases a little easier.
One of the thing I want to setup was something to monitor the amount of tablespace left in each tablespace. I already had a clunky way to do it using PL/SQL, shell scripts and web pages. But OMS looked like a better way to do it.
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.
Donald over at the Burleson Consulting web site has a very useful looking Q & A on how to do date arithmetic in Oracle. While it’s not something I or probably many people will need to use every day, it might come in very handy next time you do need to calculate how many days it is until next Christmas, Easter, Public Holiday.