Manage Learn to apply best practices and optimize your operations.

Upgrading Oracle products from 8.1.6 to 8.1.7

I was asked to jump an 8.1.6 instance to 8.1.7 so that the Sun OS could be upgraded to 9. I found an unusual combination of Oracle products running, Oracle Spacial, Context, Portal30 and Portal-To-Go. Between 8.1.6 and 8.1.7, I normally uninstall the Java and XML, and then reinstall them in 8.1.7 to get a cleaner data dictionary. I know that I am going to have to figure out versions, but what, in general, would be a good way to approach this? It won't take me very long to just open the instance in 8.1.7 and run the base RDBMS upgrade part.
Oracle Spatial and Oracle Context are database options that would be covered by the upgrade procedures for the database. If you found an Oracle Portal repository (as indicated by the presence of a schema named portal30), you should ensure that the version of Oracle Portal in use is supported by the database version you're upgrading to. That will be complicated by the fact that if, as the schema name indicates, the Portal is version 3.0.x, it's somewhat dated and you will likely need (or at least you should) to upgrade Portal as well.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.