KG1973
asked on
How can I upgrade 10G R1 to R2 ?
Hi,
We have Oracle 10G installed since last year. So far so good. But since Oracle had release latest one R2, can anyone tell me how to upgrade the existing 10G R1 ? There are a lot of data inside the server and many system had been deployed. So how can I ensure the upgrade will work 100% or another word, I am afraid if the upgrade failed, the system also failed. If the upgrade is straight foward without reconfigure or minimum changes, then I will try if the procedure is simple and easy.
Another thing is, we also have 2nd 10G installed to another machine. We plan to use this as a backup, just incase 1st server down, 2nd one will take over. But I believe it is not as siimple as it is. How can I do that ?
Thanks.
We have Oracle 10G installed since last year. So far so good. But since Oracle had release latest one R2, can anyone tell me how to upgrade the existing 10G R1 ? There are a lot of data inside the server and many system had been deployed. So how can I ensure the upgrade will work 100% or another word, I am afraid if the upgrade failed, the system also failed. If the upgrade is straight foward without reconfigure or minimum changes, then I will try if the procedure is simple and easy.
Another thing is, we also have 2nd 10G installed to another machine. We plan to use this as a backup, just incase 1st server down, 2nd one will take over. But I believe it is not as siimple as it is. How can I do that ?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you can't do RAC you can use Dataguard to ship the arch logs to the second server.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The following is a chain of events that I first thought might solve the upgrade with no downtime:
(These first steps *would* requires downtime for certain:)
1. shutdown Oracle 10g R1 on both nodes.
2. shutdown crs process.
3. upgrade CRS.
4. open the R1 databases using the R2 of crs.
-------------------------- ---------- ------
the next steps I was unsure about, until I realized that what would happen in step 7:
5. shutdown Oracle 10g R1 on node A.
6. upgrade Oracle 10g to R2 on node A
7. open Oracle 10g R2 on node A <-- This step should not work because we are trying to join an Oracle 10g R2
database to a cluster with an already running an Oracle 10g R1 instance.
8. shutdown Oracle 10g R1 on node B
9. upgrade Oracle 10g to R2 on node B
10 open Oracle 10g R2 on node B
Done!
For more details, visit http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/upgrade.htm#i1011372
Regards,
Chetan Sachdeva
(These first steps *would* requires downtime for certain:)
1. shutdown Oracle 10g R1 on both nodes.
2. shutdown crs process.
3. upgrade CRS.
4. open the R1 databases using the R2 of crs.
--------------------------
the next steps I was unsure about, until I realized that what would happen in step 7:
5. shutdown Oracle 10g R1 on node A.
6. upgrade Oracle 10g to R2 on node A
7. open Oracle 10g R2 on node A <-- This step should not work because we are trying to join an Oracle 10g R2
database to a cluster with an already running an Oracle 10g R1 instance.
8. shutdown Oracle 10g R1 on node B
9. upgrade Oracle 10g to R2 on node B
10 open Oracle 10g R2 on node B
Done!
For more details, visit http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/upgrade.htm#i1011372
Regards,
Chetan Sachdeva