| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving projects from development/test to production
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.
dwilliams_at_lifetouch.com
-----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:Helmut.Daiminger_at_wwk.de
http://www.wwk.de
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 31 2003 - 10:54:33 CST
 |
 |