Oracle-L: RE: DBA Support Database

From: Rothouse, Michael <mrothouse_at_fcg.com>
Date: Fri, 31 Oct 2003 06:19:32 -0800
Message-ID: <F001.005D5324.20031031061932@fatcity.com>

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 this, there is still no guarantee.

-----Original Message-----
Sent: Thursday, October 30, 2003 7:00 PM To: Multiple recipients of list ORACLE-L

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 account of
*everyones* inability (dare I mention 'apathy') to keep it up to date. And yes - Greg's expensive free comment is well taken. An enterprise IT repository is well worth it, but it can and will be a bear to get off the ground unless there is some serious Management committment behind it. If executed and maintained well, it can relieve a lot of pressure and work and add value to the 'business' [Hope I don't sound like damagement :) ]

John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com <http://www.klove.com/>

The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----
Sent: Thursday, October 30, 2003 3:24 PM To: Multiple recipients of list ORACLE-L

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 <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
<http://www.orafaq.net/>
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com/>
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing l! ist, 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

<http://www.bgs.ac.uk/>

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<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
<http://launch.yahoo.com/video/?1093432&fs=1&redirectURL=http://launch.y
ahoo
.com/promos/britneyspears/> Spears

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rothouse, Michael
  INET: mrothouse_at_fcg.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 Fri Oct 31 2003 - 08:19:32 CST