Resetting the OMS password

by Richard Parmiter
by Richard Parmiter

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.

Read More »

Sending Mail using PL/SQL

by m-c
by m-c

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.

Read More »

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 »