A few small points:
1. Will you be able to test your app code against a 10G database in advance
of this upgrade? The app code is the most likely source of upgrade problems.
2. In the event of a serious problem after 10G is live and has been running
for a while, how would you get the new/changed data back to the old 8174
database? You should work out a roll-back process.
3. The client tnsnames may point to a specific SID (i.e.
connect=(sid=test1)...) and so changing the listener will not cause them to
reconnect to test1a. You may need to change client tnsnames.ora.
4. To reduce/remove the need for prayer, you should try the upgrade in
advance of the real upgrade (as many times as you can) to ensure the process
works.
HTH
John.
-----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
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page