| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Monitoring with BMC
Raja,
I no longer use this at my current job. I did at my last job and am currently working with an ex-BMC installer. Here is some information that might be useful. Please let me know if you need more information or care to talk more on this subject.
Ok, BMC Patrol and the Oracle KM are the basic parts you will need to start monitoring your databases. The other BMC tools for Oracle are very good but are not addressed here.
The Patrol install will include the Operating System KM and have the Oracle KM added to it. This will require approx. 250 MB disk space. Ensure you have at least 2 MB of disk for everyday you keep a log file for. I recommend a log file should be kept at least 30 days (60 MB needed) so you can accurate track system metrics for a month. To install you will need the system root password, and the Oracle System password. The first is needed to ensure BMC will start when the system reboots, the Oracle System password is needed as BMC requires access to the system tables.
The Oracle KM will create tables either in system temporary table area, or another table you designate. This will also require room, in addition to the log file and the binaries. The room will vary upon system usage, size of dbs, etc... Allowing about 50 MB is more than ample. If the disk space for you database is very tight I highly recommend reconfiguring and "cleaning" tables before installing any product.
What does the Oracle KM do? Basic Oracle performance metric, state of database, table space used, number of users, etc... It also allows you to monitor databases using SQLNet. This allows you to look at any reachable DB without adding Patrol to the system. It will collect over 200 parameters (a BMC term for a metric) for each Oracle instance. This means if you have one set of Oracle binaries running with 5 instances, you will get only one set of data telling you about the status of the binaries (is Oracle running? is it running with no instances active? is Oracle running and the instances active?), but you will also get the data about each table. So if you instance has 1 table or a 100 each table will have the same information recorded about them.
Vital stuff to DBAs:
- What is the status of the instance?
How effective is it? DBAs arrive and do a health check in the morning. Using Patrol this can be reduced from 30 minutes to 10 minutes per instance. Adding scripts that run on-demand or when triggered by the database is straight forward. Control of what each user has access, allows DBAs not to tread on each others toes.
Install time:
O/S KM, Patrol Agent - 1 hr
Console - 1 hr
Oracle KM - 1 hr.
Time when you start getting useful data, depending on the metric (some need a history to start determining if they are in trouble) ranges from immediately to all metrics reporting within one hour.
You will need several days of operations to effectively baseline the warning levels of the parameters. This is like any other tool where the more data collect, the better vision you will have of what is normal and what is a problem.
Recommendation - purchase if you need 24/7 database uptime. A DBA and system admin must work together as the close relationship between Oracle and the O/S demands this.
-----Original Message-----
From: Viraj Luthra [mailto:viraj999_at_lycos.com]
Sent: Tuesday, July 24, 2001 10:11 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Monitoring with BMC
Hello all,
Has any one used the Oracle Monitoring with BMC, and can share experiences. Also any advantages, disadvantages kind of paper you have written for ypur company, that would be great; evaluating BMC at present.
rgds,
raja
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: viraj999_at_lycos.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / ailing Lists
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Dewey INET: adewey_at_arsenaldigital.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sun Jul 29 2001 - 10:49:08 CDT
 |
 |