My database server is running on a clustered server and Oracle is installed on both nodes (not RAC) and at any one time only one of the nodes has access to the database.
I need to upgrade the software from 126.96.36.199 to 188.8.131.52 and the requirement is to upgrade one node first then run catpatch to update the catalog on the database.
If the upgrade is not stable, can I downgrade the database back to 184.108.40.206 from 220.127.116.11? Users do not want to lose any transactions.
Chapter 7 of the Oracle 9i Migration Guide is titled "Downgrading a database back to the previous Oracle release." You can find a copy of this document on Technet here.
Since you have two instances on separate nodes that you want to upgrade, I would probably suggest using two ORACLE_HOME directories. You'll have the 18.104.22.168 ORACLE_HOME that both instances are using now. Then, install Oracle 22.214.171.124 in a new ORACLE_HOME and patch it to 126.96.36.199. Shut down one of your instances and start it up with the new ORACLE_HOME. Then run the catpatch.sql script to upgrade the data dictionary. When you are ready, upgrade the database on the other ORACLE_HOME in the same fashion. When all databases are upgraded and you are satisfied that you do not need to go back, you can remove the 188.8.131.52 ORACLE_HOME directory.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.