Have you compared this to the Oracle upgrade procedure?

-----Original Message-----
From: BenBart
[mailto:oracledba-ezmlmshield-x46740619.[Email address protected]
Sent: 05 July 2006 08:21
To: LazyDBA Discussion
Subject: 8.1.7.4 upgrade to Oracle10g

Hi all,

I am looking at carrying out my Oracle8.1.74 to Oracle10gRelease2 as
follows and I just want some feedback from the experts here:

1. Install Oracle10gRelease2.
2. Clone the current 8.1.7.4 database with a different database name
but on the same server, for example, original database is TEST1,
cloned database is TEST1A
3. Shutdown the STANDBY database and stop log-shipping.
4. Run DBUA and upgrade TEST1A to Oracle10gRelease2 and "pray" that
everything goes well.
5. Shutdown TEST1 and TEST1A.
6. Stop all LISTENER.
7. Rename the Oracle10gRelease2 LISTENER config file and use the
LISTENER configuration used on 8.1.7.4 and modify the TEST1
LISTENER to point to TEST1A instead and start the Oracle10g
LISTENER and the "upgraded" TEST1A database/instance.
8. On the client end, they should be connecting to the database as if
they are still using 8.1.7.4 and still connecting to TEST1 but
which is actually TEST1A.
9. In case of problem, stop all database and Oracle10g LISTENER.
Re-start the Oracle8.1.7.4 LISTENER and the original TEST1
database/instance.
10. On the standby server, install Oracle10gRelease2 and re-create the
STANDBY database.


Can everyone put in their thoughts and opinions here please and tell me
whether am right so far? AS these 8.1.7.4 databases are not 24x7, I'll
be doing this on the weekend, so worst case scenario, I just restore my
8.1.7.4's most recent database backup.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page