The steps are well documented in, well, the documentation.
Have you read it? Are there specific parts about which you have questions?
The best advice I can give when doing an upgrade: practice the upgrade and test your apps against the updated version before you do it "for real."
1 person found this helpful
As long as you make your database healthy and perform all the steps which are needed to prepare it for upgrade, there should be no issues. I would suggest to do a test upgrade to familiarize yourself with upgrade process and see if there are any potential issues.
Follow article 837570.1 to get a complete checklist of steps for upgrade.
First you need to check the prerequisites after following the upgrade documents
2. You need to check the preupgrade script to check whether the database is in a position to be upgraded or not.
3. run the catupgrd.sql command from $ORACLE_HOME/rdbms/admin/catupgrd.sql
4. check the invalid objects
Thank you all for you reply.
Actually i need to upgrade some of my most mission critical system at the same time the operating system version which is linux 5.3 to linux 6.5.
and i have physical standby for those system. Little bit worried about the outcome.
Since you have dataguard setup and upgrading both OS and DB at the same time so you may create first a upgrade plan and post it here for comments. Once revised and vetted, you may go for test upgrade.