One of the jobs I do the most as a DBA is added space to peoples schemas. It’s not a big thing, just something I have to monitor and watch out for. Users don’t like it when they can’t save their data into the database.
Below is a script that simplifies the main tasks required to do this.
We’ve had an Oracle Manage Server (OMS) running here at work for some time now. I think it was setup by a DBA who worked here years ago. The previous DBA didn’t use it so when I came to the job he told me to just login locally to OEM and not worry about using it.
I had some spare time the other day and thought I would have a look into what it could do. One of the first problems I ran into though was that I had to reset my password. Of course I didn’t have the admin password, and the last DBA doesn’t work here any more. So I had to find out how to reset the sysman password.
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.
I got a surprise when i saw that Oracle is to acquire Sun this morning.
Working with both products allot I’ll be interested to see how this develops. It will also be interesting to see what this means for products like MySQL and Oracle Linux.