gotcha when upgrading from 8i to 9iR2?

[a128]

I need to upgrade existing DBs from 8.1.7.3 to 9.2.0.1. For those who have experiences with this upgrade path, are there any gotchas?

Also, can I upgrade 8.1.7.3 Standard edition to 9.2.0.1 Enterprise edition in one shot?

Appreciated.

[adewri]

Originally posted by a128
I need to upgrade existing DBs from 8.1.7.3 to 9.2.0.1. For those who have experiences with this upgrade path, are there any gotchas?

No.

Originally posted by a128

Also, can I upgrade 8.1.7.3 Standard edition to 9.2.0.1 Enterprise edition in one shot?

Appreciated.

Depends. If you are a good dba then yes. If not then no.

[stecal]

Migration guide spells out if you can go directly from one version to another, or if you have to do an intermediate upgrade.

[slimdave]

I wouldn't stop at 9.2.0.1 -- apply the subsequent patches to go to 9.2.0.3(I think that's the most recent version)

[stmontgo]

the gotcha's I have seen are people not testing the migration path, you should really try that

[jovery]

If your concerned about trusting you database to the migration assitant you can always do it manually

http://support.oracle.co.uk/metalink...&p_id=159657.1

But as with all things like this make sure you test it first.

[a128]

Thanks guys!

I have one more question: When upgrading a DB from 8.1.7 to 9.2, I presume I need as much available HD space as the size of the DB to be upgraded? The migration guide says the migration assistant will check for available disk space but currently I am trying to see if my existing server has enough HD space. If not, I won't bother install Oracle 9.2 software on the server (maxed out the storage) but to build anther one.

What happen after the upgrade? I will have two set of same DB, one for 8i and the other for 9i?

I hope 8i and 9i's listeners won't both default to 1521 right after the install...

Thanks again

[jovery]

* You will need enough space to install both product sets, i.e. 8i and 9i I think 9i is just over 2.5Gb for a full install.

* When you perform the migration you will have only one DB the new migrated one.

* By default it will try to configure the 9i listener on port 1521.

HTH

[a128]

I just installed Oracle 9i software only (with no new DB installed) on a Windows 2000 system with existing 8i home. I notice there is NO 9i listener installed but the existing 8i is still there and running.

The 9i home is completed seperated from the 8i's. Does anybody know why no 9i listener is installed (thus I don't see it in Windows 2000 "Services")

Thanks,

[mike2000]

you can simply use lsnrctl of 9i to start the listener and you will have one or create a dummy database so Oracle can create the listener after the datbabase is created.