Hello Ron
I had a meeting today with people that represent ECORA in Israel.
They have a product called Ecora® Enterprise Auditor
(http://www.ecora.com/ecora/products/enterprise_auditor.asp)
that catalog all your servers and databases.
It can run on your schedule and catalog and produce inventory
-Original Message-
From: Smith, Ron L. [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
]
Sent: Thursday, October 30, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: DBA Support Database
I was thinking about putting together a database that
contains
I was thinking about putting together a database that contains a list of
DBAs, servers, databases, and applications. The database would be used
by the Helpdesk and Management to see who is responsible for a given
application or database when problems occur.
I thought I would check first and
Ron
Our help desk people use a software application that is capable of
storing configuration information like this. You may want to check with them
first to see if they already have something you can build on rather than
starting something new. Unless I'm missing something, what you describe
Ron:
I have heard of this being done especially in large companies that have
many, many databases. It is difficult to keep track of all the little
details that are spread out all over the company. Having a central data
mart for this information I thing would be very helpful. The only problem I
We recently signed a corporate agreement with Oracle that basically
gave us a named-user license for every person in the company. Now,
we have databases sprouting like rabbits. Our four-dba team now
is supporting SAP, two different Siebels, a data warehouse, and
myriad other projects - over 200
3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: DBA Support Database
I was thinking about putting together a database that
contains a list of
DBAs, servers, databases, and applications. The database
would be used
by the Helpdesk and Management to see who is responsible
Ken, Ron
I think the most important step is to ask some very hard questions about
what data you really need. From what I've seen (and been involved in), you
begin with a burst of enthusiasm and tend to collect far too much data. Then
you can't keep it all updated, so the data tends to get
I have seen something of the kind done at one of my large customers (600+ databases,
Oracle + Sybase), where I have had more than a hand into the Oracle part (the
inventory is stored in *blush* Sybase) and I am working on something similar with a
colleague elsewhere, where there are _only_ 80
Support Database
Ken, Ron
I think the most important step is to ask some very hard
questions about
what data you really need. From what I've seen (and been
involved in), you
begin with a burst of enthusiasm and tend to collect far too
much data. Then
you can't keep it all updated, so the data
]
Web:www.compuware.com
-Original Message-
Sent: Thursday, October 30, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
Subject:DBA Support Database
I was thinking about putting together a database that contains a list of
DBAs, servers, databases, and applications
Title: RE: DBA Support Database
I'll throw in my *very expensive free* comments...
expensive free comments
This begins to create the corporate metadata and architecture as Peter mentions. We are on this road, and there are several tools that can do *auto discovery*. There are some very nice
1:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA Support Database
Just a quick reply to this.
You are, in fact, formulating the sort of request which would be input to a corporate data architecture. We have built such a thing, and it includes the issues you refer to. More
3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: DBA Support Database
I was thinking about putting together a database that
contains a list of
DBAs, servers, databases, and applications. The database
would be used
by the Helpdesk and Management to see who is responsible
Support Database
I was thinking about putting together a database that
contains a list of
DBAs, servers, databases, and applications. The database
would be used
by the Helpdesk and Management to see who is responsible for a
given
application or database when problems occur
15 matches
Mail list logo