Re: Moving Code to Production

Dennis:

Both you and Stephen helped me.

Thanks much,

Ken

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, May 22, 2003 12:51 PM

> Thanks Stephen. I will be writing some policies in the future for this.
Your
> posting is going in my "save" file!
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Thursday, May 22, 2003 10:57 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Ken:
>
>
>
> Very open question. Do you want war and peace on this one? OK, I will
> start.
>
>
>
> 1. Make sure that ALL sql code does not reference the
> owner of any objects within the database. Synonyms should be created.
>
> 2. Make sure that the application does not connect to
> either the application server or the database as the owner of the objects
or
> as a highly secured account. Asking for trouble if they do.
>
> 3. Make sure that any directory references are for the
> proper environment. For example, we had an application that was migrated
to
> production but still referred to development files on the server. What
fun
> we had looking for this one.
>
> 4. Make sure ALL debugging flags have been turned off or
> removed before porting the application to production. In fact, we
required
> a complete re-compile of all code before porting to make sure.
>
> 5. Make sure the application is TESTED thoroughly.
> Separate test environment. In fact stress test the application to make
sure
> that the so-called "improvements" didn't break anything.
>
> 6. I would recommend that for any SQL changes the proper
> explain plan and statistics generation be included in the documentation
for
> the changes.
>
> 7. Proper signoff of all management parties involved in
> the change, including the user. Make sure the user performs an acceptance
> test on the new code PRIOR to the migration of the code. I love seeing
> acceptance testing done after. Really makes for some fun meetings.
>
> 8. Backup application directory and database prior to
> rollout. Just in case something is truly broke, you can restore back.
>
>
>
> How's that for a start!!!
>
>
>
> Thank You
>
>
>
> Stephen P. Karniotis
>
> Product Architect
>
> Compuware Corporation
>
> Direct: (248) 865-4350
>
> Mobile: (248) 408-2918
>
> Email: Stephen.Karniotis_at_Compuware.com
>
> Web: www.compuware.com
>
>
>
> -----Original Message-----
> Sent: Thursday, May 22, 2003 10:27 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Would like some feedback as to what to check, etc. when moving new code
> changes into the production environment.
>
>
>
> Thanks much,
>
> Ken Janusz, CPIM
>
>
>
>
> 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: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).