RE: Documenting databases
-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 09, 2003 7:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Documenting databases The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [Shrek] and produces nice pretty html pages that damagement can look at in their browser. -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Breakthrough: It finally booted on the first try.
Re: Documenting databases
Alan, When I started working at my present job there was zip,nada,zilch.. for database documentation. I started with the basics of: describe every table. describe the table data source location and provider and method of loading the data into the table. describe who or how the data in the table is used. document the database creation (create scripts to create the database, tablespaces,tables,triggers,etc..) and keep the scripts updated as conditions change. I periodically burn a CDROM with the scripts in case of a hardware failure and after a lot of changes in the scripts ( like year end work for the next year's tables) Describe the packages and objects that are used in the database (non Oracle created). create a daily/weekly/monthly(as you feel you are comfortable with) tablespace usage report to plan on new storage needs. In all cases document every thing. or CYA I hope this will get you started and remember that database documentation is an ever ending task. Ron [EMAIL PROTECTED] 12/09/2003 5:49:25 PM Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Ron Rogers 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: Documenting databases
Alan, The IT departments of several sites, hitherto fairly independent, have all been brought under a single roof at one of my customers and as a result a lot of databases have fallen into the herd of databases we had to manage there. IMHO the key point to inventory is automation; if you don't automate, it will never stay up-to-date. First of all, get hold of some platform for scripting. VERY VERY SMALLI don't know perl,/VERY VERY SMALLMICROSCOPIC I don't even plan to learn it any soon/MICROSCOPIC and as I feel comfortable with ksh, sed, awk and the like I jumped on a Unix platform, but your choice may be different. The first challenge in our case was to build an inventory of databases (asking people is totally unreliable); I have used scripts from Tim Gorman which you will find on his site (http://www.evdbt.com) - from a security paper, which I have reworked to suit my case. The idea was to probe the network (fortunately all servers are supposed to follow a special address pattern) and check for listeners, and send the lsnrctl stat command. This helps you identify servers, listeners, and instances. A suitable schema was built into a database (Oracle, but see below) to store this; note that relationships are sometimes not very simple, since a same instance can be served by several listeners. Next step was to secure a foothold into each database to execute inventory queries (it has been a good opportunity to check security too). DBSNMP/DBSNMP is a good bet. Actually, we created a special MONITOR account on each database, with only the minimum rights required. Everyday a script runs, which checks V$DATABASE, V$INSTANCE, V$LICENCE, V$VERSION (the only place BTW when you find some indication about which OS you are running on), getting information and updating it if required. Storage is of course checked as well. Database links are collected too. We have a PHP application displaying all the information (with the refresh date), conveniently crossed (for instance, we list for each database the dblinks to the database as well as the dblinks from the database). We have some summary PDF reports (storage, databases per OS, per version, etc.) which are printed every week. We are also linking to a (static) inventory of applications. It's still work in progress. We have recently added a connection test every 15mn to check database availability (trying a non-existent user. If we don't get ORA-1917 we try to ping the server and tnsping the listener to pinpoint the reason for the problem - of course we skip the other databases on the server if we can't ping it) and compute some availability percentage figure. We also intend to collect some metrics at regular intervals to have an idea about the load. I have nothing against using Access to store the data; in fact, some of the ideas were borrowed from another customer where the repository is a Sybase database (TCL scripts do a full inventory of both the Sybase and Oracle databases - several hundreds of them). But, once again, do it AUTOMATICALLY. HTH Stephane Faroult - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 09 Dec 2003 15:34:32 Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM
RE: Documenting databases
Alan - First the bad news. Obviously you can't automatically get all that information, but then you knew that. The good news. I think you'll find that information to be very valuable. I try to collect that myself. A spreadsheet or Access database is probably as good a way as any. If you have a help desk, they may be able to store this information as a configuration (or CI) in their tool. Another piece of data to consider is the database links. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 09, 2003 5:35 PM To: Multiple recipients of list ORACLE-L Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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: 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: Documenting databases
I used to document database objects (including columns) with the COMMENT commands. I stopped doing that because I think it unnecessarily increases the size of data dictionary. It's just a little, though. Yong Huang Daniel Hanks wrote: How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: Documenting databases
Alan, That sounds like a good candidate for a simple database application written in PL/SQL. Create a schema and model your app. It shouldn't require too many tables. Since you have Oracle and non-oracle information to store, most of the Oracle information could be extracted from the data dictionary automatically to update your app. You would only have to manually update the non-Oracle information. Mike Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Documenting databases
Indeed, my todo list includes an item for automating RDA on several servers. The problem is, that RDA is rather difficult to automate, at least on Windoze. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 05:24 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Documenting databases Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:Re: Documenting databases |Dan, | That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | [EMAIL PROTECTED]To:Multiple |recipients of list ORACLE-L [EMAIL PROTECTED] | c.com cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: | Recently our database manager has asked us to do the unthinkable | document our databases! To make matters worse, and without our input, |he | went ahead and created a schema and put it in an Access database (using | tables to make it look like a speadsheet). Either we use his idea or |come | up with something else. | So, I thought I'd ask everyone on the list how you do it. Text |files? | In a database (oracle, or other)? Spreadsheets? What are the pros and | cons? Etc | |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | 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: | 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). Content-type: text/html; charset=us-ascii brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font br brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font br brfont size=2 face=sans-serifJared/font brfont size=2 face=sans-serifbr /font br br br table width=100% tr valign=top td tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font br tdfont size=1 face=Arialnbsp; nbsp; nbsp; nbsp; /font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L lt;[EMAIL
RE: Re: Documenting databases
Thanks for all the responses. As I figured, everyone has a different method, but the common thread seems to be automation. I'm not sure exactly what approach I'm going to take yet, but I'll definitely try to automate it as much as possible... I'll add one of my own documentation tricks that might be useful for large sites. I have a graphical diagram (created in Visio) that I keep up to date with our database servers. Under each server is a list of databases running on it and other minor details (like Oracle release, versions of applications it supports, etc).. Finally, I have lines drawn between the servers/databases documenting triggers that update remote databases, advanced replication/streams, automated export/imports, or other important interactions. Especially if you have 50-100+ databases, it can be tough to remember where every database lives and what relationships exist between them. It's also great to give to managers who love diagrams... :-) Thanks again, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: orp.com Subject: RE: Re: Documenting databases Sent by: [EMAIL PROTECTED] .com 12/10/2003 06:29 AM Please respond to ORACLE-L Alan, The IT departments of several sites, hitherto fairly independent, have all been brought under a single roof at one of my customers and as a result a lot of databases have fallen into the herd of databases we had to manage there. IMHO the key point to inventory is automation; if you don't automate, it will never stay up-to-date. First of all, get hold of some platform for scripting. VERY VERY SMALLI don't know perl,/VERY VERY SMALLMICROSCOPIC I don't even plan to learn it any soon/MICROSCOPIC and as I feel comfortable with ksh, sed, awk and the like I jumped on a Unix platform, but your choice may be different. The first challenge in our case was to build an inventory of databases (asking people is totally unreliable); I have used scripts from Tim Gorman which you will find on his site (http://www.evdbt.com) - from a security paper, which I have reworked to suit my case. The idea was to probe the network (fortunately all servers are supposed to follow a special address pattern) and check for listeners, and send the lsnrctl stat command. This helps you identify servers, listeners, and instances. A suitable schema was built into a database (Oracle, but see below) to store this; note that relationships are sometimes not very simple, since a same instance can be served by several listeners. Next step was to secure a foothold into each database to execute inventory queries (it has been a good opportunity to check security too). DBSNMP/DBSNMP is a good bet. Actually, we created a special MONITOR account on each database, with only the minimum rights required. Everyday a script runs, which checks V$DATABASE, V$INSTANCE, V$LICENCE, V$VERSION (the only place BTW when you find some indication about which OS you
Re: Documenting databases
I apologize if someone already mentioned this (I've been busy so mostly deleting traffic in order to keep from being overwhelmed!), but did anyone mention the DBMS_METADATA package for this? Looks pretty cool, mostly intended for generated XML output but also generates DDL commands... on 12/10/03 4:39 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Thanks for all the responses. As I figured, everyone has a different method, but the common thread seems to be automation. I'm not sure exactly what approach I'm going to take yet, but I'll definitely try to automate it as much as possible... I'll add one of my own documentation tricks that might be useful for large sites. I have a graphical diagram (created in Visio) that I keep up to date with our database servers. Under each server is a list of databases running on it and other minor details (like Oracle release, versions of applications it supports, etc).. Finally, I have lines drawn between the servers/databases documenting triggers that update remote databases, advanced replication/streams, automated export/imports, or other important interactions. Especially if you have 50-100+ databases, it can be tough to remember where every database lives and what relationships exist between them. It's also great to give to managers who love diagrams... :-) Thanks again, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: orp.com Subject: RE: Re: Documenting databases Sent by: [EMAIL PROTECTED] .com 12/10/2003 06:29 AM Please respond to ORACLE-L Alan, The IT departments of several sites, hitherto fairly independent, have all been brought under a single roof at one of my customers and as a result a lot of databases have fallen into the herd of databases we had to manage there. IMHO the key point to inventory is automation; if you don't automate, it will never stay up-to-date. First of all, get hold of some platform for scripting. VERY VERY SMALLI don't know perl,/VERY VERY SMALLMICROSCOPIC I don't even plan to learn it any soon/MICROSCOPIC and as I feel comfortable with ksh, sed, awk and the like I jumped on a Unix platform, but your choice may be different. The first challenge in our case was to build an inventory of databases (asking people is totally unreliable); I have used scripts from Tim Gorman which you will find on his site (http://www.evdbt.com) - from a security paper, which I have reworked to suit my case. The idea was to probe the network (fortunately all servers are supposed to follow a special address pattern) and check for listeners, and send the lsnrctl stat command. This helps you identify servers, listeners, and instances. A suitable schema was built into a database (Oracle, but see below) to store this; note that relationships are sometimes not very simple, since a same instance can be served by several listeners. Next step was to secure a foothold into each database to execute inventory queries (it has been a good opportunity to check security too). DBSNMP/DBSNMP is a good bet. Actually, we created a special MONITOR account on each database, with only the minimum rights required. Everyday a script runs, which checks V$DATABASE, V$INSTANCE, V$LICENCE, V$VERSION (the only place BTW when you find some indication about which OS you are running on), getting information and updating it if required. Storage is of course checked as well. Database links are collected too. We have a PHP application displaying all the information (with the refresh date), conveniently crossed (for instance, we list for each database the dblinks to the database as well as the dblinks from the database). We have some summary PDF reports (storage, databases per OS, per version, etc.) which are printed every week. We are also linking to a (static) inventory of applications. It's still work in progress. We have recently added a connection test every 15mn to check database availability (trying a non-existent user. If we don't get ORA-1917 we try to ping the server and tnsping the listener to pinpoint the reason for the problem - of course we skip the other databases on the server if we can't ping it) and compute some availability percentage figure. We also intend to collect some metrics at regular intervals to have an idea about the load. I have nothing against using Access to store the data; in fact, some of the ideas were borrowed from another customer where the repository
Re: Documenting databases
On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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: Documenting databases
Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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: 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: Documenting databases
I think you can download a software called DataPublisher from AgileInfoSoftware, it will automatically document the database for you. http://www.agileinfosoftware.com/download/products.asp. The output is very impressive. Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 17:49 Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc Thanks, Alan Alan Aschenbrenner Oracle DBA IHS Group [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Eric King 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: Documenting databases
The internal stuff can be documented with OraSnap. Just google for it. It's free, detailed, and easy to setup and automate. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/09/2003 03:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Documenting databases Dan, That's a good idea for documenting structures inside the database. However, my database manager wants more high level info: database name / host, oracle version, listeners, applications that use it, cron job descriptions and times, main schemas and what they are used for, lists of developers names that access the databse, etc... Alan Daniel Hanks [EMAIL PROTECTED]To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] c.com cc: Sent by: Subject: Re: Documenting databases [EMAIL PROTECTED] .com 12/09/2003 04:09 PM Please respond to ORACLE-L On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: Recently our database manager has asked us to do the unthinkable document our databases! To make matters worse, and without our input, he went ahead and created a schema and put it in an Access database (using tables to make it look like a speadsheet). Either we use his idea or come up with something else. So, I thought I'd ask everyone on the list how you do it. Text files? In a database (oracle, or other)? Spreadsheets? What are the pros and cons? Etc How about in each database itself. COMMENT ON TABLE|COLUMN tab|tab.col IS '...' comes to mind. It's simplistic, yes, but at least you don't have to remember where you put your documentation... HTH, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks 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: 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: Documenting databases
Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:Re: Documenting databases |Dan, |That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | [EMAIL PROTECTED]To: Multiple |recipients of list ORACLE-L [EMAIL PROTECTED] | c.com cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: | Recently our database manager has asked us to do the unthinkable | document our databases! To make matters worse, and without our input, |he | went ahead and created a schema and put it in an Access database (using | tables to make it look like a speadsheet). Either we use his idea or |come | up with something else. | So, I thought I'd ask everyone on the list how you do it. Text |files? | In a database (oracle, or other)? Spreadsheets? What are the pros and | cons? Etc | |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | 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: | 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). Content-type: text/html; charset=us-ascii brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font br brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font br brfont size=2 face=sans-serifJared/font brfont size=2 face=sans-serifbr /font br br br table width=100% tr valign=top td tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font br tdfont size=1 face=Arialnbsp; nbsp; nbsp; nbsp; /font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L lt;[EMAIL PROTECTED]gt;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; cc: nbsp; nbsp; nbsp; nbsp;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; Subject: nbsp; nbsp; nbsp; nbsp;Re
Re: Documenting databases
Check this out: http://www.agileinfosoftware.com/products/datapublisher/, it might be something you are looking for. Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 20:24 Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:Re: Documenting databases |Dan, |That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | [EMAIL PROTECTED]To: Multiple |recipients of list ORACLE-L [EMAIL PROTECTED] | c.com cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: | Recently our database manager has asked us to do the unthinkable | document our databases! To make matters worse, and without our input, |he | went ahead and created a schema and put it in an Access database (using | tables to make it look like a speadsheet). Either we use his idea or |come | up with something else. | So, I thought I'd ask everyone on the list how you do it. Text |files? | In a database (oracle, or other)? Spreadsheets? What are the pros and | cons? Etc | |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | 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: | 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). Content-type: text/html; charset=us-ascii brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font br brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font br brfont size=2 face=sans-serifJared/font brfont size=2 face=sans-serifbr /font br br br table width=100% tr valign=top td tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font br tdfont size=1 face=Arialnbsp; nbsp; nbsp