RE: Oracle DB Upgrade TO DO LIST

Ben - Thanks, I printed that for my checklists file.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, June 03, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L

Ken,

Jared is probably right as far as a checklist for the actual upgrade. A test run through will probably highlight any problem areas.

After the upgrade there are a number of things that usually need to be checked/modified/recompiled (of course it depends on how you upgrade). Here is a list that I found useful. Please add to it if you wish.

• ODBC connections
• applications
• DBA scripts in SQL, PERL, etc.
• SQL*LDR jobs
• regular imports, exports, snapshots
• FTP's of data to be loaded/imported/exported
• database links
• backups
• scheduled jobs
• scripts that mail logs or reports
• alert log check scripts
• parameter files (*.ora)
• metadata for third party query tools

Ben

-----Original Message-----
Jared.Still_at_radisys.com
Sent: June 3, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L

Ken,

The best to do list will be the one you create yourself.

You can do this by reviewing the migration manual, and determining which steps are appropriate for your environment.

Jare

"KENNETH JANUSZ" <kjanusz_at_att.net>
Sent by: root_at_fatcity.com
 06/02/2003 08:49 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Oracle DB Upgrade TO DO LIST

I am looking at a project to upgrade a number of Oracle development, test and production DB's to newer releases. I have reviewed Oracle's list of tasks from OTN. I would like your feedback on other tasks, etc. that should be included. Is there a list somewhere on the web that gives a comprehensive list of tasks that need to be accomplished and "gotchas"?  

TIA,
Ken Janusz, CPIM

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Jared.Still_at_radisys.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: Ben
  INET: poelsb_at_post.queensu.ca

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: 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).