Re: Question on DB availability.

Hi Mike,

If all ports of Oracle are the same, there should be a product called Oracle Enterprise Manager on your windows client CD. This product should run on Windows NT and it is a bit too NT-oriented, however you can use it to manage Unix databases. You need to configure Oracle Intelligent Agent at the server side, OEM at the client side, and you will be able to see at a glance the status of the database, being able to shut it remotely, trap events and page you out of your bed, etc. Basically, it is an Oracle implementation of products like Tivoli and Openview. Configuration of OEM is a bit of a hassle, however www.oracle.com/support has documents available covering it. If you really get stuck, use this newsgroup and I or someone else will probably be capable of answering your questions.

Hth,

Sybrand Bakker, Oracle DBA

Mike wrote:

> I currently manage 18 databases spread over three servers in a
> development environment. All the databases are 7.3.4, and running
> on UE5000 and US30 servers using Solaris 2.5.1. I have received
> some basic DBA training, but am no Oracle expert!!!
>
> My question is this. Is there a utility in Oracle to check the
> availablity of these databases i.e., database is up, connections
> are working, database accepts logins and can be queried/updated/
> deleted etc?
>
> What I end up doing to check the status of these databases now is
> is this. I ps to see if the lgwr,smon,pmon etc are up for each
> instance...
>
> I check the listener by running lsnrctl status as oracle...
>
> I run a sql script against each db that does a simple select
> against v$database...
>
> What I imagine I want is a simple oracle utility that checks
> out my databases for me.
>
> If there is no such thing, go ahead and say so - I can handle bad
> news... :-) Also, any alternative methods to the one I am using
> that can save me time and/or effort would be appreciated...
> --
> Please remove ".nojunkmail" from my
> address before replying............
Received on Sat Oct 31 1998 - 02:29:17 CST