RE: DBA Support Database

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 databases so far.

I have recently been tasked with a similar project, so I am also very interested in knowing if this has been done before. In-house, purchased, anything?

Thanks,
Mike

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

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 see is keeping it up to date.

Ken Janusz, CPIM

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 30, 2003 9:29 AM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: kjanusz_at_att.net

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: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.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).