Oracle-L: RE: DBA Support Database

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Thu, 30 Oct 2003 15:24:24 -0800
Message-ID: <F001.005D51B9.20031030152424@fatcity.com>

I recall seeing a "command center database" in the book

Oracle 8i DBA Handbook by Loney, Theriault. chapter 6 - Managing multiple databases.

its a start. I haven't read the 9i version.

Rachel,

were there any improvements to it?

Paul

"Loughmiller, Greg" <Greg.Loughmiller_at_cingular.com> wrote:

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 tools on the market for asset discovery. They have *exit points* where one could write some basic code to access those assets(sql getting v$ info and store in your metadata?).

We have built an enterprise repository to maintain infrastructure data, application, servers, network devices, and transport layers. And now we are going down the *yellow brick road* to begin the data acquisition process.

We too, will also define and assign accountability to those elements within our repository. </expensive free comments>

greg

-----Original Message-----
Sent: Thursday, October 30, 2003 11:50 AM To: Multiple recipients of list ORACLE-L

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 system. The management of an attribute in a table can in fact be traced right back up to that level of senior management where they don't even know how to spell 'Oracle'...

peter
edinburgh

> -----Original Message-----
> From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
> 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 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 see if anyone has already designed
> such a database and might be willing to share it.
>
> Thanks!
> Ron Smith
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the

BGS. .                            http://www.bgs.ac.uk 
*********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Robson, Peter 
  INET: pgro_at_bgs.ac.uk 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
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). 


---------------------------------
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Oct 30 2003 - 17:24:24 CST