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?
- tables running out of space (extents)?
- Disk space running out?
- Rollback logs not archived?
- SQL programs errors
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.
__________________________________________
Alan B. Dewey
Geneva (Billing) Team Lead /DBA Lead
Arsenal Digital Solutions Worldwide, Inc.
4815 Emperor Boulevard, Suite 110
Durham, NC 27703
Website - www.arsenaldigital.com
Tel. (919) 941-4604
Fax (919) 474-0695
Pager (888) 646-6038
Cell (919) 523-5741
Email [EMAIL PROTECTED]
"Managing Information with a Passion"
***NOTICE***
This e-mail message is confidential, intended only for the named
recipient's) above and may contain information that is privileged, work
product or exempt from disclosure under applicable law. If you have received
this message in error, or are not the named recipient's), please immediately
notify the sender at (919) 941-4604 and delete this e-mail message from your
computer. Thank you.
-----Original Message-----
From: Viraj Luthra [mailto:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access /
ailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alan Dewey
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
