Ben - Thanks, I printed that for my checklists file.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----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-----
[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/02/2003 08:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [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: Ben
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).
