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
I agree. You can put this application in place but if there is no
accountability for keeping it up-to-date, what value does it have down
the road. Having a documented process/policy/SOP associated with this
and backed/enforced by Management may help to maintain its value
long-term. Despite
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
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 importantly, we have identified who is responsible
for every single piece of data in the
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
Oracle Applications DBA
Hitach Data Systems, Santa Clara
Work : (408) 970 7002
Fax: 408 327 3402 (Call/Email prior to fax)
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA
There are tools on the market that discover that for you. They will detect
what databases and what applications use them for you automatically.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
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
Paul,
Kevin Loney was the original author of the CC Db - way back in the Oracle7
handbook. I used to have a schema built on that basis in a previous job, and
it served the purpose well. However, the problem does remain that 'linking'
it to other parts of the IT infrastructure will not work on
Don't ask me, I didn't participate in the writing of that one and I've
never had cause to use the command center database.
--- Paul Drake [EMAIL PROTECTED] wrote:
I recall seeing a command center database in the book
Oracle 8i DBA Handbook by Loney, Theriault.
chapter 6 - Managing
14 matches
Mail list logo