Question on DB availability.

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 Thu Oct 29 1998 - 22:28:39 CST