Re: DBA Support Database
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 and list of changes. I do not know if you can add the name of the responsible person to the data, but since they keep all the data in a database I think you can easily join it with a list of your people. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 30, 2003 5:29 PM 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Yechiel Adar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DBA Support Database
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 [EMAIL PROTECTED] 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:[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: DBA Support Database
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 sounds pretty simple in terms a database design. You may want to think about what types of steps you want them to take before calling you. Oh yeah, don't forget to put listeners on your list. Nothing like an overlooked listener to get everyone's underwear in a bunch. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 30, 2003 9:30 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DBA Support Database
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 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:[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DBA 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 tends to get obsolete and not trusted. Better to start with the minimum and add more data later. One thought is to collect data on the interdependencies between the databases. If one database has a link to another, it would be nice to know this before you take one of them down and accidentally shut down some other users. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 30, 2003 10: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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RE: DBA Support Database
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 databases. In both cases the idea is to store an inventory, and to have scripts (tcl at one place, ksh at the other) running once a day to update the inventory; it of course requires having a suitable account with the required privileges created on each database. Inventory set up has been done at one place by scanning possible listener ports over the network, sending lsnrctl stat everywhere. Of course some cleanup required afterwards (... to remove extproc, among other things ...). Information collected involves startup time, Oracle version, tablespace information (also stored to an history table), database links - whatever you wish. For applications, it's a bit more manual. It's easy to get how much space is used by each schema (except SYS, SYSTEM, OUTLN ...) but then you have to 'attach' a schema to an application - and of course a DBA to an application as well. If some standards are respected, it's not too difficult ... The interface has been written with PHP at both places, with regular generation of colorful PDF reports for the management. Looks a bit like reinventing OEM, but the big advantage is that you can plug whatever you want into the system. At the biggest customer, it's linked to a similar system set up by the sysadmins showing all the information you can dream of about servers, hardware-wise as well as software-wise. Pretty impressive. For the record, the (huge team) of DBA there has at one point been forced upon some 3rd party software but they are much happier with their tools. HTH SF - --- Original Message --- - From: Vergara, Michael (TEM) [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 30 Oct 2003 08:29:27 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 [EMAIL PROTECTED] 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: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DBA Support Database
Ron, As you may have seen already, some issues have been pointed out. However, there are deeper issues... :( Databases need to run on Servers - these servers in turn rely on other services below them, namely Disk infrastructure (such as SANs, NAS, Switch fabric, etc.) as well as other networking services such as DNS, Routers, switches, gateways, etc. As well, there are the Application and other middleware layers that take part in the equation. In addition, there are the people that manage them, the organization structure that holds it together and the IT processes that define how and who does what. As you can see, this quickly gets very complicated, and maintaining this data [assuming that an application exists to do this] becomes a priority. Miss capturing or maintaining any of this, and the data quickly gets out of date or is irrelevant so that it is no use. I say all of this to say what comes next: Certain IT standards bodies have recongnized this and have specified that IT creates a 'Configuration Management Database' [and an application around it]. Processes around this include * Incident Management [something breaks, a user calls the Helpdesk who record and route it, a technician fixes it] * Problem Management [a process to identify trends in Incidents and identify/fix root causes] * Change Management [a process to document, agree and implement changes to the IT components in a controlled fashion with adequate understanding of effects and impact] * Other processes such as Asset Management, etc. In addition to other things mentioned above, the Config database should be able to map Business processes [business-speak for what an IT user does to keep the business flowing] to IT components as well as maintain the relationships and dependencies of the IT components so that impact analysis can be done Add up all this, and you see both the need for this as well as the complexity of the issue. Prepackaged applications exist to do this all : Examples are HP's Service Desk [they have been at it a long time], Troux [www.troux.com], etc. I hope that I haven't quenched your enthusiam - just wanted to make you understand that your mini-database will be (has to be) a component in the big picture. As a start, you could always create a 'Control Database' that lists all your Databases so that you can use it as a reference to put together a periodic publishing of a List of databases and versions, Sizes allocated and used, and other good stuff such as 'Average BCHR in the last month' :-) These tools have the capability to reference such standalone repositories and update themselves, so you haven't lost anything Hope this helps! John Kanagaraj 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 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 tends to get obsolete and not trusted. Better to start with the minimum and add more data later. One thought is to collect data on the interdependencies between the databases. If one database has a link to another, it would be nice to know this before you take one of them down and accidentally shut down some other users. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 30, 2003 10: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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: DBA Support Database
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] 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. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DBA Support Database
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 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- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 11: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 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:[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DBA Support Database
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" [EMAIL PROTECTED] 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- From: Robson, Peter [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 11: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 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:[EMAIL PROTECTED]] Sent: Thursday, October 30, 2003 3:30 PM To: Multiple recipients of list ORACLE-L Subject: DBA Support DatabaseI 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: [EMAIL PROTECTED] 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 l! ist, send an E-Mail message to: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: DBA Support Database
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 [EMAIL PROTECTED] 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:[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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. .
RE: DBA Support Database
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 multiple databases. its a start. I haven't read the 9i version. Rachel, were there any improvements to it? Paul Loughmiller, Greg [EMAIL PROTECTED] 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:[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears