Helmut I don't think this is off-topic, but something that many of us Oracle DBAs wrestle with. If you kept John Kanagaraj's posting yesterday on the DBA Support Database topic, it contains the "big picture". If you didn't keep it, email me privately and I'll send it. I believe he is referring to the ITIL standards body. There is probably an ITIL user group near you or a company that gives talks from time to time. That is the easiest way to get an overview of ITIL. Our organization is "evolving" in that direction. Overall, this is a long-term commitment by your organization. You don't change everything overnight. One immediate change you can implement is a "staging" system. Most of us currently have a test or development system. Staging is an exact copy of production in all respects. From the database side, cloning the database or using RMAN DUPLICATE works very well. Then the development team makes a release to you. Ideally this is on a CD-ROM labeled 1.1 or whatever. You take the CD-ROM and instructions and apply the changes to the staging server. Then the staging system is tested. If it is deemed satisfactory, then you schedule a time and make the changes on production. If it fails the testing or you are unable to apply the changes, then it gets bounced back to the development group. The release may include application or web server changes that must be coordinated with database changes. This is a small change, but it has helped our releases.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, October 31, 2003 1:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 München Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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).