Oracle Newbie

[evild]

I need some helpwith Oracle. Perhaps this is the wrong forum but you can point me in the right direction if I'm worng.
I am new to Oracle and I have been using it for my SQL for about a year now. However it has come to me that I must play more of an Oracle Admin role. The database I use at work (im a kind of admin of it) is fairly large with a massive amount of data ( a library system that controls all aspects from budgets to loans to book orders to catalogues etc etc).

I would like to know what standard oracle checks should be done and how to do them. At the moment not much checking is done on oracle. In fact the only check that is run is a disk space check twice a day.
This is far from adequate in my opinion and I would like to do more checking. The things is, I dont know what to check and how to do it and what the checks mean. Ideally I would like and email twice a day or maybe once a day that informs me of the oracle db and showing me the outcome of a number of these checks.

I have found on a web site that the following should be checked regularly:

Infrastructure availability:
Is the database up and responding to requests
Are the listeners up and responding to requests
Are the Oracle Names and LDAP Servers up and responding to requests
Are the Web Listeners up and responding to requests
Etc.

Things that can cause service outages:
Is the archive log destination filling up?
Objects getting close to their max extents
Tablespaces running low on free space/ Objects what would not be able to extend
User and process limits reached
Etc.

This sounds ok but I dont know how to do any of this and what they all mean.

What Im lokoing for is some advice. Can anyone here help me?

 

[alexhu]

You will help us to help you if you tell us your Oracle version and Operating system

Alex

 

[evild]

I though I should have included that info.

Im currently running Oracle 8.0.6.0.0 on SunOS 5.7

Its a horrible setup but thats what Ive got to work with.

 

[alexhu]

Thats close enough to what I have (8.0.5 on AIX)

I check this daily

oracle processes - ps -ef | grep _$ORACLE_SID | grep -v grep

ensure listener is running - ps -ef | grep LISTENER | grep -v grep

check intelligent agent (if using OEM) ps -ef | grep dbsnmp | grep -v grep

check for errors in alert log

grep ORA- $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert*.log

check archive areas for free space (df -k <filesystem>

check for trace files

ls -alrt $ORACLE_BASE/admin/$ORACLE_SID/udump
ls -alrt $ORACLE_BASE/admin/$ORACLE_SID/cdump
ls -alrt $ORACLE_BASE/admin/$ORACLE_SID/bdump

In addition check free tablespace space

I have a mail sent to me daily reporting on number of extents & max extents and another that shows the results of the backups.

weekly I check for invalid objects via a script mailed to me

monthly I clear all logs and tidy up filesystems

thats all I can think of at the more

Your mileage may vary - we only use the database as a data store ( no procedures, not too many triggers etc)

Alex

 

[evild]

Thanks for the info.

Our DB is quite acyive with many updates etc per day so I dont know if any further checks are needed...