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.



Oracle LazyDBA home page