Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to upgrade from 9.2.0.7 to 9.2.0.8
- Thread starter maryam421
- Start date
SantaMufasa
Technical User
Maryam, the best/simplest/most reliable method that I have found for applying a minor patch (e.g., 9.2.0.7 -> 9.2.0.8) is:
1) Download (from Oracle Metalink) the appropriate patch for your operating system.
2) Gracefully shutdown all of your Oracle processes (including the Oracle LISTENER) on the target server.
3) Perform a full, cold backup of your 9.2.0.7 database and 9.2.0.7 installation.
4) Apply the 9.2.0.8 patch.
5) Startup your newly patched Oracle instance.
6) As "sys", re-run the following Oracle data dictionary scripts (that reside in your $ORACLE_HOME/:
@$ORACLE_HOME/rdbms/admin/catalog
@$ORACLE_HOME/rdbms/admin/catproc
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
@$ORACLE_HOME/rdbms/admin/utltkprf.sql
At this point, your database is now patched to 9.2.0.8.
Let us know your results.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
1) Download (from Oracle Metalink) the appropriate patch for your operating system.
2) Gracefully shutdown all of your Oracle processes (including the Oracle LISTENER) on the target server.
3) Perform a full, cold backup of your 9.2.0.7 database and 9.2.0.7 installation.
4) Apply the 9.2.0.8 patch.
5) Startup your newly patched Oracle instance.
6) As "sys", re-run the following Oracle data dictionary scripts (that reside in your $ORACLE_HOME/:
@$ORACLE_HOME/rdbms/admin/catalog
@$ORACLE_HOME/rdbms/admin/catproc
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
@$ORACLE_HOME/rdbms/admin/utltkprf.sql
At this point, your database is now patched to 9.2.0.8.
Let us know your results.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Thread starter
- #3
Thanks for your quick response. I have three databases running on this server.
Should I shut down all of them or just the one that I am upgrading? Also do I need to the backup for all of them or only the one that I am upgrading?
As per your instruction it seems to me that the oracle software will also be upgraded with this upgrade.
Once again thanks for you quick response and all your help.
Should I shut down all of them or just the one that I am upgrading? Also do I need to the backup for all of them or only the one that I am upgrading?
As per your instruction it seems to me that the oracle software will also be upgraded with this upgrade.
Once again thanks for you quick response and all your help.
SantaMufasa
Technical User
Maryam,
Good questions.
>>> Should I shut down all (three) of them or just the one that I am upgrading?
Are all three of the databases 9.2.0.7? And if so, are they all running from the same $ORACLE_HOME? If so, then absolutely, you will need to shut them all down. You will apply the 9.2.0.8 patch once, then run the data dictionary scripts individually against each of the three instances.
If, however, the other two databases are not running 9.2.0.7, then I am not certain if Oracle will require your shutting them down. You can shut down the 9.2.0.7, then attempt to apply the patch. If Oracle proceeds, then the answer is "No", you needn't shut the others down. But if Oracle throws an error stating something to the effect that there are still Oracle processes running that you must shut down first (and it will name the ones you must shut down), then go ahead and shut them down.
This, of course, is a very good reason to apply the patch during non-business hours (if you have such a time at your organisation).
And this is also implies the answer to your next question,
>>> ...do I need to the backup for all of them or only the one that I am upgrading?
I would. (Backups never hurt anything; forgoing a backup has been a cause for regret many times for me and my colleagues.![[banghead]](/data/assets/smilies/banghead.gif "[banghead] [banghead]")
)
>>> As per your instruction it seems to me that the oracle software will also be upgraded with this upgrade.
When you apply a patch, you are doing so to the software, not directly to the database. The database runs under an Oracle software version. So although you can say that your database is 9.2.0.8, it is really such by virtue of the Oracle software becoming version 9.2.0.8.
Let us know if you have additional questions.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
Good questions.
>>> Should I shut down all (three) of them or just the one that I am upgrading?
Are all three of the databases 9.2.0.7? And if so, are they all running from the same $ORACLE_HOME? If so, then absolutely, you will need to shut them all down. You will apply the 9.2.0.8 patch once, then run the data dictionary scripts individually against each of the three instances.
If, however, the other two databases are not running 9.2.0.7, then I am not certain if Oracle will require your shutting them down. You can shut down the 9.2.0.7, then attempt to apply the patch. If Oracle proceeds, then the answer is "No", you needn't shut the others down. But if Oracle throws an error stating something to the effect that there are still Oracle processes running that you must shut down first (and it will name the ones you must shut down), then go ahead and shut them down.
This, of course, is a very good reason to apply the patch during non-business hours (if you have such a time at your organisation).
And this is also implies the answer to your next question,
>>> ...do I need to the backup for all of them or only the one that I am upgrading?
I would. (Backups never hurt anything; forgoing a backup has been a cause for regret many times for me and my colleagues.
)>>> As per your instruction it seems to me that the oracle software will also be upgraded with this upgrade.
When you apply a patch, you are doing so to the software, not directly to the database. The database runs under an Oracle software version. So although you can say that your database is 9.2.0.8, it is really such by virtue of the Oracle software becoming version 9.2.0.8.
Let us know if you have additional questions.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status
Similar threads