Upgrade to Oracle 9i in two-node cluster

[Hai Nguyen_1]

Folks,

I am looking for suggestions, procedures, experience... to minimize down time when upgrading Oracle 8i to Oracle 9i in a two-node cluster environment. Below is the summary of my current configuration:
- Cluster software version: 11.14
- Primary node: rp7400 running 11.0
- Secondary node: rp5450 running 11.0
- Two cluster packages: Oracle and Web which by default are up and running on the primary node.
- One DB instance which is on the shared disk.
- Oracle executables are loaded on both nodes.

Thanks.

Hai

[Hai Nguyen_1]

Bounce to top. Try to catch your attention.

[Christopher Caldwell · Accepted solution]

Step 1 --
Test server:
Running 8i
Install Oracle 9i
Export production database
Import into test 8i database
[follow 9i upgrade procedure -- usually conversion scripts]
time conversion to determine outage window
test

Fail partner
Install Oracle 9i

Here's where there's a number of options

You can preserve a copy of the existing db files if you have enough space
and/or backup
and/or try upgrade in place

For maximum resiliency, I'd freeze the production database and dup the data so you can quickly go back if necessary.

Upgrade fail partner.
Test/verify.

Upgrade main host [should be trivial].

Fail back to main host.

[Hai Nguyen_1]

Thanks Christopher!

Hai